March 4, 2009 Posted in General
The problem, which should never have happened, happened again just two days later, caused another 4 hours down time. Burst.net must hate me, I can’t understand why they stopped routing my IPs, again!
Read More
March 2, 2009 Posted in MySQL
I rarely check MySQL log file, but recently I got some table corruption errors, and it’s hard to notice these errors, especially when these tables are not critical. I realized that it’s necessary to monitor MySQL log file. According to MySQL manual, before version 5.1.20, it’s not possible to log MySQL errors to syslog. I’m still using 5.0, so I added the following line to cron job of my root account:
30 2 * * * tail -n 50 /var/db/mysql/hostname.err
Now I get notification email daily (no email if it’s empty), not a bad solution.
March 1, 2009 Posted in Misc
After yesterday’s server problem, I realized how ‘horrible’ a support can be, it’s beyond my imagination. Read More
March 1, 2009 Posted in Networking
Today I found some sites on my server didn’t respond, but I couldn’t find anything wrong with the server. Apache logs showed that these websites hadn’t got any visits since 16 hours ago. Read More
February 2, 2009 Posted in Misc
My ISP had a network outage yesterday, which caused a few hours sluggish time…very hard to connect. I signed up despite of many bad reviews on my ISP on WHT, mainly about the network and support. But if it’s bad, it’s bad, I’m not luckier than anyone else. A long history in the industry doesn’t mean anything!! Read More
January 21, 2009 Posted in FreeBSD General
I found I couldn’t access my server, at first I thought it was a network or power outage of my ISP. Opened a support ticket and a reboot brought it back, it turned out to be my server’s problem, checked the system logs, there is absolutely nothing between the reboot and my last login. It seems that the server simply stopped to accept any connections for whatever reasons. Read More
January 20, 2009 Posted in MySQL
I only optimized MySQl on a VPS several years ago, it seems that my server never had to. I was just aware of those my.cnf examples coming along with the installation.
There are 5 example files under /usr/local/share/mysql/:
my-huge.cnf
my-large.cnf
my-medium.cnf
my-small.cnf
my-innodb-heavy-4G.cnf
Read More
January 20, 2009 Posted in DNS
Bind configuration has never been easier, I installed bind 9.6, only commented the following line in /etc/named/named.conf.
listen-on { 127.0.0.1; };
Then I added my zone files and it’s ready. Although I’m still seeing the message “the working directory is not writable“, moreover, not only # rndc reload causes this message, but also # /etc/rc.d/named start.
January 20, 2009 Posted in Networking
I made some mistakes when adding additional IPs for my new server and was locked out twice. Here are some tips to avoid those errors.
Read More
January 19, 2009 Posted in FreeBSD General
Just after I moved to a new server, I saw the familiar signal 11 messages again: Read More
January 19, 2009 Posted in Command & Utility
Copy a local file to remote host with ssh port 123
# scp -P 123 /backup/localefile username@remotehost.com:/backup/
Copy file from remote host
# scp -P 123 username@remotehost.com:/backup/remotefile /backup/
November 22, 2008 Posted in Security
PHPClassifieds 7.5 has a SQL injection vulnerability, the detailed how-to was posted publicly, which caused many classifieds websites hacked. The fix is here. Read More
November 1, 2008 Posted in Misc
Today I started reading UNIX Shells by Example, I have to say this is a great book, at least for beginners like me. Get your copy if you are really serious about FreeBSD. Sooner or later, you will find it is very helpful to write your own scripts. Shell is very powerful and flexible, a tedious task could be easily done with a simple script.
October 31, 2008 Posted in Command & Utility
Condensed version for my own reference, only those commands I didn’t use but will make life easier. Read More
October 30, 2008 Posted in Ports
A visitor followed a post to install AwStats, this post is three years old, it’s absolutely not recommended. Ports are changing very quickly. Even if the program itself doesn’t change much, the post-installation configuration has very probably changed many times. Read More