19th February 2007 - By Aaron Gadberry
Sorry to everyone out there. I’ve had some major downtime issues the past 3-4 days. I really like my host but 3 days downtime is enough that I think I’m going to switch.
Update:I have decided to stay with my host. They have been very good in the areas of support, and that is very valuable with my customized needs.
Posted in Server Management | No Comments »
9th February 2006 - By Aaron Gadberry
Wondering how to create a good vhost.conf? Well you’ve come to the right place.
Plesk automatically updates httpd.include for each domain, making changes to this file only temporary. You don’t want to use this file if you need to make changes to Apache’s config on the fly, such as php’s open_basedir values per domain.
Instead you will want to use a vhost.conf file. This file will be placed inside your domain’s conf directory, usually found at
/var/www/vhosts/yourdomain.com/conf. Create a file called vhost.conf in whatever editor you prefer. I use joe.
You can now put in any Apache configuration options like you would into httpd.include. In my case I wanted to do three things, give my site access to
/php/includes, add a
mod_rewrite rule, and tell Apache to follow symlinks.
Read the rest of this entry »
Posted in Computers, Server Management | 46 Comments »
7th February 2006 - By Aaron Gadberry
If you run a server with Spamassassin and you have one annoying person you need to block (blacklist) from your entire server, this article is for you. It’s a fairly simple process, but you will probably need root access to the server to complete the configuration changes.
You will need to edit the Spamassassin configuration file, typically found in the
If you have joe installed you can edit it like so
Read the rest of this entry »
Posted in Computers, Server Management | 1 Comment »
11th January 2006 - By Aaron Gadberry
So you have qmail, but you want it to send your message from your isp’s smtp server instead of your own. Well it’s actually pretty simple…
First SSH to your server and create a file called
Edit it to look like this
Restart qmail for good measure with
Posted in Computers, Server Management | 2 Comments »
6th January 2006 - By Aaron Gadberry
Here is a list of some of the MySQL commands I have had to either look up or have handy for server admin.
Start MySQL –
Stop MySQL –
Restart MySQL –
If it won’t stop successfully, you can always
If you killall it though, you may need to remove the lock file to rerun it.
You can do that by running
Setup MySQL to run on boot.
First check the runlevels it starts on using
/sbin/chkconfig --list mysqld.
Then, if 3, 4, and 5 are not on, change them with
/sbin/chkconfig --level 345 mysqld on.
To view the last 10 lines of the mysql log file, use
To view the last 500 lines, use
tail -n 500 /var/log/mysqld.log
To delete duplicate records in MySQL, use the following code
CREATE TEMPORARY TABLE table_name_temp AS SELECT DISTINCT field FROM table_name;
DELETE FROM table_name;
INSERT INTO table_name(field) SELECT field FROM table_name_temp;
Posted in Computers, Server Management | No Comments »