Re: [Gnumed-devel] installing and using gnumed

[Roberto Mello]

On Fri, Oct 31, 2003 at 10:07:54AM +0100, Karsten Hilbert wrote:
> > With the bootstrap-public_db.conf I get the error after the password. 
> use bootstrap-monolithic_core.conf

Ok, I tried that after fixing what was wrong in my pg_hba.conf (gathered
it from the logs after I saw where they were).

The bootstrap program ran, but I noticed several PostgreSQL ERROR messages
flying by, so I wanted to check them. To do that I started redirecting
stderr to a pg-out file like this:

$ ./bootstrap-gm_db_system.py --conf-file=bootstrap-monolithic_core.conf 
--log-file=./foo 2> pg-out.txt

This tells me that the bootstrap script has a bug because an interactive
question is going into stderr which is now being redirected:

---
...
Do you really want to install this database setup ?
yes  <-- The "Type yes or no:" question has been redirected to the pg-out file
...
---

Now the bootstrap doesn't work anymore. Understandable, I think to myself,
since now things have been created, although it should check and ask me if
I want to drop them or not.

So I start trying to DROP the database and users it created. the
"dropuser" PostgreSQL only takes one user at a time, so I write some bash
magic:

for USER in gm-dbowner test-doc _test_doc test-nurse _test-nurse test-secretary 
_test-secretary; do dropuser $USER; done;

Run the bootstrap script again, no go. I get the following in the log:

2003-10-31 11:55:53 [WARN]  (./bootstrap-gm_db_system.py::__create_db:651): 
exception type : libpq.Warning
2003-10-31 11:55:53 [WARN]  (./bootstrap-gm_db_system.py::__create_db:651): 
exception value: WARNING:  ROLLBACK: no transaction in progress

2003-10-31 11:55:53 [DATA]  (./bootstrap-gm_db_system.py::__create_db:651): 
Traceback (most recent call last):<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA]  (./bootstrap-gm_db_system.py::__create_db:651):   
File "./bootstrap-gm_db_system.py", line 649, in __create_db<#10-0x0A-lf>    
cursor.execute(cmd)<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA]  (./bootstrap-gm_db_system.py::__create_db:651):   
File "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 3069, in 
execute<#10-0x0A-lf>    raise Warning, self.conn.notices.pop()<#10-0x0A-lf>
2003-10-31 11:55:53 [DATA]  (./bootstrap-gm_db_system.py::__create_db:651): 
Warning: WARNING:  ROLLBACK: no transaction in 
progress<#10-0x0A-lf><#10-0x0A-lf>
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772): 
Cannot bootstrap service [config].
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772): 
exception type : libpq.Warning
2003-10-31 11:55:53 [PANIC] (./bootstrap-gm_db_system.py::bootstrap:772): 
exception value: WARNING:  COMMIT: no transaction in progress


So the question is, what do I need to do in order to 
"start from scratch" the bootstrap process? It looks like I need to drop
some groups. 

Should I just go through the SQL file and reverse them manually? Is there
a better way besides reinstalling PostgreSQL?

Thanks,

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
NT = Nice Try...