<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi Ryan,<br>
<br>
I've just committed a fix for this issue on trunk. Please update
your sources and try again. Let us know if your problem was solved.<br>
<br>
Regards<br>
<pre class="moz-signature" cols="72">Razvan Crainea
OpenSIPS Developer</pre>
<br>
On 11.08.2011 21:34, Ryan Revels wrote:
<blockquote
cite="mid:CAKFmOsHf=x0q=bKMQ6ynX+qS_CpzkDjJBL4KsPO4ByBj_1VkyA@mail.gmail.com"
type="cite">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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true" 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
moz-do-not-send="true" href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<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 class="h5"><br>
<br>
On 07/26/2011 08:21 PM, Ryan Revels wrote: </div>
</div>
<blockquote type="cite">
<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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>