Re: [cobalt-users] MySQL/PHP3 Help

["David Thacker" <David@xxxxxxxxxxxxxx>]

G'day Jay,

Here's what I did the other night to get PHP3 and MySQL going on my RaQ3.  I
don't have Chilisoft ASP so I don't know what else you will need to do to make
them happy together.

It was pretty darn easy actually (even for a guy that never touched Linux or
Unix before a month ago when I got my RaQ3).

Here's what I did:

1. I telnetted to my RaQ and created a "download" directory (owned by Admin
rather than root so I can R/W via FTP).  I changed to that dir, then FTP'd
*all* the files from ftp.cobaltnet.com/pub/experimental/raq3/

2. I made backup copies of my /etc/httpd/conf/http.conf and srm.conf files
just to be safe.

3. I read that MySQL should be installed first, so that's what I did.

  rpm -ivh MySQL-3.22.32-1.i386.rpm

No errors reported, so I installed the next MySQL file (MySQL-bench...).  Got
an error message about needing MySQL-client and some Perl/DBI thing.  Decided
I wasn't going to bother with Perl using MySQL, so went on and installed
MySQL-client then MySQL-devel and finally MySQL-shared... No error messages
with any of them.

4. I read that PHP needed the freetype and gd libraries, so I rpm'd the
freetype... and gd... files.  No error messages.

5. Next I rpm'd php-3.0.16-2c2.i386.rpm which installed with no errors.  I
guessed that the other php-3.0... file was source code which i didn't need, so
I ignored it.

6. I rpm'd the php-mysql-3.0.16... file okay.  I did NOT rpm the
php-mysql-4... file because I thought it was for a different version of PHP.
I rpm'd the php-manual... and php-pgsql... files without any errors.  I didn't
bother with the ldap or imap files because I wasn't interested in them.  I
also ignored the other files I had FTP'd (mod-php...) since they appeared to
my untrained eye to be for a different version.

I then took a peek at the httpd.conf file and saw that the Addmodule line had
been added for php, so then I restarted apache and uploaded a sample php3 file
to try.  Everything worked, and phpinfo listed pgsql and mysql support.

The rest of my night was spent poking through the MySQL docs trying to figure
out how to set a root password, create a test database, etc.  Once I figured
that out, I was able to successfully run a test MySQL query via a php script,
and everything worked flawlessly.

I think Cobalt needs to write an updated PHP+MySQL RaQ3 KB article, but even
without one I was able to muddle my way through on the first try.

Good luck!

PHP looks great from my quick look so far.  I can see why people are excited
about it.

BTW, greetings from Alberta.  If you ever get the chance to send me some
comments about your experiences pro & con with Chilisoft ASP I'd be
interested.

dAvid tHacker                                  Tel:  (403)782-5432
Thacker Network Technologies Inc.              Fax:  (403)782-1794
5338 - 51 Ave.                         Email: David@xxxxxxxxxxxxxx
Lacombe, AB  T4L 1N5                     Http://www.ThackerNet.com


----- Original Message -----
From: "BlackSun" <admin@xxxxxxxxxxx>
To: "Cobalt Users List" <cobalt-users@xxxxxxxxxxxxxxx>
Sent: May 5, 2000 1:20 PM
Subject: [cobalt-users] MySQL/PHP3 Help


> Can anyone out there provide me with a clear, consise list of
> specific files and instructions on how to properly install MySQL
> and PHP3 on a RaQ3 and RaQ3i?
>
> I'm also running Chillisoft ASP, and I understand (from Cobalt)
> that I need an extra file or two to get the two to mesh.
> --
>
> Has anyone created a .pkg file for us "non-tech" guys?
>
> Thanks for any assistance.
> --
>
> Jay Tingley | info@xxxxxxxxxxx
>
>
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>
>