[OpenSIPS-Devel] [ opensips-Bugs-2871734 ] Error Setting DB Perms with Postgres

[SourceForge.net]

Bugs item #2871734, was opened at 2009-10-02 08:10
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2871734&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: core
Group: 1.5.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error Setting DB Perms with Postgres

Initial Comment:
This is OpenSIPS 1.5.3 with a Postgres DB backend.

The opensipsdbctl script(s) assume that all tables have a column, type serial, called "id" However, the DR_RULES & DR_GATEWAYS tables have their main columns called "gwid" & "rulesid" When the script tries to GRANT permissions to the sequences, it fails, as the sequence is called dr_rules_rulesid_seq, rather than the name dr_rules_id_seq.

Changing the column names to just "id" (instead of gwid & rulesid) allows the opensipsdbctl scripts to complete without error.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2871734&group_id=232389