search for: realtime_mysql

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

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 res_mysql.conf) res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = MyDBase dbuser =...

...<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]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' to retrieve info about this device. And in Asterisk 1.4.16.1 I see: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'P...

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 1 of `ast_strlen_zero' makes pointer from integer without a cast res_c...

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 mysql successfully. Could you tell me what's wrong with me ? -- Best regards...

...rs Mailing List - Non-Commercial Discussion Subject: [asterisk-users] Upgrade from 1.4 to 1.6 : problems with realtimemysql 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 res_mysql.conf) res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = MyDBase dbuser = as...

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]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Everything is fine. Column Name Column Value -------------------- --------------------...

...== Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack [2007-06-03 20:16:10] DEBUG[27424]: res_config_mysql.c:650 mysql_reconnect: MySQL RealTime: Everything is fine. [2007-06-03 20:16:10] DEBUG[27424]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_peers WHERE name = '1014' -- Called 1014 [2007-06-03 20:16:10] WARNING[27424]: channel.c:3222 ast_channel_make_compatible: No path to translate from SIP/1014-081e93c0(256) to OSS/dsp(64) [2007-06-03 20:16:10] WARNING[27424]: channel.c:322...

...DYNAMIC; and my extconfig.conf looks like this... [settings] sipusers => mysql,voip,sip sippeers => mysql,voip,sip voicemail => mysql,voip,voicemail extensions => mysql,voip,extensions and when my phone tries to register i get Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:117 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '5625551212' Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:605 mysql_reconnect: MySQL RealTime: Everything is fine. Mar 24 21:26:32 DEBUG[28397]: db.c:177 ast_db_get: Unable to find key '5625551212' in family 'SIP/...

...ve fixed this problem. i want res_config_mysql.so any one help me ----------------------------------------------------- [root@localhost asterisk-addons]# make cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o res_config_mysql.o res_config_mysql.c res_config_mysql.c: In function `realtime_mysql': res_config_mysql.c:142: warning: passing arg 1 of `ast_strlen_zero' makes pointer from integer without a cast res_config_mysql.c:144: warning: assignment makes pointer from integer without a cast res_config_mysql.c:149: warning: assignment makes pointer from integer without a cast res_con...

...make res_config_mysql gcc -g -c -fPIC -o res_config_mysql.o res_config_mysql.c gcc res_config_mysql.o -o res_config_mysql /usr/lib/gcc/i386-redhat-linux/3.4.6/../../../crt1.o(.text+0x18): In function `_start': : undefined reference to `main' res_config_mysql.o(.text+0x4e): In function `realtime_mysql': /usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:100: undefined reference to `ast_log' res_config_mysql.o(.text+0xb5):/usr/local/src/asterisk-addons-1.4.1/res_config_mysql.c:108: undefined reference to `ast_log' res_config_mysql.o(.text+0x181):/usr/local/src/asterisk-addons-1...

...; Realtime/outgoing@extensions [asterisk1] switch => Realtime/sip@extensions include => outgoing ------------------------------- so now i'm trying to get calls to work correctly, and when a incoming call comes in it gives this error Mar 23 20:09:18 DEBUG[27067]: res_config_mysql.c:117 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '5625551212' Mar 23 20:09:18 DEBUG[27067]: res_config_mysql.c:605 mysql_reconnect: MySQL RealTime: Everything is fine. Mar 23 20:09:18 DEBUG[27067]: db.c:177 ast_db_get: Unable to find key '5625551212' in family 'SIP/...

...9;./astconf/sip_buddies.frm' (errno: 13) [Feb 24 09:05:25] DEBUG[32664]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_buddies WHERE name = '494' [Feb 24 09:05:25] DEBUG[32664]: MySQL RealTime: Everything is fine. and in CLI: [Feb 24 09:23:16] WARNING[32664]: res_config_mysql.c:135 realtime_mysql: MySQL RealTime: Failed to query database. Check debug for more info. [Feb 24 09:23:16] NOTICE[32664]: chan_sip.c:10935 handle_request_register: Registration from '"886" <sip:886@vpbx.elmit.com>' failed for '61.218.43.42' - Username/auth name mismatch I have ad...

...37 <sip:xxxxxxxx@yyy.yy.yyy.yyy:5060;user=phone;transport=' is not a valid SIP contact (missing sip:) trying to use anyway Any ideas how to stop this? Most of the time it's harmless but some make the SQL queries so long they overflows sql in res_config.c: static struct ast_variable *realtime_mysql(..) { char sql[256]; .. snprintf(sql, sizeof(sql), "SELECT * FROM %s WHERE %s%s '%s'", table, newparam, op, newval); .. } then: Apr 25 11:29:46 DEBUG[1480] res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sip SET ipaddr = 'yyy.yy.yyy.yyy', port = '2...

...[2007-01-15 11:06:23] DEBUG[28528]: db.c:236 ast_db_del: Unable to find key 'edwin' in family 'SIP/Registry' [2007-01-15 11:06:23] DEBUG[28521]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [2007-01-15 11:06:23] DEBUG[28521]: res_config_mysql.c:139 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM SipUser WHERE name = 'edwin' [2007-01-15 11:06:23] DEBUG[28521]: acl.c:199 ast_append_ha: 0.0.0.0/255.255.255.255 appended to acl for peer [2007-01-15 11:06:23] DEBUG[28521]: acl.c:199 ast_append_ha: 10.0.1.77/255.255.0.0/255.255.0.0 appended...

...ecember 20, 2007 1:35 AM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 > > On Wednesday 19 December 2007 16:12:27 Mindaugas Kezys wrote: > > [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 = realtime_mysql: > > MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name =3D=20 > > 'Provider' AND host =3D 'dynamic' > > > > Note: host =3D 'dynamic' > > Correct, that's the FIRST lookup that is done. > > It then checks the IP address and...

...e this for the first time. Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation. With debug I can see: [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = '109' AND host = 'dynamic' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:365 update_mysql: MySQL RealTim...

...05:39:22] DEBUG[15081]: chan_sip.c:21658 handle_incoming: Ignoring SIP message because of retransmit (REGISTER Seqno 44199, ours 44199) [Oct 5 05:39:22] DEBUG[15081]: res_config_mysql.c:1602 mysql_reconnect: MySQL RealTime: Connection okay. [Oct 5 05:39:22] DEBUG[15081]: res_config_mysql.c:371 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM VOIP_Comptes_SIP WHERE name = 'SIPUSER001' AND host = 'dynamic' [Oct 5 05:39:22] DEBUG[15081]: chan_sip.c:23734 build_peer: -REALTIME- peer built. Name: SIPUSER001. Peer objects: 13 [Oct 5 05:39:22] WARNING[15081]: acl.c:392 ast_get_...