Re: [cobalt-security] MySql version for cobalt raQ4r

[Michael Stauber <cobalt@xxxxxxxxxxxxxx>]

Hi Jerry,

> What version of MySql works on the raQ4r?

The most recent version of MySQL is 3.23.40 if I'm not mistaken and you can 
grab the RPMs for RedHat and install them on a RaQ3 or RaQ4 without problem. 
I used them fourty times in the last six weeks on RaQ3's and 4's.

However, on the RaQ4 you will want to recompile PHP4 so that PHP can 
interface with MySQL through it's embedded MySQL function calls. This is also 
a good chance to upgrade your PHP to version 4.0.6, as the RaQ4 has an older 
version of PHP installed. So grab the sources at www.php.net, read the 
installation docs and go for it.

> Can I configure MySql on a separate virtual domain by it's self?

MySQL is a demon and it will work globally for all sites. MySQL on your 
server can even be remotely acessed from other machines to store or read 
data. 

With a tool like PHPmyAdmin or the MySQL module included in Webalizer you can 
then comfortably create MySQL user accounts for your webhosting customers and 
restrict access to the individual databases. Of course this can also be done 
by the MySQL shell tools which are included in the basic install (see "man 
mysqladmin" or the MySQL documentation).

For Perl to work with MySQL you need to install the DBI drivers which you can 
fetch from CPAN.org and also as RPM from RedHat or rpmfind.net. When in doubt 
and promted with the choice to choose between RPMs for RH 7.0 or 6.2 go for 
the RPMs compiled for RH 6.2 which will most likely have less broken 
dependencies.

Warning: If you try to install RPMs and are noted that several required 
items are missing, then don't blindly install packages if you don't know for 
sure what they are for. I just had the case that some genius upgraded his 
glibc [waving with OS restore CD]. ;o)

-- 

With best regards,

Michael Stauber
SOLARSPEED.NET