bump?<br><br><div class="gmail_quote">On Tue, Jul 26, 2011 at 12:21 PM, Ryan Revels <span dir="ltr"><<a href="mailto:ryan@revelous.net">ryan@revelous.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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>
</blockquote></div><br>