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@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@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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 19th of September 2011
OpenSIPS solutions and "know-how"
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
