Prerequisites


SingleStore Helios supports browser-based single sign-on (SSO) with Google Chrome, Mozilla Firefox, and Microsoft Edge. To use browser-based SSO on macOS, you will need to set your default browser to either Chrome or Firefox.

To authenticate using browser-based SSO on Linux distributions, you must have the gnome-keyring-daemon and an active Login Password Keyring. If the Login Password Keyring is not configured, refer to Install a Gnome Keyring Manager for Linux Distributions.



Set up the driver


The plugin used in the SingleStore driver requires the driver to be downloaded with all its dependencies.

  • Start DbVisualizer
  • Go to Tools->Driver Manager
  • Find the SingleStore JDBC driver and select it
  • Select the artifact and click the edit (pencil) button
  • Select Download dependencies and click OK



Download certificate and copy server and port


To be able to connect to the database in SSL mode, the certificate for the database server has to be downloaded locally.


  • In the SingleStore Portal, find the group on the left navigation menu and select it
  • Click the Connect button and choose CLI client
  • Take note of the endpoint server and port, these are needed as input to create a SingleStore connection in DbVisualizer
  • Click the download button to download the certificate



Set driver properties

To connect to the server using SSO, a few properties need to be set. The server certificate must be trusted for the SSL connection and the SSO browser flag has to be turned on for the plugin to kick in.


  • In DbVisualizer, create a new SingleStore connection in the object tree
  • Type in the server and port from the previous step. Leave username and password empty.
  • Select the properties tab
  • Select Driver Properties
  • Find and set the following properties:
  • serverSslCert: This should point to the certificate file downloaded in the previous step.
  • sslMode: verify_ca
  • credentialType: BROWSER_SSO


Connect


Connect to the SingleStore database, and the default browser should load and open the SingleStore portal website. After a successful log in (or if already logged in), a message should show that confirms the log in was successful. Return to DbVisualizer which should now be logged in.