apt-get -o Acquire::Check-Valid-Until=false update
(invalid since 900d 10h 15min 15s). Updates for this repository will not be applied.
Leave a reply
journalctl mysql logs
journalctl -u mysql.service -f
jq: error while loading shared libraries: libonig.so.5: cannot open shared object file: No such file or directory
yum install oniguruma -y
yum install libsodium -y
mysqld[]: mysqld: Can’t read dir of ‘/etc/mysql/mysql.conf.d/’ (Errcode: 13 – Permission denied)
journalctl -u mysql.service -f
mysqld[]: mysqld: Can’t read dir of ‘/etc/mysql/mysql.conf.d/’ (Errcode: 13 – Permission denied)
mysqld[]: mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
mysql.service: Control process exited, code=exited, status=1/FAILURE
systemd[1]: mysql.service: Failed with result ‘exit-code’.
systemd[1]: Failed to start MySQL Cluster Community Server.
ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/
apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld
check if certificate and key match
openssl pkey -in ssl_key.key -pubout -outform pem | sha256sum
openssl x509 -in ssl_cert.crt -pubkey -noout -outform pem | sha256sum
apk install telnet
apk update
apk add busybox-extras
csf flush all blocks
The firewall on this server is blocking your connection
csf -df
apt show upgradable security
apt list --upgradable | grep "\-security"
mysql slave read only
Make sure you are working on slave server:
SHOW SLAVE STATUS \G ;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
SELECT @@global.read_only, @@global.super_read_only;
+--------------------+--------------------------+
| @@global.read_only | @@global.super_read_only |
+--------------------+--------------------------+
| 0 | 0 |
+--------------------+--------------------------+
1 row in set (0.00 sec)
SET GLOBAL super_read_only = 1;
SELECT @@global.read_only, @@global.super_read_only;
+--------------------+--------------------------+
| @@global.read_only | @@global.super_read_only |
+--------------------+--------------------------+
| 1 | 1 |
+--------------------+--------------------------+
1 row in set (0.00 sec)
Save config settings:
super_read_only = On
mysql> INSERT INTO authors (id,name,email) VALUES(1,"Test","[email protected]");
ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement
If ERROR 1193 (HY000): Unknown system variable 'super_read_only'
SET GLOBAL read_only = 1;
UPDATE mysql.user SET super_priv='N' WHERE user<>'root';
FLUSH PRIVILEGES;
select user,host,plugin,Super_priv from mysql.user;
+------------------+-----------+-------------+------------+
| user | host | plugin | Super_priv |
+------------------+-----------+-------------+------------+
| root | localhost | unix_socket | Y |
| replica_user | % | | N |
Unable to locate package lsb_release
apt install -y lsb-release
zabbix_get []: Check access restrictions in Zabbix agent configuration
failed to accept an incoming connection: connection from “192.168.1.100” rejected, allowed hosts: “127.0.0.1”
vim /etc/zabbix/zabbix_agentd.conf
Server=127.0.0.1,192.168.1.100
imap-login: Info: Aborted login auth failed, 1 attempts in 0 secs
dovecot enable plaintext auth
disable_plaintext_auth = no
service dovecot restart
* OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE LITERAL+ AUTH=PLAIN AUTH=CRAM-MD5] Dovecot (Ubuntu) ready
sender verify fail for The mail server could not deliver mail to The account or domain may not exist, they may be blacklisted, or missing the proper dns entries.
cPanel whitelist sender
WHM >> Service Configuration >> Exim Configuration Manager
Sender verification bypass IP addresses
Trusted SMTP IP addresses
Unable to negotiate with xx.xx.xx.xx port 22: no matching key exchange method found. Their offer: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
ssh -oKexAlgorithms=+diffie-hellman-group1-sha1 192.168.1.100
ubuntu gcloud
apt install apt-transport-https ca-certificates gnupg -y
echo "deb [signed-by=/usr/share/keyrings/cloud.google.gpg] https://packages.cloud.google.com/apt cloud-sdk main" | tee -a /etc/apt/sources.list.d/google-cloud-sdk.list
curl https://packages.cloud.google.com/apt/doc/apt-key.gpg | apt-key --keyring /usr/share/keyrings/cloud.google.gpg add -
apt update
apt install google-cloud-sdk
gcloud init
Welcome! This command will take you through the configuration of gcloud.
Your current configuration has been set to: [default]
You can skip diagnostics next time by using the following flag:
gcloud init --skip-diagnostics
Network diagnostic detects and fixes local network connection issues.
Checking network connection...done.
Reachability Check passed.
Network diagnostic passed (1/1 checks passed).
You must log in to continue. Would you like to log in (Y/n)?