MySQL localhost only ❡

Installation

root@server:~# apt install mariadb-server

mysql-secure-installation is deprecated, just use the mysql client program as root

logged in give root@localhost a password:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';

PHP requirements ❡

You should use php-fpm to play nicely with kreise-apps later

apt install php-fpm

For Apache2 enable the fpm module as hinted after the package installed:

NOTICE: Not enabling PHP 8.4 FPM by default.
NOTICE: To enable PHP 8.4 FPM in Apache2 do:
NOTICE: a2enmod proxy_fcgi setenvif
NOTICE: a2enconf php8.4-fpm
NOTICE: You are seeing this message because you have apache2 package installed.

PHP MySQL Support ❡

> None of the supported PHP extensions (MySQLi, PDO_MySQL) are available.

then add mysql support for PDO. We only use PDO in kreise-apps

apt install php-mysql-pdo

AdminNeo ❡

root@server:/var/www/# mkdir adminneo
root@server:/var/www/# cd adminneo

You need to build the package yourself at: https://www.adminneo.org/download

Then grab the single php file.

/etc/apache2/sites-available/adminerevo-ssl.conf

<VirtualHost 10.x.x.x:443>
    ServerName adminneo.domain.tld

    DocumentRoot /var/www/adminneo

    <Directory /var/www/adminneo>
        Require all granted
        DirectoryIndex adminneo-5.5.0.php
    </Directory>

    SSLEngine on
    SSLCertificateFile /etc/letsencrypt/live/wildcard.domain.tld/fullchain.pem
    SSLCertificateKeyFile /etc/letsencrypt/live/wildcard.domain.tld/privkey.pem
    Include /etc/letsencrypt/options-ssl-apache.conf

    <FilesMatch "\.(cgi|shtml|phtml|php)$">
        SSLOptions +StdEnvVars
    </FilesMatch>
    <Directory /usr/lib/cgi-bin>
        SSLOptions +StdEnvVars
    </Directory>
</VirtualHost>

Symlink

root@server:/etc/apache2/sites-enabled# ln -s -r ../sites-available/adminneo-ssl.conf /etc/apache2/sites-enabled/adminneo-ssl.conf