similar to: Strange problem with channel allocation

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

hey all, I'm getting this warning on the console when I leave a voicemail on my test server: [Oct 16 20:56:36] WARNING[3853]: app_voicemail.c:6552 vm_exec: Prefixing the mailbox with an option is deprecated ('u250@local-vm-users'). [Oct 16 20:56:36] WARNING[3853]: app_voicemail.c:6553 vm_exec: Please move all leading options to the second argument. This is what voicemail.conf

Hello, in asterisk 1.4.30 all realtime configurations go well. In asterisk 1.6.2.11 the following appears on CLI : [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf) [Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: MyDBase (check

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

What would cause this? It happened out of the blue: -- Executing VoiceMail("Zap/3-1", "u326@default") in new stack -- Playing 'vm-theperson' (language 'en') -- Playing 'digits/3' (language 'en') -- Playing 'digits/2' (language 'en') -- Playing 'digits/6' (language 'en') -- Playing

Hello, I have configured one provider in Asterisk Realtime DB without username and password, only host=<providers_IP> and ipaddress=<providers_IP> Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/NUMBER at Provider) In Asterisk 1.4.15 debug I see that Realtime engine is using query: [Dec 20 00:02:15] DEBUG[14634]:

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

This is a problem with extconfig.conf - not your res_ or cdr_ ones. In your case - extconfig.conf probably contained something like 'sippeers => mysql,MyDBase,sippeers'. The 'problem' is that the middle parameter is no longer for the database name - it is for the context in res_mysql.conf. So, the above now becomes 'sippeers => mysql,general,sippeers'. Give that a

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

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

Oh heck. It really looks like realtime has been seriously screwed up. When a call comes in to Asterisk, I can see asterisk executing these queries. SELECT * FROM ast_sip_peers WHERE host = '2XX.YYY.142.205' SELECT * FROM ast_sip_peers WHERE name = '2944093' SELECT * FROM ast_sip_peers WHERE name = '2944093' So, the first thing it does is check and see if there are any

Hi ALL; I got the latest Asterisk-addons for Mysql-Cdr, but I have problem compiling that.It says: # make ..... ........ res_config_mysql.c: In function `realtime_mysql': res_config_mysql.c:143: warning: passing arg 1 of `ast_strlen_zero' makes pointer from integer without a cast res_config_mysql.c: In function `realtime_multi_mysql': res_config_mysql.c:242: warning: passing arg

hi,all when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql database anymore, error as follow: [Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf) the content of res_mysql.conf is: http://www.pastebin.org/81966 i've try command " mysql -uroot -proot" ,i can connect to

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 there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

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

Hi evereybody, I'm trying to use musiconhold during dial tones. But I only can call earing dial tones instead of music. Now will see my configuration files. AGI File(using AGI script to EXEC DIAL) print "EXEC Dial Zap/g2/numberc||m\"; $res=checkresult(); Extension.conf exten =>_numberb,1,Answer exten =>_numberb,2,SetMusicOnHold,default exten =>_numberb,3,AGI,dial.agi