[OpenSIPS-Devel] Table creation errors with Postgres

[Liviu Chircu]

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
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel