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

[Fourhundred Thecat]

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,