Author Archives: itdoctor - Page 37
Ubuntu – Mysql – too many sleep connections
You got error ” too many connections” when connecting to database, when you check the server “show processlist” you see a lot of process having “sleep” status. Here is...
Ubuntu – mysql 5.6 – max connections 214
You try to increase your connections to 1000 by editing /etc/ (change max_connections=1000) , but when you login to your database, you can only see your mysql only accept...
taskhost (2940) WebCacheLocal: Database recovery/restor – Juniper SSL
If you can’t start Junier SSL VPN and got the error below in system viewer: taskhost (2940) WebCacheLocal: Database recovery/restore failed with unexpected error -1032 Here is the fix:...
Install PHP on Ubuntu 16.04
List all php packages installed: dpkg -l | grep php| awk '{print $2}' |tr "\n" " " Remove all php package: sudo aptitude purge `dpkg -l | grep php|...
Ubuntu – adding startup script
Edit file: / This file will auto run at startup. This file is a bash file, it might be run when all the services is not ready yet,...
Good article to detect a DOS attack
DDOS attack measures
Apache DOS attack – CLOSE_WAIT
Our servers recently were crashed due to a large number connections to web (apache) services, we didn’t see anything abnormal on the web. The server will crash when there...
Mod Status – server-status .htaccess WordPress
# BEGIN WordPress <IfModule ; RewriteEngine On RewriteBase / # server info and status RewriteRule ^(server-info|server-status) - # RewriteCond %{REQUEST_URI} !=/server-status # /server info and status RewriteCond %{REQUEST_FILENAME}...
Some useful commands to work with hard disk in Ubuntu
#View Raid Status cat /proc/mdstat #View the member of a raid mdadm /dev/md1 #View Hard disk info - such as serial hdparm -i #List all hard disks detected...
Jabber – Outlook 2013 Calendar Intergation
Problem: Jabber doesn’t show Outlook calendar even though we have selected Microsoft Outlook for Calendar Intergation FIX: Add a new entry in this registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Messaging Subsystem MAPIXVER = “#8221;