[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] Database install
From: |
Geordie |
Subject: |
[Gnumed-devel] Database install |
Date: |
Wed, 8 Oct 2008 12:35:44 -0400 |
User-agent: |
KMail/1.9.9 |
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
- [Gnumed-devel] Database install,
Geordie <=