Socket connection on Mac with JDBC fails - fixed!

Support
1

What issue or error are you experiencing?

Before updating localwp six months ago, all sockets on multiple sites were working for years.

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

none. not sure what happened.

System Details

  • Local Version:
    Version 9.0.5+6706
  • Operating System (OS) and OS version:
    mac os sonoma

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

2

for anyone who may have similar issue. add ‘useSSL=FALSE’ to your URL if connecting that way:

jdbc:mysql:///local?junixsocket.file=/Users//Library/Application Support/Local/run/KedrFYVKg/mysql/mysqld.sock&socketFactory=org.newsclub.net.mysql.AFUNIXDatabaseSocketFactoryCJ&useSSL=FALSE

3

Glad to hear you found a workaround @mc2prod! We’d be happy to help troubleshoot this some for you however and figure out what changed when you updated previously.

Can you share some more details about the issues you’ve run into the last 6 months and any other workarounds you’ve had to use? Feel free to share any screenshots as well.

As a reminder you can always downgrade to older versions of Local as well if you encounter a bug: