[Advacs-discuss] Latest CVS updates
Oliver Elphick
olly@lfix.co.uk
Sun, 05 Sep 2004 15:24:53 +0100
On Sun, 2004-09-05 at 13:34, David Palmer wrote:
> Oliver Elphick wrote:
>
> > I now have buildable SQL for these modules:
> >
> > GL General Ledger CB Cashbook SL Sales Ledger PL Purchase Ledger
> >
> > Obviously this is by no means final, but I should be grateful if
> > people would download from CVS and attempt an installation.
> >
> > You need postgresql 7.4 and postgresql-client installed.
>
> Unfortunately, as I have recently made the giant step from apt-get to
> aptitude, this has been about my limit. I have checked as I thought that
> I would need make, and it is installed so it must be part of the base
> install.
It is a standard package.
It should all be pretty simple. Once development is further on and the
system is packaged, the installation scripts will do all that is
necessary.
Install the necessary packages - you will need to have
/etc/apt/sources.list pointing at testing or unstable, since PostgreSQL
7.2 (from stable) won't handle schemas:
# apt-get install postgresql cpp make cvs
(you don't need to choose a local CVS repository, since you aren't
creating your own projects)
Create an advacs directory:
$ mkdir /some/path/to/advacs
and cd into it:
$ cd /some/path/to/advacs
Download the project modules:
$ cvs -z3 -d:ext:developername@cvs.alioth.debian.org:/cvsroot/advacs co sql
$ cvs -z3 -d:ext:developername@cvs.alioth.debian.org:/cvsroot/advacs co docs
or for anonymous (read-only) access:
$ cvs -z3 -d:pserver:anonymous@cvs.alioth.debian.org:/cvsroot/advacs co sql
$ cvs -z3 -d:pserver:anonymous@cvs.alioth.debian.org:/cvsroot/advacs co docs
(password for pserver: just press return)
(As the project is developed, keep the local copy up to date thus:
$ cd /some/path/to/advacs/sql
$ cvs -z3 update -d -P
$ cd /some/path/to/advacs/docs
$ cvs -z3 update -d -P
)
Make yourself an administrative user of postgresql:
$ su
# su - postgres
$ createuser -a -d mylogin
$ exit
# exit
...or do all the schema creation while logged into Linux as such an
administrative user.
Create the schemas:
$ cd /some/path/to/advacs/sql/GL
$ make install
$ cd ../SL
$ make install
$ cd ../PL
$ make install
$ cd ../CB
$ make install
At the moment, only the user who installs them has any permissions on
the schemas that are created; other PostgreSQL users will not be able to
access them.
> I will get on top of this and CVS, but along with other
> responsibilities, I regret that I'm not going to be of much use in this
> regard initially.
The above is just about all you will need for now.
> > Download the sql module and start in sql/GL. Each Makefile provides
> > these targets: all, install, clean and purge:
> >
> > all creates the SQL script install does "all" and "purge" and then
> > runs the SQL script to create the schema clean removes the SQL script
> > and the auxiliary files used to create it purge does "clean" and
> > also drops the schema
> >
> > Do "make install" in each module (sql/GL sql/CB sql/PL sql/SL) Each
> > install should run without errors; if you hit any problems, let me
> > know.
> >
> > You need to set the search_path so as to see all the schemas. Run
> > the following command (all on one line):
> >
> > psql -d advacs -c "ALTER DATABASE advacs SET SEARCH_PATH TO
> > sl,pl,cb,gl,core,public"
You can skip this last bit now; I've put it into the Makefiles.
> > Then take a look at the schema and consider what might be missing.
>
> This is something else, complete with scary music.
Don't worry - just run the commands and ask for help if you get stuck!
> I've read up on make, by way of Pinfo, but there's a bit of a quantum
> leap between here and there.
> I will get on top of it, but at the moment I'll be (slightly) more
> functional with the docs.
You don't actually need to know any more than how to type in the command
"make install". Almost all of the make documentation is about how to
write makefiles.
> I'm working on html at the moment, and as each stage materialises I'll
> forward it to the group for perusal/approval. That's if there's no
> restriction on file sizes/types on the list, and then perhaps someone
> could handle the upload for me.
> I started off writing something before I realised how much Oliver had
> done in this regard. A lot of what I had written was superfluous, but
> I've put in a little of what I have done where I thought it might not
> have over application, and that will be ready soon.
The advacs.html documents are automatically generated and will be
refreshed frequently as the schemas are developed. I will also try to
keep the diagrams (advacs.dia) up to date. Everything else I have
written is in text files, which you can just convert into HTML or XML by
inserting appropriate tags.
> I thought that I would do the main documentation first in html, as xml
> can be nested within that environment, and things like man pages are
> summaries of the main docs.
I thought that HTML was something that was generated from docbook source
along with everything else?
> This might help you, Helmut, if I handle the writing and format, all you
> will need to do is the translation.
>
> Not being able to download and run is a bit of a handicap as far as
> writing documentation for something, though.
I hope the above instructions will be sufficient. Any way, at the
moment, there are only things to look at, not to run, except the
installation process itself.
> I might have to bother you people with some questions.
> It won't be too bad, I'm no accountant, but very familiar with aspects
> such as cash/stock balance imprest systems and production costings.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"He hath not dealt with us after our sins; nor rewarded
us according to our iniquities. For as the heaven is
high above the earth, so great is his mercy toward
them that fear him. As far as the east is from the
west, so far hath he removed our transgressions from
us." Psalms 103:10-12