World of *Nix

Thanks for visiting my blog. This is not a technical post (most of my previous post are technical 😛 ).
Today i am going to share the history of this blog. I started blogging about 2 years ago with wordpress.com. After passing some time i moved my entire blog to blogspot.com. Then i tried lot’s of other host like x10hosting.com, 100webs etc . But every where there is some limit ion. So i move my blog to this paid hosting about 3 months ago.

From the very beginning i tried to share my knowledge with you. To share the knowledge with more and more people, i always try to some more people in. So if you think my blog is really helped you, please don’t forget to tell your friend about my blog.

To get more people in, i added digg support on my everypost (past and future). So if you really like any my post, please give a digg (it’s so simple, just click on the digg icon then follow there instruction). Though it will waste your little time, belive me, it will help lots of other people to get this post :).

If you have any feedback, please write it on comment or send a mail to smibrahim[at]gmail.com

thanks,
lavluda

Today i bought this nokia 5300 🙂 .

Few minutes ago, one of our mysql database table (it’s really a big table) was crashed.
So to repair this i login that server and excute

repair table tablename

But the repair process failed, and i got this output.

test.t1 | repair | error | 13 when fixing table |
| test.t1 | repair | status | Operation failed |

Then i start searching on google. After passing some time i found the reason. Mysql can’t repair that table as there is a trigger on this table. So i tried to drop the trigger

drop trigger triggername

no luck, mysql can’t drop the trigger, as the table was crashed 🙁

Now i studied more and more. At last i got the solution 🙂

REPAIR TABLE tablename USE_FRM

Now the table repair complete successfully. Thanks to Allah as i got the solution in time:)

Nowadays, lots of php developers are thinking to move their development environment to linux. And I am writing this tutorial for them. As I like Debian GNU/Linux (www.debian.org) best and ubuntu (www.ubutnulinux.org) is now doing great, in this tutorial I am using the commands for debian & ubuntu.

Ok, now starting:

First on all let’s make a list of software a PHP developer need mostly:

1.Apache
2.PHP
3.Mysql
4.PHP IDE

Ok, let’s start with Apache. Debian & ubuntu use APT to manage the packages. You can easily install apache using apt, here is the command

Debian user:

su

Ubuntu user:

sudo su

Rest of the command ar same for both debian & ubuntu.

apt-get install apache2

It will install all the apache2 & all the related packages (software)
If you need to enable mod_rewrite, follow this link
Now install the PHP

Apt-get install php5 libapache2-mod-php5

This will install the php5 and configure your apache2 server for PHP. You don’t need to do anything.
Lets test the server, if it working ok.

touch /var/www/info.php

Chown www-data:www-data info.php

Now edit this info.php with your feviourate editor and add write code to show phpinfo():
and now browse http://localhost/info.php from your browser. Now check if all your requested library are installed.
if you need any more library, you can check if it already available on your debian/ubuntu package list.

apt-cache search php5-

then you will get the list of available php5 library. Now simple use this command to install it.

apt-get install php5-gd

(example, if you want to install php5 GD library)

Remember: after installing every extra packages, you must need to restart apache server

/etc/init.d/apache2 restart

Ok, so you have now apache2 and php5 installed system. Let’s install mysql:

apt-get install mysql-server-5.0 php5-mysql

It will install all the necessary packages to run mysql-server.
Now restart your apache to take effect.
Complete!!!! Server is allmost ready.
Now i am going to derive how you will transfer your old code to this new environment. Belive me it’s too simple, so don’t worry.

First of all copy your source code to /var/www, here is the details procedure:

mkdir /windows

Here we make a folder for C drive of windows to mount.
mount /dev/hda1 /windows
then we mount the C drive to windows folder (here i use hda1 as example, if your hdd is sata then it will be sda1)

cp -r windows/Apache2/htdocs/xyz /var/www

here we copied our xyz site to /var/www (in debian and ubuntu, default apache2 root folder is /var/www)

cd /var/www

chown -R www-data:www-data xyz

Now change the ownership to www-data

Now we need to move the mysql database, there is two way:

1.use phpmyadmin
2.simple copy the database from data folder
I am deriving the 2nd way.

cp -r /windows/Mysql/data/xyz /var/lib/mysql

chown -R mysql:mysql /var/lib/mysql/xyz

You are done.

PHP Ide for linux environment:

