Setting up the mysql_ Plugin in Munin Rumi, June 6, 2014 After spending a few days trying to get the mysql_ plugin working in my munin installation, I’ve decided to write up the process. It include some pointers about troubleshooting and diagnosing problems with the plugin. Once you have munin and mysql working: # Save this to /etc/munin/plugin-conf.d/mysql_ [mysql_*] env.mysqlconnection DBI:mysql:mysql;host=127.0.0.1;port=3306… Continue Reading
Importing Big mysqldump with Progress Bar PV Rumi, December 12, 2013 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV using-… Continue Reading
PHP enable error reporting Rumi, December 11, 2013 You can set PHP error reporting on in php.ini file (in case you have access to this file). Set the following lines: error_reporting = E_ALL display_errors = On If you have no access to php.ini file but you can modify .htaccess file on your server (in root of your public_hml… Continue Reading
Installing Apache2, PHP5, MySQL and PHPMyadmin On Debian Rumi, December 8, 2013 First we install MySQL 5 like this: apt-get install mysql-server mysql-client You will be asked to provide a password for the MySQL root user – this password is valid for the user root@localhost as well as root@server1.example.com, so we don't have to specify a MySQL root password manually later on:… Continue Reading
Install VNCServer on Centos 5 Rumi, December 5, 2013 Install VNC Server to operate CentOS with GUI remotely from Windows client. VNC is already installed if you already build Desktop Environment. If it's not installed, Install by a command 'yum -y install vnc-server'. [root@ns ~]# yum -y install vnc-server [root@ns ~]# vi /etc/sysconfig/vncservers # line 20: make valid and… Continue Reading
Linux service restart shell script Rumi, November 29, 2013November 29, 2013 I badly needed a script that would check if my running services (in this script it'll check varnish and apache2 services) are alive- if not, it'll restart the dead service and write a log. Pretty handy! Continue Reading
Using the DIV tag to display columns rather than tables Rumi, November 15, 2013 The TABLE element may be a convenient way of producing stable layouts, but the W3C WAI guidelines are pretty clear that tables are for displaying tabular information, not for arranging page content. The DIV element is used as the basic layout element as it does not add any extra meaning… Continue Reading
.htaccess URL redirect Rumi, November 13, 2013 # This allows you to redirect your entire website to any other domain Redirect 301 / http://mt-example.com/ # This allows you to redirect your entire website to any other domain Redirect 302 / http://mt-example.com/ # This allows you to redirect index.html to a specific subfolder Redirect /index.html http://example.com/newdirectory/ # Redirect… Continue Reading
OpenFiler Installation On Headless NAS Rumi, November 12, 2013 So, you have a Dell 715N nas or similar and wish to install OpenFiler onto it? This nas is headless, it has no USB ports, no CDROM, no floppy. It’s only connection to the outside world is it’s serial port and it’s network interfaces (2). You may or may not… Continue Reading
Nginx wordpress fancy URL or permalink fixing Rumi, November 12, 2013 If your wordpress is installed in the root directory i.e. yourdomain.com, you can use the following directives- location / { try_files $uri $uri/ /index.php?$args; } # Add trailing slash to */wp-admin requests. rewrite /wp-admin$ $scheme://$host$uri/ permanent; location ~* \.(jpg|jpeg|png|gif|css|js|ico)$ { expires max; log_not_found off; } Or if your wordpress is… Continue Reading