similar to: Realtime MySQL - Asterisk 1.8.2

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

Hi to all! I'm trying to create a context for integration with extensions.lua and libsql.mysql, but I'm not getting to run. When I reload the module pbx_lua.so the following error appears: [Feb 24 16:59:29] ERROR[30749]: pbx_lua.c:1249 exec: Error executing lua extension: error loading module 'luasql.mysql' from file '/usr/lib/lua/5.1/luasql/mysql.so':

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 friends, I am using Real Time Asterisk Architecture where I have put the Sip users/peers and extensions defining the dialplan in tables in a mysql database. Currently, asterisk points to my single database server as configured: ------------------------------------------ /etc/asterisk/res_mysql.conf ------------------------------------------ [general] dbhost = xxx dbname =

Hi Is there any harm in using res_mysql for some things and res_odbc for others? We already use res_mysql for ARA but could do with having CEL logged to MySQL. Thanks in Advance Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: ish at pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, Duplex

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

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, Can Asterisk write to multiple MySQL databases in different machines, at the same time, as a backup scheme? If it does, where can that be configured? In res_mysql.conf file? Does anyone ever made it? Regards, Ricardo. -------------- next part -------------- An HTML attachment was scrubbed... URL:

there is a problem in compiling asterisk-addons any one have 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':

Okay, so here's the configuration I have for MySQL Realtime (Asterisk version 1.6.2.17): In /etc/asterisk/extconfig.conf: sipusers => mysql,mya2billing,cc_sip_buddies In /etc/asterisk/res_mysql.conf: [mya2billing] dbhost = localhost dbname = mya2billing dbuser = a2billinguser dbpass = REDACTED dbport = 3306 And here's the error messages I get: voip2*CLI> realtime mysql status

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

Hi, list. We have a problem with loss peers after 'sip reload', our configuration: Asterisk 11.6-cert1, SIP realtime peers, sip.conf: - rtcachefriends=yes - rtsavesysname=yes - rtupdate=yes - rtautoclear=yes When we do 'sip reload' , peers are removing from available. Before `sip reload` : srv-pbx2*CLI> sip show peers Name/username Host

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

I am trying to configure RealTime Voicemail with MySQL. I downloaded compiled and installed the CVS HEAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the

I've got my res_mysql.conf stating: [general] dbhost = 127.0.0.1 dbname = switchref dbuser = asteriskuser dbpass = xxxxxxx dbport = 3306 and my extconfig.conf stating: sipusers => mysql,switchref,sip_buddies sippeers => mysql,switchref,sip_buddies When Asterisk starts, and I show peers and show users, I don't see anything that is in the database. When looking at the traffic

Hi actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. I read on the wiki: =================================================== Database Config put the following in res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = myuser dbpass = mypass dbport = 3306 Values in sip.conf or iax.conf like in older versions of * are no longer used. Database Table Lets

Guys, I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database

Hi All. I have export some db parameter in /etc/bashrc as follows ... export DB_NAME=xyz export DB_IP=1x.1x.1x.1x export DB_PWD=dkjfaoi Now, I want use these all environment variable into /etc/asterisk/res_mysql.conf file. Is there any way to do this..?? -- Regards, Chandrakant Solanki -------------- next part -------------- An HTML attachment was scrubbed... URL:

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing