LAMP on CentOS Rumi, June 6, 2014September 8, 2016 Installing MySQL 5 To install MySQL, we do this: yum -y install mysql mysql-server Then we create the system startup links for MySQL (so that MySQL starts automatically whenever the system boots) and start the MySQL server: chkconfig –levels 235 mysqld on /etc/init.d/mysqld start Set passwords for the MySQL root… Continue Reading
Fix Date Time on PVE OpenVZ Guest machine Rumi, June 6, 2014 Stop VE vzctl stop 101 in HD node, run: vzctl set 101 –capability sys_time:on –save Start VE: vzctl start 101 Enter VE: vzctl enter 101 mv /etc/localtime /etc/localtime.old ln -s /usr/share/zoneinfo/Asia/Dhaka /etc/localtime date 092115442006 (09 = Month, 21 = day, 15 = hour, 44=minutes, 2006 = year) Run date to… Continue Reading
Update PHP 5.4 on Debian 6 Squeeze Rumi, June 6, 2014 Set up Dotdeb First add Dotdeb to your Apt sources: sudo vim /etc/apt/sources.list /etc/apt/sources.list deb http://packages.dotdeb.org squeeze all deb-src http://packages.dotdeb.org squeeze all deb http://packages.dotdeb.org squeeze-php54 all deb-src http://packages.dotdeb.org squeeze-php54 all Save & Exit. Now go for the next- Continue Reading
Reinstall Openssh server on Debian 6/7 Rumi, June 6, 2014 Linux: Debian / Ubuntu Linux Remove SSHD Server Type the following commands: # apt-get –purge remove openssh-server Now reinstall the openssh again using- # apt-get install openssh-server Voila Src: http://www.cyberciti.biz/faq/howto-unix-linux-remove-delete-opensshd-server/ Continue Reading
Install Phalcon framework in Debain 6/7 Rumi, June 6, 2014 This repo can be used additionally to the squeeze-php54 repo of dotdeb.org. Add the following into /etc/apt/sources.list deb http://debrepo.frbit.com/ frbit-squeeze main Add the key, update apt and install packages wget -O – http://debrepo.frbit.com/frbit.gpg | sudo apt-key add – aptitude update aptitude install php5-igbinary php5-mongo php5-oauth php5-phalcon php5-runkit php5-stats php5-stomp php5-yaf… Continue Reading
২৫ এর পর যা সত্যি Rumi, June 6, 2014 বয়স কি পঁচিশ পেরিয়েছে? যদি আপনার বয়স পচিশ পার হয়ে গিয়ে থাকে তাহলে ইতিমধ্যেই আপনি জেনে গিয়েছেন অনেকগুলো সত্য। যেই বিষয়গুলো আগে অর্থহীন মনে হতো অথবা তেমন একটা গুরুত্ব দিতেন না সেগুলোই হয়তো এখন অনেক বেশি গুরুত্বপূর্ণ আপনার কাছে। আবার যেগুলোকে জীবনের সবচাইতে জরুরি মনে হত এমন অনেক কিছুই হয়তো… Continue Reading
Reset root password in Centos/Redhat/SL linux Rumi, June 6, 2014 1. Boot the system and when you see the following message “Press any key to enter the menu”, press any key. (You will see the list of available kernel versions.) 2. Press e in order to edit commands before booting. 3. Highlight the list item with vmlinuz in it by… Continue Reading
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