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

[David Santiago]

The user I'm the running the script with?  well, I'm executing the script
with my personal user on the server where opensips is installed, while the
database is on a different one...

I have modified the opensipsctlrc to specify different users (rw and ro),
and passwords than those provided by default, but the point is that I do not
have the password of the database server root user. It seems that the script
requires such kind of access to the database in order to create those rw and
ro users, ins't it?

On Mon, Oct 25, 2010 at 12:45 PM, Bogdan-Andrei Iancu <
bogdan at voice-system.ro> wrote:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20101025/fc8f5062/attachment.htm