mysqlfrm --diagnostic /root/table.frm
dump mysql frm strcuture
Leave a reply
Category Archives: linux
sed replace recursive
grep -rl oldtext . | xargs sed -i 's/oldtext/newtext/g'
openvz limit smtp connection
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT
-A FORWARD -s xx.xx.xx.xx/32-p tcp -m multiport –dports 25,587,465 -j LOG –log-prefix “FORWARD:DROP:” –log-level 6
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 465 -m limit –limit 1/sec -j ACCEPT
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 587 -m limit –limit 1/sec -j ACCEPT
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 25 -m limit –limit 1/sec -j ACCEPT
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 465 -j DROP
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 587 -j DROP
-A FORWARD -s xx.xx.xx.xx/32 -p tcp -m tcp –dport 25 -j DROP
554 SMTP synchronization error
If you are getting such error trying to pass some data to exim server, you need to wait exim reponse before passing some data:
echo "quit" | nc -d 2 -C exim.server.com 25
create hash sha-512
mkpasswd -m sha-512 password [salt]
mkpasswd -m sha-512 password
$6$/w.JqEDwOnkq0njo$pW7aC7UaXgvphtq8bikkeVs/5pieGmEqOxwYzZZvHwsqQ6WF0L1EWAQybsTMssNg3k.iFiaLomDq2kEi0IkPU1
binary file (standard input) matches
cat some_file.txt | grep -a sme_string
WARNING: cannot stat file ‘ta.key’: No such file or directory (errno=2)
openvpn –genkey –secret /etc/openvpn/ta.key
openvpn server.conf
prestashop change admin password sql
UPDATE `ps_employee` SET `passwd` = MD5('<_COOKIE_>password') WHERE `ps_employee`.`id_employee` = 1;
clients systemd[1]: ssh.service: Failed with result ‘start-limit-hit’
sshd -t
Missing privilege separation directory: /var/run/sshd
mkdir -v /var/run/sshd
service ssh restart
ReferenceError: URL is not defined
class urlshim extends url lighthouse error:
vi /usr/lib/node_modules/lighthouse/lighthouse-core/lib/url-shim.js +1
Add this line:
global.URL = require(‘url’).URL;
centos 7 node js 8
curl -sL https://rpm.nodesource.com/setup_8.x | bash -
yum install nodejs
htaccess force https
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
dropping privs did not work: No such file or directory
lxc list
dropping privs did not work: No such file or directory
If you have such issue with snap, you can try:
exit
or just CTRL+D
or just relogin to the server
Warning: newuidmap is not setuid root Warning: newgidmap is not setuid root
sudo chmod u+s /usr/bin/newuidmap
sudo chmod u+s /usr/bin/newgidmap
Setting up the GPG keyring ERROR: Unable to fetch GPG key from keyserver
You can try skip validation:
lxc-create -n ubuntu1 -t download — –no-validate –dist ubuntu –release bionic –arch amd64