Some additional detail. I restarted my Cloud SQL instance and looked at the logs... it seems the server side certificates got wiped out somehow? Who can fix it up? I'd really rather not replace/reset all my certificates but at this point that's my best guess on how to fix this.
2016-10-22 12:42:47 0 [Note] (mysqld 5.6.31-log) starting as process 554455 ... 2016-10-22 12:42:47 554455 [Note] Semi-sync replication initialized for transactions. 2016-10-22 12:42:47 554455 [Note] Semi-sync replication enabled on the master. 2016-10-22 12:42:47 554455 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-10-22 12:42:47 554455 [Note] InnoDB: The InnoDB memory heap is disabled 2016-10-22 12:42:47 554455 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-10-22 12:42:47 554455 [Note] InnoDB: Memory barrier is not used 2016-10-22 12:42:47 554455 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-10-22 12:42:47 554455 [Note] InnoDB: Using CPU crc32 instructions 2016-10-22 12:42:47 554455 [Note] InnoDB: Initializing buffer pool, size = 96.0M 2016-10-22 12:42:47 554455 [Note] InnoDB: Completed initialization of buffer pool 2016-10-22 12:42:47 554455 [Note] InnoDB: Highest supported file format is Barracuda. 2016-10-22 12:42:51 554455 [Note] InnoDB: 128 rollback segment(s) are active . 2016-10-22 12:42:51 554455 [Note] InnoDB: 5.6.31 started; log sequence number 10094548402 2016-10-22 12:42:52 554455 [Note] RSA private key file not found: /sfs/ industryopening/jobdb/data//private_key.pem. Some authentication plugins will not work. 2016-10-22 12:42:52 554455 [Note] RSA public key file not found: /sfs/ industryopening/jobdb/data//public_key.pem. Some authentication plugins will not work. 2016-10-22 12:42:52 554455 [Note] Add the 'cloudsqladmin' user with the password hash '*ACE49C8814A8031C812FD739A573BDD4FFF8F7EE' 2016-10-22 12:42:53 554455 [Note] Event Scheduler: Loaded 0 events 2016-10-22 12:42:53 554455 [Note] : ready for connections. Version: '5.6.31-log' socket: '' port: 0 (43, 47) (Google) On Saturday, October 22, 2016 at 9:17:40 AM UTC-4, Robert Fox wrote: > > Yesterday I was getting complaints about certificate dates. My certs are > not expired. Today I'm getting a more generic error: > > > Exception in thread "main" java.sql.SQLNonTransientConnectionException: > SSL Connection required, but not supported by server. > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:550) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:512) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:480) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:498) > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:494) > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:72) > at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1634) > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:637) > at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:351) > at > com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:224) > at java.sql.DriverManager.getConnection(DriverManager.java:664) > at java.sql.DriverManager.getConnection(DriverManager.java:208) > at .... my code > > > I have had my database on SSL only for month and months. Certificates > setup and going for months and months... basically my config didn't change. > > I'm using MySQL Connector version 5.1.39 from Compute engine. > Also failing to connect from MySQL Workbench. Help!!! > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/e8dceb24-ffde-42ed-b818-530bce44f409%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
