Self-hosting

3958 readers

16 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

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

you are viewing a single comment's thread
view the rest of the comments

[–] 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.