thr3ads.net - asterisk users - [asterisk-users] setting up ODBC for cdr logging into MariaDB [Oct 2019]

If this information is useful, please help other people find it:
Share via:

Fourhundred Thecat

2019-Oct-12 02:12 UTC

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

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,

John Covici

2019-Oct-12 05:35 UTC

head link

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

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

Doug Lytle

2019-Oct-12 09:06 UTC

head link

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

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>

Fourhundred Thecat

2019-Oct-12 12:15 UTC

head link

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

On 12/10/2019 11.06, Doug Lytle wrote:> 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
>
> [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
thank you. My system is also Debian Buster. I have same packages
installed, except libmyodbc

There is no such package in the repositories:
 apt-cache search libmyodbc

and thus, I have no file /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so

did you compile libmyodbc yourself ?

Reasonably Related Threads

Search for more seemingly similar threads

asterisk users - Oct 2019 - setting up ODBC for cdr logging into MariaDB

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

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

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

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

Reasonably Related Threads