[OpenSIPS-Users] opensips-1.5.1 postgres tables error

Matteo Piazza matteo.piazza at trentinonetwork.it
Fri Jun 19 10:13:54 CEST 2009


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
==========================================================================




More information about the Users mailing list