Reseller Level -> enhanced
Category Archives: Hosting
mod_ruid2 does not support CentOS8
To fix directadmin install/setup:
dnf install libjpeg-turbo-devel libpng-devel freetype-devel
cd /usr/local/directadmin/custombuild/
vi options.conf
mod_ruid2=no
php1_release=7.2
php1_mode=php-fpm
./build iconv
./build php y
php -v
PHP 7.2.33 (cli) (built: Sep 25 2020 20:48:19) ( NTS )
If still ERROR: Unable to globalize '/usr/local/directadmin/data/users/*/php/php-fpm72.conf' (ret=2) from /usr/local/php72/etc/php-fpm.conf at line 68
./build all d
./build rewrite_confs
./build rewrite_confs
Checking to ensure /etc/httpd/conf/ssl.crt/server.ca is set.
Using xx.xx.xx.xx for your server IP
ls: cannot access '/usr/local/directadmin/data/users/*/httpd.conf': No such file or directory
grep: /usr/local/directadmin/conf/directadmin.conf: No such file or directory
Enabling http2 in directadmin.conf.
grep: /usr/local/directadmin/conf/directadmin.conf: No such file or directory
Enabling http2 in directadmin.conf.
Job for php-fpm72.service failed because the control process exited with error code.
See "systemctl status php-fpm72.service" and "journalctl -xe" for details.
Restarting apache.
Job for httpd.service failed because the control process exited with error code.
See "systemctl status httpd.service" and "journalctl -xe" for details.
cd /usr/local/directadmin
./directadmin i
./directadmin p
./build rewrite_confs
Checking to ensure /etc/httpd/conf/ssl.crt/server.ca is set.
Using xx.xx.xx.xx for your server IP
Restarting apache.
systemctl status httpd.service | grep active
Active: active (running) since Fri 2020-09-25 21:15:35 CEST; 2min 36s ag
systemctl status php-fpm72.service | grep active
Active: active (running) since Fri 2020-09-25 21:15:32 CEST; 3min 39s ago
Status: "Processes active: 0, idle: 0, Requests: 0, slow: 0, Traffic: 0req/sec"
apache find root
grep -i -r DocumentRoot /etc/apache2/sites-available/
grep -i -r DocumentRoot /etc/httpd/
mediawiki mysql password config file
LocalSettings.php
$wgDBtype = "mysql";
$wgDBserver = "localhost";
$wgDBname = "db_name";
$wgDBuser = "db_user";
$wgDBpassword = "password";
mysql /etc/init.d restart not working
/etc/init.d/mysql does not start mysqld at system start up on Ubuntu
grep debian-sys-maint /etc/mysql/debian.cnf
ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)
mysql> UPDATE mysql.user SET Password = password(‘password’) WHERE User = ‘debian-sys-maint’;
service mysql restart
mariadb 10.4.14 centos 8
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
Google datastudio connect MySQL 8 problem
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
},
monit check fpm
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 start from command line
nginx -g "pid /var/run/nginx.pid; worker_processes `sysctl -n hw.ncpu`;"
ubuntu upgrade filebeat
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
imapsync centos 8
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
cyberpanel change ip
/etc/cyberpanel/machineIP
whm login without password
whmapi1 create_user_session user=root service=whostmgrd
new pod using run
sudo podman run -dt --pod new:nginx -p 32597:80 quay.io/libpod/alpine_nginx:latest
from caching_sha2_password back to mysql_native_password
[mysqld]
default_authentication_plugin=mysql_native_password