<?php $filename = 'test.txt'; if (is_writable($filename)) { echo 'The file is writable'; } else { echo 'The file is not writable'; } ?>
Monthly Archives: March 2021
wg-quick: /usr/bin/wg-quick: line 32: resolvconf: command not found
apt install openresolv
503 valid rcpt command must precede data cPanel
You should check if cPanel mailbox disk quota not exceeded
An error occurred while saving sent message. Unable to perform operation. No free disk space.
Roundcube error message. you should check if mailbox disk quota not exceeded
A error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: wheezy Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 9334A25F8507EFA5
apt-key adv --keyserver keys.gnupg.net --recv-keys 9334A25F8507EFA5
(invalid since 900d 10h 15min 15s). Updates for this repository will not be applied.
apt-get -o Acquire::Check-Valid-Until=false update
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