[unixODBC-support] problem with MySQL Connector with unixODBC in Mac OSX

Carlos Andrey carlosandrey at gmail.com
Tue Sep 4 04:45:51 BST 2012


Good afternoon,

i have recently installed unixODBC 3.5.1 with MySQL connect 5.1.11 in mi MAC OSX Lion. i have worked with unixODBC in my Linux without a problem, but i don't make running with OSX. 

the MySQL server is running in a linux machine.

my odbcinst.ini is

[ODBC]
Trace File=/tmp/sql.log
Trace=yes
Pooling=No
UsageCount=3

[ODBC Connection Pooling]
PerfMon=0
Retry Wait=
UsageCount=8

[ODBC Drivers]
MySQL5.1=Installed
UsageCount=2

[MySQL5.1]
Driver=/usr/local/lib/libmyodbc5.so
Setup=
Description=ODBC for MySQL 5.1
Driver64=/usr/local/lib/libmyodbc5.so
FileUsage=1
UsageCount=15


my odbc.ini is
[ODBC]
Trace=yes
TraceAutoStop=0
TraceFile=/tmp/sqllog.log
TraceLibrary=

[ODBC Data Sources]
db01=MySQL5.1

[db01]
Driver=MySQL5.1
Description=Base de Datos MySQL
port=3306
database=portnetdllo
option=3
user=root
password=password
server=192.168.130.50

evidently i have permission in my DB for the root user and my Mac IP

when i just try to connect with isql the error is:
[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

when i see the log error i can see:

[ODBC][27293][1346729968.849228][__handles.c][460]
                Exit:[SQL_SUCCESS]
                        Environment = 0x7f9821000000
[ODBC][27293][1346729968.849510][SQLAllocHandle.c][375]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x7f9821000000
[ODBC][27293][1346729968.849665][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x7f9821020400
[ODBC][27293][1346729968.850799][SQLConnect.c][3700]
                Entry:
                        Connection = 0x7f9821020400
                        Server Name = [db01][length = 4 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
                UNICODE Using encoding ASCII 'char' and UNICODE 'UCS-2-INTERNAL'

                DIAG [08S01] [MySQL][ODBC 5.1 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[ODBC][27293][1346729968.864320][SQLConnect.c][4067]
                Exit:[SQL_ERROR]
[ODBC][27293][1346729968.864618][SQLError.c][434]
                Entry:
                        Connection = 0x7f9821020400
                        SQLState = 0x7fff61f7c871
                        Native = 0x7fff61f7c86c
                        Message Text = 0x7fff61f7c87b
                        Buffer Length = 500
                        Text Len Ptr = 0x7fff61f7c86a
[ODBC][27293][1346729968.865006][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = 08S01
                        Native = 0x7fff61f7c86c -> 2002
                        Message Text = [[unixODBC][MySQL][ODBC 5.1 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)]
[ODBC][27293][1346729968.865474][SQLError.c][434]
                Entry:
                        Connection = 0x7f9821020400
                        SQLState = 0x7fff61f7c871
                        Native = 0x7fff61f7c86c
                        Message Text = 0x7fff61f7c87b
                        Buffer Length = 500
                        Text Len Ptr = 0x7fff61f7c86a
[ODBC][27293][1346729968.865606][SQLError.c][471]
                Exit:[SQL_NO_DATA]
[ODBC][27293][1346729968.865772][SQLError.c][514]
                Entry:
                        Environment = 0x7f9821000000
                        SQLState = 0x7fff61f7c871
                        Native = 0x7fff61f7c86c
                        Message Text = 0x7fff61f7c87b
                        Buffer Length = 500
                        Text Len Ptr = 0x7fff61f7c86a
[ODBC][27293][1346729968.865976][SQLError.c][551]
                Exit:[SQL_NO_DATA]
[ODBC][27293][1346729968.866363][SQLFreeHandle.c][284]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x7f9821020400
[ODBC][27293][1346729968.866731][SQLFreeHandle.c][333]
                Exit:[SQL_SUCCESS]
[ODBC][27293][1346729968.867101][SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x7f9821000000

when i review the log i notice in this segment:
                       Server Name = [db01][length = 4 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]

in Server Name is not taking the real server name and isn't taking user and password neither

please help me

regards,

Carlos Andrey Montoya 
Skype:andr3w
carlosandrey at gmail.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20120903/178b8954/attachment.html>


More information about the unixODBC-support mailing list