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... <br><br>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?<br>
<br><div class="gmail_quote">On Mon, Oct 25, 2010 at 12:45 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi David,<br>
<br>
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.<br>
<br>
Regards,<br>
Bogdan<br>
<br>
David Santiago wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5">
The call to opensipsdbctl create is asking me for the password on<br>
every single table created. But the real problem is that after several<br>
tables have been created the following error happens:<br>
<br>
...<br>
...<br>
-e Creating core table: drouting<br>
Password for user almira:<br>
NOTICE: CREATE TABLE will create implicit sequence<br>
"dr_gateways_gwid_seq" for serial column "dr_gateways.gwid"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index<br>
"dr_gateways_pkey" for table "dr_gateways"<br>
NOTICE: CREATE TABLE will create implicit sequence<br>
"dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index<br>
"dr_rules_pkey" for table "dr_rules"<br>
NOTICE: CREATE TABLE will create implicit sequence<br>
"dr_gw_lists_id_seq" for serial column "<a href="http://dr_gw_lists.id" target="_blank">dr_gw_lists.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index<br>
"dr_gw_lists_pkey" for table "dr_gw_lists"<br>
NOTICE: CREATE TABLE will create implicit sequence "dr_groups_id_seq"<br>
for serial column "<a href="http://dr_groups.id" target="_blank">dr_groups.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index<br>
"dr_groups_pkey" for table "dr_groups"<br>
-e Creating core table: load_balancer<br>
Password for user almira:<br>
NOTICE: CREATE TABLE will create implicit sequence<br>
"load_balancer_id_seq" for serial column "<a href="http://load_balancer.id" target="_blank">load_balancer.id</a>"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index<br>
"load_balancer_pkey" for table "load_balancer"<br>
Password for user almira:<br>
ERROR: permission denied to create role<br>
-e \E[37;32mWARNING: Create user in database failed, perhaps they<br>
already exist? Try to continue..<br>
Password for user almira:<br>
Password for user almira:<br>
Password for user almira:<br>
Password for user almira:<br>
[: 300: acc: unexpected operator<br>
[: 300: acc: unexpected operator<br>
<br>
Any hint about where to have a look in order to fix this?<br>
<br>
<br>
Regards,<br>
David<br>
<br></div></div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
</blockquote>
<br>
<br>
-- <br>
Bogdan-Andrei Iancu<br>
OpenSIPS Bootcamp<br>
15 - 19 November 2010, Edison, New Jersey, USA<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
<br>
</blockquote></div><br>