Re: [cobalt-developers] PHP4 + MySQL on Cobalt Raq3 HOWTO -- NEED guinea pigs!

["Richard Nellist" <richard@xxxxxxxxxxxxxxx>]

I read through the quick HOWTO and have the following comments. I've chopped
the whole message to keep this one brief.

>Now you'll need to start retriving the nescessary files.  We'll use wget,
>a utility to retrieve files from the World Wide Web without using a
>full-fledged browser.  Here are the commands (this is the most time
>consuming step):
>
>wget http://www.mysql.com/Downloads/MySQL-3.23/MySQL-3.23.23-1.i386.rpm
>wget
>http://www.mysql.com/Downloads/MySQL-3.23/MySQL-bench-3.23.23-1.i386.rpm
>wget
>http://www.mysql.com/Downloads/MySQL-3.23/MySQL-client-3.23.23-1.i386.rpm
>wget
>http://www.mysql.com/Downloads/MySQL-3.23/MySQL-devel-3.23.23-1.i386.rpm
>wget
>http://www.mysql.com/Downloads/MySQL-3.23/MySQL-shared-3.23.23-1.i386.rpm
>wget
>http://fsr.ku.dk/people/troels/rpms/php/install-ready/i586/php-4.0.2-2.i586
.rpm
>wget
>http://fsr.ku.dk/people/troels/rpms/php/install-ready/i586/php-mysql-4.0.2-
2.i586.rpm
>

wget is actually much more powerful. It can be used for grabbing whole ftp
or http sites, and supports resume. I'm not actually at my Linux box but
using something along the lines of the following can replace all the
individual commands for retrieving the MySql rpms.

wget -c -np ftp://ftp.mysql.com/MySQL-3.23/MySQL*-3.23.23-1.i386.rpm should
pull all the required MySQL files.

	The -c tells it to resume, so if the transfer is interrupted it doesn't
pull all the files from scratch but resumes from where it stopped, even if
it was mid-file (very useful for long downloads).

	The -np tells wget not to travel up the directory structure.

You could also add -b which will switch wget into the background after it
starts, will all the screen output redirected to a log file.

Typing wget --help will give the options, it may be necessary to use the
allow file types option eg --allow=.i386.rpm and specify the wildcard (*) as
the filename. Although if there is more than one set of .i386.rpm it will
pull them all.

I will confirm the actual switches for wget and post them.

Use wget with care otherwise you could end up trying to mirror a whole site
and all it's links.

>Finally you're ready to install.  First you'll need to become root:
>
>su
>

'su' actually stands for Switch User and if invoked with a valid username
after it will prompt you for a password if that user has higher priviledges
than the one you are logged in as. ie 'su auser' will make the system Switch
User to the 'auser' account and you will have all their restrictions.
Similarly 'su' or 'su root' will switch you to the 'root' user account.


>then enter your password when it prompts you to.  Now invoke the installer
>program, rpm:
>
>rpm -Uvh MySQL-*
>rpm -Uvh php-*
>
>Alright! All the nescessary files are in place!  To activate PHP,
>you'll need to restart the web server:
>
>/etc/rc.d/init.d/httpd restart
>
>You're done!  To test PHP, create a file in one your web directories named
>something.php with the following:
>
><?php phpinfo(); ?>
>
>Fire up your web browser the appropriate URL, and you should see the PHP4
>logo.  Congrats!
>
>--Ricky Dhatt, Sept 00.
>
>Websites:
>MySQL: http://www.mysql.com/
>PHP: http://www.php.net/
>PHP4 RPM site: http://fsr.ku.dk/people/troels/rpms/php/
>
>For the curious:
>su stands for SuperUser, which basically means you become the root user.
>
>wget is a utility to retrieve files from the World Wide Web without using
>a full-fledged browser.
>
>rpm stands for Redhat Package Manager, which neatly installs pre-compiled
>programs on your server.
>
>

Hope this helps,

Regards

Richard Nellist.
NellyBase Associates.