Hi all,

I am trying to use the unixODBC module to connect to MariaDB as a first step and then to test it to connect to MSSQL (please don’t blame me on MSSQL...). I am using Kamailio 4.3.5 on CentOS7.2 fully patched. Here info about installed unixODBC:

[root@r5dev-KAM1 ~]# yum list installed | grep unix

unixODBC.x86_64                       2.3.1-11.el7                    @base

unixODBC-devel.x86_64            2.3.1-11.el7                    @base

Which leads me to my possible problem that I can’t start Kamailio with db_unixodbc.so because it is giving me this error:

r5dev-KAM1 /usr/local/kamailio/sbin/kamailio[16307]: ERROR: <core> [db.c:203]: db_bind_mod(): Module db_unixODBC not found. Missing loadmodule?

Followed by errors from modules depending on the DBURL are failing as well. Here my modules part:

...

#!define DBURL "unixODBC://root:<passw>@localhost/MARIADB"

...

# Module Path

mpath="/usr/local/kamailio/lib64/kamailio/modules/"

loadmodule "tls.so"

# ----- tls params -----

modparam("tls", "config", "/usr/local/kamailio/etc/kamailio/tls.cfg")

#loadmodule "db_mysql.so"

loadmodule "db_unixodbc.so"

...

I doublechecked that the module was compiled and is present:

[root@r5dev-KAM1 ~]# ls -ll /usr/local/kamailio/lib64/kamailio/modules/ | grep unix

-rwxr-xr-x. 1 root root  184451 28. Apr 08:56 db_unixodbc.so

I tried to check the db.c and db_unixodbc.c but I am not familiar with the c-syntax.

I somehow suspect that the error is related to Linux case sensitivity if db.c is trying to check if „unixODBC“ is installed and then trying to match it with the „db_unixodbc.so“ but I’m am not sure.

Can someone please give further advice?

Respectfully

Dimitry Nagorny

Trainee