similar to: MSSQL ODBC Connections

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

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

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple

Hi, all What is the use of astdb? Is it used to store realtime values like sip etc. Regards, Bhrugu Mehta -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100127/b13d6a62/attachment.htm

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

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'm trying to get asterisk cdr_odbc configured, but it can't connect through my odbc driver. switchboard*CLI> module load cdr_odbc [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: cdr_odbc: Unable to connect to datasource: asterisk /etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup =

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

Hello, I'm trying to execute a stored procedure on a MSSQL Server from the dial plan, but it's not working. I'm getting the following error: Unable to execute query.... Asterisk has been compiled with UnixODBC, and I've done the necessary configurations in func_odbc, res_odbc and odbc.ini. Has anyone done this before with success? -------------- next part -------------- An HTML

On 12/07/2018 02:25 PM, Joshua C. Colp wrote: > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote: >> >> Hi, >> >> is cdr logging using odbc buggy? I'im only getting an error >> "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". >> >> Connecting with isql to the datasource given in cdr_odbc.conf works just >> fine,

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, Trying to compile ODBC support in asterisk for DB integration. I had this working with MySQL on the same machine, but have never used ODBC driver. Have used yum to install the following: compat-gda-odbc.i386 1.2.4-1.fc6 installed libgda-odbc.i386 1:1.9.100-10.fc6 installed mysql-connector-odbc.i386 3.51.12-2.2

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

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

Hi, Since a few days I'm experiencing this: > cdr_odbc: Connected to asterisk > cdr_odbc: Error in Query -1 > cdr_odbc: Query FAILED Call not logged! > cdr_odbc: Connected to asterisk > cdr_odbc: Reconnecting to dsn asterisk > cdr_odbc: Trying Query again! > cdr_odbc: Error in Query -2 > cdr_odbc: Query FAILED

hi, all i want to create cd-rom with asterisk. how it possible. when i put disk in cdrom it boot automatifcally and auto-start installation like TRIXBOX. any idea. thnks, Bhrugu Mehta

Hello, I'm stuck with getting cdr records stored in MySql database. I have a working realtime environment and have verified that the db connection works fine when used via res_config_mysql.conf. I'd appreciate Your help on how to get the odbc connector working as I think there's something wrong with its configuration. The problem presented itself as an error when making a call that