All statements must be terminated by a semicolon. rw- 1 ronr staff 1679 Aug 27 17:01 node.keyĬlient sql -url Welcome to the cockroach SQL interface. Openssl pkcs8 -topk8 -inform PEM -outform DER -in -out 8 -nocrypt So I re-created the certs directory and the my-safe-directory as listed in Path: /tmp/DbVisualizer/jdbc/postgresql/postgresql.jarĬockroach sql -url must be making some foolish error: Sslrootcert = /home/marc/.cockroach-certs/ca.crt URL: jdbc:postgresql://localhost:26257/postgres **: SSL error: Received fatal alert: bad_certificate**Īnd I still have no clue why I get this error. 16:41:12.151 INFO 532 Exception while connecting cdb secure 16:41:12.145 INFO 532 Exception while connecting cdb secure Doing so would certainly make things easier.
Thanks for your reply good to know it works and happy to see that the cli will soon also generate the pk8 files. I selected PostgreSQL and overrode the ssl parameters but left the factory at the default: blah
#DBVISUALIZER TRUE HOW TO#
: SSL error: Received fatal alert: bad_certificateĪt .convert(MakeSSL.java:67)Īt 3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:359)Īt 3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:148)Īny ideas about how to get this working? dbVisualizer is a very nice SQL tool with briljant graphing options in it…Ĭonfirmed that it works using the original pem-encoded certificates.
#DBVISUALIZER TRUE ARCHIVE#
The ZIP archive installer will not add any entries to the Start menu, add desktop launchers or register the software in the Windows registry. Unpack the distribution file with the built-in zip archive extraction utility in Windows. 16:01:57.375 INFO 500 Exception while connecting cdb secure All files are contained in an enclosing folder named DbVisualizer.
Path: /Applications/dbvis/DbVisualizer 10.0.13.app/Contents/java/app/jdbc/postgresql/postgresql.jar DbVisualizer will need to be restarted after applying these changes. Postgresql.SQLCommanderMostRecentSchema = public kinit with an appropriate principal and launch DbVisualizer Open DbVisualizer preferences ('DbVisualizer' > 'Preferences') and add the following properties. Postgresql.SQLCommanderMostRecentCatalog = zabbix URL: jdbc:postgresql://localhost:26257/system Openssl x509 -in -inform pem -outform der -out Īnd referenced them in the connection details
Openssl x509 -in ca.crt -inform pem -outform der -out ca.der I am struggling to get dbvisualizer to connect to crdb using ssl and certificates.