MySQL Lists are EOL. Please join:

List:MySQL ODBC« Previous MessageNext Message »
From:Arthur P Goldberg Date:November 23 2016 11:26am
Subject:Re: Installation of MySQL Connector/ODBC fails
View as plain text  
Thanks Bogdan

I found that www.actualtech.com<http://www.actualtech.com> works for my configuration.

Until you solve the problem below, I strongly recommend that you withdraw mysql-connector-odbc-5.3.6-osx10.10-x86-64bit from distribution or, at the very least, include your information below in mysql-connector-odbc-5.3.6-osx10.10-x86-64bit/INSTALL and mysql-connector-odbc-5.3.6-osx10.10-x86-64bit/README so that other users do not waste their time trying to use a version of Connector/ODBC 5.3.6 for OS X that does not work as I have done.

Regards
Arthur


On Nov 23, 2016, at 4:12 AM, Bogdan Degtyariov <bogdan.degtyariov@stripped<mailto:bogdan.degtyariov@strippedm>> wrote:

On 23/11/2016 7:25 AM, Goldberg, Arthur P wrote:
Hi

Since writing the below I’ve attempted to use Mac OS X 10.10 (x86, 64-bit), Compressed TAR Archive<https://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_connector_odbc_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=IbXsdQDwJeh8Saq_rjm8MSQau50XinftuRfyeZHgi9c&e= >. Following the directions at https://urldefense.proofpoint.com/v2/url?u=https-3A__dev.mysql.com_doc_connector-2Dodbc_en_connector-2Dodbc-2Dinstallation-2Dbinary-2Dosx.html&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=k1Dvv51TEIBJSubXsdMWVHuzBJk14vzj3Ai5ypblZ_g&e= , I get
$ ls -l /usr/local/lib
total 19480
-rwxr-xr-x@ 1 root  wheel  4988284 Nov 21 22:08 libmyodbc5a.so
-rwxr-xr-x@ 1 root  wheel  4984300 Nov 21 22:08 libmyodbc5w.so

$ /usr/local/bin/myodbc-installer
dyld: Library not loaded: /Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbc.2.dylib
 Referenced from: /usr/local/bin/myodbc-installer
 Reason: image not found
Trace/BPT trap: 5


Examining myodbc-installer further, it uses the following dylibs:
$ otool -L /usr/local/bin/myodbc-installer
/usr/local/bin/myodbc-installer:
/Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbc.2.dylib (compatibility version 3.0.0, current version 3.0.0)
/Volumes/hd2/pb2/build/sb_0-18231254-1457622765.94/unixODBC-2.3.2-osx10.10-x86-64bit/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0)
/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1197.1.1)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 120.0.0)
This appears to use a dylibs that are not available in the ODBC connector tarball (libodbc.2.dylib, and libodbcinst.2.dylib). Perhaps they map to the dylibs in the tarball, but how is not clear.



On Nov 21, 2016, at 9:38 PM, Arthur Goldberg <arthur.p.goldberg@stripped<mailto:arthur.p.goldberg@mssm.edu><mailto:arthur.p.goldberg@stripped>> wrote:

Hi

I use a Mac running OS X Yosemite 10.10.
I’ve downloaded "Mac OS X 10.10 (x86, 64-bit), DMG Archive” from https://urldefense.proofpoint.com/v2/url?u=https-3A__dev.mysql.com_downloads_connector_odbc_5.2.html&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=gzfoPAjgpASoVyfjqZHE1kk_z5B0vqL_E91AMc4eyJM&e= , verified its MD5 (42770b6703771204c1fe46e15b9aa347), and attempted to install the archive. Repeatedly, I receive the error “The Installation failed”. See https://urldefense.proofpoint.com/v2/url?u=https-3A__www.dropbox.com_s_cilcuzd00vz4jpk_InstallationFailed2.jpg-3Fdl-3D0&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=1UfNxbzprvU9V2Clr1g0vreOZ7eVMpXLgXei_g35clo&e= . The installation appears to fail just after the ‘package validation’ phase starts.


Rebooting the Mac does not help.
Is there another ODBC driver that’s likely to connect Excel with MySQL on my Mac? Or can this be fixed?

Thanks
Arthur



Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.karrlab.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=tUcmaMN6p-W_3f6kE1WGY2SLDJh_fUqbH0SBO8MkhGg&e= >
Arthur.P.Goldberg@stripped<mailto:Arthur.P.Goldberg@stripped><mailto:Arthur.Goldberg@stripped>
Follow us on Twitter @IcahnInstitute<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_IcahnInstitute&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=-dynhZ_lBYateOVrdaf0BF6Erb10r46M_A4EqcW78WA&e= >


Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.karrlab.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=tUcmaMN6p-W_3f6kE1WGY2SLDJh_fUqbH0SBO8MkhGg&e= >
Arthur.P.Goldberg@stripped<mailto:Arthur.P.Goldberg@stripped><mailto:Arthur.Goldberg@mssm.edu>
Follow us on Twitter @IcahnInstitute<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_IcahnInstitute&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=-dynhZ_lBYateOVrdaf0BF6Erb10r46M_A4EqcW78WA&e= >

Hi Arthur,

Thanks for your interest in MySQL software.
We are aware of the problem you described.

The Connector/ODBC 5.3.6 for OSX needs UnixODBC to work.
The problem with UnixODBC is that there is no official binary distribution for OSX.

The immediate solution of the MySQL Connector/ODBC issue you are experiencing is building UnixODBC from sources (https://urldefense.proofpoint.com/v2/url?u=http-3A__www.unixodbc.org_&d=AwIDaQ&c=4R1YgkJNMyVWjMjneTwN5tJRn8m8VqTSNCjYLg1wNX4&r=TntoeYH7lekXzpBRjXwLTkqiWTbWAvp3pHKo_kZp5qI&m=g2g4dLuIQUx3Xe0Sfz89xGQDuwb0t4tdjnz_3r0WiUM&s=N87IBiAbTpFHLwzJUN0lLTdC5o7Hy3HChgMEIytqMBM&e= )

In the upcoming release of Connector/ODBC 5.3.7 this issue should be resolved. Unfortunately, I cannot disclose the date of the release prior to the official announcement.
Thanks for your patience.

--
Best Regards,
Bogdan Degtyariov

Arthur Goldberg, PhD
Associate Professor of Genetics and Genomic Sciences
Icahn Institute for Genomics & Multiscale Biology
Icahn School of Medicine at Mount Sinai
646 526 5020
Karr Lab<http://www.karrlab.org/>
Arthur.P.Goldberg@stripped<mailto:Arthur.Goldberg@stripped>
Follow us on Twitter @IcahnInstitute<https://twitter.com/IcahnInstitute>

Thread
Installation of MySQL Connector/ODBC failsArthur P Goldberg22 Nov
  • Re: Installation of MySQL Connector/ODBC failsArthur P Goldberg22 Nov
    • Re: Installation of MySQL Connector/ODBC failsBogdan Degtyariov23 Nov
      • Re: Installation of MySQL Connector/ODBC failsArthur P Goldberg23 Nov
        • Re: Installation of MySQL Connector/ODBC failsBradley Giesbrecht23 Nov
  • Re: Installation of MySQL Connector/ODBC failsAnton Shepelev11 Mar
    • Re: Installation of MySQL Connector/ODBC failsBogdan Degtyariov2 Apr
  • Re: Installation of MySQL Connector/ODBC failsAnton Shepelev12 Apr
    • Re: Installation of MySQL Connector/ODBC failsBogdan Degtyariov15 Apr