I am attempting to set up a little PhpMyAdmin host in a LXC container running Devuan 6 (based on Debian 13) and I am running into problems with the setup script run by apt install, which I believe is actually dbconfig-mysql making its own set of debconf style prompts. This is for my homelab, and my MariaDB server has self-signed SSL certs. The problem is that I can’t figure out either of the following: * how to have the dbconfig-mysql setup procedure not verify SSL certs * how to manually run the portion of the procedure which sets up a database for PhpMyAdmin in order to completely work around the dbconfig-mysql setup process Regarding the former issue, in /etc/mysql/mariadb.conf.d/50-client.cnf I set [client] ssl-verify-server-cert = off and [client-mariadb] disable-ssl-verify-server-cert but this doesn’t affect the setup or dpkg-reconfigure process for PhpMyAdmin. Regarding the second issue, I’m just stumped. Any hints would be appreciated! edit: changed dbconfig-common to dbconfig-mysql

  • ThorrJoOP
    1·
    10 months ago

    I managed to figure out how to bypass the cert verification in dbconfig-mysql (named on the tin as dbconfig-common) and got my appliance set up!

    1. apt install dbconfig-mysql before installing the PhpMyAdmin package

    2. In /usr/share/dbconfig-common/internal/dbc-mysql, in both sections where temporary my.cnf is defined, set ssl-verify-server-cert = off right below the port = line.

    3. to install PhpMyAdmin, run DEBIAN_PRIORITY=low apt install phpmyadmin and follow the prompts

    4. In /etc/phpmyadmin/config.inc.php add the following line directly under $cfg['Servers'][$i]['host'] = $dbserver;:

      $cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['ssl_verify'] = false;