Site Archives

MySQL export/import and charset problems

Posted by plattapuss on May 31st, 2006

Today I discovered I messed up a database upgrade in MySQL. I had a rather large database which I exported from my main server and imported onto my testing server. Both machines had the same version of MySQL. I ran some update scripts on the testing server DB, verified the data, then exported the updated [...]

Limiting sendmails Max Recipients

Posted by plattapuss on May 12th, 2006

There have been a lot of attempts lately on peoples servers to send spam through online forms. This is done by creating a crafty email with a carefully placed Bcc: tag which is then remotely submitted to your unsuspecting form on your server. All the email that goes through your form now from this person [...]

Setting up sendmail over SSL on Ensim

Posted by plattapuss on May 12th, 2006

If you are like me and prefer a slightly more secure connection, or again, you are like me, and your local ISP doesn’t allow you to use port 25 on your own server to send email, then here is the solution. We are going to turn on TLS/SMTP AUTH AND SSL/SMTP AUTH on sendmail. First, [...]

Stuck in maintenance mode on Ensim

Posted by plattapuss on May 11th, 2006

Here is a little quick fix that I needed tonight. Took awhile to find the solution so I thought it worth writing about. I just upgrade my Ensim box with up2date, installed a new version of PHP and upgraded a few other things. Then, like you need to do on an Ensim box, I put [...]