Re: [asterisk-users] setting up ODBC for cdr logging into MariaDB
On 10/12/19 8:15 AM, Fourhundred Thecat wrote: did you compile libmyodbc yourself ? No, If I recall correctly, after a lot of searching, I ran into the apt source below and created the myodbc.list and put it into /etc/apt/sources.list.d cat myodbc.list deb http://ftp.de.debian.org/debian jessie main I just ignored the complaints about not having a GPG key. Doug -- _ -- 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
Re: [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 ? -- _ -- 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
Re: [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 -- _ -- 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
Re: [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 cov...@ccs.covici.com -- _ -- 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