[Gnumed-devel] Database install

[Geordie]

HI
A while back I messed up Apache2 trying to get ssl certificates to work. 
Remove -- purge did not help or clean up all the details. So I decided to 
install a new system. With this senario in mind I fired up virtualbox and 
thought I give the Debian Testing package available form 
http://wiki.gnumed.de/bin/view/Gnumed/InstallerGuideKno a try and installed 
this in Virtual Box. Well to my surprise up pops a Gnome interface and I 
expected to see a running version of gnumed installed. It was not included 
and then I read the install instruction -I know I should read these first but 
heh damn the torpedo's lets go. I had to mess with a punch of scripts to 
install no thankyou. So blew that out. If I am going to install scripts I 
will do it on a fresh install. So off I went,downloaded the business card 
install for Debian testing (lenny) and a way we went. As usual something was 
not quite right and the kde desktop did not initialize. Also acpi was 
processing all sorts of errors and the interface was just plain ugly. Enough 
of this, I installed the latest version of sidux. An hour later I was up and 
running and everything worked -wonderful. By the way that CD install took the 
better part of night 6-8 hours to download and install. 
So what has this got to do gnumed. Well I installed gnumed, set up postrges 
and got nothing. The bootstrap stalled at V2 and I could not connect to 
salaam. No I did not send the error logs. 
However, after installing gnumed, I installed Ledgersmb which requires 
Postgres and Apache2. I had to mess with pg_hba but six command lines later 
for postgres and one for Apache Ledgersmb was up and running. It was not 
super simple but it worked. I know you guys have spent a lot of time on 
gnumed, but I wonder if you made it too complicated.
I was wondering if it is possible to install  gnumed like the instruction set 
for Ledgersmb or I am I making this more complicated
I have included the install directions for Ledgersmb dealing with Postgres

$ createuser --no-superuser --createdb --no-createrole \
+               -U postgres --pwprompt --encrypted ledgersmb
+
+  Here it will prompt twice for the new ledgersmb database 
+  user password, remember what you enter here for step 5.
+
+  2) Create postgres database for ledgersmb
+
+       $ createdb -U ledgersmb -O ledgersmb -E UNICODE ledgersmb
+
+  Depending on the configuration of your daabase, you may need to edit 
+  /etc/postgresql/8.x/main/pg_hba.conf for the appropriate permissions.
+
+        $ createlang plpgsql -U postgres ledgersmb
+
+  3) Add databases for all datasets which you want to have available
+
+  For instance, we want a dataset for each of examplecom, exampleorg and 
+  examplenet, so...
+
+       $ createdb -T ledgersmb examplecom
+       $ createdb -T ledgersmb exampleorg
+       $ createdb -T ledgersmb examplenet
+
+  4) Populate the user database and set an admin password (this admin 
password
+  will be used to log into the administrative interface).

        $ psql -U ledgersmb -dledgersmb -f 
/usr/share/ledgersmb/sql/Pg-central.sql 
        $ psql -U ledgersmb -d ledgersmb
ledgersmb=> UPDATE users_conf SET password = md5('apassword') WHERE id = 1;
and then there is a symbolic link to Apache

I have one more question. Have you tried running the usb stick setup on a 
WindowsXp VirtualBox? If So are there any complications? Notice I am asking 
before I play.
Many thanks
Geordie