Here is a quick list of useful commands for any MySQL database administrator. Show the server full status : mysqladmin -u root -p extended-status You may also sort specific information with “grep” as followed : mysqladmin -u root -p extended-status | grep Threads Show the current running process and queries (remove “-i 1” to display… Read More »
VMware ESXi hypervisor have some great SNMP capability, whatever to gather information status of your hardware, monitoring or statistic usage of your resources. Follow these easy steps to enable such feature. 1. Enable SSH from the vSphere client and connect to it using your favorite terminal application : Configuration tab > Security Profile > Services >… Read More »
Using cURL, you can easily grab some information about the server who’s running a Web site. To get all the possible information, simply use (replace domain.tld with the actual domain name) : curl -s -I domain.tld You can also can just output the server info like this : # curl -s -I microsoft.com|grep Server Server:… Read More »
Using Nginx as Apache reverse proxy and receiving “502 Bad Gateway” error and, additionally have something like this in your error log file? [error] SSL_do_handshake() failed (SSL: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol) while SSL handshaking to upstream, client: 0.0.0.0, server: www.domain.tld, request: “GET / HTTP/1.1”, upstream: “https://127.0.0.1:4343/”, host: “www.domain.tld” Since you are using SSL, you obviously need… Read More »
Having this error while uploading large files with Nginx? 413 Request Entity Too Large or ; [error] client intended to send too large body 1. Edit the main Nginx configuration file : /etc/nginx/nginx.conf 2. Append the following and set the value to meet your needs (this example assume that the max upload file size is… Read More »
Experiencing the following error while running “apt-get update” on your Ubuntu server? W: Failed to fetch http://ca.archive.ubuntu.com/ubuntu/dist/precise/restricted/source/Sources Hash Sum mismatch E: Some indes files failed to download. They haev been ignored, or old ones used instead. Just run the following command : sudo rm -Rf /var/lib/apt/lists/* And run the update command again : sudo apt-get… Read More »
After updating vsFTPd (version 3.0.2 +), you may have noticed the following error while trying to log using a chrooted account : 500 OOPS: vsftpd: refusing to run with writable root inside chroot () This error would only happen if you have the following parameter enabled (chroot users into their home directory) : chroot_local_user=YES The… Read More »
The following procedure is about reseting root password and preserve the current configuration on your Juniper device running JunOS. 1. As soon you see “Hit [Enter] to boot immediately, or space bar for command prompt.” message, just press the space bar as indicated : FreeBSD/PowerPC U-Boot bootstrap loader, Revision 2.1 (marcelm@apg-bbuild01.juniper.net, Wed Feb 6 11:23:55… Read More »
Due to the recent POODLE (Padding Oracle On Downgraded Legacy Encryption) SSLv3 vulnerability discovery, you may want to disable it to protect you and your visitors against this exploit. Here is the procedure for Windows Server/IIS. Note that older/obsolete browsers are not implementing TLS, shame on users for not doing their updates then! 1. Open… Read More »
Having this error message while running a “yum install” or “yum update” command on your RHEL/CentOS Linux system? Error: database disk image is malformed 1. Simply run the following command to fix this issue : yum clean all 2. Alternatively, if the problem is still persisting, then try to move the RPM database to a… Read More »