Wanted: Nice clean LAMP Server with MySQL 4.1

[timster]

Please forgive the ramblings of this Linux newbie. If you can't help him, he'll be forced to develop in FileMaker Pro.

I've been tasked with setting up a LAMP server (since I know PHP/MySQL I'm automatically the Linux expert around here, but hey I'm just a Mac head.)

The tricky part is the MySQL server must be 4.1.x. (Apache 2 and PHP 5 would be nice but aren't necessary.)

Is there a version of Linux where I can get that "out of the box"? Our credit card is ready.

The long, sad story:
Our Fedora Core 2 disks come with MySQL 3, and upgrading from there has proved difficult for me. I got things working installing from source, but then I don't know how to make it so you can administrate the box from the GUI. For instance if you clicked to restart the web server it restarts the wrong apache.I won't necessarily be administrating this box, so I've got to set things up so they make sense.

Any help or advice is appreciated.

[bcolflesh]

Some distros listed here:

[distrowatch.com...]

[encyclo]

Neither are Linux, but I believe both NetBSD and FreeBSD have packages for MySQL 4.1.x and probably Apache 2 and PHP 5 too. For Linux, try Debian Sid (unstable) - it's more stable than the name would suggest. ;)

[timster]

Thanks folks.

I thought about FreeBSD, since it's similar to the Unix "under the hood" of the Mac. Right now I'm going to work with the Fedora Core 3, since I've worked with Fedora a little.

Wish me luck, I'll let you know how it goes.

[tolachi]

Good lord no........ Not Fedora. Well maybe it's not that bad but I would go with Debian stable and use backports from here:

[dotdeb.org...]

Unstable isn't a bad idea either. Despite the name it is very stable.

[timster]

Ah shucks. Only the developers release of Fedora Core has the MySQL 4.1.

You have to click through that distrowatch site to find that out though. Or maybe download, burn, and install the "current" version, like we did. Oh well, lesson learned.

Looks like FreeBSD includes MySQL 4.1 in their current and stable releases.

Hmm, I am a Mac head after all -- any reason I shouldn't try this with Darwin?

[SeanW]

Only the developers release of Fedora Core has the MySQL 4.1.

Why not use those RPMs in your FC2 box?

At worst, download the .srpm and execute

rpmbuild --rebuild foo.src.rpm

Install the resulting RPMs

Sean

[timster]

At worst, download the .srpm and execute
rpmbuild --rebuild foo.src.rpm
Install the resulting RPMs

Yikes! Thanks, but that's just how all the Linux websites read. A little beyond me yet, I'm afraid.

Anyway, the happy ending: We kept the Fedora Core 3 and, with a few hints from local Linux guys, were able to uninstall MySQL 3 and install version 4.1.9.

We got hung up for a while when two RPM's depended on one another. (I'd learned to stay away from "--nodep" by then.) We couldn't find an example of removing 2 RPM's at once, but guessed it:

rpm -e firstrpm secondrpm

Then we reinstalled, and just kept downloading and installing whatever the error message told us it needed. That took a while but it worked.

Now all is well until I need to add a PDF library...

Thanks to everyone for your advice.