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

[Bogdan-Andrei Iancu]

Hi David,

The error says that your current postgres user (you are running the 
opensips script with) has no permission / privilege  to create new 
access users (opensips and opensipsrw) for postgres.

Regards,
Bogdan

David Santiago wrote:
> 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
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
15 - 19 November 2010, Edison, New Jersey, USA
www.voice-system.ro