Cdr fails after updating to mysql 5


#1

Hi there
recently i updated from asterisk 1.2.4 to 1.2.7. I use a billing program i developed which needs mysql5 (triggers). Under asterisk 1.2.4 i updated mysql (rpms, im on CentOS), and the cdr kept working. But now under asterisk 1.2.7 it is not working. it stopped logging calls, heres the error:

May 9 13:15:13 DEBUG[3332] cdr_addon_mysql.c: cdr_mysql: inserting a CDR record.
May 9 13:15:13 DEBUG[3332] cdr_addon_mysql.c: cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid) VALUES (‘2006-05-09 13:14:56’,’“Telefono IP” <207>’,‘207’,‘201’,‘from-internal’, ‘SIP/207-209d’,‘SIP/201-c2ca’,‘Dial’,‘SIP/201|20|tTrwW’,17,14,‘ANSWERED’,3,’’,‘1147194896.0’)
May 9 13:15:13 ERROR[3332] cdr_addon_mysql.c: mysql_cdr: Failed to insert into database: (2013) Lost connection to MySQL server during queryMay

any thoughts on why is this happening?
thanks in advance


#2

nevermind. mysql problem, not asterisk