similar to: Help on ODBC & Asterisk usage

Hello, I have now been playing with Asterisk for about a week and absolutely love it! Unfortunately I seam to be having a problem with cdr records and mysql via the ODBC method It would appear to all be set up properly, and I am able to successfully. log inbound/outbound activity into my mysql cdr database. All the inserted values appear to be correct and meaningful but for the Duration

Hello everyone. Every time I try to install the odbc on wine, I've got this error [Image: http://img585.imageshack.us/img585/4769/winebug.png ] (http://imageshack.us/photo/my-images/585/winebug.png/) This seams to be, when mdac28 is being installed. Anyone can help me with this? Thanks, wizard2010 ------ System Information Ubuntu 10.10 Wine Version: 1.2.31 Winetricks Version: 20110629

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:

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

Both of our production asterisk servers are dumping core when making writes to our cdr tables. Here is a backtrace of the problems we are having: #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at util.c:347 347 if (tds_ctx && tds_ctx->err_handler) { (gdb) bt #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at

I notice you have MySQL-asterisk as your definition in your odbc.ini but you are trying to connect to simply 'MySQL' with your 'isql' command. Does isql work with 'MySQL-asterisk' as the DSN instead of simply 'MySQL' ? I have machines that use /etc/odbc.ini and machines that use /usr/local/etc/odbc.ini depending on if I used a package to instal ODBC or if I

I'm currently running a setup that's worked great with MySQL in the past, but we're migrating to ODBC for when we actually integrate the system into our current legacy/voip network. The database I'm trying to use is PostgreSQL, and I've got it working great for Realtime, and if I use cdr_pgsql for the cdr records. However, if I try to use cdr_odbc against the same

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. I have an Asterisk 13.14.1 setup which uses ODBC to write CEL and CDR records. The connection to my database server depends on a VPN tunnel being up, and if Asterisk starts before that tunnel is functional, I get messages such as the following in the Asterisk log file: [2020-06-23 10:40:22.384335] delta WARNING[1697]: res_odbc.c:958 in odbc_obj_connect: res_odbc: Error SQLConnect=-1

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

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

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 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 All, I have a quick question with regards the pbx_lua module. Would the lua dialplan have direct access to the odbc configuration within Asterisk, those odbc connections/dsn's that are defined in res_odbc.conf/extconfig.conf/cdr.conf? Thanks Bruce

Hi, I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not understand database functionality on asterisk fully. The most suspected area is func_odbc. I already googled but not luck. Your guide is warmly welcomed *Error messages when I make call and leave message.* -- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en') [2014-05-28

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

It looks like when you use odbc for CDR storage, rather than getting a Dispositon string like ANSWERED, CONGESTION etc, you'll get an integer (1,2,4,8). Does anyone know where I can find what strings (ANSWERED etc) these integers map to? Doug.

HI ALL; Is astersik enable to translate between different codecs. I have couple of SIP-UA , one with (a-law) and the other with (g729), registered with my astersik box.Can astersik translate between alaw-g729 and vice varsa. Regards mohammad -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello, I am trying to set up cdr logging into MariaDB through ODBC. I have installed unixodbc unixodbc-dev and now I am struggling with configuring /etc/odbcinst.ini All the examples online use non-existent libraries, ie: [MySQL] Description = MySQL ODBC MyODBC Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1 I have

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