Arg! MySQL Support For PHP...

Arg! MySQL Support For PHP...

Post by Weston Can » Fri, 29 Sep 2000 04:00:00



OK. I've just about had it with PHP and MySQL.

I was very pleased to find PHP 3 practically all installed after the basic
setup for LinuxPPC. A little bit of tweaking of the Apache conf files, and
basic PHP scripts were running.

MySQL doesn't come with the distro, though, so I downloaded the rpm and
installed it*. And... hmmm, no rpm for PHP with MySQL support
(postgres, though -- gotta check that out), but hey, I'm not afraid of
making it from the source. So I grab the source and proceed to:

./configure --with-mysql --with-pgsql

and it runs through the litany of stuff it checks and then:

        checking for MySQL support... no
        configure: error: Invalid MySQL directory
                          - unable to find libmysqlclient.a or
libmysqlclient.so

So I need to find these two files, and give configure a path for them.
 After some unsuccesful looking around, I finally result to

       find / -name "*mysql*" -print

and nothing comes up. These files are nowhere to be found on the filesystem.

So maybe I need to download the source for mysql? Alright, I go and grap
an RPM of the source (why not a tarball? I don't know. I'm still under the
illusion there might be some sort of advantage to rpms at this point). I
have it on my system now, all 4.2MB. But when I try to install this
package, I get:

        D:    file: mysql-3.22.32.spec action: unknown
        D:    file: mysql-3.22.32.tar.gz action: unknown
        D:    file: mysql.gif action: unknown

In short, it doesn't know what to do with these things.

Help?

(I'm downloading the tarballed source tonight, but as you can see,
I'm in need of sage advice).

(And please tell me that I don't have to make apache too).

cheer and warm fuzzies,
                        Weston

* (this, by the way, was my first introduction to the fact
that rpm installs everything in /usr/bin. Why is this? I'd really like
to see things like MySQL go in the traditional /usr/local/bin, or
better yet, just be able to tell rpm where to put it).

 
 
 

Arg! MySQL Support For PHP...

Post by erne » Sat, 07 Oct 2000 04:00:00


Weston Cann a crit :

Quote:> OK. I've just about had it with PHP and MySQL.
> In short, it doesn't know what to do with these things.

> Help?

Well, start downloading the tarball sources of PHP MySQL and Apache.
To install MySQL:

cd /usr/src
tar xvf your-MySQL-tarball
cd mysql...
./configure
make
make install
cp /usr/src/mysql.../support-filesmysql.server /etc/rc.d/init.d/mysql

place the K90mysql and S90mysql in the good directories

/usr/src/mysql.../scripts/mysql_instqll_db

To install Apache/Php
cd /usr/src
tar xvf your-apache-tarball
tar xvf your-php-tarball
cd apache...
./configure
cd ..
cd php3...
./configure --with-mysql --with-apache=../apache... -enable-track-vars
make
make install
cp /usr/src/php3.../php3.ini.dist /usr/local/lib/php3.ini
cd ..
cd apache...
./configure --activate-module=src/modules/php3/libphp3.a
make
make install
cp /usr/local/apache.../bin/apachectl /etc/rc.d/init.d/httpd
ln -s /usr/local/apache.../bin/httpd /usr/bin/httpd

place all the K90httpd and S90httpd in the good directories

to start
/etc/rc.d/init.d/mysql start
/etc/rc.d/init.d/httpd start

to stop
/etc/rc.d/init.d/mysql start
/etc/rc.d/init.d/httpd start

I hope this can help you.
I you need any further information:

Bruno

 
 
 

Arg! MySQL Support For PHP...

Post by Thomas Bj?rn Anders » Tue, 10 Oct 2000 07:52:07



> Weston Cann a crit :

> > OK. I've just about had it with PHP and MySQL.

> > In short, it doesn't know what to do with these things.

> > Help?

> Well, start downloading the tarball sources of PHP MySQL and Apache.
> To install MySQL:

Or grab some rpms from
ftp://ftp.linuxppc.org/contrib/software/System_Enviroment/Daemons/php... etc.

Thomas
--

                                                                  +++ATH

 
 
 

1. PHP + MySQL - apparently installed OK - but no MySQL support!

Hi all...

I'm trying to install PHP as an Apache module, with MySQL
support.  MySQL is an RPM, and PHP is the latest tarball.
The configure, make & make install all work fine - ie,
report no errors - and PHP module install fine into Apache
- ie, php3info() works in a trial page.

However, when I tried to call MySQL, it produced a fatal
error:  mysql_connect unsupported or undefined.  Does this
mean MySQL didn't compile into PHP, or something else?

I'm running RedHat 6.  Are there known issues, or is it
just my stupidity?  I'd be very grateful if someone reading
this could give me the benefit of their knowledge - please

frustrating!

Regards,

Daniel.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

2. MP in linux-ppc ??

3. PHP/MySQL "mysql.sock" not found ???

4. freeware.bull.net down?

5. weird php error when using php-mysql-4.2.3 from ports

6. env variables being set to strange values on login

7. PHP+MySQL vs. PHP+PostgreSQL

8. printing in linux

9. Setting up Apache with PHP and MySQL support

10. PHP with MySQL support under Linux

11. RedHat 6.1/PHP with MySQL support / mod_perl

12. problems installing php with mysql support

13. PHP with Mysql support