<!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 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<br>
<br>
On 07/26/2011 08:21 PM, Ryan Revels wrote:
<blockquote
cite="mid:CAKFmOsFimHYxYvSOEcWpCRANiBwy7mb4NgHU-rrdBARrynvJEA@mail.gmail.com"
type="cite">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 class="Apple-style-span" face="'courier new',
monospace">root@core-dev:~# opensipsdbctl create</font></div>
<div><font class="Apple-style-span" 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 class="Apple-style-span" face="'courier new',
monospace">root@core-dev:~# opensipsdbctl create</font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">-e \E[37;33mINFO: creating database opensips ...</font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">Password for user postgres: </font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">NOTICE: CREATE TABLE / UNIQUE will create
implicit index "version_t_name_idx" for table "version"</font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">Password for user postgres: </font></div>
</div>
<div><font class="Apple-style-span" face="'courier new',
monospace"><br>
</font></div>
<div><font class="Apple-style-span" face="arial, helvetica,
sans-serif">Finally, it spits out the following error and
fails:</font></div>
<div>
<div><font class="Apple-style-span" face="'courier new',
monospace">ERROR: relation "dr_gateways_id_seq" does not
exist</font></div>
<div><font class="Apple-style-span" face="'courier new',
monospace">-e \E[37;31mERROR: Grant privileges to standard
tables failed!</font></div>
</div>
<div><font class="Apple-style-span" face="'courier new',
monospace"><br>
</font></div>
<div><font class="Apple-style-span" face="arial, helvetica,
sans-serif">What am I doing incorrectly?</font></div>
<div><font class="Apple-style-span" face="arial, helvetica,
sans-serif"><br>
</font></div>
<div><font class="Apple-style-span" face="arial, helvetica,
sans-serif">Thanks,</font></div>
<div><font class="Apple-style-span" face="arial, helvetica,
sans-serif">Ryan</font></div>
<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>
<br>
<br>
<pre class="moz-signature" cols="72">--
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 19th of September 2011
OpenSIPS solutions and "know-how"</pre>
</body>
</html>