Recently while working on a travel portal, I needed to import huge csv data into MySQL database. Apart from the importing data into its tables, there was another problem. how to upload some 650Mb huge data file of sql dump to server for importing. The trick is that download the csv directly on your server…
You can tell passenger to start the application in production environment with following command on shell by going to the app folder first. I wanted to use Passenger for Redmine app. Start Passenger Log into shell and go to app directory and type the following command: root@server [/home/redmine]# passenger start -a 0.0.0.0 -p 3000 -d…
Debugging is part and parcel of development and especially now applications getting complex with the advent of mobile apps development, developers need to log Form submitted $_POST and $_FILES data. Here’s a useful snippet to log the posted data that you can place in your PHP script to help you identify the problematic part. Jut…
On a Joyent server, I needed to install the libphp2 for PHP on SmartMachine so that WordPress can use SSH in your PHP code, but when I tried following command to install package, it gave followign error: [root@server]# pecl channel-update pear.php.net bash: pecl: command not found This error can be resolved by doing following: [user@server]#…
Copying MySQL databases from one server to other remote machine is task every webmaster has to do very often if not daily, and if your databases are huge, following command comes very handy to do this job without first downloading and then uploading the dump file. Also, phpMyAdmin and other MySQL clients fail while importing…
For transferring one website from one server to another, I had to take the backup. usually this is not a big issue, but this time this machine was 64 bit Spark machine and the new server was a 32 bit GNU machine. While uncompressing, I got the following error: root@server # tar -xvf file.tar.gz tar:…
There are times when you want to change your website directory structure for the latest directory structure on the request of your SEO team or for some other reason, and using 301 redirects in apache’s .htaccess, this can be done very quickly and efficiently. Here are some scenarios that I have encountered and used .htaccess…
For a Drupal based website to work properly, you need FFmpeg installed on server. Before going any further, please note that FFmpeg and FFmpeg PHP extension are two different things (distinct software). While FFmpeg is available as a package on Joyent Smart Machine, however you’ll need to download the FFmpeg extension package from the http://ffmpeg-php.sourceforge.net/…
Setting up osTicket on cPanel is easy and somewhat in Plesk as well, especially the email piping part as they have in depth articles on their wiki. But as soon as you try to set up email piping other than cPanel hosting and Plesk hosting environments, you are in the uncharted waters. Recently, I had…
If you ever have managed some website/portal that has any meaningful traffic, you already know what can it do to your MySQL server performance if you don’t optimise your queries and enable php server side caching. One of the things that you can do at DB level is to enable mysql_query_cache to speed up DB…
Redmine is a mature and very good project management web application using Ruby on Rails framework. Since it requires specific Rails and Ruby Gems versions, Installing and configuring Redmine is not child’s play. One option of setting up Redmine is by downloading the latest stable release from http://www.redmine.org/wiki/redmine/Download Since Apache, MySQL and Ruby are usually…
Compressing your website files, especially the text files, with mod_gzip or mod_deflate on Apache not only save heaps of network bandwidth, but also speed up downloading your website up to 70%. Most web servers can compress hosted website files in gzip format before sending them for download. To enable compression, configure your web server to…
If you ever have developed a website which has tasted a bit of success and has reached to serious volume of traffic, welcome to the Big boys club and new headaches! More traffic means high server load which forces you to take number of steps, some of the most important are listed here (in no…
Setting up Redmine, a great project management tool, is not easy and setting it up one over SSL protocol is not a trivial task. There are number of steps required to accomplish this feat and since there is no guide available, I had a hard time getting it done recently. I scorched Redmine forums, Ruby…
First of all, backup the httpd.conf file with the following command: cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.bkup.ssl.1 The following command opens httpd.conf and searches for the term SSL: vi +/SSL /etc/httpd/conf/httpd.conf You should see the following lines with the prompt at SSL selected: # # Use name-based virtual hosting. # #NameVirtualHost *:80 # # NOTE: NameVirtualHost cannot be…