Fresh cvs update a few minutes ago.
Still won't complete
. Before running the script I deleted gnumed_v2 and gm-dbo manually. I said
yes to everything and typed in 'password' as the password for gm--dbo. BTW,
your text here is ambiguous, you asd for the password for gm-dbo when it does
not exist. You could change the script text here to ask for the existing
password for this owner, or enter a new password if it doesn't exist.
Regards
Richard
On Tuesday 06 December 2005 03:21, Karsten Hilbert wrote:
> On Mon, Dec 05, 2005 at 09:21:18AM +1100, Richard wrote:
> > There is still a syntax error in your install, see attatched log file
> > (Fresh CVS right now - I mean completely new tree - deleted previous
> > one).
>
> Your PG 8.1 probably has check_function_headers set to yes.
> Which is good as it unearthed the below bug. Which is now
> fixed.
>
> Karsten
2005-12-06 07:50:59 ------------------------------------------------------------
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: initial log level is [INFO]
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): 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-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): $Revision: 1.31 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): $Revision: 1.5 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): $Revision: 1.59 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): $Revision: 1.13 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): text domain is [bootstrap_gm_db_system]
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set
2005-12-06 07:50:59 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): Giving up and falling back to NullTranslations() class in despair.
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): 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-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): client encoding according to locale system: [ISO-8859-1]
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.24 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.14 $
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: log level change from [INFO] to [DATA]
2005-12-06 07:50:59 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): startup ($Revision: 1.16 $)
2005-12-06 07:50:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-local_first.conf>)
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-06 07:50:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf']
2005-12-06 07:50:59 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf]
2005-12-06 07:50:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf]
2005-12-06 07:50:59 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf,v $] ($Revision: 1.4 $)
2005-12-06 07:50:59 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-06 07:50:59 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-06 07:51:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-monolithic_core.conf>)
2005-12-06 07:51:00 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-06 07:51:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf']
2005-12-06 07:51:00 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf]
2005-12-06 07:51:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf]
2005-12-06 07:51:00 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf,v $] ($Revision: 1.41 $)
2005-12-06 07:51:00 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-06 07:51:00 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [config]
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): if environment variable [GM_CORE_DB] exists, it override database name in config file
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping server [local host]
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connecting to server template database
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as postgres
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected to template database [template1]
2005-12-06 07:51:01 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database users and groups
2005-12-06 07:51:01 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): option <password> not found in group [user GnuMed owner]
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): User [gm-dbo] does not exist.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): User [gm-dbo] exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-doctors exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_medical exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_office exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_medical exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_office exists.
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-public exists.
2005-12-06 07:51:05 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): CREATE USER "any-doc"
WITH PASSWORD 'any-doc'
IN GROUP "gm-doctors", "gm-public"
2005-12-06 07:51:05 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists
2005-12-06 07:51:05 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmPublicAccounts.sql,v $', '$Revision: 1.7 $')
2005-12-06 07:51:05 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmPublicAccounts.sql:30: ERROR: relation "gm_schema_revision" does not exist
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmPublicAccounts.sql]
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmTestAccounts.sql]
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as gm-dbo
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 07:51:05 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] does not exist.
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] exists.
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Successfully created GNUmed database [gnumed_v2].
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as postgres
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping procedural languages
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installing procedural language [pg/SQL]
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql does not exist.
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql exists.
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): procedural language [pg/SQL] successfully installed
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as gm-dbo
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevision.sql]
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevisionViews.sql]
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmServices.sql]
2005-12-06 07:51:06 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view v_missing_translations
2005-12-06 07:51:06 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmI18N.sql:223: ERROR: view "v_missing_translations" does not exist
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmI18N.sql]
2005-12-06 07:51:06 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit.sql]
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_ins on audit_fields cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:94: ERROR: rule "audit_fields_no_ins" for relation "audit_fields" does not exist
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_upd on audit_fields cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:95: ERROR: rule "audit_fields_no_upd" for relation "audit_fields" does not exist
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_del on audit_fields cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:96: ERROR: rule "audit_fields_no_del" for relation "audit_fields" does not exist
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_ins on audit_trail cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:117: ERROR: rule "audit_trail_no_ins" for relation "audit_trail" does not exist
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_upd on audit_trail cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:118: ERROR: rule "audit_trail_no_upd" for relation "audit_trail" does not exist
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_del on audit_trail cascade
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:119: ERROR: rule "audit_trail_no_del" for relation "audit_trail" does not exist
2005-12-06 07:51:07 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit-dynamic.sql]
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function add_x_db_fk_def (name, name, text, name, name)
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmCrossDB_FKs.sql:61: ERROR: function add_x_db_fk_def(name, name, text, name, name) does not exist
2005-12-06 07:51:07 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmCrossDB_FKs.sql]
2005-12-06 07:51:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): 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-06 07:51:07 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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-06 07:51:07 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): failed to import [../sql/gmCrossDB_FK-views.sql]
2005-12-06 07:51:07 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cannot import schema definition for database [gnumed_v2]
2005-12-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap service [config].
2005-12-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exception type : Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exception value: database.__init__(): Cannot bootstrap database.
2005-12-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Traceback (most recent call last):<#10-0x0A-lf>
2005-12-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ConstructorError: database.__init__(): Cannot bootstrap database.<#10-0x0A-lf>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): locals by frame, outmost frame first
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [?] in [./bootstrap_gm_db_system.py] at line 1423 <<<
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_auditing = <function bootstrap_auditing at 0xb77c3bfc>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): db_server = __main__.db_server
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cfg_file = bootstrap-monolithic_core.conf
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmLog = <module 'Gnumed.pycommon.gmLog' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): getpass = <module 'getpass' from '/usr/lib/python2.4/getpass.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): dsn_format = %s:%s:%s:%s:%s
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _interactive = 1
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connect = <function connect at 0xb77c356c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ConstructorError = Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): fileinput = <module 'fileinput' from '/usr/lib/python2.4/fileinput.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_services = <function bootstrap_services at 0xb77c35a4>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _import_schema = <function _import_schema at 0xb77c3cdc>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): dbapi = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_notifications = <function bootstrap_notifications at 0xb77c3c34>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): handle_cfg = <function handle_cfg at 0xb77c3df4>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _run_query = <function _run_query at 0xb77c3c6c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aud_gen = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): become_pg_demon_user = <function become_pg_demon_user at 0xb77c3d84>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exit_with_msg = <function exit_with_msg at 0xb77c3d14>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): libpq = <module 'pyPgSQL.libpq' from '/usr/lib/python2.4/site-packages/pyPgSQL/libpq/__init__.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): notify_gen = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): db_error = libpq.DatabaseError
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmService = __main__.gmService
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): re = <module 're' from '/usr/lib/python2.4/re.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmCfg = <module 'Gnumed.pycommon.gmCfg' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ask_for_confirmation = <function ask_for_confirmation at 0xb77c3ca4>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _bootstrapped_servers = {'local host': <__main__.db_server instance at 0xb77bafac>}
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __version__ = $Revision: 1.16 $
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __file__ = ./bootstrap_gm_db_system.py
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _dbowner = <__main__.user instance at 0xb77baf4c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): string = <module 'string' from '/usr/lib/python2.4/string.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __license__ = GPL
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): show_msg = <function show_msg at 0xb77c3d4c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __builtins__ = <module '__builtin__' (built-in)>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): glob = <module 'glob' from '/usr/lib/python2.4/glob.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _cfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb77c966c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): get_cfg_in_nice_mode = <function get_cfg_in_nice_mode at 0xb77c3dbc>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __author__ = [EMAIL PROTECTED]
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): sys = <module 'sys' (built-in)>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _bootstrapped_dbs = {}
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _keep_temp_files = True
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cached_passwd = {'gm-dbo': 'password', 'postgres': ''}
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _log = <Gnumed.pycommon.gmLog.cLogger instance at 0xb7ba6c2c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cached_host = ('', '')
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __name__ = __main__
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmAuditSchemaGenerator = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database = __main__.database
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmPsql = <module 'Gnumed.pycommon.gmPsql' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): PgSQL = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): time = <module 'time' from '/usr/lib/python2.4/lib-dynload/time.so'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmNotificationSchemaGenerator = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): os = <module 'os' from '/usr/lib/python2.4/os.pyc'>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): no_clues =
Logging on to the PostgreSQL database returned this error
%s
on %s
Please contact the GNUmed development team on [EMAIL PROTECTED]
Make sure you include this error message in your mail.
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): user = __main__.user
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [handle_cfg] in [./bootstrap_gm_db_system.py] at line 1393 <<<
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): tmp = yes
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [bootstrap_services] in [./bootstrap_gm_db_system.py] at line 1148 <<<
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): services = ['config', 'reference', 'demographics', 'clinical', 'documents', 'office']
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service_alias = config
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service = <__main__.gmService instance at 0xb77bafec>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [bootstrap] in [./bootstrap_gm_db_system.py] at line 903 <<<
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database_alias = core
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): self = <__main__.gmService instance at 0xb77bafec>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [__init__] in [./bootstrap_gm_db_system.py] at line 530 <<<
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aCfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb77c966c>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): self = <__main__.database instance at 0xb77bafcc>
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): overrider = GM_CORE_DB
2005-12-06 07:51:07 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aDB_alias = core
2005-12-06 07:51:07 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap services.
2005-12-06 07:51:07 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): shutdown
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
