[Home]

Summary:ASTERISK-11736: CDR_ODBC don't log the first call when it needs to reconnect
Reporter:Yves Räber (yraber)Labels:
Date Opened:2008-03-27 02:14:06Date Closed:2011-06-07 14:03:15
Priority:MajorRegression?No
Status:Closed/CompleteComponents:CDR/cdr_odbc
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:After a while without any activity (I don't know exactl how much, but a few hours) it seems that Asterisk looses the MySQL connection, and when it tries to reconnect, the first call is not logged. This problem only occurs on the first call on reconnection, the next onces are ok.

Here is the what appears on the CLI :

      > cdr_odbc: Error in Query -1
      > cdr_odbc: Query FAILED Call not logged!
      > cdr_odbc: Reconnecting to dsn MySQL-asterisk
Really destroying SIP dialog '6f2f45a40df45efd2d787858031a0340@xxx.xxx.xxx.xx' Method: INVITE
      > cdr_odbc: Connected to MySQL-asterisk
      > cdr_odbc: Trying Query again!
      > cdr_odbc: Error in Query -2
      > cdr_odbc: Query FAILED Call not logged!

I don't know it this can be relevant, but I'm also using res_odbc.

****** ADDITIONAL INFORMATION ******

Asterisk 1.4.18.1
MySQL 5.0.22
UnixODBC 2.2.11
Ubuntu 6.06.1

/etc/asterisk/res_odbc.conf
[global]
dsn=MySQL-asterisk
username=asteriskCDR
password=XXXXX
table=AsteriskCDR
loguniqueid=yes
dispositionstring=yes

/etc/odbc.ini

[MySQL-asterisk]
Description     = MySQL ODBC Driver Testing
Driver          = MySQL
Socket          = /var/run/mysqld/mysqld.sock
Server          = localhost
Database        = asteriskdb

/etc/odbcinst.ini
[MySQL]
Description     = MySQL driver
Driver          = /usr/lib/odbc/libmyodbc.so
Setup           = /usr/lib/odbc/libodbcmyS.so
CPTimeout       =
CPReuse         =
UsageCount      = 1
Comments:By: Tilghman Lesher (tilghman) 2008-03-27 08:26:30

Please set "idlecheck" to 3600 in res_odbc.conf.  The parameter was created specifically for the buggy MySQL driver.