1.Zend ( i personaly use this)
2.PHPEd
3.PHPEclipse
4.quanta plus
5.emacs
6.vi
7.PHPedit

***I know this tutorial needs more edit, please make your comments if you got anything wrong, or missed anything. I want it a cool tutorial for php developers.

Read some reviewed, the best and most affordable php hosting solutions on the market.

Few minutes ago i make a unoffical repository of deb packages for debian (though it’s empty).
you have to add this line to your /etc/apt/sources.list
deb http://debian.lavluda.com binary/

if you want to release any deb file unofficaly for debian and need help to host it, send me the .deb file and don’t forget to add signature to your package.

** for testing i added the d4x on my repository, i will remove it.

please test my repository and give your feedback here.

At last from yeasterday i avoid windows 100% .

Previously my home pc was runing on linux but my developemnt laptop was runing on windows & linux (mostly windows).

But from yeasterday i removed windows from my lapptop.

So back to linux 😀 .

Here is the list that i am using now:

My OS: Debian GNU/Linux (etch)
php Editor: Zend Development Environment(linux )
Email Client: Evolution
CD/DVD burning software: GnomeBaker
Mp3/audio player: Rythm Box, totem, amarok
DVD/Video: totem/xine
Browser: Iceweasel (firefox)
Office: openOffice.org
Image editor: gimp, inkspace
Project Time tracker: gnoTime
Downloader: d4x

Here i am going to describe how to enable mod_rewrite in apache2.2 -specaily for debian.

In default installion of apache2.2 on debian never enable mod_rewrite default. So you may need to enable .

First install the apache2.2 with this command :
debian user please use “su” before start this process
ubuntu user please use “sudo su” before start this process

apt-get install apache2 (it will install apache 2.2)

on current debian system you can enable mod_rewrite with simple command

a2enmod rewrite

old style, you can skip this portion

now use locate to find if the mod_rewrite.so is availble on your server

updatedb
locate mod_rewrite.so


it will found in “/usr/lib/apache2/modules”

new apache follow some folders to enable and disable mods.
so now do this:

cd /etc/apache2/mods-enabled
touch rewrite.load
gedit rewrite.load (you may use any editor to edit this file)

now paste this following line

LoadModule rewrite_module /usr/lib/apache2/modules/mod_rewrite.so

end of old style

Then edit /etc/apache2/sites-available/default or /etc/apache2/sites-available/000-default (check which one available on your system)

Find the following

Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all

and change it to

Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order allow,deny
allow from all

and finally restart Apache

/etc/init.d/apache2 restart
or
service apache2 restart

OK, you done 😀

don’t forget to comment, if it works or not.

thanks.

if you like my post, please tweet it, so other also can see this post.

If you have a very good project & need help to host, please contact with me. May be I can help you to host it.
What you have to do is only give me little credit for this help.

My contact email: smibrahim[at]gmail.com

Don’t forget to write details of your project.

Yesterday I made a journey from Dhaka to Chittagong (my home). On the train I used my laptop and get connected online by using edge connection. I really enjoyed the time. Here is some pictures that is taken by my brother farid mazumder .

You can get more details (live) here

গত কাল এক বন্ধুর জন্য পিএইচপিএর বাংলা বই কিনতে গিয়েছিলাম নিলক্ষেত। কিন্তু বইয়ের অবস্থা দেখে খালি হাতেই বাড়ি ফিরলাম। কি আর বলব তাদের বইয়ের কোয়ালিটি। মোট 2 টি বই পেয়েছিলাম। 1তম টায় দেখলাম পিএইচপি আর মাই এসকিউল ইনেস্টলশেন করতে করেতই অর্ধেক বই শেষ বাকিটা যা্ষ্ট ম্যানোয়ালের ট্রানসলেশন। আর দ্বিতীয় বইটিতে দেখলাম যা আলোচনা করা দরকারঁ তার সম্প্রর্কে খুব কমই লিখেছে। শুধু আজে বাজে কথায় ভর্তি।

আমি খু্বই হতাশ হলাম। চিন্তা করছি সময় করতে পারলে একবার চেষ্টা করে দেখব, একটা পিএইচপি বই লেখতে পারি কিনা যা দিয়ে যে কোন ব্যক্তি অন্তত বেসিকটা ভালভাবে বুঝে শিখতে পারবে।