[OpenSIPS-Users] avoid down time caused by mysql server connection lost

[Bogdan-Andrei Iancu]

Hi Julien,

I see you get a crash there :(....can you post the backtrace ?

Thanks,
Bogdan

Julien Chavanton wrote:
>
> Hi, I have single point of failure for Opensips with siptrace and CDR, 
> if the Mysql server is disconnected from the network opensip will stop 
> working, I would rather continue to accept calls without storing 
> CDR/trace or use a secondary mysql connection.
>
> Is there any recommendation / best practice ?
>
> -------------------------------- config
>
> modparam("siptrace", "db_url", "mysql://login:password@x.x.x.x/opensips")
>
> modparam("acc", "db_url", "mysql://login:password@x.x.x.x/opensips")
>
> -------------------------------- log
>
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: 
> INFO:core:handle_sigs: child process 4835 exited by a signal 11
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4844]: 
> CRITICAL:core:receive_fd: EOF on 24
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: 
> INFO:core:handle_sigs: core was generated
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: 
> INFO:core:handle_sigs: terminating due to SIGCHLD
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4840]: 
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4834]: 
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4843]: 
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4842]: 
> INFO:core:sig_usr: signal 15 received
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro