topic Re: PHP and MySQL in Operating System - Linux

PHP and MySQL

Vernon Brown_4 — Fri, 25 Feb 2005 12:30:28 GMT

I'm trying to setup a phpbb forum. Just getting started, I find that I have to have PHP and MySQL running. I have a Fedora Core 1 distro, running Apache II web server.

How can I determine if I have PHP and/or MySQL installed ?

Thanks for any help !

Vern

Re: PHP and MySQL

Dave Falloon — Fri, 25 Feb 2005 14:30:22 GMT

rpm -qa |egrep -I "mysql|php"

That would tell you if the rpm's are installed.

--Dave

Re: PHP and MySQL

Vernon Brown_4 — Fri, 25 Feb 2005 14:56:36 GMT

This is what I get

Seems that it found php but not mysql ?

Half way there :)

[veb@veb veb]$ rpm -qa |egrep -I "mysql|php"
php-4.3.8-1.1
php-ldap-4.3.8-1.1
php-mbstring-4.3.8-1.1
php-imap-4.3.8-1.1
[veb@veb veb]$

BTW I was able to write an embeded PHP script and it worked. It was echo: Hello World the output was Hello World.

Thanks; now how to enable MySQL ?

Re: PHP and MySQL

Dave Falloon — Fri, 25 Feb 2005 17:20:33 GMT

you need the rpm.

Its probably on the fedora cd, pop the cd in the drive,

make sure its mounted,

Then search for a mysql rpm:

find /mnt/cdrom -name \*.rpm |grep -i mysql

When you find the rpm you need install it on the system:

rpm -Uvh

You may have to resolve some dependancies but they should be on the disks somewhere as well.

--Dave

Re: PHP and MySQL

Vernon Brown_4 — Sat, 26 Feb 2005 07:27:54 GMT

Oops; meant to give more points.

I didn't find MySQL on the Fedora Core 1 CD, and didn't find it on the loaded system. I did find it on another partition that boots up SuSE 9.

Thanks for your help; I think I can get there from here :)

Re: PHP and MySQL

NiCK_76 — Sat, 26 Feb 2005 09:58:33 GMT

Hi Brown,

Put a php test file in the web root directory.
For example,edit file info.php that contain following content.

Visit URL http://YOUR_IP/info.php via web bowser.It works ,If you can saw php info page and mysql enable.

NiCK

Re: PHP and MySQL

Vernon Brown_4 — Sun, 27 Feb 2005 09:56:34 GMT

Thanks; neat !

PHP is running and working Ok. I downloaded the current MySQL .gz package and untar'd it at /var/www/mysql to test it. Self test passed all tests.

I'm not yet successful with the phpbb install however. It complains that the database is not supported, however MySQL 4.1.x (which I have) is selected in the phpbb install options.

Re: PHP and MySQL

KristofH — Thu, 10 Mar 2005 15:40:52 GMT

I suggest installing APT, it will surely make things easier. Have a look at the following site:

http://apt.freshrpms.net/

Re: PHP and MySQL

Vernon Brown_4 — Thu, 10 Mar 2005 15:54:40 GMT

My problem was that PHP was not compiled with SQL functionality. I downloaded and compiled PHP form source and that fixed it.

Thank for the link. I downloaded the software and willhave a go at it.