[unixODBC-support] Can't open lib error

Christopher Walker kris240376 at gmail.com
Tue Feb 23 22:17:07 GMT 2016

Thanks for taking the time to help.

It's a bit late but I did manage to solve the problem.

After a bit more searching I performed the following steps to figure
out what was going on.

I ran the following and was met with a "file does not exist" error message:

  # dltest /usr/lib64/libmyodbc5a.so

I then did the the following to try and isolate the issue:

  # export LD_DEBUG=all
  # dltest /usr/lib64/libmyodbc5a.so 2>/dev/shm/dltest.txt
  # export LD_DEBUG=
  # grep "lookup error" /dev/shm/dltest.txt

This pointed to a missing symbol named 'my_thread_end_wait_time'.

It looks like my installation of MariaDB is a bit too old for the
version of mysql-connector-odbc that I'm trying to use.  I've tried
compiling both the newer and older version of mysql-connector-odbc and
they both fail.  Seems that I'm not going to be able to use MariaDB
via unixODBC.

Since Asterisk requires unixODBC I'm going to give PostgreSQL a try.
I really don't feel like having to write a build script for MySQL when
there is one for PostgreSQL already on SlackBuilds.org.

On Tue, Feb 23, 2016 at 3:29 PM, Nick Gorham <nick at lurcher.org> wrote:
> On 23/02/16 19:01, Christopher Walker wrote:
>> I've recently installed unixODBC and the mysql-connector-odbc and I'm
>> getting the following error message when I execute `isql -v`.
>> Can't open lib '/usr/lib64/libmyodbc5a.so' : file not found
>> [ISQL]ERROR: Could not SQLConnect
>> Can anyone offer any assistance on this?
>> My configuration is as follows:
>>    * Slackware 14.1 64-bit
>>      * removed libiodbc and virtuoso packages
>>    * mariadb 5.5.43
>>    * mysql-connector-odbc 5.2.7
>> ls -lah of /usr/lib64/libmyodbc5a.so:
>>    -rwxr-xr-x 1 root root 344K Feb 23 12:08 /usr/lib64/libmyodbc5a.so*
> What does
> ldd /usr/lib64/libmyodbc5a.so
> Show?
> --
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support

More information about the unixODBC-support mailing list