Image of Cortney & Jeremy

mysql

Why Best Practices Are Important (or: How I Pwn’d The Shit Out Of My ISP)

September 28, 2012
Thumbnail image for Why Best Practices Are Important (or: How I Pwn’d The Shit Out Of My ISP)

Note: The events described herein took place many, many years ago (the statute of limitations has long since expired!), but the moral of the story remains the same. This topic came up on IRC a few nights ago and since a) several were interested in the story and b) I’m heading out to DerbyCon shortly, […]

3 comments Read the full article →

Send Email from PostgreSQL

February 1, 2008

At work, I use both the MySQL and PostgreSQL relational database systems. My personal preference is PostgreSQL though I’m often forced to use MySQL as more software seems to support it. In addition, you may know that I’m a huge fan of Perl. I use it almost exclusively for scripts that interact with databases. Most […]

2 comments Read the full article →

CakePHP on OS X can’t connect to MySQL

January 5, 2008

If you’re trying to use CakePHP on OS X with a MySQL database, you’ll probably have problems connecting to the database server (by default). In my case, I created the MySQL database using the MySQL command-line client, created a MySQL user for the application, gave it the appropriate permissions, configured CakePHP’s database.php configuration file, and […]

6 comments Read the full article →

Aggregating and analyzing logs from multiple web servers

October 7, 2007

Over a year ago, we replaced our single web server running IIS5 on Windows 2000 with a pair of HP DL140‘s running Apache on RHEL4. These two machines serve up our main web site as well as a number of low-traffic sites, to the world. When the Marketing folks, who handle the web sites, asked […]

4 comments Read the full article →