New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Xcode Built SequelPro Throws Dialog.so Error #3310

Open
deepSymmetry opened this Issue Nov 24, 2018 · 3 comments

Comments

Projects
None yet
2 participants
@deepSymmetry

deepSymmetry commented Nov 24, 2018

  • Sequel Pro Version: Cloned the latest repository
  • macOS Version: 10.12.6
  • MySQL Version: 5.7

Description
I successfully cloned and built it using Xcode. While trying to connect to MySQL through SSH tunnel, it throws following error. I am fairly new to Xcode and Objective C and the reason I am building is because enhancement #3227 can't be fixed. So I thought I would make some local changes and build a custom version for my use. I am done with my changes and the app launches well although it asks me for Keychain every time I launch, probably because the build signatures are different each time (but this is a secondary issue and I can live with it).

I tried different architectures and deployment targets but same issue. I am building using the based macOS SDK 10.13. I have the official version deployed and I have no issues with that.

I do not think the issue is with reach the MySQL host but it has to do with incompatible libraries as if I am building a 32 bit version trying using 64 bit libraries.
Please advise.

Unable to connect to host 127.0.0.1, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Authentication plugin 'dialog' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/dialog.so, 2): no suitable image found. Did find:
/usr/local/mysql/lib/plugin/dialog.so: unknown file type, first eight bytes: 0x7F 0x45 0x4C 0x46 0x02 0x01 0x01 0x00

@dmoagx

This comment has been minimized.

Member

dmoagx commented Dec 14, 2018

That is a runtime issue, not a build issue.
The server requests the cleartext/dialog auth plugin, which is not supported by Sequel Pro (see #2996).
However the MySQL client library finds a file on your machine which it thinks it could use to do dialog auth, but it can't (/usr/local/mysql/lib/plugin/dialog.so).

That file is completely unrelated to Sequel Pro and part of some other MySQL installation on your Mac.

@deepSymmetry

This comment has been minimized.

deepSymmetry commented Dec 14, 2018

But I have the official Sequel Pro client installed which runs flawlessly. Should it also not exhibit the same behavior?

@dmoagx

This comment has been minimized.

Member

dmoagx commented Dec 15, 2018

Sequel Pro 1.1.2 uses a much older version of the MySQL client libraries

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment