similar to: cdr_addon_mysql 'Failed to insert into database' stops * call processing

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

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'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

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

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

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]:

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> --

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'.

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

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

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

Good Afternoon Everyone, I am having a problem with compiling the CVS version of *-addons downloaded today. I am also having problems compiling an older version as well but im ignoring that one for now. I believe I have all the correct libraries, and I have done extensive searches everywhere I just wondered if I was missing something really silly, or if this is a problem other people have

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