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 _______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
