Thanks a lot Daniel, that was the culprit.

Best Regards
Dimitry Nagorny
Trainee

Von: sr-users [mailto:sr-users-boun...@lists.sip-router.org] Im Auftrag von 
Daniel-Constantin Mierla
Gesendet: Freitag, 29. April 2016 12:30
An: Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org>
Betreff: Re: [SR-Users] unixODBC failure/bug?


Hello,

can try with ODBC written with lowercase letters in DBURL? File names should be 
case sensitive on Linux OS.

Cheers,
Daniel

On 29/04/16 11:45, Nagorny, Dimitry wrote:
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




_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users@lists.sip-router.org<mailto:sr-users@lists.sip-router.org>

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



--

Daniel-Constantin Mierla

http://www.asipto.com

http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

Kamailio World Conference, Berlin, May 18-20, 2016 - 
http://www.kamailioworld.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to