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
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
Many-To-One Mappings IIS Rumi, February 13, 2013February 13, 2013 Many-to-one Client certificate mapping is used by the Internet Information Services (IIS) to associate an end user to a windows account when the client certificate is used for the user authentication. The user session is executed under the context of this mapped windows account by IIS. For this to work… 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