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

Carlos Andrey carlosandrey at gmail.com
Tue Sep 4 23:58:21 BST 2012


Hello Everybody,

someone can help me whit this error?

gracias,
Carlos Andrey Montoya 
Skype:andr3w
carlosandrey at gmail.com


El 3/09/2012, a las 22:45, Carlos Andrey escribió:

> 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/20120904/8c0b5386/attachment-0001.html>


More information about the unixODBC-support mailing list