[asterisk-users] setting up ODBC for cdr logging into MariaDB

[John Covici]

I think you are missing a package, you need the odbc driver from
mariadb, downloaded from their git repository -- if you build this
using the default installation on a Debian type system, you would get
/usr/local/lib64/libmaodbc.so as the driver file.

On Fri, 11 Oct 2019 22:12:08 -0400,
Fourhundred Thecat wrote:
> 
> 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 these odbc related libraries on my system. Which of those do I
> have to use for `Driver =` ?
> 
>   /usr/lib/x86_64-linux-gnu/libodbc.so
>   /usr/lib/x86_64-linux-gnu/libodbccr.so
>   /usr/lib/x86_64-linux-gnu/libodbcinst.so
> 
>   /usr/lib/x86_64-linux-gnu/odbc/libesoobS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libmimerS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libnn.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg1S.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg2S.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcminiS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcnnS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libodbctxtS.so
>   /usr/lib/x86_64-linux-gnu/odbc/liboplodbcS.so
>   /usr/lib/x86_64-linux-gnu/odbc/liboraodbcS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libsapdbS.so
>   /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
> 
> I have tries many possible permutations, but none worked.
> 
> thanks,
> 
> -- 
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> 
> Check out the new Asterisk community forum at: https://community.asterisk.org/
> 
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 

-- 
Your life is like a penny.  You're going to lose it.  The question is:
How do
you spend it?

         John Covici wb2una
         covici at ccs.covici.com