this post was submitted on 13 Nov 2025
4 points (100.0% liked)

Self-hosting

3955 readers
1 users here now

Hosting your own services. Preferably at home and on low-power or shared hardware.

Also check out:

founded 3 years ago
MODERATORS
poVoq@slrpnk.net
sam_uk@slrpnk.net
4
can't disable SSL certificate verification in dbconfig-mysql setup of PhpMyAdmin (lemmy.sdf.org)
submitted 1 month ago* (last edited 1 month ago) by ThorrJo@lemmy.sdf.org to c/selfhosting@slrpnk.net
3 comments fedilink hide all child comments
 

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

top 3 comments
sorted by: hot top controversial new old
[–] StopSpazzing@lemmy.world 2 points 1 month ago* (last edited 1 month ago) (1 children)

https://www.adminer.org/en/

I dumped phpmyadmin when i realized what a resource hog it was. Simple php file to do the same thing.

[–] ThorrJo@lemmy.sdf.org 1 points 1 month ago

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

[–] ThorrJo@lemmy.sdf.org 1 points 1 month 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;