[OpenSIPS-Users] OpenSIPS db schema on PostgreSQL

[Bogdan-Andrei Iancu]

Hi Ryan,

Is the table "dr_gateway" already created in DB ?

Also try to set VERBOSE to 1 in opensipcctlrc and run the script again

Regards,
Bogdan

On 07/26/2011 08:21 PM, Ryan Revels wrote:
> 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.
>
> After configuring opensipsctlrc, I first encounter this error:
> root at core-dev:~# opensipsdbctl create
> -e \E[37;31mERROR: ~./pgpass does not exist, please create this file 
> and support proper credentials for user postgres.
>
> 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...
>
> Then, I am repeatedly prompted for the DB root user's password as 
> opensipsdbctl creates the schema:
> root at core-dev:~# opensipsdbctl create
> -e \E[37;33mINFO: creating database opensips ...
> Password for user postgres:
> Password for user postgres:
> Password for user postgres:
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
> "version_t_name_idx" for table "version"
> Password for user postgres:
>
> Finally, it spits out the following error and fails:
> ERROR:  relation "dr_gateways_id_seq" does not exist
> -e \E[37;31mERROR: Grant privileges to standard tables failed!
>
> What am I doing incorrectly?
>
> Thanks,
> Ryan
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-- 
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 19th of September 2011
OpenSIPS solutions and "know-how"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110809/e2a16b0c/attachment.htm>