cat << EOF > /etc/yum.repos.d/mariadb.repo
[mariadb]
name = MariaDB-10.4
baseurl=http://yum.mariadb.org/10.4/centos8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
rpm –import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
dnf update
dnf –disablerepo=AppStream install MariaDB-server MariaDB-client
Workaround is tu use proxysql
mysql_query_rules:
{
rule_id=1
active=1
match_pattern="\@\@query_cache_size"
replace_pattern="null"
apply=0
},
{
rule_id=2
active=1
match_pattern="\@\@query_cache_type"
replace_pattern="null"
apply=0
},
{
rule_id=3
active=1
match_pattern="\@\@tx_isolation"
replace_pattern="null"
apply=0
},
grep -r "listen =" /etc/php/*/fpm/pool.d/*
find /run -iname php*.pid
vi /etc/monit/conf.d/php-fpm
check process php-fpm with pidfile /run/php/7/php-fpm.pid
start program = "/usr/sbin/service php7-fpm start" with timeout 60 seconds
stop program = "/usr/sbin/service php7-fpm stop"
if failed unixsocket /var/run/php7-fpm.sock then restart
monit -t
service monit reload
nginx -g "pid /var/run/nginx.pid; worker_processes `sysctl -n hw.ncpu`;"
wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | apt-key add -
echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | tee /etc/apt/sources.list.d/elastic-7.x.list
apt-get update
apt list --upgradable | grep filebeat
apt-get --only-upgrade install filebeat
dnf install wget perl-App-cpanminus gcc perl-libwww-perl perl-IO-Socket-INET6
dnf install wget perl-App-cpanminus gcc
cpanm lazy Test::MockObject
wget https://imapsync.lamiral.info/imapsync
perl -Mlazy imapsync
chmod +x imapsync
/etc/cyberpanel/machineIP
whmapi1 create_user_session user=root service=whostmgrd
sudo podman run -dt --pod new:nginx -p 32597:80 quay.io/libpod/alpine_nginx:latest
[mysqld]
default_authentication_plugin=mysql_native_password
yum install http://rpms.litespeedtech.com/centos/litespeed-repo-1.1-1.el8.noarch.rpm
dnf install lsphp74 lsphp74-mysqlnd lsphp74-process lsphp74-mbstring lsphp74-mcrypt lsphp74-gd lsphp74-opcache lsphp74-bcmath lsphp74-pdo lsphp74-common lsphp74-xml lsphp74-json
#PureDB @sysconfigdir@/pureftpd.pdb
PureDB /etc/pure-ftpd/pureftpd.pdb
mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.01 sec)
mysql_secure_installation
Securing the MySQL server deployment.
/usr/local/lsws/bin/lswsctrl start
[WARNING] Server signature does not match the license key #2.
Please request a new license key!
[WARNING] Server signature does not match the license key #2.
Please request a new license key!
2020-08-17 11:24:47.232298 [NOTICE] Memory size is: 4718592KB.
2020-08-17 11:24:47.722767 [ERROR] [LICENSE] License key operation failure: EXCEPTION LR.AM: Invalid license key file
[FATAL] license problem, back to Apache!
2020-08-17 11:24:48.745494 [NOTICE] Switch back to Apache …
[ERROR] Failed to start litespeed!
[ERROR] Cannot detect control panel environment. Only cPanel WHM, Plesk, DirectAdmin are checked for now.
[WARNING] Server signature does not match the license key #2.
Please request a new license key!
[WARNING] Server signature does not match the license key #2.
Please request a new license key!
2020-08-17 11:24:51.954129 [NOTICE] Memory size is: 4718592KB.
2020-08-17 11:24:52.413312 [ERROR] [LICENSE] License key operation failure: EXCEPTION LR.AM: Invalid license key file
[FATAL] license problem, back to Apache!
2020-08-17 11:24:53.441160 [NOTICE] Switch back to Apache …
[ERROR] Failed to start litespeed!
/usr/local/lsws/bin/lshttpd -r
/usr/local/lsws/bin/lshttpd -V
/usr/local/lsws/bin/lswsctrl restart