[asterisk-bugs] [JIRA] (ASTERISK-20456) Unable to take calls when MYSQL server is unreachable

[Ksenia (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-20456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=222942#comment-222942 ] 

Ksenia commented on ASTERISK-20456:
-----------------------------------

Sorry for not responding for a long time - we have found a workaround for that issue using an external script to insert records. But now I have encountered the problem again on Ubuntu 14.04.1 (3.13.0-32). If mysql server is unreachable it seems to me that asterisk core does not load, just like the other modules like pbx_config.so. So 'dialplan show' comand shows only context from features.conf. 

This is my test config of cdr_mysql.conf. Fake mysql host 1.1.1.1 is chosen to emulate mysql server outage.
{{[global]}}
{{hostname=1.1.1.1}}
{{dbname=asterisk}}
{{table=cdr}}
{{password=password}}
{{user=asterisk}}
{{port=3306}}
{{sock=/tmp/mysql.sock}}
{{timezone=UTC}}

Then I start asterisk with /etc/init.d/asterisk debug (-cvvvvvddddd).
Everything hangs on   
{{== Parsing '/etc/asterisk/cdr_mysql.conf': Found}}
There are no error messages indicating a database is unreachable (unlike the situation with Gentoo). Full log is attached. I can provide any additional information if needed.


> Unable to take calls when MYSQL server is unreachable
> -----------------------------------------------------
>
>                 Key: ASTERISK-20456
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20456
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/cdr_mysql
>    Affects Versions: 1.8.15.0
>         Environment: Gentoo
>            Reporter: Ksenia
>            Assignee: Rusty Newton
>         Attachments: asterisk_start_debug.txt
>
>
> We store cdr records in a mysql database on a remote server. When mysql server becomes unreachable, it's impossible to make and take calls. Only unloading of cdr_mysql module helps while the server is unreachable. When I connect to the console, of course there are messages like 'cannot connect to database ...'. I'm using asterisk 1.8.15.0 on Gentoo.
> Any help will be appreciated.



--
This message was sent by Atlassian JIRA
(v6.2#6252)