similar to: Debugging Realtime Asterisk

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

Anyone have any idea what this is talking about. Here is my zapata.conf [channels] switchtype=5ess signalling=pri_cpe echocancel=yes echocancelwhenbridged=yes echotraining=400 callerid=asreceived group=1 context=default musiconhold=default faxdetect=incoming channel => 1-23 Here is my zaptel.conf span=1,1,0,esf,b8zs bchan=1-23 # set this to 1-15,17-31 for E1 dchan=24 # set this to 16 for

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to

I have been playing with res_odbc in these last days, but it doesn't want to work. This is the output when starting Asterisk, so everything seems OK: [res_odbc.so] => (ODBC Resource) == Parsing '/etc/asterisk/res_odbc.conf': Found Jul 7 20:11:32 NOTICE[-1084915040]: res_odbc.c:132 load_odbc_config: registered database handle 'mysql' dsn->[MySQL-asterisk] Jul 7

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

Hi, Can somebody tell me what I've been doing wrong for the res_config_odbc not to work properly. I already looked on the mailing list for some answer but I can't find one. The closes subject I found is "res_odbc not working". Btw, I already followed BKW reply on that subject. I guessed the log below can tell us res_odbc.so is succefully loaded, so it easy to presumed it

Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings=

Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---------------------------------------+ | Connected! | | | |

If someone could explain me this (added some extra debugging code Mar 10 00:47:13 NOTICE[7561]: chan_sip.c:8448 handle_request: Registration from '<sip:a7@domain>' failed for '172.20.41.7' Mar 10 00:47:13 WARNING[7561]: res_config_odbc.c:97 realtime_odbc: SQL param name is a7 Mar 10 00:47:13 WARNING[7561]: res_odbc.c:90 odbc_smart_execute: SQL Execute error! Attempting a

Hi I was trying to have realtime voicemail working with ODBC Driver. Everything works fine with MySQL Realtime access, BUT as I want to implement ODBC Storage as well, it seems that everything should go through ODBC ( what I read on voip-info wiki page ) But I do not manage to make it work with ODBC. Outside Asterisk, ODBC works fine, I can access my databases & tables ! Asterisk fails to

Hi, ? I want queues.conf to be stored on a MySQL database using dynamic realtime. I am using asterisk 11.2.1 and?MySQL 5.1.67, the?MySQL database is hosted on?another server but?I can access the?database via ODBC. ? I have created the following tables: ? SQL> show tables; +-----------------------------------------------------------------+ |

Has anyone had any luck with PostgreSQL and Realtime? The realtime instructions on voip-info seem pretty straight forward... just not woking for me. I've included all of my config files below, and my console output. Entire console bootup output: [root@abox asterisk]# /usr/sbin/asterisk -vvvvvvc == Parsing '/etc/asterisk/asterisk.conf': Found == Parsing

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

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 am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

Hi all I'm trying to configure my Asterisk setup to load the musiconhold.conf file from an ODBC connection to MySQL, working through the example given in the excellent book "Asterisk: The Definite Guide". I'm using Asterisk 1.4.19 and MySQL 5.1.58. I've configured the ODBC bit and in my GeneralLog on MySQL I can see the asterisk user connecting and sending a few SQL

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

I have an Ubuntu system and went into Synaptic and checked asterisk for installation. Once installed, I started it with /usr/sbin/asterisk -vvvgc and got the following output with several errors and notices. Do I need to do more or are these ok? I expected to have some conf files in /etc/asterisk but there is nothing there. Thanks! Created by Mark Spencer <markster@digium.com>

Hi I'm using asterisk 1.0.3_1 from the freebsd ports. Everything works ok, except I can's get res_config to populate sip.conf (or any other conf file for that matter). my unixodbc works and I can access the database with the isql tool. There are no warnings or anything else in the asterisk log file indicating a problem. I have used the guide from