[OpenSIPS-Devel] [ opensips-Bugs-3578406 ] Postgres create DB error
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=detailatid=1086410aid=3578406group_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
[OpenSIPS-Devel] [ opensips-Bugs-3578406 ] Postgres create DB error
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=detailatid=1086410aid=3578406group_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
[OpenSIPS-Devel] [ opensips-Bugs-3578406 ] Postgres create DB error
Bugs item #3578406, was opened at 2012-10-19 09:45 Message generated for change (Comment added) made by bogdan_iancu You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=1086410aid=3578406group_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
[OpenSIPS-Devel] [ opensips-Bugs-3578406 ] Postgres create DB error
Bugs item #3578406, was opened at 2012-10-19 09:45 Message generated for change (Tracker Item Submitted) made by tganzeboom You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=1086410aid=3578406group_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: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Toine (tganzeboom) Assigned to: Nobody/Anonymous (nobody) 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