su - postgres -c 'psql -x -c "\l"'
postgres list databases
Leave a reply
postgres list tables
su - postgres -c 'psql -x -c "\dt" -d database_name' | grep Name
ps show threads
ps -eLf
secure root authorized_keys
chattr +i ~/.ssh/authorized_keys
chattr +i ~/.ssh
php-fpm disable warnings
vi /etc/php-fpm.d/www.conf
php_admin_value[error_reporting] = E_ALL & ~E_NOTICE & ~E_WARNING & ~E_STRICT & ~E_DEPRECATED
FastCGI: failed to connect to server connect() fail
/usr/sbin/php-fpm --daemonize --fpm-config /etc/php/fpm/php-fpm.conf
php-fpm check config
php-fpm -t
php-fpm -tt
ubuntu wireguard
apt install wireguard
pound linux
Pound is a reverse-proxy load balancing server. It accepts requests from HTTP/HTTPS clients and distributes them to one or more Web servers. The HTTPS requests are decrypted and passed to the back-ends as plain HTTP
require ip range
Apache Require IP address
Require ip 10.1.2.3
Require ip 10.1.2.1 10.1.2.2
Require ip 10.1.0.0/24
compare 2 database tables
sdiff <(mysql -B -e "show tables;" -D a_database) <(mysql -B -e "show tables;" -D b_database)
skip same record from first col:
sdiff <(mysql -B -e "show tables;" -D a_database) <(mysql -B -e "show tables;" -D b_database) | grep '[<>]'
relay=none, delay=312, delays=dsn=, status=deferred (connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)
service amavisd start
netstat -natp | grep :10024
tcp 0 0 127.0.0.1:10024 0.0.0.0:* LISTEN 16736/amavisd (mast
tcp6 0 0 ::1:10024 :::* LISTEN 16736/amavisd (mast
disable_functions prestashop
disable_functions = proc_open,phpinfo,show_source,system,shell_exec,passthru,exec,popen
mysql disallow remote login
bind-address=127.0.0.1
windows install zabbix agent
https://www.zabbix.com/download_agents/
c:\zabbix\zabbix_agentd.exe -c c:\zabbix\zabbix_agentd.conf -i