Aaron Gadberry

Help – v. helped, help·ing, helps

Was this site helpful?
My Amazon.com Wishlist

Archive for the 'Server Management' Category

Helpful information to dedicated server administrators.

Hosting Issues

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 »

Using Plesk and vhost.conf

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 | 47 Comments »

How To: Blacklist an Email Address

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 /etc/mail/spamassassin/ directory.

If you have joe installed you can edit it like so joe /etc/mail/spamassassin/local.cf.
Read the rest of this entry »

Posted in Computers, Server Management | 1 Comment »

How To: Have qmail send to an external smtp server

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 /var/qmail/control/smtproutes.

Edit it to look like this

/var/qmail/control/smtproutes
:smtp.myisp.com

Restart qmail for good measure with /etc/rc.d/init.d/qmail reload

You’re done!

Posted in Computers, Server Management | 2 Comments »

MySQL Commands

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 – /etc/rc.d/init.d/mysqld start
Stop MySQL – /etc/rc.d/init.d/mysqld stop
Restart MySQL – /etc/rc.d/init.d/mysqld restart

If it won’t stop successfully, you can always killall mysqld.
If you killall it though, you may need to remove the lock file to rerun it.
You can do that by running rm /var/lock/subsys/mysql.

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 tail /var/log/mysqld.log.
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 »