getting closer, it did
==> bootstrapping "reference" ...
==> bootstrapping "demographics" ...
Cannot bootstrap services.
Please check the log file for details.
before crapping. See log.
Richard
PS thanks for the effort.
On Tuesday 06 December 2005 08:41, Karsten Hilbert wrote:
> Richard,
>
> I have put a hammer to the nail. It should work now.
>
> Karsten
2005-12-06 09:02:10 ------------------------------------------------------------
2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: initial log level is [INFO]
2005-12-06 09:02:10 [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 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): $Revision: 1.31 $
2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): $Revision: 1.5 $
2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): $Revision: 1.59 $
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): $Revision: 1.13 $
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): text domain is [bootstrap_gm_db_system]
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set
2005-12-06 09:02:11 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): Giving up and falling back to NullTranslations() class in despair.
2005-12-06 09:02:11 [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 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): client encoding according to locale system: [ISO-8859-1]
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.24 $
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.14 $
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: log level change from [INFO] to [DATA]
2005-12-06 09:02:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): startup ($Revision: 1.16 $)
2005-12-06 09:02:11 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-local_first.conf>)
2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-06 09:02:11 [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 09:02:11 [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 09:02:11 [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 09:02:11 [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 09:02:11 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-06 09:02:11 [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 09:02:12 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-monolithic_core.conf>)
2005-12-06 09:02:12 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-06 09:02:12 [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 09:02:12 [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 09:02:12 [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 09:02:12 [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.42 $)
2005-12-06 09:02:12 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-06 09:02:12 [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 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [config]
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-06 09:02:13 [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 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping server [local host]
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connecting to server template database
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as postgres
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected to template database [template1]
2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database users and groups
2005-12-06 09:02:13 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): option <password> not found in group [user GnuMed owner]
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): User [gm-dbo] exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-doctors exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_medical exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_office exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_medical exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_office exists.
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-public exists.
2005-12-06 09:02:17 [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 09:02:17 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists
2005-12-06 09:02:17 [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 09:02:17 [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 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmPublicAccounts.sql]
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmTestAccounts.sql]
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as gm-dbo
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] does not exist.
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] exists.
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Successfully created GNUmed database [gnumed_v2].
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as postgres
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping procedural languages
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installing procedural language [pg/SQL]
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql does not exist.
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql exists.
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): procedural language [pg/SQL] successfully installed
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as gm-dbo
2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevision.sql]
2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevisionViews.sql]
2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmServices.sql]
2005-12-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view v_missing_translations
2005-12-06 09:02:20 [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 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmI18N.sql]
2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit.sql]
2005-12-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_ins on audit_fields cascade
2005-12-06 09:02:20 [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 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_upd on audit_fields cascade
2005-12-06 09:02:20 [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 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_fields_no_del on audit_fields cascade
2005-12-06 09:02:20 [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 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_ins on audit_trail cascade
2005-12-06 09:02:20 [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 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_upd on audit_trail cascade
2005-12-06 09:02:20 [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 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop rule audit_trail_no_del on audit_trail cascade
2005-12-06 09:02:20 [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 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit-dynamic.sql]
2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmNotifications-static.sql]
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmNotifications-dynamic.sql]
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmHousekeeping.sql]
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [default] not installed here yet
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmConfig-static.sql]
2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmConfigData.sql]
2005-12-06 09:02:21 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_options
2005-12-06 09:02:21 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmConfigViews.sql:118: ERROR: view "v_cfg_options" does not exist
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_numeric
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmConfigViews.sql:141: ERROR: view "v_cfg_opts_numeric" does not exist
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_string
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmConfigViews.sql:167: ERROR: view "v_cfg_opts_string" does not exist
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_str_array
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmConfigViews.sql:193: ERROR: view "v_cfg_opts_str_array" does not exist
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_data
2005-12-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmConfigViews.sql:219: ERROR: view "v_cfg_opts_data" does not exist
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmConfigViews.sql]
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Registering service [config] (GNUmed internal name: [default]).
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Service [default] resides in core database.
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): It will be automatically recognized by GNUmed.
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [reference]
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database [core] already bootstrapped
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [reference] not installed here yet
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me
2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmReference.sql]
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmReference-dynamic.sql]
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmReference-data.sql]
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Registering service [reference] (GNUmed internal name: [reference]).
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Service [reference] resides in core database.
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): It will be automatically recognized by GNUmed.
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [demographics]
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database [core] already bootstrapped
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [personalia] not installed here yet
2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me
2005-12-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics.sql]
2005-12-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-Grants.sql]
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): drop index idx_identity_dob
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:11: ERROR: index "idx_identity_dob" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop index idx_names_last_first
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:12: ERROR: index "idx_names_last_first" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop index idx_names_firstnames
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:13: ERROR: index "idx_names_firstnames" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop index idx_uniq_act_name
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:27: ERROR: index "idx_uniq_act_name" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop trigger tr_uniq_active_name on names
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:36: ERROR: trigger "tr_uniq_active_name" for table "names" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function f_uniq_active_name()
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:37: ERROR: function f_uniq_active_name() does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop trigger tr_always_active_name on names
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:39: ERROR: trigger "tr_always_active_name" for table "names" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function f_always_active_name()
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:40: ERROR: function f_always_active_name() does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop trigger TR_delete_names on identity
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:82: ERROR: trigger "tr_delete_names" for table "identity" does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function F_delete_names()
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:83: ERROR: function f_delete_names() does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function add_name(integer, text, text, bool)
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:101: ERROR: function add_name(integer, text, text, boolean) does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop function set_nickname(integer, text)
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:132: ERROR: function set_nickname(integer, text) does not exist
2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
create function set_nickname(integer, text) returns integer as '
DECLARE
_id_identity alias for $1;
_nick alias for $2;
_names_row record;
BEGIN
-- 0.1: Just always set the nickname inside the active name
-- post 0.1: openEHR-like (name: pk, fk_identity, name, fk_type, comment, is_legal, is_active ...)
-- does name exist ?
select into _names_row * from names where id_identity = _id_identity and active = true;
if not found then
msg = ''Cannot set nickname ['' || _nick || '']. No active <names> row with id_identity ['' || _id_identity || ''] found.''
raise exception msg;
end if;
-- can directly set nickname ?
-- if _names_row.preferred is null then
update names set preferred = _nick where id = _names_row.id;
return _names_row.id;
-- end if;
-- must create new row
-- 1) deactivate old row ...
-- update names set active = false where id = _names_row.id;
-- 2) insert new row from old row and new data ...
--insert into names (id_identity, active, firstnames, lastnames, preferred, comment)
-- values (_id_identity, true, _names_row.firstnames, _names_row.lastnames, _nick, _names_row.comment);
--if found then
-- return currval(''names_id_seq'');
--end if;
--return NULL;
END;' language 'plpgsql'
2005-12-06 09:02:25 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-views.sql:165: ERROR: syntax error at or near "msg" at character 1QUERY: msg = 'Cannot set nickname [' || $1 || ']. No active <names> row with id_identity [' || $2 || '] found.' raise exception msgCONTEXT: SQL statement in PL/PgSQL function "set_nickname" near line 12
2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): failed to import [../sql/gmDemographics-Person-views.sql]
2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot import schema definition for service [demographics] into database [core].
2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap services.
2005-12-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): shutdown
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
