0
mflorezm

mysql ODBC not working

Recommended Posts

Hi, i'm having problems to install and use MysQL ODBC connector in  ARMBIAN 5.60 stable Ubuntu 16.04.5 LTS 3.4.113-sun8i.  As you know for this version of ubuntu there is no Package 'libmyodbc' installation candidate.

 

So, I downloaded ODBC driver for Ubuntu 16.04 directly with wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.11-linux-ubuntu16.04-x86-32bit.tar.gz (32bit as H3 is 32 bits - but same happens with 64 bits too)  

 

Copied all libraries (libmyodbc5a.so  libmyodbc5S.so  libmyodbc5w.so) to folder /usr/local/odbc/lib

 

then create the /etc/odbc.ini file with the following data:

 

[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3
Charset=utf8

 

and create the /etc/odbcinst.ini
 

[MySQL]
Description=MySQL driver for Linux
Driver=/usr/local/odbc/lib/libmyodbc5w.so
Setup=/usr/local/odbc/lib/libmyodbc5S.so
FileUsage=1
 

nevertheless, while using isql i always receive the following error:

 

root@orangepiplus:/usr/local/odbc/lib# isql -vvv MySQL-asteriskcdrdb
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/odbc/lib/libmyodbc5w.so' : file not found
[ISQL]ERROR: Could not SQLConnect

 

of course it is not true, because the all the library files are there:

 

root@orangepiplus:/usr/local/odbc/lib# ls
libmyodbc5a.so  libmyodbc5S.so  libmyodbc5w.so

 

Any ideas? is it the kernel? is it the ARMHF arquitecture? because the same process works perfect on other linux machines i386.

 

Regards,

 

Mauricio F.

 

 

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
0