Bogdan,<br><br>This is a brand new install so no tables exist. Here is the complete output with verbose=1:<br><br># opensipsdbctl create<br>-e database engine 'postgres' loaded<br>-e \E[37;33mINFO: creating database opensips ...<br>
-e Creating core table: standard<br>NOTICE: CREATE TABLE / UNIQUE will create implicit index "version_t_name_idx" for table "version"<br>-e Creating core table: acc<br>NOTICE: CREATE TABLE will create implicit sequence "acc_id_seq" for serial column "<a href="http://acc.id">acc.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey" for table "acc"<br>NOTICE: CREATE TABLE will create implicit sequence "missed_calls_id_seq" for serial column "<a href="http://missed_calls.id">missed_calls.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "missed_calls_pkey" for table "missed_calls"<br>-e Creating core table: domain<br>NOTICE: CREATE TABLE will create implicit sequence "domain_id_seq" for serial column "<a href="http://domain.id">domain.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domain_pkey" for table "domain"<br>NOTICE: CREATE TABLE / UNIQUE will create implicit index "domain_domain_idx" for table "domain"<br>
-e Creating core table: group<br>NOTICE: CREATE TABLE will create implicit sequence "grp_id_seq" for serial column "<a href="http://grp.id">grp.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey" for table "grp"<br>
NOTICE: CREATE TABLE / UNIQUE will create implicit index "grp_account_group_idx" for table "grp"<br>NOTICE: CREATE TABLE will create implicit sequence "re_grp_id_seq" for serial column "<a href="http://re_grp.id">re_grp.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "re_grp_pkey" for table "re_grp"<br>-e Creating core table: permissions<br>NOTICE: CREATE TABLE will create implicit sequence "address_id_seq" for serial column "<a href="http://address.id">address.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "address_pkey" for table "address"<br>-e Creating core table: registrar<br>NOTICE: CREATE TABLE will create implicit sequence "aliases_id_seq" for serial column "<a href="http://aliases.id">aliases.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliases_pkey" for table "aliases"<br>-e Creating core table: usrloc<br>NOTICE: CREATE TABLE will create implicit sequence "location_id_seq" for serial column "<a href="http://location.id">location.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "location_pkey" for table "location"<br>NOTICE: CREATE TABLE / UNIQUE will create implicit index "location_account_contact_idx" for table "location"<br>
-e Creating core table: msilo<br>NOTICE: CREATE TABLE will create implicit sequence "silo_id_seq" for serial column "<a href="http://silo.id">silo.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "silo_pkey" for table "silo"<br>
-e Creating core table: alias_db<br>NOTICE: CREATE TABLE will create implicit sequence "dbaliases_id_seq" for serial column "<a href="http://dbaliases.id">dbaliases.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dbaliases_pkey" for table "dbaliases"<br>
NOTICE: CREATE TABLE / UNIQUE will create implicit index "dbaliases_alias_idx" for table "dbaliases"<br>-e Creating core table: uri_db<br>NOTICE: CREATE TABLE will create implicit sequence "uri_id_seq" for serial column "<a href="http://uri.id">uri.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey" for table "uri"<br>NOTICE: CREATE TABLE / UNIQUE will create implicit index "uri_account_idx" for table "uri"<br>
-e Creating core table: nathelper<br>NOTICE: CREATE TABLE will create implicit sequence "nh_sockets_id_seq" for serial column "<a href="http://nh_sockets.id">nh_sockets.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nh_sockets_pkey" for table "nh_sockets"<br>
-e Creating core table: speeddial<br>NOTICE: CREATE TABLE will create implicit sequence "speed_dial_id_seq" for serial column "<a href="http://speed_dial.id">speed_dial.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "speed_dial_pkey" for table "speed_dial"<br>
NOTICE: CREATE TABLE / UNIQUE will create implicit index "speed_dial_speed_dial_idx" for table "speed_dial"<br>-e Creating core table: avpops<br>NOTICE: CREATE TABLE will create implicit sequence "usr_preferences_id_seq" for serial column "<a href="http://usr_preferences.id">usr_preferences.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usr_preferences_pkey" for table "usr_preferences"<br>-e Creating core table: auth_db<br>NOTICE: CREATE TABLE will create implicit sequence "subscriber_id_seq" for serial column "<a href="http://subscriber.id">subscriber.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subscriber_pkey" for table "subscriber"<br>NOTICE: CREATE TABLE / UNIQUE will create implicit index "subscriber_account_idx" for table "subscriber"<br>
-e Creating core table: pdt<br>NOTICE: CREATE TABLE will create implicit sequence "pdt_id_seq" for serial column "<a href="http://pdt.id">pdt.id</a>"<br>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pdt_pkey" for table "pdt"<br>
NOTICE: CREATE TABLE / UNIQUE will create implicit index "pdt_sdomain_prefix_idx" for table "pdt"<br>-e Creating core table: dialog<br>NOTICE: CREATE TABLE will create implicit sequence "dialog_id_seq" for serial column "<a href="http://dialog.id">dialog.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dialog_pkey" for table "dialog"<br>-e Creating core table: dispatcher<br>NOTICE: CREATE TABLE will create implicit sequence "dispatcher_id_seq" for serial column "<a href="http://dispatcher.id">dispatcher.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dispatcher_pkey" for table "dispatcher"<br>-e Creating core table: dialplan<br>NOTICE: CREATE TABLE will create implicit sequence "dialplan_id_seq" for serial column "<a href="http://dialplan.id">dialplan.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dialplan_pkey" for table "dialplan"<br>-e Creating core table: drouting<br>NOTICE: CREATE TABLE will create implicit sequence "dr_gateways_gwid_seq" for serial column "dr_gateways.gwid"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_gateways_pkey" for table "dr_gateways"<br>NOTICE: CREATE TABLE will create implicit sequence "dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_rules_pkey" for table "dr_rules"<br>NOTICE: CREATE TABLE will create implicit sequence "dr_gw_lists_id_seq" for serial column "<a href="http://dr_gw_lists.id">dr_gw_lists.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_gw_lists_pkey" for table "dr_gw_lists"<br>NOTICE: CREATE TABLE will create implicit sequence "dr_groups_id_seq" for serial column "<a href="http://dr_groups.id">dr_groups.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_groups_pkey" for table "dr_groups"<br>-e Creating core table: load_balancer<br>NOTICE: CREATE TABLE will create implicit sequence "load_balancer_id_seq" for serial column "<a href="http://load_balancer.id">load_balancer.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "load_balancer_pkey" for table "load_balancer"<br>ERROR: role "postgres" already exists<br>-e \E[37;32mWARNING: Create user in database failed, perhaps they already exist? Try to continue..<br>
[: 300: acc: unexpected operator<br> List of relations<br> Schema | Name | Type | Owner <br>--------+------------------------+----------+----------<br> public | acc | table | postgres<br>
public | acc_id_seq | sequence | postgres<br>[: 300: acc: unexpected operator<br>[: 300: dbaliases: unexpected operator<br>[: 300: dbaliases: unexpected operator<br>[: 300: domain: unexpected operator<br>[: 300: domain: unexpected operator<br>
[: 300: grp: unexpected operator<br>[: 300: grp: unexpected operator<br>[: 300: uri: unexpected operator<br>[: 300: uri: unexpected operator<br>[: 300: speed_dial: unexpected operator<br>[: 300: speed_dial: unexpected operator<br>
[: 300: pdt: unexpected operator<br>[: 300: pdt: unexpected operator<br>[: 300: subscriber: unexpected operator<br>[: 300: subscriber: unexpected operator<br>[: 300: location: unexpected operator<br>[: 300: location: unexpected operator<br>
[: 300: re_grp: unexpected operator<br>[: 300: re_grp: unexpected operator<br>[: 300: address: unexpected operator<br>[: 300: address: unexpected operator<br>[: 300: address: unexpected operator<br>[: 300: address: unexpected operator<br>
[: 300: missed_calls: unexpected operator<br>[: 300: missed_calls: unexpected operator<br>[: 300: usr_preferences: unexpected operator<br>[: 300: usr_preferences: unexpected operator<br>[: 300: aliases: unexpected operator<br>
[: 300: aliases: unexpected operator<br>[: 300: silo: unexpected operator<br>[: 300: silo: unexpected operator<br>[: 300: dialog: unexpected operator<br>[: 300: dialog: unexpected operator<br>[: 300: dispatcher: unexpected operator<br>
[: 300: dispatcher: unexpected operator<br>[: 300: dialplan: unexpected operator<br>[: 300: dialplan: unexpected operator<br>[: 300: dr_gateways: unexpected operator<br>[: 300: dr_gateways: unexpected operator<br>ERROR: relation "dr_gateways_id_seq" does not exist<br>
-e \E[37;31mERROR: Grant privileges to standard tables failed!<br><br>Thanks,<br>Ryan<br><br><div class="gmail_quote">On Tue, Aug 9, 2011 at 10:39 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div bgcolor="#ffffff" text="#000000">
Hi Ryan,<br>
<br>
Is the table "dr_gateway" already created in DB ?<br>
<br>
Also try to set VERBOSE to 1 in opensipcctlrc and run the script
again<br>
<br>
Regards,<br>
Bogdan<div><div></div><div class="h5"><br>
<br>
On 07/26/2011 08:21 PM, Ryan Revels wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5">I am attempting to install OpenSIPS 1.7 using
PostgreSQL as the DB. I'm using the latest OpenSIPS 1.7 subversion
on Debian Squeeze and postgresql-9.0.
<div><br>
</div>
<div>After configuring opensipsctlrc, I first encounter this
error:</div>
<div>
<div><font face="'courier new',
monospace">root@core-dev:~# opensipsdbctl create</font></div>
<div><font face="'courier new',
monospace">-e \E[37;31mERROR: ~./pgpass does not exist,
please create this file and support proper credentials for
user postgres.</font></div>
</div>
<div><br>
</div>
<div>This (~./pgpass) is obviously a typo. Nonetheless, for some
reason opensipsdbctl needs a file at ~/.pgpass before it will
attempt to run. I have yet to figure out what this file is
actually used for...</div>
<div><br>
</div>
<div>Then, I am repeatedly prompted for the DB root user's
password as opensipsdbctl creates the schema:</div>
<div>
<div><font face="'courier new',
monospace">root@core-dev:~# opensipsdbctl create</font></div>
<div><font face="'courier new',
monospace">-e \E[37;33mINFO: creating database opensips ...</font></div>
<div><font face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font face="'courier new',
monospace">NOTICE: CREATE TABLE / UNIQUE will create
implicit index "version_t_name_idx" for table "version"</font></div>
<div><font face="'courier new',
monospace">Password for user postgres: </font></div>
</div>
<div><font face="'courier new',
monospace"><br>
</font></div>
<div><font face="arial, helvetica,
sans-serif">Finally, it spits out the following error and
fails:</font></div>
<div>
<div><font face="'courier new',
monospace">ERROR: relation "dr_gateways_id_seq" does not
exist</font></div>
<div><font face="'courier new',
monospace">-e \E[37;31mERROR: Grant privileges to standard
tables failed!</font></div>
</div>
<div><font face="'courier new',
monospace"><br>
</font></div>
<div><font face="arial, helvetica,
sans-serif">What am I doing incorrectly?</font></div>
<div><font face="arial, helvetica,
sans-serif"><br>
</font></div>
<div><font face="arial, helvetica,
sans-serif">Thanks,</font></div>
<div><font face="arial, helvetica,
sans-serif">Ryan</font></div>
</div></div><pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote><font color="#888888">
<br>
<br>
<pre cols="72">--
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 19th of September 2011
OpenSIPS solutions and "know-how"</pre>
</font></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br>