SSL MySQL remote server (phpmyadmin)

Discussion in 'Installation/Configuration' started by Stelios, Sep 18, 2020.

  1. Stelios

    Stelios Active Member HowtoForge Supporter

    Hi all,
    On a multi-server setup when I access PHPMyAdmin (it is installed with ssl under my main server which holds just the control panel of ISPconfig) and login to any of my servers (got a list with a few) I'm getting on the right side:

    Server connection: SSL is not being used

    The relevant docs saying:
    I'm not sure what's the next steps. Do I need to create with certbot SSLs on all my DB servers and configure the MySQL or I shall just add the relevant SSL entry in PHPMyAdmin config?

    If anyone has a working PHPMyAdmin config with the SSL enabled will be very much appreciated.

    Am I understanding correct that I need to replace all entries in my config that have
    $cfg['Servers'][$i]['host']
    with:
    $cfg['Servers'][$i]['ssl']['host'] etc?

    Thanks in advance
     
  2. Stelios

    Stelios Active Member HowtoForge Supporter

    Further to my post I tried by adding:

    PHP:
        //$cfg['Servers'][$i]['ssl'] = true;
        //$cfg['Servers'][$i]['key'] = '/etc/letsencrypt/live/controlpanel.mydomain.com/fullchain.pem';
        //$cfg['Servers'][$i]['cert'] = '/etc/letsencrypt/live/controlpanel.mydomain.com/privkey.pem';
    to my config file but with the above in the config it doesn't work at all (can't login).
    Under mysql logs there is no error.

    Any help is very much appreciated.
     

Share This Page