asterisk users - Jun 2020 - CDR mysql: timeout when remote database unavailable

> 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 expected, if mysql cannot be reached, after 2 seconds the call
will progress normally.

Instead, the call still terminates if mysql cannot be reached.

Is it possible to set in asterisk, if mysql is unreachable then skip the
step and simply ignore mysql logging ?

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

Doug

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 a call which starts at a time when MySQL is not 
available.

It sounds as though you made a call, then terminated MySQL, and the call did 
not terminate.
> The console logged the mysql failure, but the call continued.
> 
> You may want to consider moving to cdr_odbc instead.
I certainly agree with that suggestion / recommendation.


Antony.

-- 
"Black holes are where God divided by zero."

 - Steven Wright

                                                   Please reply to the list;
                                                         please *don't* CC
me.