apt-get install percona-xtrabackup-24
innobackupex Error: Unsupported server version
Leave a reply
SSD Health Status on VMware ESXi
/opt/smartstorageadmin/ssacli/bin/ssacli ctrl slot = 0 pd all show detail
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
},
find mysql sock
mysqladmin variables | grep socket
sslh
sslh accepts connections on specified ports, and forwards them further based on tests performed on the first data packet sent by the remote client.
Probes for HTTP, TLS/SSL (including SNI and ALPN), SSH, OpenVPN, tinc, XMPP, SOCKS5, are implemented, and any other protocol that can be tested using a regular expression, can be recognised. A typical use case is to allow serving several services on port 443 (e.g. to connect to SSH from inside a corporate firewall, which almost never block port 443) while still serving HTTPS on that port.
vmware check smart
esxcli storage core device list
esxcli storage core device smart get -d disk_name
vmware get version cli
vmware -vl
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
ERROR instance/beat.go:951 Exiting: 1 error: setting ‘filebeat.prospectors’ has been removed
Change filebeat.prospectors:
to:
filebeat.inputs:
create sftp user ubuntu
adduser -d /some/path user
Match User user
ForceCommand internal-sftp
PasswordAuthentication yes
ChrootDirectory /some/path
PermitTunnel no
AllowAgentForwarding no
AllowTcpForwarding no
X11Forwarding no
chown root.root /some/
chown user.user /some/path
lftp: Fatal error: Host key verification failed.
lftp -p 22 sftp://user@server
Password:
lftp [email protected]:~> ls
Fatal error: Host key verification failed.
ssh user@server should fix it
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