search for: mysql_logs

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

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

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

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

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

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

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

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

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

I'm trying to compile the cdr_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'

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

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

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

Hi everybody, Firstly I'm going to describe the scenario where I'm working. I use a E400P with Asterisk CVS-05/22/03-11:14:50, and I'm working with asterisk trow AGI scripts (Perl). The configuration of extension.conf is: exten =>_s,1,Answer exten =>_s,2,AGI,script.agi Inside the AGI script is call Dial application as follows: print "EXEC Dial

I don't know if I have something screwed up with my MYSQL installation/Asterisk install or a bad configuration. I have imported the tables into a MYSQL database residing on localhost. I have check permissions on the user as well as the password and I have the same error comin up. I have succesfully connected to the database remotely and with MYPHPAdmin with the same setting below is a copy

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

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