similar to: ODBC Voicemail storage

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212]

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

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

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, im trying to get an odbc connection to work. Its no problem if asterisk an mysl running on one machine. When i try to set up an external DB it won't connect. External connections to the db are possible (bind-address = 0.0.0.0 and the user asterisk is allowed to connect from each ip). The password in the config is the right one i already double checked it. Jul 23 12:31:54

Hi all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get

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 list, yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>. I am using asterisk 1.4.2 with mysql. I also installed the proper odbc driver for

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

Hi, I am trying now for over 4 hours setting up cdr-logging via odbc into a mysql database. But with no success. Do you have any hint for me? cat /etc/odbc.ini ------------------ [MySQL-asterisk] Description = MySQL ODBC Driver Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = localhost User = xxx Password = xxx Database = asterisk Option = 3 Port = and /etc/odbcinst.ini

?Many people are reporting the same issue, so it is not my imagination. Asterisk 13 above 13.1 is useless for anybody who ?relies on res_odbc.so. As you know, after that version, the dropped the complexity of Pooling onto unix_odbc itself. Not so simple, it seems. I noticed that after a few hours of inactivity, any call to func_odbc-defined funcions will block and hang for ever. All we can do at

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

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

Hi list, I hope someone could help me. I've started using Asterisk 1.6.0.14 to get queue logs in real time with odbc (our databases are all PostgreSQL) but it's not working. However, cdr odbc is working well. When asterisk starts next message appears: WARNING[4217] config.c: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available My

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

Hi, I am using a 64-bit RHEL 5 machine. I built Asterisk latest 1.6 branch. The system has ODBC and Postgres installed. psql, isql and odbc work fine. Asterisk "make menuselect" for some reason does not see the installed packages and refuses to build res_odbc and other packages. How do I force it to do that? Is there a way to modify the output file from menuselect and make it