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·
      7 days ago

      Thanks, but I really dislike adminer’s UI, although granted I’ve been using a fairly old version.

  • ThorrJoOP
    1·
    6 days 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;