I was assigned to find out how to install Subversion on CentOS. It is a good version control system right now, especially for development teams in any enterprises. Installing Subversion on CentOS is quite easy as follows.

I have a mission to rip a subtitle from a DVD. My laptop is Ubuntu Feisty Fawn and my favorite tool is mencoder. In fact, I have never done something relating to subtitles before. However, mencoder should be able to satisfy me as always.

I would like to drop all tables in a database of MySQL but I don't want to drop the database itself. The reason are that the created tables seemed to be incorrect and I would like to recreate or import it again. However, I am so lazy to create the database and grant the user/pass again. Fortunately, I found a workaround trick.

My friend posted about reseting mysql root password long time ago. It still works but you have to know how to change root password properly. Since I have to do it by myself, I will explain more detail in this post.

Sometimes authenticating password against LDAP in PHP can't rely on userPassword attribute because they might use only lmPassword or ntPassword. It is not quite easy but not too hard as long as we have LDAP Account Manager.

There are so many hash. SHA1 is one of them which is widely used in recent years even though it is not safe to use right now. By the way, it is still the default hash function for storing password in LDAP especially OpenLDAP. In order to develop a website with LDAP authentication manually against POSIX account, SSHA hash function or SHA1 is the easiest solution.