similar to: Realtime Failover - Multiple DSN 's in extconfig.conf

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

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

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config:

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

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

Hi All, I am trying to configure asterisk realtime. But i am unable to get the extensions listed successfully when i type "sip show peers" in the asterisk CLI . i am unable to see any failure logs when i do a reload i can able to connect to the data source through "odbc show" in the CLI, Any hep in this regard is highly appreciated. Following is the configuration

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

I am using asterisk 1.6.1.6 and have been setting up a system to use a Postgresql database as the realtime DB via the ODBC route. I have got extensions and voicemail working but am having trouble with SIP The problem seems to be with using a schema. If I put the table "sip" in the schema "foo" then I add this entry to extconfig.conf sippeers => odbc,psqldb,foo.sip Restart

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

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

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, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available

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! Please is it possible for Cisco 5XX phones to use asterisk/FreePBX phone directories, and if so, how? Thanks in advance! On Feb 17, 2013 6:40 PM, <asterisk-users-request at lists.digium.com> wrote: > Send asterisk-users mailing list submissions to > asterisk-users at lists.digium.com > > To subscribe or unsubscribe via the World Wide Web, visit >

Hello there I'd like to use sip users and peers realtime. I think I done all I need to get asterisk works fine in realtime: res_odbc.conf configuration. extconfig.conf sippeers => odbc,asterisk,sipclient sipusers => odbc,asterisk,sipclient sip.conf [general] rtcachefriends=yes The sipclient table as suggest in this article: SIP Realtime, MySQL table structure (

I have configured my mysql database by following this link http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue The only difference is that I am using ODBC instead of MySQL with Realtime. Within extensions.conf I have the following for my queue exten => 9**2**1611,1,Answer exten => 9**2**1611,2,Queue(irock.com,tT,,,300) exten => *50,1,Answer exten =>

So this is what i've done so far... my extconfig.conf looks like this [settings] ;example => odbc,asterisk,alttable ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk sipusers => mysql,voip,sip sippeers => mysql,voip,sip voicemail => mysql,voip,voicemail extensions => mysql,voip,extensions -------------------- and my extensions.conf has the following lines in it.

Hi, I have 2 databases DBNAME1 and DBNAME2. In each database I have a table called sipusers (so DBNAME1.sipusers and DBNAME2.sipusers). Can I use both sipusers tables in Asterisk RealTime? Something like this: /etc/asterisk/extconfig.conf: [settings] sipusers => odbc,DBNAME1,sipusers sippeers => odbc,DBNAME1,sipusers sipusers => odbc,DBNAME2,sipusers sippeers =>