I'm trying to get gnumed running again, without luck.
I enclose my pg_hba.conf with suggestions as per your log file, and the
redo-public.log result.
user richard has full postgres privileges. I have tried running a richard
(which always used to work) and root (as suggestedin your log file).
Perhaps you could understand the logic of the script. It seems to create the
db, then the user gm-db to own the database (so how can I know what the
password is). Does it assume the password is blank,
Anyhow, I was hoping to get it working on Monday to show the IT people from
Newcastle, so hopefully you could help.
Postgres version is:8.1
Thanks in anticipation.
Richard
2005-12-02 17:31:41 ------------------------------------------------------------
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: initial log level is [INFO]
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): instantiated log file /home/richard/gnumed/gnumed/server/bootstrap/redo-public.log with ID /home/richard/gnumed/gnumed/server/bootstrap/redo-public.log
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): $Revision: 1.31 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): $Revision: 1.5 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): $Revision: 1.58 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): $Revision: 1.13 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): text domain is [bootstrap_gm_db_system]
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set
2005-12-02 17:31:41 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): Giving up and falling back to NullTranslations() class in despair.
2005-12-02 17:31:41 [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-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): client encoding according to locale system: [ISO-8859-1]
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.23 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.13 $
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: log level change from [INFO] to [DATA]
2005-12-02 17:31:41 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): startup ($Revision: 1.15 $)
2005-12-02 17:31:41 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-local_first.conf>)
2005-12-02 17:31:41 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-02 17:31:41 [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-02 17:31:41 [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-02 17:31:41 [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-02 17:31:41 [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-02 17:31:41 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-02 17:31:41 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-02 17:31:43 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-monolithic_core.conf>)
2005-12-02 17:31:43 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-02 17:31:43 [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-02 17:31:43 [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-02 17:31:43 [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-02 17:31:43 [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.40 $)
2005-12-02 17:31:43 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-02 17:31:43 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): may have trouble connecting as gm-dbo if IDENT auth is forced upon us
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [config]
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): if environment variable [GM_CORE_DB] exists, it override database name in config file
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): environment variable [GM_CORE_DB] is not set, using database name from config file
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping server [local host]
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connecting to server template database
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as postgres
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected to template database [template1]
2005-12-02 17:31:44 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database users and groups
2005-12-02 17:31:44 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): option <password> not found in group [user GnuMed owner]
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): User [gm-dbo] exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-doctors exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_medical exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_office exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_medical exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_office exists.
2005-12-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-public exists.
2005-12-02 17:31:45 [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-02 17:31:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists
2005-12-02 17:31:45 [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-02 17:31:45 [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-02 17:31:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmPublicAccounts.sql]
2005-12-02 17:31:46 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmTestAccounts.sql]
2005-12-02 17:31:46 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as gm-dbo
2005-12-02 17:31:46 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-02 17:31:46 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed] does not exist.
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed] exists.
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Successfully created GNUmed database [gnumed].
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed on localhost as postgres
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping procedural languages
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installing procedural language [pg/SQL]
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql does not exist.
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql exists.
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): procedural language [pg/SQL] successfully installed
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed on localhost as gm-dbo
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevision.sql]
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevisionViews.sql]
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmServices.sql]
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view v_missing_translations
2005-12-02 17:31:47 [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-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmI18N.sql]
2005-12-02 17:31:47 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit.sql]
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_ins on audit_fields cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:95: ERROR: rule "audit_fields_no_ins" for relation "audit_fields" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_upd on audit_fields cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:96: ERROR: rule "audit_fields_no_upd" for relation "audit_fields" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_del on audit_fields cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:97: ERROR: rule "audit_fields_no_del" for relation "audit_fields" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_ins on audit_trail cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:118: ERROR: rule "audit_trail_no_ins" for relation "audit_trail" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_upd on audit_trail cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:119: ERROR: rule "audit_trail_no_upd" for relation "audit_trail" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_del on audit_trail cascade
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:120: ERROR: rule "audit_trail_no_del" for relation "audit_trail" does not exist
2005-12-02 17:31:47 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
select log_script_insertion('$RCSfile: gmAudit-dynamic.sql,v $', '$Revision: 1.4 $', true)
2005-12-02 17:31:47 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmAudit-dynamic.sql:150: ERROR: function log_script_insertion("unknown", "unknown", boolean) does not existHINT: No function matches the given name and argument types. You may need to add explicit type casts.
2005-12-02 17:31:47 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): failed to import [../sql/gmAudit-dynamic.sql]
2005-12-02 17:31:47 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cannot import schema definition for database [gnumed]
2005-12-02 17:31:47 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap service [config].
2005-12-02 17:31:47 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exception type : Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-02 17:31:47 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exception value: database.__init__(): Cannot bootstrap database.
2005-12-02 17:31:47 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Traceback (most recent call last):<#10-0x0A-lf>
2005-12-02 17:31:47 [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-02 17:31:47 [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-02 17:31:47 [PANIC] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ConstructorError: database.__init__(): Cannot bootstrap database.<#10-0x0A-lf>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): locals by frame, outmost frame first
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [?] in [./bootstrap_gm_db_system.py] at line 1423 <<<
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_auditing = <function bootstrap_auditing at 0xb77c6c6c>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): db_server = __main__.db_server
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cfg_file = bootstrap-monolithic_core.conf
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmLog = <module 'Gnumed.pycommon.gmLog' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): getpass = <module 'getpass' from '/usr/lib/python2.4/getpass.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): dsn_format = %s:%s:%s:%s:%s
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _interactive = 1
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connect = <function connect at 0xb77c65dc>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ConstructorError = Gnumed.pycommon.gmExceptions.ConstructorError
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): fileinput = <module 'fileinput' from '/usr/lib/python2.4/fileinput.pyc'>
2005-12-02 17:31:47 [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-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_services = <function bootstrap_services at 0xb77c6614>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _import_schema = <function _import_schema at 0xb77c6d4c>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): dbapi = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrap_notifications = <function bootstrap_notifications at 0xb77c6ca4>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): handle_cfg = <function handle_cfg at 0xb77c6e64>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _run_query = <function _run_query at 0xb77c6cdc>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aud_gen = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): become_pg_demon_user = <function become_pg_demon_user at 0xb77c6df4>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): exit_with_msg = <function exit_with_msg at 0xb77c6d84>
2005-12-02 17:31:47 [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-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): notify_gen = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): db_error = libpq.DatabaseError
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmService = __main__.gmService
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): re = <module 're' from '/usr/lib/python2.4/re.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmCfg = <module 'Gnumed.pycommon.gmCfg' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.pyc'>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): ask_for_confirmation = <function ask_for_confirmation at 0xb77c6d14>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _bootstrapped_servers = {'local host': <__main__.db_server instance at 0xb77bcf6c>}
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __version__ = $Revision: 1.15 $
2005-12-02 17:31:47 [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-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __file__ = ./bootstrap_gm_db_system.py
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _dbowner = <__main__.user instance at 0xb77bcf4c>
2005-12-02 17:31:47 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): string = <module 'string' from '/usr/lib/python2.4/string.pyc'>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __license__ = GPL
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): show_msg = <function show_msg at 0xb77c6dbc>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __builtins__ = <module '__builtin__' (built-in)>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): glob = <module 'glob' from '/usr/lib/python2.4/glob.pyc'>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _cfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb77cb5ec>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): get_cfg_in_nice_mode = <function get_cfg_in_nice_mode at 0xb77c6e2c>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __author__ = [EMAIL PROTECTED]
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): sys = <module 'sys' (built-in)>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _bootstrapped_dbs = {}
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _keep_temp_files = True
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cached_passwd = {'gm-dbo': '', 'postgres': ''}
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): _log = <Gnumed.pycommon.gmLog.cLogger instance at 0xb7ba6c2c>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): cached_host = ('', '')
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): __name__ = __main__
2005-12-02 17:31:48 [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-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmAuditSchemaGenerator = <module 'gmAuditSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.pyc'>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database = __main__.database
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmPsql = <module 'Gnumed.pycommon.gmPsql' from '/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.pyc'>
2005-12-02 17:31:48 [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-02 17:31:48 [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-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): PgSQL = <module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>
2005-12-02 17:31:48 [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-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): time = <module 'time' from '/usr/lib/python2.4/lib-dynload/time.so'>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): gmNotificationSchemaGenerator = <module 'gmNotificationSchemaGenerator' from '/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.pyc'>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): os = <module 'os' from '/usr/lib/python2.4/os.pyc'>
2005-12-02 17:31:48 [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-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): user = __main__.user
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [handle_cfg] in [./bootstrap_gm_db_system.py] at line 1393 <<<
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): tmp = yes
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [bootstrap_services] in [./bootstrap_gm_db_system.py] at line 1148 <<<
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): services = ['config', 'reference', 'demographics', 'clinical', 'documents', 'office']
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service_alias = config
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service = <__main__.gmService instance at 0xb77bcfec>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [bootstrap] in [./bootstrap_gm_db_system.py] at line 903 <<<
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database_alias = core
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): self = <__main__.gmService instance at 0xb77bcfec>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): >>> execution frame [__init__] in [./bootstrap_gm_db_system.py] at line 530 <<<
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aCfg = <Gnumed.pycommon.gmCfg.cCfgFile instance at 0xb77cb5ec>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): self = <__main__.database instance at 0xb77bcfcc>
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): overrider = GM_CORE_DB
2005-12-02 17:31:48 [DATA] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): aDB_alias = core
2005-12-02 17:31:48 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap services.
2005-12-02 17:31:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): shutdown
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description. A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
# local DATABASE USER METHOD [OPTION]
# host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
#
# DATABASE can be "all", "sameuser", "samegroup", a database name, or
# a comma-separated list thereof.
#
# USER can be "all", a user name, a group name prefixed with "+", or
# a comma-separated list thereof. In both the DATABASE and USER fields
# you can also write a file name prefixed with "@" to include names from
# a separate file.
#
# CIDR-ADDRESS specifies the set of hosts the record matches.
# It is made up of an IP address and a CIDR mask that is an integer
# (between 0 and 32 (IPv6) or 128(IPv6) inclusive) that specifies
# the number of significant bits in the mask. Alternatively, you can write
# an IP address and netmask in separate columns to specify the set of hosts.
#
# METHOD can be "trust", "reject", "md5", "crypt", "password",
# "krb4", "krb5", "ident", or "pam". Note that "password" sends passwords
# in clear text; "md5" is preferred since it sends encrypted passwords.
#
# OPTION is the ident map or the name of the PAM service, depending on METHOD.
#
# Database and user names containing spaces, commas, quotes and other special
# characters must be quoted. Quoting one of the keywords "all", "sameuser" or
# "samegroup" makes the name lose its special character, and just match a
# database or username with that name.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect. You can use
# "pg_ctl reload" to do that.
# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL listen
# on a non-local interface via the listen_addresses configuration parameter,
# or via the -i or -h command line switches.
#
# CAUTION: Configuring the system for local "trust" authentication allows
# any local user to connect as any PostgreSQL user, including the database
# superuser. If you do not trust all your local users, use another
# authentication method.
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
local template1 postgres ident sameuser
local gnumed all md5
host gnumed all 127.0.0.1 255.255.255.255 md5
# IPv4 local connections:
#host all all 127.0.0.1/32 trust
# IPv6 local connections:
# host all all ::1/128 trust
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
