Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Antony Stone
On Wednesday 10 June 2020 at 16:33:53, Doug Lytle wrote: > >>> Instead, the call still terminates if mysql cannot be reached. > > I just tested this, I'm using cdr_odbc, by shutting down mysql and I did > not experience the call being dropped. That sounds different to me. The OP is asking about

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Doug Lytle
>>> Instead, the call still terminates if mysql cannot be reached. I just tested this, I'm using cdr_odbc, by shutting down mysql and I did not experience the call being dropped. The console logged the mysql failure, but the call continued. You may want to consider moving to cdr_odbc instead.

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Fourhundred Thecat
> On 2020-06-08 16:37, Sean Bright wrote: > > In the case of cdr_mysql, the connect timeout is configurable by putting > the following in cdr_mysql.conf: > > [global] > timeout = 5 ; Set connect timeout to 5 seconds OK, so i changed the timeout to 2 sec, but it does not have the desired effect. I

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-08 Thread Sean Bright
On 6/7/2020 2:54 AM, Fourhundred Thecat wrote: I would still like to know where the Aterisk mysql timeout duration comes from, and whether it can be configured. In the case of cdr_mysql, the connect timeout is configurable by putting the following in cdr_mysql.conf: [global] timeout = 5 ; Se

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-07 Thread Jeff LaCoursiere
Isn't the MySQL stuff deprecated in favor of odbc? You may be barking up the wrong tree if you plan to make source changes. j On Sun, Jun 7, 2020, 1:55 AM Fourhundred Thecat <400the...@gmx.ch> wrote: > > On 2020-06-06 10:38, Antony Stone wrote: > > On Saturday 06 June 2020 at 09:18:11, Fourhun

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Fourhundred Thecat
> On 2020-06-06 10:38, Antony Stone wrote: On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: In a situation when I start asterisk, and the remote database is unreachable, asterisk waits for several minutes before it actually starts (before it loads sip module, etc). And when data

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Antony Stone
On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: > In a situation when I start asterisk, and the remote database is > unreachable, asterisk waits for several minutes before it actually > starts (before it loads sip module, etc). > > And when database is unreachable during operation

[asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Fourhundred Thecat
Hello, I am using CDR mysql to log to remote server: in modules.conf, I preload the modules: [modules] preload => cdr_mysql.so preload => app_mysql.so and in cdr_mysql.conf, I have all the details defined (hostname, dbname, table, password, user, port). In a situation when I start asterisk, a