[OpenSIPS-Users] opensips-1.5.1 postgres tables error

[Cao Lei-MNW784]

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: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of Matteo Piazza
Sent: Friday, June 19, 2009 4:14 PM
To: users at lists.opensips.org
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
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users