Hi, The schemas: db/schema/dr_rules.xml, and dr_gateways.xml is broken towards opensipsdbctl Quickfix: replace 'gwid', and 'rulesid' with 'id' in the xmlfiles. Also opensipsdbctl.base is broken as it misses module 'nathelper' as a standard module Quickfix: add 'nathelper' in STANDAR_MODULES in opensipsdbctl.base
After that a postgres installation is homefree, also with extras and precens tables. Regards Arvii Cao Lei-MNW784 wrote: > > Yup, that's the problem with postgres db. > > I also experienced the same one. The reason is, there is no column "id" > created. > You can check the scripts/postgres/drouting-create.sql, the one created is > "gwid" > > You can bypass this problem by removing the tables causing problems at > STANDARD_TABLES in /usr/local/lib/opensips/opensipsctl/opensipsdbctl.base > > There are several need to remove. > > Maybe a better solution is to modify opensipsdbctl.pgsql, to grant the > correct gwid_seq , not id_seq. > > Note: If you are going to run opensips with openxcap, I suggest you to > switch to mysql, as what I did, because you will run into lots of > problems. > > Thanks & Regards > Cao, Charles > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Matteo Piazza > Sent: Friday, June 19, 2009 4:14 PM > To: [email protected] > Subject: [OpenSIPS-Users] opensips-1.5.1 postgres tables error > > I found an issue using opensips-1.5.1-notls. > > When I try to create the tables for a postgres database (8.3 version) on > a debian 5.0 I have the following error: > > > # opensipsdbctl create > INFO: creating database opensips ... > NOTICE: CREATE TABLE / UNIQUE will create implicit index > "version_t_name_idx" for table "version" > .... > .... > .... > NOTICE: CREATE TABLE will create implicit sequence > "load_balancer_id_seq" for serial column "load_balancer.id" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "load_balancer_pkey" for table "load_balancer" > ERROR: relation "dr_gateways_id_seq" does not exist > ERROR: relation "dr_gateways_id_seq" does not exist > ERROR: Grant privileges to standard tables failed! > > If i try to create the table on a mysql database on the same machine and > with the same compilate version everithing is fine. > If I try to create the table on the same postgres database with openser > 1.3.4 everything is fine. > > Kind Regards > Matteo > > -- > ========================================================================== > Matteo Piazza > Trentino Network s.r.l. > Area Innovazione > Via Gilli, 2 - 38100 TRENTO > Tel (+39) 0461.020224 > Mob (+39) 335.5378482 > Fax (+39) 0461.020201 > Cap. Soc. sottoscritto 7.573.248,00 - i. v. > REG. IMP. C.F. e P. IVA 01904880224 > Società soggetta a direzione e controllo da parte della Provincia > Autonoma di Trento. C.F. e P. IVA 00337460224 > ========================================================================== > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- View this message in context: http://n2.nabble.com/opensips-1.5.1-postgres-tables-error-tp3118364p3444481.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
