similar to: real time connection failed

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:

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

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

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:

Hi, I'm starting testing 1.6.2 beta. CentOs 5.2 I found my first crash, first I have [Mar 20 20:30:41] WARNING[11201]: res_config_mysql.c:611 update_mysql: Attempted to update column 'useragent' in table 'sip', but column does not exist! [Mar 20 20:30:41] ERROR[11201]: res_config_mysql.c:581 update_mysql: MySQL RealTime: Updating on column 'lastms', but

I get that a lot since moving to 1.4.21 (from 1.4.18 or something). [Jun 17 09:19:54] WARNING[22053]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Question 1: what debug file should I be looking at? Mick -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

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 to all. I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration

Hello, We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see 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]:

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

Dear All, I would like to ask please if someone has a AGI script that select a value from a database and dial this value as a destination number Regards -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090220/e2aa530c/attachment.htm

I am getting this error when reload my asterisk "cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf" I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf which is attached Res_odbc.conf ============== ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes

Hello, I just checked out the latest CVS and compiled and now get the following error: [res_config_mysql.so] => (MySQL RealTime Configuration Driver) Jan 26 13:03:51 WARNING[27081]: config_old.c:27 ast_load: ast_load is deprecated, use ast_config_load instead! == Parsing '/etc/asterisk/res_mysql.conf': Found Jan 26 13:03:51 WARNING[27081]: res_config_mysql.c:561 parse_config: MySQL

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

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

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 =