[SOLVED] ODBC MySQL on x86_64 FC11

Doug Hutcheson · 12-17-2009, 04:14 AM

Folks, I have MySQL installed correctly and can connect to it on the command line. It reports Server version: 5.1.40. I have unixODBC installed. I have downloaded the MySQL ODBC drivers and put them in the correct directory. I have edited odbcinst.ini and odbc.ini in the default directory /usr/local/etc and even symlinked these into /etc to be sure. However, isql cannot connect:

Code:

[doug@cardraeh ~]$ isql MySQL-test test -v
[08S01][unixODBC][MySQL][ODBC 5.1 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[ISQL]ERROR: Could not SQLConnect

This is my odbcinst.ini:

Code:

[MySQL]
Description     = MySQL driver for Linux
Driver          = /usr/lib64/libmyodbc5-5.1.6.so
Setup           = /usr/lib64/libmyodbc3S-5.1.6.so
FileUsage       = 1

And this is odbc.ini:

Code:

[MySQL-test]
Description     = MySQL test database
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
SERVER      = localhost
USER        = test
PASSWORD    =
PORT        = 3306
DATABASE    = test

I downloaded the pre-built drivers from the MySQL downloads page, but wonder whether it would be worth downloading the source and compiling locally. Anyone have any experience of using the pre-built drivers?

datopdog · 12-17-2009, 04:30 AM

That is because it is trying to connect to the wrong socket, the socket is in /var/lib/mysql/mysql.sock

Doug Hutcheson · 12-17-2009, 04:32 AM

Stupid me. I do not have a /tmp/mysql.sock, which is why isql cannot connect to it. My question now is "Why don't I have a /tmp/mysql.sock?"

datopdog · 12-17-2009, 04:35 AM

You do not have a /tmp/mysql.sock because the fedora packagers think /var/lib/mysql/mysql.sock is a better place for the socket, you need to configure your client to use that socket

Doug Hutcheson · 12-17-2009, 04:42 AM

Thanks datopdog. Yep - you are right, there it is. Now, how do I get that location to be recognised by ODBC? Is there a setting I need to add to odbc.ini or odbcinst.ini?

Doug Hutcheson · 12-17-2009, 05:27 AM

Solved: Added the following line to odbc.ini:
SOCKET = /var/lib/mysql/mysql.sock

Thanks to datopdog for insightful help.