Perfect Server Automated ISPConfig 3 Installation, Installing packages failed
Following the https://www.howtoforge.com/ispconfig-autoinstall-debian-ubuntu/ guide on Ubuntu 22.04 (LTS) x64 fails installing phpmyadmin database entries.
Details:
[INFO] Installing phpMyAdmin
[WARN] Query CREATE DATABASE IF NOT EXISTS phpmyadmin; failed. (/lib/os/class.ISPConfigDebianOS.inc.php:354)
[WARN] Query CREATE USER IF NOT EXISTS 'pma'@'localhost'; failed. (/lib/os/class.ISPConfigDebianOS.inc.php:354)
[WARN] Query ALTER USER 'pma'@'localhost' IDENTIFIED BY 'XXX'; failed. (/lib/os/class.ISPConfigDebianOS.inc.php:354)
[WARN] Query GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY 'XXX' WITH GRANT OPTION; failed. (/lib/os/class.ISPConfigDebianOS.inc.php:354)
[WARN] Query FLUSH PRIVILEGES; failed. (/lib/os/class.ISPConfigDebianOS.inc.php:354)
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)
[WARN] Command mysql --defaults-file=/etc/mysql/debian.cnf -D phpmyadmin < /usr/share/phpmyadmin/sql/create_tables.sql failed. (/lib/os/class.ISPConfigDebianOS.inc.php:361)
[INFO] HTTPoxy config.
[INFO] Installing acme.sh (Let's Encrypt).
[INFO] acme.sh (Let's Encrypt) installed.
[INFO] ISPConfig does not yet support mailman3 and mailman2 is no longer available in Ubuntu 22.04.
[INFO] Installing packages haveged, geoip-database, libclass-dbi-mysql-perl, libtimedate-perl, build-essential, autoconf, automake, libtool, flex, bison, debhelper, binutils
[ERROR] Exception occurred: ISPConfigOSException -> Installing packages failed. (/ispconfig.ai.php:15)
root@ethical-hacker:~# cat /etc/mysql/debian.cnf
# THIS FILE IS OBSOLETE. STOP USING IT IF POSSIBLE.
# This file exists only for backwards compatibility for
# tools that run '--defaults-file=/etc/mysql/debian.cnf'
# and have root level access to the local filesystem.
# With those permissions one can run 'mariadb' directly
# anyway thanks to unix socket authentication and hence
# this file is useless. See package README for more info.
[client]
host = localhost
user = root
[mysql_upgrade]
host = localhost
user = root
# THIS FILE WILL BE REMOVED IN A FUTURE DEBIAN RELEASE.