similar to: Asterisk realtime error

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:

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==

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

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 am using the current HEAD of asterisk and for asterisk-addons. I have been trying to setup realtime mysql voicemail but no sucess. I keep getting this error below. The necessary modules are loaded, res_config_mysql.so ... Any pointers will help. Thanks mail*CLI> realtime mysql status Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL RealTime: Failed to connect

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

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

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:

Hi! I am new here. Well I'm doing a call center using asterisk and I'm looking for an open source screen pop software to pop the caller's information, its call history and others things. i was looking around and find the U-rang2 the problem is that it isn't open source. if someone knows about an open source screen pop please tell me. thanks in advance renzzo -------------- next

Hi; I have entries as below in DB, mysql> select * from sip_buddies; +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ | id | name | context | defaultip | host | mailbox | type | regseconds | ipaddr | username | port | +----+------+----------+------------+---------+------------+--------+-------

Dear Sir, Kindly note that I'm getting the following error when trying to register on asterisk server: [Feb 20 17:12:32] WARNING[2865]: res_config_mysql.c:358 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. I can connect to the database using the username and password defined inside res_mysql.conf but still getting the issue Regards -------------- next

I'm having a few issues with the MySQL realtime configuration in CVS-HEAD. I tested it initially with realtime extensions (realtime_ext => mysql,asterisk,extensions) and a realtime switch in extensions.conf and that works fine, So I though I'd go back and test a static configuration mapping. I used the table structure from the asterisk guru postgres howto to create something

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

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

It seems that when setting qualify = 200 or qualify = yes in the database for a sip friend/peer, RealTime does not update the registration status like it should. I also have several peers which have been offline and Asterisk still reports them as registered, even though the registration seconds are only 200. Asterisk Ver: CVS HEAD 12/1/2004 Layout of sip_buddies: mysql> describe

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Yes, we mostly talk about asterisk, hardware, software, phones, people, events and things asterisk-related. Asterisk is a registered trademark of Digium. Asterix is a registered trademark of Ren? Goscinny. We never discuss that, though. Here's the short URL for sending out to others that might be interested: http://x2z.eu It lands here: http://www.VoipUsersConference.org Once again, I

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 :

Hello there! I was testing Asterisk for the last two weeks using the Realtime driver for MySQL, and leaving "rtcachefriends=yes" configured to enable MWI. Today I started making additional tests with "rtcachefriends=no" because we will probably need to use Asterisk without this cache. For some strange reason, calls stop to get routed between the SIP clients. I've