[Users] database persistent connection

[Daniel-Constantin Mierla]

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