Prefered Perl & MySQL versions
 

Greetings,

I am laying the groundwork down for a new server. I made a handful of non-public servers on Windows machines about 2-3 years ago, but now I am ready to try my hand at a Linux server. This server will be built upon the Linux From Scratch distribution.

I can choose to use the 'stable' LFS / BLFS 6.3 release that contains:

• Perl 5.8.8
• MySQL 5.0.41

Or, I can use the 'development' LFS / BLFS 6.7 release that contains:

• Perl 5.12.1
• MySQL 5.1.52

My question to the community is: Which versions of Perl & MySQL would be the preferred versions to use? Are there any incompatibilities with a particular version?


Thanks in advance for your replies,
-Codemephit

The older versions are probably your best bet. Though, I am not sure if you will run into other issues given I haven't seen anyone using that flavor of Linux for an EQEmu server yet and there aren't any guides specifically for it.

I think perl 5.12 should be ok, but the 5.1 MySQL would cause a problem because I think of the "Range" reserved word issue.

LOL, maybe someone should convert the tables & code so this could be upgrated?

I fixed that issue with the 'range' field in the item table back in July 2009. It should work fine with MySQL 5.1, unless a subsequent change broke it again.

5.1 works just fine. I am on 5.1.41

Thanks for all the input.

I have decided to build the stable 6.3 version of LFS BLFS.

I chose Linux from Scratch as the distro for my server because it has no extra application overhead. You get only what you want (as far as packages go) and it seems to meet all the EQEmu requirements for downloading (SVN), building (GCC), and running (MySQL, Perl).

No bluetooth daemon, no KDE desktop, no CUPS spooler... simply a tight, efficient, stable, professional grade platform for hosting an EQ server. And as an added bonus you can manage it remotely!

Sorry... I think I lost sight of my direction and almost began a sales pitch for LFS ;)



@trevius: I am making careful notes of my entire process. If it turns out as good as I am hoping it will, I plan to write up a complete guide for the community. It is a fair amount of work to get LFS installed, but it is a phenomenal learning experience and imho a perfect choice for hosting an EQEmu server.

-Codemephit

(P.S. If I fail miserably, you guys are not allowed to laugh!)

I have always been impressed by debian since seeing a barebones install using only 20mb of ram at work.