similar to: Realtime & sippeers using NAT

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

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

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

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

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 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've been going in circles for a few weeks now with Realtime SIP. My extconfig.conf has: sipusers => mysql,dbname,ast_sip_users sippeers => mysql,dbname,ast_sip_users When I do a 'sip show peers' I see all my phones. When I do a 'sip show users' I only see a few of them. I can't work out why this is the case. They are also coming up with NAT as

Hi, I would have expected that peers of type friend ( for example an SIP-phone) registring at Asterisk will be searched in sipusers. But the peers will be searched in sippeers. May be sombody can explain the difference? Asterisk 1.4 thanks Thomas

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

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

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

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.

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 Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

Hi I am trying to make asterisk load config from database, so far I get the sip, extension working, but voicemail seems still looking for config file, not from the database. the extconfig.conf looks like ... sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies extensions => mysql,asterisk,extensions_table voicemail => mysql,asterisk,voicemail_users .. 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: