I've had a little bit of down-time for the last few days, which I can only attribute to my clients holding off until the day we leave for vacation to throw everything I've been waiting on my way. I've been working on some sites that use PHP and MySQL and it's gotten to the point where working with a single account on a hosted site is a hindrance, so I decided I'd look into setting up a Linux server on my internal network for testing.
After a whole 5 minutes of research, I decided to give
Fedora a try, especially since it has a lot of the stuff I need already setup, or so I thought.
My first lesson, don't bother trying to run Linux on a Celeron 466 with only 192 MB of RAM. It took forever to load things, and I was getting bogged down by loading times. So I proceeded to install Fedora on an extra box I have here. To be honest, I have no idea what its specs are, but I know it's only a year old and has 1GB of RAM, so I knew it would perform better (and it did).
Lesson number 2, installing some things in Linux is wonderfully complicated. It turns out that the MySQL version included in Fedora is out-of-date. In a Windows world, I'd just download the latest version of MySQL, install, and I'd be ready to go. Not so with Linux.
I installed the version of MySQL I needed just fine, but in the process of doing so, I broke the module that connects PHP and MySQL, so the two couldn't talk to each other. Again, you'd think all I need to do is upgrade the connector, but you'd be wrong.
It turns out that the connector has dependencies on PHP, meaning that it only works with a very specific version of PHP. The PHP install in Fedora is not a standard install, so a standard version of the connector won't work. So now I need to get a standard install of PHP, and here's where the real fun begins.
In Linux, it seems that there are two main installation methods. One is to use a prepackaged installation file, called an RPM. The other method is to download the source code and compile it yourself. Guess which one you need to use for PHP. So what's the problem? I haven't the first clue as to how to go about doing the compile myself.
So that's where I am at the moment. I've been looking for some basic instructions on how to do this, but I don't think it's the same for everyone, so finding something standard may be out of the question.