#877 TOra 3 on win64 won't connect to mysql

open
nobody
None
5
2014-01-22
2014-01-15
Milan Avramovic
No

Hi,

TOra won't open libmysql on 64bit windows for some reason.

When configuring MySQL path:

  1. if I point at the dir containing libmysql.dll ("c:\Program Files\MySQL\MySQL Connector C 6.1 6.1.2\lib\") I get the error "Couldn't validate library file: C:/Program Files/MySQL/MySQL Connector C 6.1 6.1.2/lib/lib/opt/libmysql.dll"

  2. if I point at the dir above ("c:\Program Files\MySQL\MySQL Connector C 6.1 6.1.2\") the configurator does not complain, but adds \lib\opt\ at the end - MySQL Path says "C:/Program Files/MySQL/MySQL Connector C 6.1 6.1.2/lib/opt" (there is libmysql in boh lib and lib/opt)

However you cannot select MySQL as connection provider in either case.

All software is 64bit versions (Windows, TOra, MySQL connector).

TOra Version 3.0.0.(5007svn)

MySQL Connector/C 6.1.2 and 6.0.2 (corresponding to Mysql 5.6 and 5.5 respectively)

Discussion

  • Ivan Brezina
    Ivan Brezina
    2014-01-22

    Which OS are you using? Isn't it Windows 7? I've just made some tests and these are mine findings:

    • Windows 7 does not have an entry for "localhost" in windows\system\etc\host
      this results that mysql client can not resolve "localhost" onto ip address
    • Connecting to ip address 127.0.0.1 is working fine
    • The newest version of Mysql Connector (6.1) is able to handle this somehow and is able to connect to "localhost".

    PS: do you really have libmysql.dll in both locations ("/lib" "/lib/opt")? I've just installed mysql-connector-c-6.1.3-winx64.msi and the only .dll is in "C:/Program Files/MySQL/MySQL Connector C 6.1/lib/libmysql.dll"

    Ivan