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

[Doug Lytle]

On 10/11/19 10:12 PM, 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:


On my Debian Buster I have:

dpkg -l|grep odbc

ii  libmyodbc:amd64               5.1.10-3 amd64        the MySQL ODBC 
driver
ii  libodbc1:amd64                2.3.6-0.1 amd64        ODBC library 
for Unix
ii  odbcinst                      2.3.6-0.1 amd64        Helper program 
for accessing odbc ini files
ii  odbcinst1debian2:amd64        2.3.6-0.1 amd64        Support library 
for accessing odbc ini files
ii  unixodbc                      2.3.6-0.1 amd64        Basic ODBC tools
ii  unixodbc-dev:amd64            2.3.6-0.1 amd64        ODBC libraries 
for UNIX (development files)

cat /etc/odbcinst.ini

[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/libodbcpsql.so.1
Setup           = /usr/lib/libodbcpsqlS.so.1
FileUsage       = 1

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup           = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage       = 1


Doug

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20191012/33aa3104/attachment.html>