similar to: ODBC version for cdr?

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

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

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

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 =

I have been searching for the last two days and I cannot seem to set Asterisk to work from a database, can someone please tell me what I am doing wrong here? Here are my files [app_dbodbc.so] => (Database access functions for Asterisk extension logic) == Parsing '/etc/asterisk/odbc.conf': Found > app_dbodbc: dsn is MySQL-asterisk > app_dbodbc: username is

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

I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on my-server Driver=/usr/lib64/libmyodbc3.so SERVER=my-server I can successfully do the following:

Hello, I'm using Slackware 11.0. I've installed unixODBC from the source files. I've built and tested an odbc connection. I'm trying to install Asterisk 1.4. I can't get it to recognize the unixODBC installation. I've tried using the "--with-odbc=/usr/local" flag to the configure process. .... checking for SQLConnect in -lodbc... no configure: ***

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

I'm trying to move our asterisk setup from an i686 server to an x86_64 (Dual AMD Opteron) server. Everything has been manually compiled: MySQL 4.1.10, MyODBC 3.51.11, unixODBC 2.2.10 (because I couldn't find any usable RPMs). And obviously Asterisk, where I'm using the STABLE release CVS-Nv1-0-5-02/21/05. The OS is Redhat Enterprise ES 4.0, kernel 2.6.9-5.0.3.ELsmp. Asterisk is

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

We are using DISA with local SIP users. The user enters in a 2 digit code then they get a dialtone and the phone dials out. The problem is that the calls waits 10 seconds after the outgoing number is dialed, no matter what I put for the timeout values. Anyone else using DISA that has run into this? exten => _2X,1,Answer exten => _2X,2,DigitTimeout(2) exten =>

Hi, I'm expiriencing very annoying issue with Asterisk while using ODBC on Linux box running Debian with following packages: Asterisk-node0:/tmp# dpkg -l | grep -i odbc ii libiodbc2 3.52.6-2 iODBC Driver Manager ii libmyodbc 3.51.15r409-4 the MySQL ODBC driver ii libodbcinstq1c2

If I upgrade libpri 1.4.0 to 1.4.1, do I then need to recompile asterisk even though I'm not upgrading asterisk? -- ----- Chris Stinson Network Operations Center ISDN-Net, Inc. 615-221-4200 x103 noc at isdn.net

i have installed the asterisk 1.6 before that installed the necessary packages in Debian, * i followed the steps as follows, root at astserver: ~# apt-get install unixodbc unixodbc-dev odbc-postgresql postgresql-8.1 postgresql-contrib postgresql-dev * then i installed the asterisk 1.6 version with the odbc modules as in the selected list. * then i created the database as asterisk and the user

This is my musiconhold.conf and my folder: root@voip:/etc/asterisk# less musiconhold.conf [classes] default => quietmp3:/var/lib/asterisk/mohmp3 ;loud => mp3:/var/lib/asterisk/mohmp3 ;random => mp3:/var/lib/asterisk/mohmp3,-z ;unbuffered => mp3nb:/var/lib/asterisk/mohmp3 ;quietunbuf => quietmp3nb:/var/lib/asterisk/mohmp3 ; Note that the custom mode cannot handle escaped parameters

I'm having an issue with an asterisk install that anything recorded (in .gsm format) and all of the pre-recorded .gsm files are choppy. All calls into the asterisk box is fine and any voice mails left in a box are fine as well. It's just the playback of any recorded message and any of the pre-recorded files. Anyone have an idea what might be going on? The only problem is the playback of

I'm not really being too lucky in the last days. After trying to compile cdr_mysql with no success, I am switching to cdr_odbc. I have installed unixODBC, iODBC and MyODBC correctly, I am even able to make queries with isql. But when trying to "make" in the cdr directory of the latest CVS, that's what I get: # cd /usr/src/asterisk/cdr # make cc -o cdr_odbc.so cdr_odbc.o -lodbc