2005-12-05 09:09:37 ------------------------------------------------------------
2005-12-05 09:09:37 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: initial log level is [INFO]  
2005-12-05 09:09:37 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): instantiated log file /home/richard/gnumed/gnumed/server/bootstrap/redo-v2.log with ID /home/richard/gnumed/gnumed/server/bootstrap/redo-v2.log
2005-12-05 09:09:37 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): $Revision: 1.31 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): $Revision: 1.5 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): $Revision: 1.58 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): $Revision: 1.13 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): text domain is [bootstrap_gm_db_system]
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set
2005-12-05 09:09:38 [WARN]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): Giving up and falling back to NullTranslations() class in despair.
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): PostgreSQL via DB-API module "<module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>": API level 2.0, thread safety 1, parameter style "pyformat"
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): client encoding according to locale system: [ISO-8859-1]
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:address@hidden): $Revision: 1.24 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:address@hidden): $Revision: 1.14 $
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: log level change from [INFO]   to [DATA]  
2005-12-05 09:09:38 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): startup ($Revision: 1.16 $)
2005-12-05 09:09:38 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (<aDir=None>, <aName=bootstrap-local_first.conf>)
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-05 09:09:38 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf']
2005-12-05 09:09:38 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf]
2005-12-05 09:09:38 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf]
2005-12-05 09:09:38 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf,v $] ($Revision: 1.4 $)
2005-12-05 09:09:38 [WARN]  (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user
2005-12-05 09:09:38 [WARN]  (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-05 09:11:10 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (<aDir=None>, <aName=bootstrap-monolithic_core.conf>)
2005-12-05 09:11:10 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-05 09:11:10 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf']
2005-12-05 09:11:10 [INFO]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf]
2005-12-05 09:11:10 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf]
2005-12-05 09:11:10 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf,v $] ($Revision: 1.41 $)
2005-12-05 09:11:10 [WARN]  (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user
2005-12-05 09:11:10 [WARN]  (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [config]
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core]
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): if environment variable [GM_CORE_DB] exists, it override database name in config file
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping server [local host]
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): connecting to server template database
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as postgres
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully connected
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully connected to template database [template1]
2005-12-05 09:11:11 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database users and groups
2005-12-05 09:11:11 [WARN]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): option <password> not found in group [user GnuMed owner]
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): User [gm-dbo] exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-doctors exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_medical exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_office exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_medical exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_office exists.
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Group gm-public exists.
2005-12-05 09:11:13 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): CREATE USER "any-doc"
	WITH PASSWORD 'any-doc'
	IN GROUP "gm-doctors", "gm-public"

2005-12-05 09:11:13 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:26: ERROR:  role "any-doc" already exists
2005-12-05 09:11:13 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmPublicAccounts.sql,v $', '$Revision: 1.7 $')
2005-12-05 09:11:13 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:30: ERROR:  relation "gm_schema_revision" does not exist
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmPublicAccounts.sql]
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmTestAccounts.sql]
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as gm-dbo
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully connected
2005-12-05 09:11:13 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] does not exist.
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] exists.
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Successfully created GNUmed database [gnumed_v2].
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as postgres
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully connected
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): bootstrapping procedural languages
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): installing procedural language [pg/SQL]
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql does not exist.
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql exists.
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): procedural language [pg/SQL] successfully installed
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as gm-dbo
2005-12-05 09:11:14 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully connected
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevision.sql]
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevisionViews.sql]
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmServices.sql]
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop view v_missing_translations
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmI18N.sql:223: ERROR:  view "v_missing_translations" does not exist
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N.sql]
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit.sql]
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_fields_no_ins on audit_fields cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:94: ERROR:  rule "audit_fields_no_ins" for relation "audit_fields" does not exist
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_fields_no_upd on audit_fields cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:95: ERROR:  rule "audit_fields_no_upd" for relation "audit_fields" does not exist
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_fields_no_del on audit_fields cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:96: ERROR:  rule "audit_fields_no_del" for relation "audit_fields" does not exist
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_trail_no_ins on audit_trail cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:117: ERROR:  rule "audit_trail_no_ins" for relation "audit_trail" does not exist
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_trail_no_upd on audit_trail cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:118: ERROR:  rule "audit_trail_no_upd" for relation "audit_trail" does not exist
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop rule audit_trail_no_del on audit_trail cascade
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:119: ERROR:  rule "audit_trail_no_del" for relation "audit_trail" does not exist
2005-12-05 09:11:15 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit-dynamic.sql]
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): 
drop function add_x_db_fk_def (name, name, text, name, name)
2005-12-05 09:11:15 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmCrossDB_FKs.sql:61: ERROR:  function add_x_db_fk_def(name, name, text, name, name) does not exist
2005-12-05 09:11:16 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmCrossDB_FKs.sql]
2005-12-05 09:11:16 [DATA]  (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): create or replace function add_x_db_fk_def (name, name, text, name, name) returns unknown as '
DECLARE
	src_table ALIAS FOR $1;
	src_col ALIAS FOR $2;
	ext_srvc ALIAS FOR $3;
	ext_tbl ALIAS FOR $4;
	ext_column ALIAS FOR $5;
	dummy RECORD;
	msg text;
