Archive for the 'Sysadmin' Category

Deploying Rails with Mongrels on a Shared Web Server
Thursday, January 10th, 2008

Rails probably won’t be the next big thing. With behemoths like ASP.NET offering tight integration with existing desktop apps and household names like PHP now bundled with every Linux distribution, Rails doesn’t have enough to offer the run-of-the-mill web developer to win them over.
But some know.
Once you’ve learned Rails (and thus Ruby), you think of [...]

Serious Neckpain: Virtual Mail Hosting with Postfix and DBMail
Wednesday, January 2nd, 2008

It’s supposed to be easier this way, right? Doing virtual mail hosting with mbox files is just asking for it. My manager recommended dbmail over dovecot, and he’s a smart guy, so I’ll go with it. It can’t be that hard. Much to my chagrin, there isn’t a single recent howto [...]

Quick Fix - Tomcat: Name java:comp is not bound in this Context
Wednesday, February 14th, 2007

An application that was running fine started throwing this exception on startup: javax.naming.NameNotFoundException: Name java:comp is not bound in this Context. Tracing showed it came from code that was used to glean the database connection information from the environment (configured through context XML files).

Coyote Point E350si Load Balancer Cutover Woes
Monday, February 5th, 2007

I’m just finishing up a 65-hour week in which I was planning, executing and troubleshooting the first installation of a load balancer in my data center. To quell the rising traffic levels, it was decided to move one of the oldest customers of the company from a “highly-available” active/standby web/application server using the heartbeat [...]

More mod_rewrite / .htaccess: going the distance with URL masking
Tuesday, January 23rd, 2007

Continuing in the saga of a customer’s SEO (search engine optimization) journey, I was told that I needed to find a way to mask the URLs used by our custom content management system completely using only the .htaccess file. Previously I was asked to make it possible to enter blah.com/bliggity into the browser and [...]

Mod_rewrite / .htaccess nuances
Thursday, January 18th, 2007

In the post “Mod_rewrite, how could I forget?!?” I wrote about using an htaccess generated by ColdFusion to make links that will display as blah.com/product rather than blah.com/index.cfm?page=123. In practice, as usual, it was a bit more tricky than most mod_rewrite tutorials put it–not vastly different, but just enough to require about 1/2 hour [...]

Automated Exporting of an Entire ORACLE Database Without a Password
Friday, January 12th, 2007

Due to a recent fiasco at my work with developers wiping out data in databases, I’ve decided it’d be a good idea to export the database so that we could recover individual tablespaces and tables if necessary. The answer doesn’t immediately present itself, however, because I don’t have the ’sys’ user password. I’m ok, [...]

Restoring an ORACLE Tablespace
Thursday, January 11th, 2007

A developer asked me the other day, “Do we have backups of the [insert website name here] database? I accidentally issued an SQL UPDATE statement without a WHERE clause and overwrote a bunch of data.”
“And you didn’t make an export before you started working on it, did you?”, I replied, admonishingly. The answer [...]