nvidia drivers in ubuntu maverick

The other day, I ran an update on my Maverick box that wiped out my video settings. Nvidia released a nice new driver for GeForce 6000+ but I’m using a GeForce 5 series card so I think the upgrade probably replaced my video settings with the nice new ones.

There are a lot of unresolved forum posts about this … if you’re using an older video card, you just need to uninstall the new Nvidia drivers and re-install the legacy drivers:

apt-get remove --purge nvidia-current
apt-get install nvidia-173

setting up Ubuntu Lucid 10.04 for web development Part 1

Ubuntu Lucid 10.04 is the most recent LTR released about a week ago, so naturally I wanted to take a look. I upgraded my test server which is where I run demo installs of various content management systems and where I store works-in-progress. This requires that the server must serve up a number of applications written in php, django, plone, and ruby on rails. Continue reading

WordPress 2.9 Illegal Mix of Collations in Database

In the course of investigating a problem with runaway Apache processes, I discovered this collation issue.

In the apache error log, the first error to confront me was this:

 WordPress database error Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT comment_ID FROM wp_comments WHERE comment_post_ID = '2933' AND comment_approved != 'trash' AND  .... etc

Continue reading

$PATH settings on Mac Snow Leopard

Managing Paths

The problem with setting up an environment piecemeal is when you sit down to do something, you have to figure out what rabbit hole you’d gone down when you left off. In this case, I remembered installing mysql, but usually the last thing I do when I install mysql is install phpmyadmin because it’s such a handy productivity tool. Well, there was no phpmyadmin on my system, but that could be because Snow Leopard came with PHP 5.3 out of the box which is incompatible with most of the popular PHP web applications out there. Continue reading

open ssl upgrade from ssl 2 -> ssl 3

I inherited a number of web servers that had been installed and configured by different contractors and am now in the process of evaluating what needs to happen to bring them all up to snuff as well as figuring out ways to streamline regular updates. Some of those web servers are still on Red 7.3 (!), the last free open source version of Red Hat. They’re quite old in server years. Additionally I have a few other servers I set up a year ago that are more up-to-date running Ubuntu 8 LTS, but the Apache version is 2.2.11 and 2.2.8. Our security scanning service notifies me regularly that SSL v 2 must be upgraded to SSL v3, which requires an upgrade to Apache 2.2.13 Continue reading