BEGIN
	-- src table exists ?
	select relname into dummy from pg_class where relname = src_table;
	if not found then
		raise exception ''add_x_db_fk_def: Source table [%] does not exist.'', src_table;
		return false;
	end if;
	-- src column exists ?
	select pgc.relname into dummy from pg_class pgc, pg_attribute pga where
		pgc.relname = src_table
			and
		pga.attrelid = pgc.oid
			and
		pga.attname = src_col;
	if not found then
		-- FIXME: find out how to pass in table AND column
		msg = ''add_x_db_fk_def: Source column ['' || src_col || ''] not found in source table ['' || src_table || ''].''
		raise exception msg;
		return false;
	end if;
	-- add definition
	insert into x_db_fk (
		fk_src_table, fk_src_col, ext_service, ext_table, ext_col
	) values (
		src_table, src_col, ext_srvc, ext_tbl, ext_column
	);
	return true;
END;' language 'plpgsql'
2005-12-05 09:11:16 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmCrossDB_FK-views.sql:50: ERROR:  syntax error at or near "raise" at character 103QUERY:  SELECT  'add_x_db_fk_def: Source column [' ||  $1  || '] not found in source table [' ||  $2  || '].' raise exception  $3 CONTEXT:  SQL statement in PL/PgSQL function "add_x_db_fk_def" near line 26
2005-12-05 09:11:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): failed to import [../sql/gmCrossDB_FK-views.sql]
2005-12-05 09:11:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): cannot import schema definition for database [gnumed_v2]
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap service [config].
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden): exception type : Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden): exception value: database.__init__(): Cannot bootstrap database.
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden): Traceback (most recent call last):<#10-0x0A-lf>
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden):   File "./bootstrap_gm_db_system.py", line 901, in bootstrap<#10-0x0A-lf>    database(aDB_alias = database_alias, aCfg = _cfg)<#10-0x0A-lf>
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden):   File "./bootstrap_gm_db_system.py", line 530, in __init__<#10-0x0A-lf>    raise ConstructorError, "database.__init__(): Cannot bootstrap database."<#10-0x0A-lf>
2005-12-05 09:11:16 [PANIC] (./bootstrap_gm_db_system.py:address@hidden): ConstructorError: database.__init__(): Cannot bootstrap database.<#10-0x0A-lf>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): locals by frame, outmost frame first
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): >>> execution frame [?] in [./bootstrap_gm_db_system.py] at line 1423 <<<
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):   bootstrap_auditing = <function bootstrap_auditing at 0xb783d8ec>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            db_server = __main__.db_server
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             cfg_file = bootstrap-monolithic_core.conf
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                gmLog = <module 'Gnumed.pycommon.gmLog' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):              getpass = <module 'getpass' from '/usr/lib/python2.4/getpass.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):           dsn_format = %s:%s:%s:%s:%s
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):         _interactive = 1
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):              connect = <function connect at 0xb783d25c>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):     ConstructorError = Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            fileinput = <module 'fileinput' from '/usr/lib/python2.4/fileinput.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):        pg_hba_sermon = 
I have found a connection to the database, but I am forbidden
to connect due to the settings in pg_hba.conf. This is a
PostgreSQL configuration file that controls who can connect
to the database.

Depending on your setup, it can be found in
/etc/postgresql/pg_hba.conf (Debian)
/usr/local/pgsql/pgdata/pg_hba.conf (FreeBSD, ?? Mac OS X)
FIXME: where do RedHat & friends put it
 or whichever directory your database files are located.

For gnumed, pg_hba.conf must allow password authentication.
For deveopment systems, I suggest the following

local    template1 postgres                             ident sameuser
local    gnumed    all                                  md5
host     gnumed    all    127.0.0.1 255.255.255.255     md5

For production systems, a different configuration will be
required, but gnumed is not production ready.
There is also a pg_hba.conf.example in this directory.

You must then restart (or SIGHUP) your PostgreSQL server.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):   bootstrap_services = <function bootstrap_services at 0xb783d294>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):       _import_schema = <function _import_schema at 0xb783d9cc>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                dbapi = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): bootstrap_notifications = <function bootstrap_notifications at 0xb783d924>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):           handle_cfg = <function handle_cfg at 0xb783dae4>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):           _run_query = <function _run_query at 0xb783d95c>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):              aud_gen = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): become_pg_demon_user = <function become_pg_demon_user at 0xb783da74>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):        exit_with_msg = <function exit_with_msg at 0xb783da04>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                libpq = <module 'pyPgSQL.libpq' from '/usr/lib/python2.4/site-packages/pyPgSQL/libpq/__init__.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):           notify_gen = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             db_error = libpq.DatabaseError
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            gmService = __main__.gmService
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                   re = <module 're' from '/usr/lib/python2.4/re.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                gmCfg = <module 'Gnumed.pycommon.gmCfg' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): ask_for_confirmation = <function ask_for_confirmation at 0xb783d994>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): _bootstrapped_servers = {'local host': <__main__.db_server instance at 0xb783c56c>}
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):          __version__ = $Revision: 1.16 $
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):     no_server_sermon = 
I cannot find a PostgreSQL server running on this machine.

