similar to: error messages related to mysql in asterisk CLI

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

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

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'

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

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

Here is a log from a recent call made out on a ZAP channel from a SIP phone inside my network. For some reason, CDR is billing time even though the "busy tone" was detected. It's also logging the call as ANSWERED. Is this normal behavior? Seems a little odd to me. I have this as the first 3 lines of my zapata.conf [channels] busydetect=1 busycount=3 CVS HEAD updated late

Hi, Using Zack's -shared replacement posted earlier, addons now compiles. For some reason though, when trying to load it cannot find cdr_mysql.conf even though it's in the /etc/asterisk directory as it should be. Anyone with any ideas? There's still references to _i386 files that are probably incorrect as well. Thanks Rob console messages: apsvr1*CLI> reload Mar 23

Hello, I have an Asterisk box with a TE410P connected to a PRI line and agents with X-Lite installed on the same LAN as the Asterisk server. Sometimes, when I make outbound calls it hangs up as soon as other party tries to picks up the call. Does someone ever experienced this situation? On X-Lite, only G711-ulaw is enabled and here is what i put in sip.conf: [4001] type=friend username=4001

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 all, I think I've run out of options in terms of what I know about this. I have created a user called asteriskuser and granted all privileges to the asteriskcdrdb database. Then I created the table via the cdr_mysql.txt file. I have edited the cdr_mysql.conf file to reflect this, and added load => cdr_addon_mysql.so after compiling it from the latest CVS. If I check the

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

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'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 call from XLite phone to PSTN (I've tried this from internet and from local network the same) The Xlite doesn't write that it is connected but receives excelent audio. At the other end comes only noise. Some times only for a second you can here the caller voice , but this was only one time :) I saw with ethereal that UDP packets are coming and going to the asterisk

________________________________ From: Jody Gugelhupf <knueffle at yahoo.com> To: "asterisk-users at lists.digium.com" <asterisk-users at lists.digium.com> Sent: Thursday, November 29, 2012 10:23:01 PM Subject: audio trouble with asterisk, help very much appreciated Hi there :) first about my setup, running centos 6.2, asterisk 1.8.13.0, freepbx 2.9.0.12.? I have a