[SR-Users] unixODBC failure/bug?

[Daniel-Constantin Mierla]

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 at 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 at 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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160429/cba7b30e/attachment.html>