Hello Babil,
Apologies for the delay! It seems your email "got lost" through all git
commit messages from the dev list.
Indeed, your assumption was correct (the pgsql table creation script was
broken). Vlad just fixed this and backported it all the way down to
OpenSIPS 1.11. Thank you for reporting!
Best regards,
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com
On 14.02.2015 05:47, Babil Golam Sarwar wrote:
Dear OpenSIPS,
I'm extending OpenSIPS (a module and some core) and PJSIP for internal
system compatibility purposes. My OpenSIPS code base is branch 1.11
(Git revision `17c5990`).
While creating the OpenSIPS databases for Postgres through
`opensipsdbctl create`, I'm getting the following errors:
```
creating table 3: dialog
ERROR: relation "dialog_id_seq" does not exist
```
This error originates from `scripts/opensipsdbctl.pgsql` at the following line:
```
sql_query opensips 'GRANT ALL PRIVILEGES ON TABLE dialog_id_seq TO opensips;'
```
Also, if I proceed to create the additional tables, I'm getting
similar errors with the following tables:
```
ERROR: relation "call_center" does not exist
ERROR: relation "call_center_id_seq" does not exist
ERROR: Grant privileges to extra tables failed!
```
I understand that the errors are related to Posgres' `GRANT`, and I
don't get any of these errors with MySQL. Would you please be able to
share some insights to fix these errors? I'm confident that my changes
didn't introduce them.
--
Regards,
Babil (Golam Sarwar)
PGP Key Fingerprint : D3A1 EED0 5BA0 72D3 A011 75CB 8EA6 7D99 F433 E92D
PGP Key Download URL: http://bit.ly/gsbabil-pgp-key
_______________________________________________
Devel mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
