Munin to monitor mysql on Debian 6 Rumi, March 19, 2013 First we need to install some Mysql-Munin perl libraries: apt-get install libipc-sharelite-perl Also some Perl stuff will be needed: perl -MCPAN -eshell install IPC::ShareLite Next let’s activate Munin Mysql plugin: Assuming you have already installed both munin & mysql ln -s /usr/share/munin/plugins/mysql_* /etc/munin/plugins Restart both Apache & Munin: /etc/init.d/apache2 restart… Continue Reading
MySQL Root Password Reset Rumi, March 18, 2013 First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords. mysqld_safe –skip-grant-tables You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to… Continue Reading
Hide the Apache Web Server Version number with ServerSignature and ServerTokens directives Rumi, March 7, 2013 You can easily hide Apche (httpd) version number and other information. There are two config directives that controls Apache version. The ServerSignature directive adds a line containing the Apache HTTP Server server version and the ServerName to any server-generated documents, such as error messages sent back to clients. ServerSignature is… Continue Reading
Securing directory using .htaccess file Rumi, February 25, 2013October 20, 2013 First make sure your Apache configuration is set for allowing .htaccess. Read this Article first before you move to the next steps. .htaccess File Creation: Let's assume /test-dir1 is to be password protected. $ cd /var/www/html/test-dir1 $ vi .htaccess Write the following lines into this file: AuthName "Authorized Users Only."… Continue Reading
Install htop in Linux- Redhat/CentOS/SL and Debian/Ubuntu Rumi, February 18, 2013 There are times you want to have a better control over the system processes and usage and also having a better visual of RAM and CPU usage on your server.As You may already know there is a Linux command called top which will show the resources and users cpu usage… Continue Reading
Apache Web Server .htaccess File functional Rumi, February 8, 2013 .htaccess is Apache's directory-level configuration file. It allows end user to configure authentication and other options without editing main httpd.conf file. Make sure AccessFileName set to .htaccess Search httpd.conf for AccessFileName directive. It defines name of the distributed configuration file: # grep -i AccessFileName httpd.conf Make sure users are allowed… Continue Reading
Force HTTPS / SSL using .htaccess and mod_rewrite Rumi, February 7, 2013 Sometimes you may need to make sure that the user is browsing your site over securte connection. An easy to way to always redirect the user to secure connection (https://) can be accomplished with a .htaccess file containing the following lines: RewriteEngine On RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]… Continue Reading
Install Munin on SL 6 Rumi, January 31, 2013 [root@master ~]# yum –enablerepo=epel -y install munin munin-node # install from EPEL [root@master ~]# vi /etc/munin/munin.conf # line 60: change to your hostname Continue Reading
MySQL Master-Master or Master-Slave Replication Error Fix Rumi, January 18, 2013 Scenario Master – Master replication MasterA is a client facing server MasterB is a warm standby server (read only) MasterB restarted abruptly and when instances were braught back up MasterA (it’s slave) was showing the following error: MasterA has the following error in show slave status: Last_IO_Errno: 1236 Last_IO_Error: Got… Continue Reading
Enabling munin node plug-ins on Debian Rumi, January 18, 2013January 18, 2013 Munin uses plug-ins to determine what data is gathered and reported. It includes several plug-ins for the types of data most people would be interested in, but not all of those plug-ins are enabled on a fresh installation. What are plug-ins? When a munin node gathers data about a slice… Continue Reading