similar to: mysql problems

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

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

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 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 Guys, We have just set up Asterisk (CVS Head) for a realtime enviorment using MySQL & Asterisk Addons. I have populated the "sip_buddies" table with the same information that is came from our sip.conf, however registration seems to fail for the softphone we have set up. Does anyone have any idea as to what I should be looking for here? I'm not getting any error messages

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

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

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 :

vpbx*CLI> sip show peers Name/username Host Dyn Nat ACL Port Status 621/621 192.168.250.76 D N 5060 OK (65 ms) 626/626 192.168.250.109 D N 5060 OK (180 ms) 616/Ronald Softphone (Unspecified) D N 0 UNKNOWN 615/Ronald office 192.168.250.103 D N 5060 OK (41

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

Hi all, I have recently installed asterisk 1.4.1 and asterisk-addons (1.4). I have configured the extconfig.conf file and mapped sippeers to mysql as such; sippeers => mysql,asterisk,sip_buddies I have created the sip_buddies table and checked that we can login to the mysql db from the command prompt. I have also copied the res_mysql.conf.sample file as res_mysql.conf to the

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:

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, I noticed that changes to realtime sip peers are not applied until a 'reload'. A 'sip reload' does not make any changes to realtime sip peers. When changing for instance the mailbox-parameter in the realtime sip_buddies table, the change is not applied with a 'sip reload'. For every change there is a complete 'reload' necessary. Why does a 'sip

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

Hi everybody, First of all i am sorry my English :) i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below [root at ao042 asterisk]# isql -v asterisk +---------------------------------------+ | Connected! | | | |

maybe a dumb question but what do we have here??? sip-friends.sql # # Table structure for table `sipfriends` # CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `username` varchar(40) default '', `ipaddr` varchar(20) NOT NULL default '',

Howdy, My first forray into using res_mysql.conf for realtime access of sip users and extensions. I have the following relevant section of extensions.conf: --- [trunklocal] exten => _NXXXXXX,1,Dial(${GLOBAL(TRUNK)}/${EXTEN:${GLOBAL(TRUNKMSD)}}) [local] include => trunklocal include => trunktollfree [longdistance] include => local include => trunkld [international] include