[OpenSIPS-Users] Problem creating tables for OpenSIPS with PostgreSQL

David Santiago david.santiago at almiralabs.com
Fri Oct 22 18:52:27 CEST 2010


The call to opensipsdbctl create is asking me for the password on
every single table created. But the real problem is that after several
tables have been created the following error happens:

...
...
-e Creating core table: drouting
Password for user almira:
NOTICE:  CREATE TABLE will create implicit sequence
"dr_gateways_gwid_seq" for serial column "dr_gateways.gwid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dr_gateways_pkey" for table "dr_gateways"
NOTICE:  CREATE TABLE will create implicit sequence
"dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dr_rules_pkey" for table "dr_rules"
NOTICE:  CREATE TABLE will create implicit sequence
"dr_gw_lists_id_seq" for serial column "dr_gw_lists.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dr_gw_lists_pkey" for table "dr_gw_lists"
NOTICE:  CREATE TABLE will create implicit sequence "dr_groups_id_seq"
for serial column "dr_groups.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dr_groups_pkey" for table "dr_groups"
-e Creating core table: load_balancer
Password for user almira:
NOTICE:  CREATE TABLE will create implicit sequence
"load_balancer_id_seq" for serial column "load_balancer.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"load_balancer_pkey" for table "load_balancer"
Password for user almira:
ERROR:  permission denied to create role
-e \E[37;32mWARNING: Create user in database failed, perhaps they
already exist? Try to continue..
Password for user almira:
Password for user almira:
Password for user almira:
Password for user almira:
[: 300: acc: unexpected operator
[: 300: acc: unexpected operator

Any hint about where to have a look in order to fix this?


Regards,
David



More information about the Users mailing list