[OpenSIPS-Devel] [ opensips-Bugs-3578406 ] Postgres create DB error

[SourceForge.net]

Bugs item #3578406, was opened at 2012-10-19 09:45
Message generated for change (Comment added) made by tganzeboom
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3578406&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Toine (tganzeboom)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: Postgres create DB error

Initial Comment:
Downloaded the latest 1.8, but got this error:

ERROR:  relation "dr_gateways_gwid_seq" does not exist

Also, I have to give my password multiple times. I have read this in earlier versions, but it seems to have come back?

Error is also below, included this for clearity

/opensips/1.8# opensipsdbctl create
database engine 'postgres' loaded
INFO: creating database opensips ...
Password for user postgres:
Password for user postgres:
Creating core table: standard
Password for user postgres:
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "version_t_name_idx" for table "version"
Creating core table: acc
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for serial column "acc.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey" for table "acc"
NOTICE:  CREATE TABLE will create implicit sequence "missed_calls_id_seq" for serial column "missed_calls.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "missed_calls_pkey" for table "missed_calls"
Creating core table: domain
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for serial column "domain.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "domain_pkey" for table "domain"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "domain_domain_idx" for table "domain"
Creating core table: group
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for serial column "grp.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey" for table "grp"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "grp_account_group_idx" for table "grp"
NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for serial column "re_grp.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "re_grp_pkey" for table "re_grp"
Creating core table: permissions
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for serial column "address.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "address_pkey" for table "address"
Creating core table: registrar
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for serial column "aliases.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "aliases_pkey" for table "aliases"
Creating core table: usrloc
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq" for serial column "location.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "location_pkey" for table "location"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "location_account_contact_idx" for table "location"
Creating core table: msilo
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for serial column "silo.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "silo_pkey" for table "silo"
Creating core table: alias_db
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq" for serial column "dbaliases.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dbaliases_pkey" for table "dbaliases"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "dbaliases_alias_idx" for table "dbaliases"
Creating core table: uri_db
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for serial column "uri.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey" for table "uri"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "uri_account_idx" for table "uri"
Creating core table: nathelper
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "nh_sockets_id_seq" for serial column "nh_sockets.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "nh_sockets_pkey" for table "nh_sockets"
Creating core table: speeddial
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq" for serial column "speed_dial.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "speed_dial_pkey" for table "speed_dial"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "speed_dial_speed_dial_idx" for table "speed_dial"
Creating core table: avpops
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "usr_preferences_id_seq" for serial column "usr_preferences.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "usr_preferences_pkey" for table "usr_preferences"
Creating core table: auth_db
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "subscriber_id_seq" for serial column "subscriber.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "subscriber_pkey" for table "subscriber"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "subscriber_account_idx" for table "subscriber"
Creating core table: pdt
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "pdt_id_seq" for serial column "pdt.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pdt_pkey" for table "pdt"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "pdt_sdomain_prefix_idx" for table "pdt"
Creating core table: dialog
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dialog_id_seq" for serial column "dialog.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dialog_pkey" for table "dialog"
Creating core table: dispatcher
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dispatcher_id_seq" for serial column "dispatcher.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dispatcher_pkey" for table "dispatcher"
Creating core table: dialplan
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dialplan_id_seq" for serial column "dialplan.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dialplan_pkey" for table "dialplan"
Creating core table: drouting
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dr_gateways_id_seq" for serial column "dr_gateways.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dr_gateways_pkey" for table "dr_gateways"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "dr_gateways_dr_gw_idx" for table "dr_gateways"
NOTICE:  CREATE TABLE will create implicit sequence "dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dr_rules_pkey" for table "dr_rules"
NOTICE:  CREATE TABLE will create implicit sequence "dr_carriers_id_seq" for serial column "dr_carriers.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dr_carriers_pkey" for table "dr_carriers"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "dr_carriers_dr_carrier_idx" for table "dr_carriers"
NOTICE:  CREATE TABLE will create implicit sequence "dr_groups_id_seq" for serial column "dr_groups.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dr_groups_pkey" for table "dr_groups"
Creating core table: load_balancer
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "load_balancer_id_seq" for serial column "load_balancer.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "load_balancer_pkey" for table "load_balancer"
Password for user postgres:
Password for user postgres:
Password for user postgres:
creating table: acc
creating table 3: acc
Password for user postgres:
created table: acc
Password for user postgres:
creating table: dbaliases
creating table 3: dbaliases
Password for user postgres:
created table: dbaliases
Password for user postgres:
creating table: domain
creating table 3: domain
Password for user postgres:
created table: domain
Password for user postgres:
creating table: grp
creating table 3: grp
Password for user postgres:
created table: grp
Password for user postgres:
creating table: uri
creating table 3: uri
Password for user postgres:
created table: uri
Password for user postgres:
creating table: speed_dial
creating table 3: speed_dial
Password for user postgres:
created table: speed_dial
Password for user postgres:
creating table: pdt
creating table 3: pdt
Password for user postgres:
created table: pdt
Password for user postgres:
creating table: subscriber
creating table 3: subscriber
Password for user postgres:
created table: subscriber
Password for user postgres:
creating table: location
creating table 3: location
Password for user postgres:
created table: location
Password for user postgres:
creating table: re_grp
creating table 3: re_grp
Password for user postgres:
created table: re_grp
Password for user postgres:
creating table: address
creating table 3: address
Password for user postgres:
created table: address
Password for user postgres:
creating table: address
creating table 3: address
Password for user postgres:
created table: address
Password for user postgres:
creating table: missed_calls
creating table 3: missed_calls
Password for user postgres:
created table: missed_calls
Password for user postgres:
creating table: usr_preferences
creating table 3: usr_preferences
Password for user postgres:
created table: usr_preferences
Password for user postgres:
creating table: aliases
creating table 3: aliases
Password for user postgres:
created table: aliases
Password for user postgres:
creating table: silo
creating table 3: silo
Password for user postgres:
created table: silo
Password for user postgres:
creating table: dialog
creating table 3: dialog
Password for user postgres:
created table: dialog
Password for user postgres:
creating table: dispatcher
creating table 3: dispatcher
Password for user postgres:
created table: dispatcher
Password for user postgres:
creating table: dialplan
creating table 3: dialplan
Password for user postgres:
created table: dialplan
Password for user postgres:
creating table: dr_gateways
creating table 1: dr_gateways
Password for user postgres:
ERROR:  relation "dr_gateways_gwid_seq" does not exist
created table: dr_gateways
Password for user postgres:
creating table: dr_rules
creating table 2: dr_rules
Password for user postgres:
created table: dr_rules
Password for user postgres:
creating table: dr_groups
creating table 3: dr_groups
Password for user postgres:
created table: dr_groups
Password for user postgres:
creating table: nh_sockets
creating table 3: nh_sockets
Password for user postgres:
created table: nh_sockets
Password for user postgres:
creating table: load_balancer
creating table 3: load_balancer
Password for user postgres:
created table: load_balancer
INFO: Core OpenSIPS tables succesfully created.
Install presence related tables? (y/n): n
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): n
/opensips/1.8#

----------------------------------------------------------------------

>Comment By: Toine (tganzeboom)
Date: 2012-10-23 03:57

Message:
Patch works! Thanks.

Toine

----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2012-10-21 08:55

Message:
Hi Toine,

Please apply and test the following patch.

Thanks and regards,
Bogdan

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3578406&group_id=232389