similar to: Upgrade from 1.4 to 1.6 : problems with realtime mysql

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

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

Hello I have already several Asterisk servers running with similar configuration, but now I stumble into a problem. I have mysql configuration res_config_mysql.conf : [MyAsteriskDB] dbhost = 127.0.0.1 dbname = MyAsteriskDB dbuser = astadmin dbpass = mysecret dbport = 3306 dbsock = /var/lib/mysql/mysql.sock requirements=warn ; or createclose or createchar Realtime seems to be loaded :

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

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 =

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

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

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

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

Hello all, I recently noticed the realTime effort and must say it is a nice idea! I would appreciate any help to get it running .. I downloaded the code & patches and succefully patched my asterisk (CVS-HEAD-11/29/04-12). - created a DB called asterisk, and a table sip using the schema supplied at http://bugs.digium.com/bug_view_page.php?bug_id=0002613. - entered an entry: insert into

Does anybody have realtime queue members working? Not the queues themselves, just the members. I have realtime working for voicemail and sippeers, but I can't get queue members to work. Here is what I have: res_mysql.conf: [general] dbhost = 127.0.0.1 dbname = ASTERISK dbuser = myuser dbpass = mypass dbport = 3306 dbsock = /tmp/mysql.sock queues.conf: [general]

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

Hello *'s, i am using Realtime Sip drivers but its not working here is my configs: extconfig.conf [settings] ; Realtime configuration engine ; ; maps a particular family of realtime ; configuration to a given database driver, ; database and table (or uses the name of ; the family if the table is not specified ; sipfriends => mysql,asterisk,sip_friends res_mysql.conf [general] dbhost =

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

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Thanks John, You are my savior. This is such a great relief. Apparently realtime will not use either '127.0.0.1' or 'localhost' to connect to the database. I had to use the actual IP address attached to the NIC before it worked. My OS is Debian just a note and Asterisk HEAD from August 20, 2005 Details below for those who might be swimming in the same pool with me.

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