search for: mysql_log

...is working well except for a strange problem I ran into this morning. During some cdr database maintenance, the cdr table was locked for a few minutes, during this condition all the Asterisk servers stopped processing calls and reported this error: Jan 5 09:57:03 ERROR[938]: cdr_addon_mysql.c:226 mysql_log: mysql_cdr: Failed to insert into database: (1205) Lock wait timeout exceeded; try restarting transaction Jan 5 09:57:54 ERROR[970]: cdr_addon_mysql.c:226 mysql_log: mysql_cdr: Failed to insert into database: (1205) Lock wait timeout exceeded; try restarting transaction Jan 5 09:58:45 ERROR[515]:...

hi there :) i get this error in the asterisk CLI: Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away when I run 'cdr mysql status' i get: Connected to voiceone at localhost, port 3306 using table cdr for 18 minutes, 24 seconds. Wrote 8 records since last restart and 1 records since last reconnect. I checked my /etc...

Hi list! I'm getting this error frequently: ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (2026) SSL connection error: SSL_CTX_set_default_verify_paths failed Right now, as a workaround, I reload Asterisk via cron once an hour, and after the reload everything is fine again _for a while_. Still, over the course of a month I lose about 12...

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: 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 ('2...

Hi, Need help on mysql cdr, i keep on seeing this log on the console. but my db is up and i see the calls being logged on the cdr table. is there a timeout when there is no activity? can i remove the timeout if there is any? thanks [Nov 25 13:22:37] ERROR[21026]: cdr_addon_mysql.c:171 mysql_log: cdr_mysql: Server has gone away. Attempting to reconnect. [Nov 25 14:20:32] ERROR[21061]: cdr_addon_mysql.c:171 mysql_log: cdr_mysql: Server has gone away. Attempting to reconnect. regards, nhadie

Following the latest * CVS update, my MySQL was broken. Following the update, Asterisk-addons would compile fine, but when I ran asterisk I got the following error: ERROR[1202489024]: cdr_addon_mysql.c:203 mysql_log: Failed to insert into databas I then tried using the patch (bug id 0001823) from bugs.digium.com, and found that Asterisk-addons would no longer compile, giving me the following errors: make clean ; make install rm -f *.so *.o .depend ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mys...

...2007-06-03 20:16:18] NOTICE[27408]: chan_sip.c:2758 auto_congest: Auto-congesting SIP/1014-081e93c0 [2007-06-03 20:16:18] NOTICE[27408]: chan_sip.c:2758 auto_congest: Auto-congesting SIP/1014-081e93c0 -- SIP/1014-081e93c0 is circuit-busy [2007-06-03 20:16:18] DEBUG[27424]: cdr_addon_mysql.c:210 mysql_log: cdr_mysql: inserting a CDR record. [2007-06-03 20:16:18] DEBUG[27424]: cdr_addon_mysql.c:226 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,userfield) VALUES ('2...

...62160]: rtp.c:189 send_dtmf: Sending dtmf: 49 (1), at 192.168.1.151 Aug 12 16:31:47 DEBUG[1127562160]: rtp.c:189 send_dtmf: Sending dtmf: 35 (#), at 192.168.1.151 == Spawn extension (local, 110, 2) exited non-zero on 'SIP/sip3-768a' Aug 12 16:31:51 DEBUG[1127562160]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Aug 12 16:31:51 DEBUG[1127562160]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUE...

Hi, I get the following after a call has finished: ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away Does this error message only appear when asterisk makes a new connection to mysql, because the old connection was stale (and dropped) ? If so, is there a way to get asterisk to stop reporting this as an error seeing it seem...

...-fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:107: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:107: (Each undeclared identifier is reported only once cdr_addon_mysql.c:107: for each function it appears in.) cdr_addon_mysql.c: In function `usecount': cdr_addon_mysql.c:417: `mysql_lock...

...x[5038]: Jan 7 15:37:00 DEBUG[1150495040]: File chan_sip.c, Line 567 (__sip_ack): Jan 7 15:37:00 asterisk_pbx[5038]: Jan 7 15:37:00 DEBUG[1150495040]: File chan_sip.c, Line 567 (__sip_ack): Jan 7 15:37:01 asterisk_pbx[5038]: Jan 7 15:37:01 DEBUG[1234379840]: File cdr_addon_mysql.c, Line 123 (mysql_log): Jan 7 15:37:01 asterisk_pbx[5038]: Jan 7 15:37:01 DEBUG[1234379840]: File cdr_addon_mysql.c, Line 130 (mysql_log): Jan 7 15:37:01 asterisk_pbx[5038]: Jan 7 15:37:01 DEBUG[1234379840]: File chan_sip.c, Line 1081 (sip_hangup): Festival's info is very minimal, but seems to indicate succes...

...cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:108: error: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:108: error: (Each undeclared identifier is reported only once cdr_addon_mysql.c:108: error: for each function it appears in.) cdr_addon_mysql.c: In function `usecount': cdr_addon_mysql...

..._mysql module, but I am receiving error messages. I have installed mysql-devel. Here is the output of make cdr_mysql: cc -fPIC -I/usr/local/mysql/include -I/usr/include/mysql -c -o cdr_mysql.o cdr_mysql.c cdr_mysql.c:30:26: mysql/errmsg.h: No such file or directory cdr_mysql.c: In function `mysql_log': cdr_mysql.c:74: `CR_SERVER_GONE_ERROR' undeclared (first use in this function) cdr_mysql.c:74: (Each undeclared identifier is reported only once cdr_mysql.c:74: for each function it appears in.) make: *** [cdr_mysql.o] Error 1 I have looked up CR_SERVER_GONE_ERROR, but I'm not sure...

...*. I've checked out the asterisk-addons but at "make install", I receive the following error: ./mkdep -fPIC -I../asterisk -I/usr/include/mysql `ls *.c` cc -fPIC -I../asterisk -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:113: structure has no member named `userfield' cdr_addon_mysql.c:114: structure has no member named `userfield' cdr_addon_mysql.c:114: structure has no member named `userfield' make: *** [cdr_addon_mysql.o] Error 1 any ideas? thanks, wr

running make gives: cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:108: error: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:108: error: (Each undeclared identifier is reported only once cdr_addon_mysql.c:108: error: for each function it appears in.) cdr_addon_mysql.c: In function `usecount': cdr_addon_mys...

Sometimes I get the following error on the console: [May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log: mysql_cdr: Failed to insert into database: (1062) Duplicate entry '1180628004.3214' for key 1 -- Zap/38-1 answered UniCall/11-1 Why would the UNIQUEID be duplicated? Isn't is supposed to be UNIQUE? This worries me a bit because the customer is losing calls that will not appear in...

...default => default => mp3:/home/asterisk/directory1/directory2/mp3 The problem is, that when I try to call with Dial using 'm' option asterisk don't call to the number. Here there are the debug message from asterisk: Jun 25 11:08:41 DEBUG[24595]: File cdr_mysql.c, Line 58 (mysql_log): cdr_mysql: inserting a CDR record. Jun 25 11:08:41 DEBUG[24595]: File cdr_mysql.c, Line 61 (mysql_log): cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2003-06-2...

...the database remotely and with MYPHPAdmin with the same setting below is a copy of my cdr_mysql.conf [global] hostname=192.168.2.9 dbname=asteriskcdr user=asteriskcdr password=<password> port=3306 sock=/tmp/mysql.sock The error I am getting is: ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: cannot connect to database server localhost. Call will not be logged. I am also getting this message though it might be unrelated: WARNING[1142106560]: File chan_sip.c, Line 435 (retrans_pkt): Maximum retries exceeded on call 1ec6564257f5e18b15c350742dcc5e68@192.168.2.9 for seqno 102...

...t;IAX2/815748XXXX-16", "815748XXXX") in new stack -- Executing Hangup("IAX2/815748XXXX-16", "") in new stack == Spawn extension (outbound-scripted, 555*, 2) exited non-zero on 'IAX2/815748XXXX-16' May 20 11:10:34 ERROR[3286]: cdr_addon_mysql.c:144 mysql_log: cdr_mysql: cannot connect to database server localhost. -- Hungup 'IAX2/815748XXXX-16' May 20 11:11:00 NOTICE[3275]: chan_iax2.c:7323 socket_read: Rejected connect attempt from 65.182.165.XXX, request '815748XXXX@outbound-scripted' does not exist exten => ${CALLERID(NU...

...asterisk -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon _mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:108: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:108: (Each undeclared identifier is reported only once cdr_addon_mysql.c:108: for each function it appears in.) cdr_addon_mysql.c: In function `usecount': cdr_addon_mysql.c:420: `mysql_lock...