MySQL Connection Issues

  1. 6 months ago

    James D

    31 May 2019 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    Hi There,

    I have just started to try and connect to MySQL from XOJO and have encountered the following error:

    Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/Users/williamyu/builds/lib/plugin/caching_sha2_password.so, 2): image not found

    I don't have this issue connection with other tools and via C#, so I'm assuming it is a XOJO issue... any ideas?

    Thanks

  2. Anthony D

    31 May 2019 Pre-Release Testers, Xojo Pro Seattle WA

    These may help:

    https://forum.xojo.com/49634-mysql-connection-error
    https://forum.xojo.com/48779-mysql-caching-sha2-password-error
    https://forum.xojo.com/49017-can-t-authenticate-against-mysql-com-server
    https://forum.xojo.com/52627-unable-to-connect-to-database-caching-sha2-password-workaround

  3. James D

    31 May 2019 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    Thanks Anthony, I have already done that.

    The error message would suggest that it is a build problem: /Users/williamyu/builds/lib/plugin/caching_sha2_password.so,

    And given that it is so basic, one has to ask what kind of testing is being done on this and why by now in the current release it is still an issue. I mean seriously, if you can't connect to the database who could you even run any tests???

  4. Anthony D

    31 May 2019 Pre-Release Testers, Xojo Pro Seattle WA

    Didn’t notice William’s name in the path before. This sounds like something Xojo may need to address.

    One thought:

    I didn’t see a version of Xojo mentioned in your post… have you tried using the plugin from a different version of Xojo? The issue may be an issue with the version of the MySQL plugin being used.

  5. Norman P

    31 May 2019 Pre-Release Testers, Xojo Pro under a bus

    when a project is linked it stores a path name of various libs/dylibs
    but at runtime it just blurts that path back out because it cant say much more
    the name, not the entire path , is really whats important

    have all the plugin bits been copied as binary etc to the target ?
    seems one might be missing

or Sign Up to reply!