Tuesday, August 4, 2009

Apache crashes due to error log file size

Apache will crash if your error log or access log's file size reaches 2GB which is the maximum file size of Apache in Linux.

When this problem occurs, you can just delete that file and restart Apache.

You might also consider switching Apache log from normal log into zwrotatelog which will consume a bit more of your server's resource!

Mail For Exchange and Nokia E71

We cannot use the latest version of Mail For Exchange (current version is 2.9.158 S60 3.1 HS). The problem is that MfE will just keep being unable to connect to the Exchange server. This definitely is a bug.

As far as I know, the only working version for Nokia E71 is Mail For Exchange 2.7.0 S60 3.1 which you cannot get it from Nokia's official site anymore.

I did a lot of Googling until I found this working version which you can get it from here

Monday, July 27, 2009

how to rename a table in oracle (sqlplus)

alter table
   table_name
rename to
   new_table_name;

Friday, July 24, 2009

how to change cpan mirror list

$ cpan
cpan) o conf init

This will bring you to reconfigure everything.

Tuesday, July 21, 2009

browsing website anonymously

Bah! Stop searching for an anonymous web browsing service, here is the best one:

HIDE MY ASS

http://www.hidemyass.com

Reliable, fast and etc

Now, you can browse porn sites safely!

HA HA HA

how to set default schema in sqlplus - oracle

SQL> alter session set current_schema=some_schema_name;

Friday, July 10, 2009

how to mount macosx partition from linux

# mount -t hfsplus /dev/usb-sda2 /mnt/usb-sda2

But if you can't write into the mounted partition, you might have to disable journaling on this hfs partition by executing this command from your macosx on this drive:

# /usr/sbin/diskutil disableJournal /Volumes/mac-backup

Tuesday, July 7, 2009

Friday, July 3, 2009

how to combine several pdf files into one pdf file

gs -dNOPAUSE -sDEVICE=pdfwrite -sOUTPUTFILE=combinedpdf.pdf -dBATCH 01.pdf 02.pdf 03.pdf .......

gs is GhostScript.