Monthly Archives: February 2021

list slave mysql

show slave mysql

mysql> SELECT * FROM information_schema.PROCESSLIST AS p WHERE p.COMMAND = 'Binlog Dump';

+---------+------+-------------------------+------+-------------+---------+---------------------------------------------------------------+------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+---------+------+-------------------------+------+-------------+---------+---------------------------------------------------------------+------+
| 3973053 | user | srv-mysql-slave1:53014 | NULL | Binlog Dump | 3743978 | Master has sent all binlog to slave; waiting for more updates | NULL |
+---------+------+-------------------------+------+-------------+---------+---------------------------------------------------------------+------+

Command: MLSD Error: The data connection could not be established: ECONNREFUSED – Connection refused by server

Command: MLSD
Error: The data connection could not be established: ECONNREFUSED - Connection refused by server
Error: Connection timed out after 60 seconds of inactivity
Error: Failed to retrieve directory listing

echo "40000 45000" > /etc/pure-ftpd/conf/PassivePortRange
echo "1.2.3.4" > /etc/pure-ftpd/conf/ForcePassiveIP

service pure-ftpd restart

ModuleNotFoundError: No module named ‘skbuild’

pip3 install “camelot-py[cv]”
ModuleNotFoundError: No module named ‘skbuild’

pip3 install scikit-build

“Problem with the CMake installation, aborting build. CMake executable is %s” % cmake_executable)
Problem with the CMake installation, aborting build. CMake executable is cmake

python3 -m pip install -U pip
pip3 install opencv-python
pip3 install “camelot-py[cv]”

RBL whitelisting postfix

vi /etc/postfix/rbl_override
10.10.10.10 OK
12.23.34.45 OK
mail.freemailer.tld OK
domain.com OK
[email protected] OK
email@ OK

postmap /etc/postfix/rbl_override

mtpd_recipient_restrictions =
reject_invalid_hostname,
reject_unknown_recipient_domain,
reject_unauth_pipelining,
permit_mynetworks,
permit_sasl_authenticated,
reject_unauth_destination,
check_client_access hash:/etc/postfix/rbl_override,
reject_rbl_client dsn.rfc-ignorant.org,
reject_rbl_client dul.dnsbl.sorbs.net,
reject_rbl_client list.dsbl.org,
reject_rbl_client sbl-xbl.spamhaus.org,
reject_rbl_client bl.spamcop.net,
reject_rbl_client dnsbl.sorbs.net,
reject_rbl_client cbl.abuseat.org,
reject_rbl_client ix.dnsbl.manitu.net,
reject_rbl_client combined.rbl.msrbl.net,
reject_rbl_client rabl.nuclearelephant.com,
permit