similar to: asterisk-users Digest, Vol 38, Issue 83

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

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

Hi all, I'm using asterisk in real time mode...All extensions are defined in table sip_buddies...Everything looks fine and asterisk is reading extensions info from the sip_buddies table...The problem occurs as soon as any information on an extension is changed from sip_buddies table...Which mean, if I change the secret field in sip_buddies table then i should reload asterisk to read again 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'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

hello i am trying to use res_odbc for sipuser. my connection is working. i have checked using isql. even cdr_odbc is working but i hav problem in res_odbc. i have created user in sip_buddies table but asterisk is no getting user from this sip_buddies table. /etc/asterisk/extconfig.conf [settings] sipusers=>odbc,asterisk,sip_buddies sippeers=>odbc,asterisk,sip_buddies

Hello, Asterisk. I am currently using Asterisk (asterisk-1.2.13) and asterisk-addons-1.2.3_1 on FreeBSD 6.1-RELEASE-p10 So, after setup asterisk for realtime extension: res_mysql.conf: [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = asterisk dbpass = asterisk dbport = 3306 dbsock = /tmp/mysql.sock res_odbc.conf: [mysql] enabled => yes dsn => asterisk username => asterisk

can anybody identify why the CLI is issuing a failure message while debug shows everything is fine???? this makes no sense to me. also, why is the username being updated? this has got to be wrong from CLI -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 Dec 24 12:16:35 NOTICE[15776]:

Hi all, I have configured Asterisk using Mysql database. The peers that I have mentioned in the database are successfully registered to Asterisk, But I am getting a warning stating "Mysql realtime: Failed to query the database" Below I am pasting error. Could anybody please let me know what's the cause for this warning.... *CLI> -- Registered SIP 'bharat'

Hi, I've troubles with setting up Asterisk Realtime and MD5 authentication. With clear text passwords everything is working fine. -- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600 -- Saved useragent "Cisco-CP7940G/8.0" for peer edwin [2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine.

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100)

I am using Realtime on Asterisk 11.5 with a SQLite3 backend. While everything seems to be working fine I keep getting this error on my log files: [2014-02-17 19:55:18] WARNING[20569] res_config_sqlite3.c: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = '5060', "regseconds" = '1392692118',

hello i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf => odbc,mysql1,sip_buddies sipfriends => odbc,mysql1,sip_buddies

hello i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this odbc connection is working properly is there some thing required /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf =>

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