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
