How to use rdb: SSL connection?

  • Resolved rlohmj

    (@rlohmj)


    2 years, 8 months ago

    Hi Peter,

    Really great plugin! Been using it since I heard about it with a variety of uses with local db connections.

    However I recently started on a new project that needs rdb connections.

    1. I have a front-end form that receives user input data in a “local” website.
    2. I need to store this data in a rdb to show in front-end of some other “remote” website. (this rdb is a local db of the “remote” website.)
    3. This rdb connection in the “local” website works fine without SSL connection.

    So here comes my question…
    How do I activate SSL connection properly?

    – I have read your Remote SSL connections Docs and am still confused. (Please treat me as a total beginner.)
    – Where does the “Client Key”, “Client Cert” and “CA Cert” come from?
    – I have default autoSSL cPanel, inc. generated certs for my domains, but do not know where to find their file location. Am I suppose to use these in the SSL connection setup fields?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @rlohmj,

    Using SSL involves several steps. I would start to connect without SSL first. Are you able to connect without SSL?

    Is your MySQL Database self hosted? Or are you using a provider?

    If you are using a provider, do they offer certificates?

    If you are self-hosted, you can generate your own certificates using OpenSSL. This isn’t very hard. Just follow the instructions here:
    https://docs.devart.com/studio-for-mysql/connecting-to-db/generating-certificates.html
    There are many other resources as well. On this page:
    Client Key=client-key.pem
    Client Cert=client-cert.pem
    CA Cert=ca-cert.pem

    If you are using a provider, you can ask them. They might use different names.

    Make sure you add the necessary files to your my.ini and restart your database. Also make sure your the plugin has access to your client files.

    A lot of things can go wrong. When everything is installed and you want to be sure if your connection is safe, you can use wireshark to analyze your network traffic.

    Does this help?

    Best regards,
    Peter

    Thread Starter rlohmj

    (@rlohmj)

    Hi @peterschulznl,

    Connecting without SSL works perfectly.

    I’m using a provider, so I’ve informed them of my issue and its resolved.

    Thank you for the clarification!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to use rdb: SSL connection?’ is closed to new replies.