Bugs item #3578406, was opened at 2012-10-19 09:45 Message generated for change (Settings changed) made by bogdan_iancu 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: Closed 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 _______________________________________________ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel