similar to: asterisk with odbc

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

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

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

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 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, 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, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

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

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

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.

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

Hello list, scrambling different pieces of info together I've come with the following : I want to have my "register =>" statements in a MySQL-database, so I've made the following table. table ast_config : id 1 cat_metric 0 var_metric 0 commented 0 filename sip.conf category general var_name register var_val username:password at sip.provider.net In ext_config

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

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

Hello list, using asterisk 1.4.30. When setting up the MySQL table 'musiconhold' as described in http://www.voip-info.org/wiki/view/Asterisk+config+musiconhold.conf , what is the meaning of the fields : `*digit*` char(1) NOT NULL default '', `*sort*` varchar(16) NOT NULL default '', and what are there default values ?! What is the default value of :

Hi all, From the web, I can find a table scheme of sipusers for ARA using. However, I can't find any meaning of each field, especially for the field regserver which is new in the table. Can any tell me more detail about the usage of each field? CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `host` varchar(31) NOT NULL

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 all, I try to use a agi script to get a variable from * und put them into a script which gives me another variablke and put this in *. My problem is now it seems the var ID is empty coz i always jump into the result 0 loop. The $MSN should be in the SetCIDNum. #!/usr/bin/php -q <?php include("/var/lib/asterisk/agi-bin/phpagi.php"); $agi = new AGI(); $ID =