similar to: cdr mysql error

Hi All, I have some Asterisk 1.2 servers using the cdr_mysql addon (1.2.3) spitting cdr's over to a MySQL database on another server. All 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

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

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

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

Hi i have an issue getting agentLogin working /etc/asterisk/queues.conf member => Agent/1001 member => Agent/1002 extension.conf exten => 110,1,Wait,1 exten => 110,2,AgentLogin() now, i call 110 by a firefly client, trying to login in as 1001 agent: Aug 12 16:31:36 DEBUG[1103408048]: chan_sip.c:4423 build_route: build_route: Contact hop: <sip:sip3@192.168.1.151:5060> --

I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58 I get the following errors: 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

I'm trying to compile cdr_addon_mysql but keep getting this error. Again, searching the Wiki and the mailing list archive didn't bring up anything useful. Any help? Yes, I'm using MySQL 4.0. Maybe I have to switch back to 3.23? # make 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

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

Having some trouble building cdr_addon_mysql. I've installed mysql and mysql-dev and all related rpms on a RH9 box. The box is up and running *. 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

>> I'm trying to compile cdr_addon_mysql but keep getting this error. >> Again, searching the Wiki and the mailing list archive didn't bring up >> anything useful. Any help? Yes, I'm using MySQL 4.0. Maybe I have to >> switch back to 3.23? >> >> >> # make >> cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o

Folks I am getting the following error as of today after updating both asterisk and asterisk-addons. These are both under /usr/src. Any ideas? dora-debian:/usr/local/src/asterisk-addons# make ./mkdep -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql `ls *.c` cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c

Hello, I know that there was a previous posting regarding this in which the addition of: CFLAGS+=-I../asterisk/include fixed the problem, but I have tried that and am still getting the following when trying to run make: ./mkdep -fPIC -I../asterisk/include/asterisk -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql `ls *.c` cc -fPIC -I../asterisk/include/asterisk -I../asterisk -D_GNU_SOURCE

hi, ive read through the last few posts with people having problems compiling the asterisk-addons for mysql support, and none of them have helped me resolve my compile problem. I currently have -- CVS-06/24/04-22:20:31 and downloaded asterisk-addons. I compiled * first then asterisk-addons, have added CFLAGS+=-I../asterisk/include When I try to make install for asterisk-addons i get

What's going on here? 555* seems to indicate that the number is being passed as the callerID because NoOp says the phone number. I'm trying to emulate cell phone voicemail where you call your own number to check your voicemail. -- Accepting AUTHENTICATED call from 65.182.165.XXX: > requested format = gsm, > requested prefs = (), > actual format

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 seems to write the CDR to

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack

Hello, I have Asterisk running on a RH9 box; Everything seems to be working as it should, except for Festival. Every time that Festival is called from Asterisk, Asterisk silently shuts down. Festival doesn't give any error indication and Asterisk just plain dies without a peep. Festival was installed per the Wiki, using source and patched with festival-1.4.3-diff; it works fine at the

Hi, I need help with modifying cdr_addon_mysql.c I want to have more fields in cdr table in asterisk. I've tried to modify cdr_addon_mysql.c and replace userfield with ex team (sed -e 's/userfield/team/g' ). When I try to recomplie menuselect/menuselect --check-deps menuselect.makeopts Generating embedded module rules ... make[1]: Nothing to be done for `all'.

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

I am trying to compile current cvs asterisk-addons for mysql cdr but I get the following error. Iam running mysql 4.0.20 and cvs v1 stable version of asterisk. cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -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