Does Cdr Adaptive Odbc Re-connect Automatically After A Long Idle Time?

Home » Asterisk Users » Does Cdr Adaptive Odbc Re-connect Automatically After A Long Idle Time?
Asterisk Users 1 Comment

Hi all,

I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL’s cdr table. After my testing, this scenario is working well.

After a long idle time, I didn’t make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR messages in the CLI at this period.

Could you please tell me which settings are wrong? Why dose my odbc connection not re-connect to MySQL automatically?

I checked the setting below:

CLI:
ubuntu*CLI> cdr show status

Call Detail Record (CDR) settings
——————————–

One thought on - Does Cdr Adaptive Odbc Re-connect Automatically After A Long Idle Time?

  • I would be inclined to check the database side over asterisk. We use almost the same setup and don’t have any issues. We go some time 12
    hours between calls. Once thing you could do is enable debug logs and see what Asterisk is doing when the odbc connection is down. EG: it should be attempting to reconnect.