Try (as root):
/etc/init.d/postgresql start

if that fails, you can build a database from scratch:

PGDATA=some directory you can use
initdb
cp pg_hba.conf.example $PGDATA/pg_hba.conf
pg_ctl start 

if none of these commands work, or you don't know what PostgreSQL
is, go to the website to download for your OS at:

http://www.postgresql.org/

On the other hand, if you have a PostgreSQL server
running somewhere strange, type hostname[:port]
below, or press RETURN to quit.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             __file__ = ./bootstrap_gm_db_system.py
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             _dbowner = <__main__.user instance at 0xb783c5ac>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):               string = <module 'string' from '/usr/lib/python2.4/string.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):          __license__ = GPL
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             show_msg = <function show_msg at 0xb783da3c>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):         __builtins__ = <module '__builtin__' (built-in)>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 glob = <module 'glob' from '/usr/lib/python2.4/glob.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 _cfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb783c92c>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): get_cfg_in_nice_mode = <function get_cfg_in_nice_mode at 0xb783daac>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):           __author__ = address@hidden
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                  sys = <module 'sys' (built-in)>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):    _bootstrapped_dbs = {}
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):     _keep_temp_files = True
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):        cached_passwd = {'gm-dbo': '', 'postgres': ''}
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 _log = <Gnumed.pycommon.gmLog.cLogger instance at 0xb7ba16ec>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):          cached_host = ('', '')
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             __name__ = __main__
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):     superuser_sermon = 
I can't log on as the PostgreSQL database owner.
Try running this script as the system administrator (user "root")
to get the neccessary permissions.

NOTE: I expect the PostgreSQL database owner to be called "%s"
If for some reason it is not, you need to adjust my configuration
script, and run again as that user.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): gmAuditSchemaGenerator = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             database = __main__.database
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):               gmPsql = <module 'Gnumed.pycommon.gmPsql' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            cfg_files = ['bootstrap-local_first.conf', 'bootstrap-monolithic_core.conf', 'bootstrap-de.conf', 'bootstrap-es.conf', 'bootstrap-ca.conf', 'bootstrap-au.conf', 'bootstrap-test_data.conf', 'bootstrap-local_last.conf']
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):              __doc__ = GNUmed schema installation.

This script bootstraps a GNUmed database system. All the
infrastructure is in place to support distributed
services. However, until further notice one should stick
to monolithic database design as cross-database links
are not well supported yet.

This will set up databases, services, database tables,
groups, permissions and possibly users.

There's a special user called "gm-dbo" who owns all the
database objects.

For all this to work you must be able to access the database
server as the standard "postgres" superuser.

This script does NOT set up user specific configuration options.

All definitions are loaded from a config file.

Please consult the User Manual in the GNUmed CVS for
further details.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                PgSQL = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):       welcome_sermon = 
Welcome to the GNUmed server instllation script.

You must have a PostgreSQL server running and
administrator access.

Please select a database configuation from the list below.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 time = <module 'time' from '/usr/lib/python2.4/lib-dynload/time.so'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): gmNotificationSchemaGenerator = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                   os = <module 'os' from '/usr/lib/python2.4/os.pyc'>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             no_clues = 
Logging on to the PostgreSQL database returned this error
%s
on %s

Please contact the GNUmed development team on address@hidden
Make sure you include this error message in your mail.

2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 user = __main__.user
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): >>> execution frame [handle_cfg] in [./bootstrap_gm_db_system.py] at line 1393 <<<
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                  tmp = yes
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): >>> execution frame [bootstrap_services] in [./bootstrap_gm_db_system.py] at line 1148 <<<
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):             services = ['config', 'reference', 'demographics', 'clinical', 'documents', 'office']
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):        service_alias = config
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):              service = <__main__.gmService instance at 0xb783c5ec>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): >>> execution frame [bootstrap] in [./bootstrap_gm_db_system.py] at line 903 <<<
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):       database_alias = core
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 self = <__main__.gmService instance at 0xb783c5ec>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden): >>> execution frame [__init__] in [./bootstrap_gm_db_system.py] at line 530 <<<
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 aCfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb783c92c>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):                 self = <__main__.database instance at 0xb783c5cc>
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            overrider = GM_CORE_DB
2005-12-05 09:11:16 [DATA]  (./bootstrap_gm_db_system.py:address@hidden):            aDB_alias = core
2005-12-05 09:11:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap services.
2005-12-05 09:11:16 [INFO]  (./bootstrap_gm_db_system.py:address@hidden): shutdown