[Users] database persistent connection

[tele]

Daniel,

you are right.
my client lib and the server version:

mysql-client-5.0.18_1 Multithreaded SQL database (client)
mysql server 4.0.18

the database is on different machine.
the errors in the syslog are:

Feb  5 11:39:22 obr /usr/local/sbin/openser[10830]:
ERROR:usrloc:db_load_urecord: db_query failed
Feb  5 11:39:22 obr /usr/local/sbin/openser[10830]: submit_query: 
Feb  5 11:39:22 obr /usr/local/sbin/openser[10830]: db_raw_query: Error
while submitting query
Feb  5 11:39:22 obr /usr/local/sbin/openser[10830]: avpops:db_query_avp:
error - cannot do the query

the problem could be the mysql client lib version.

thank you very much!

:tele




On Mon, 2007-02-05 at 12:07 +0200, Daniel-Constantin Mierla wrote:
> Hello,
> 
> even if was disconnected, openser should print a message and attempt to 
> connect again. What are the error messages you get in syslog? What 
> version of mysql and mysql client library are you using?
> 
> Cheers,
> Daniel
> 
> PS. dev8 is quite old, you should update to latest devel version.
> 
> 
> On 02/02/07 11:43, tele wrote:
> > Hi,
> >
> > I've an annoying problem with database persistent connection.
> > I'm using mysql database for location and avp stuff.
> >
> > During the day all it's but after a day i retest some call and seams
> > that the proxy lost connection with the database, and avp and location
> > stuff didn't works anymore.
> >
> > I'm using this version of openser:
> >
> > # openser -V
> > version: openser 1.2.0-dev8-notls (i386/freebsd)
> > flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM,
> > SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
> > ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
> > MAX_URI_SIZE 1024, BUF_SIZE 65535
> > poll method support: poll, select, kqueue.
> > @(#) $Id: main.c,v 1.23 2006/10/02 15:51:45 bogdan_iancu Exp $
> > main.c compiled on 12:38:52 Nov 27 2006 with gcc 3.4.4
> >
> > i've also configure a small ping_interval for the mysql module
> >
> > modparam("mysql", "ping_interval", 60)
> > modparam("mysql", "auto_reconnect", 1)
> >
> > and the usrloc:
> >
> > modparam("usrloc", "db_mode",   3)
> > modparam("usrloc", "matching_mode", 1)
> >
> > I've also check that the NTP is correct on the servers.
> > I don't know why openser lost connection with the database.
> >
> > any hints? 
> >
> > thanks
> >
> > :tele
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >