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:06 | Date Closed: | 2011-06-07 14:03:15 |
Priority: | Major | Regression? | No |
Status: | Closed/Complete | Components: | 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. |