Re: [cobalt-users] RaQ4 / MySQL - Consideration of article.

["Nico Meijer" <cobalt-users@xxxxxxxxxxxxxxx>]

Hi Roger,

> Due to problems lately with the list I sending this query again.

Due to probably the same problems, you might or might not receive this
message. If it reaches you, it'll be after a day or 3. FYI, I'm typing this
on March 28.

> I have plans to get MySQL installed on my Raq4 server.
> May some of the raq proffesionals do a little evaluation of this article
> http://www.webmasterbase.com/article.php/228/19  ??

I am not a RaQ pro, but have been using RedHat Linux (5.2+), PHP (3.0.x+)
and MySQL (3.22.??+) for some time now.

> Are this a good article for installation on raq4 or should i stay with
> cobalts .rpm files ?

I haven't installed MySQL other than from a rpm, but a) I couldn't find a
timestamp on the article b) I don't see anything in the tutorial that
distincts it from a rpm install, other than that it'll cost you a load of
time compiling (so I'm told).

Read the MySQL documentation on installing at
http://www.mysql.com/doc/I/n/Installing_source.html (use the source) and
http://www.mysql.com/doc/L/i/Linux-RPM.html (use the force).

Installing MySQL thru rpm is one of the best business decisions I have made.
I'm able to upgrade MySQL anytime in a matter of seconds. BTW - don't use
RedHat's mysql rpms. It's a different ball game altogether.

I haven't found the time to install MySQL's MySQL rpms on my RaQ just yet,
but I don't foresee any problems with it. rpm is rpm, Linux is Linux, to put
it bluntly. Last time I checked Cobalt's ftp site, the rpm wasn't up to the
latest version. There are known bugs in previous versions (esp. 3.22.x) and
personally, I'd like to stay on top with the latest stable release
(currently 3.23.36; damn, need to upgrade *again* ;-P).

If anybody knows of any installation problems on RaQ equipment (I have a 3)
regarding the original rpms from MySQL, I'm very interested!

BTW - MySQL is a program that can not and will not interfere with any other
program/installation, unless you could somehow explicitly tell it to do so.
The rpm install installs all databases in /var/lib/mysql, which is not
practical under RaQ. You should therefore make symlinks (man ln) to the
actual datadirs, or symlink the entire /var/lib/mysql dir to maybe
/home/mysql.

Search the archives for something like "mysql quota" to see some interesting
stuff on that matter.

> Im planning to skip the PHP chapter !

Suggestion: create a php file that says something like

<?
echo phpinfo();
?>

and look for Configure Command. See if '--with-mysql' is listed. If not:
bummer, you'll be unable to use PHP with MySQL, which is, imho, a *killer*
combo! Don't deprive yourself of that.

I have never installed PHP thru rpm. PHP is most certainly best installed
from source as you need to be very careful with the install options.

> All feedback welcome.

This article has been evaluated on this list before (or was that you
aswell?). Other than stating "Go RTFM!" (which you should just as much as I
should), I hope to have made some (personal) additions to the factual data
that'll help you reach your goal.

Geez, do I sound scared of being flamed? ;-)

Good luck... Nico