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>