Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#570 Postgres create DB error

trunk
closed-fixed
modules (454)
5
2015-02-06
2012-10-19
Toine
No

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#

Discussion

  • Hi Toine,

    Please apply and test the following patch.

    Thanks and regards,
    Bogdan

     
    • milestone: --> trunk
    • assigned_to: nobody --> bogdan_iancu
    • status: open --> open-fixed
     
  • Toine
    Toine
    2012-10-23

    Patch works! Thanks.

    Toine

     
    • status: open-fixed --> closed-fixed