Re: [SR-Users] unixODBC failure/bug?

Thanks a lot Daniel, that was the culprit. Best Regards *Dimitry Nagorny* Trainee *Von:*sr-users [mailto:sr-users-bounces@lists.sip-router.org] *Im Auftrag von *Daniel-Constantin Mierla *Gesendet:* Freitag, 29. April 2016 12:30 *An:* Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.sip-router.org&gt; *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(a)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://twitter.com/#%21/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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users