/etc/my.cnf.d/server.cnf
tmp_table_size=256M
max_heap_table_size=256M
ERROR 1114 (HY000) at line 7932: The table ‘g_search_index’ is full
Leave a reply
Monthly Archives: March 2018
directadmin missing user in user list
If after migration user is missing in user list:
mv -v /usr/local/directadmin/data/admin/show_all_users.cache /usr/local/directadmin/data/admin/show_all_users.cache_back
directadmin show force tasks
/usr/local/directadmin/dataskq d
Can’t Load URL: The domain of this URL isn’t included in the app’s domains. To be able to load this URL, add all domains and subdomains of your app to the App Domains field in your app settings.
Laravel auth issue using socialite.
https://developers.facebook.com/apps
Valid OAuth redirect URIs should contain full redirect URL from config/services.php
find sed replace email
find /root/ -type f -exec sed -i -e 's/admin@xxx\.com/[email protected]/g' {} \;
openvz localtime timezone
ln -sf /usr/share/zoneinfo/EET /etc/localtime
ns1 named[32257]: zone xxx.lt/IN: journal rollforward failed: journal out of sync with zone
rm -rf db.xxx.lt.jnl
service named restart
bash grep ip regex
grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}\b"
iptables block user-agent: wordpress
iptables -A INPUT -p tcp –dport 80 -m string –string ‘WordPress’ –algo kmp -j DROP
or
iptables -N WordPress-PingVerify
iptables -I INPUT -p tcp –dport 80 -m string –to 70 –algo bm –string ‘GET /’ -j WordPress-PingVerify
iptables -A WordPress-PingVerify -p tcp –dport 80 -m string –to 80 –algo bm ! –string ‘User-Agent: WordPress/’ -j RETURN
iptables -A WordPress-PingVerify -p tcp –dport 80 -m string –to 300 –algo bm –string ‘verifying pingback from’ -j DROP
iptables -A WordPress-PingVerify -j RETURN
or
iptables -N WordPress-PingBacks
iptables -I INPUT -p tcp –dport 80 -m string –to 70 –algo bm –string ‘GET /’ -j WordPress-PingBacks
iptables -A WordPress-PingBacks -p tcp –dport 80 -m string –to 80 –algo bm ! –string ‘User-Agent: WordPress/’ -j RETURN
iptables -A WordPress-PingBacks -p tcp –dport 80 -j DROP
iptables -A WordPress-PingBacks -j RETURN
directadmin find license id
cat /usr/local/directadmin/scripts/setup.txt
Fix license:
cd /usr/local/directadmin/scripts
./getLicense.sh 123 1234 1.2.3.4
service directadmin restart
prestashop debug
vi config/defines.inc.php
define('_PS_MODE_DEV_', true);
rsync limit bandwidth
rsync –bwlimit=5000 /backup/folder user@host:/remote/backup/folder/
rsync ionice
ionice -c3 rsync -aSv /dir/dir/. /dir/dir/.
-c 1 (real time – don’t use this one on multi user systems!)
-c 2 (best effort “round robin” with -n 0-7 range to set priority on sets of groups to give preference to some processes)
-c 3 (idle only)
directadmin list active users
grep -ir "Suspended=no" /usr/local/directadmin/data/users/*/user.conf | awk -F"/" '{ print $7 }