Addition to PHP 5 / MySQL "play nice" article

ppowell

re: http://phpbuilder.com/board/showthread.php?t=10246585

Good article, but incomplete..

This will only work for MySQL 4.+ and PHP 5 in a Windows environment; there was no mention if you're in Linux/UNIX as to how it would be done

Furthermore, there is no current support or PHP 5 with MySQL 5 for Linux and AFAIK won't be any in existence until the release of Fedora Core 5 in March 2006.

Just wanted to add my $0.02 worth

Phil

thorpe

Furthermore, there is no current support or PHP 5 with MySQL 5 for Linux and AFAIK won't be any in existence until the release of Fedora Core 5 in March 2006.

time to switch distro then.

Sxooter

I'm running FC2 with MySQL 5.x and php 5 just fine.

Of course, I compiled php to get it working, but I had to do that anyway to get oracle support to work...

ppowell

How did you get PHP5 to talk to MySQL5 when there should be no module to allow for it to occur? Curious.

Phil

Sxooter

There's no pre-built modules. MySQL support is there, you just need the right libs.

Running MySQL 5.0.16, I downloaded:

MySQL-client-5.0.16-0.glibc23.i386.rpm
MySQL-server-5.0.16-0.glibc23.i386.rpm
MySQL-devel-5.0.16-0.glibc23.i386.rpm

Well crap. I had this working a while back, but just tried it on my own box, and I'm getting comile errors after configure runs.

dangit I'll try and figure it out and get back to ya.

Sxooter

OK, my current build was erroring out on zlib. Looks like it might be working this time, I had to add a --with-zlib-dir to make it happy. We'll see.

Sxooter

OK, it's the mysqli extension, and on my current fc 2 box it is not working.

But it was working, back when I was troubleshooting MySQL 5.0.4 or so when it first came out. So, something on my box has changed.

I fear I may have to download the mysql source to make it work, and at this point, It's just not worth the effort. ugh.

You'd think with PHP being one of the driving forces behind MySQL that they'd have this stuff working by now. PostgreSQL support is a snap in PHP, as simple as sqllite.

Note that there are folks on this page: mysqli who do have mysql 5 and php 5 working.

Sxooter

OK, the problem I'm running into is with zlib. I recently setup php to handle libgd for my gallery program, and it required zlib. MySQL seems to include its own zlib, and the two versions weren't getting along. I'm not breaking my gallery program to get mysql working right this minute, so it might be a while before I have it running, but I will have it running, dang it.

ppowell

re: http://us3.php.net/manual/en/ref.mysqli.php

Brad Marsh's solution was for FreeBSD; he doesn't have a tested version for FC 4 nor RHEL 4 I'm afraid. Can't verify if that works but it seems you're having the same problems we're having over here mainly with FC 4.

Phil

Sxooter

Yeah, and I'm note sure what I want to do about it just yet. Seems mysql insists on using it's own version of libz.

Geez, those guys just don't get it some times.

libz is a shared lib. You don't include it and insist on using your own everywhere. grrrrrr

Sxooter

OK, I went to see if there was an update to php 5.0, and it appears 5.1 is the replacement, so I'm gonna download that and play with it...

Sxooter

OK, Here's a PHP bug report:

http://bugs.php.net/bug.php?id=35400

seems the problem showed up with MySQL 5.0.16... dangit.

And here's the MySQL bug for it:

http://www.phpbuilder.com/board/showthread.php?p=10684875#post10684875

crap on a stick, the problem appears to have been introduced in v 5.0.16

ppowell

Ahh I suddenly feel somewhat vindicated 🙂

Phil

thorpe

i have php5.0.5 and mysql 5.0.15 running fine here on gentoo.

Sxooter

I downloaded the file /home/smarlowe/MySQL-devel-5.0.15-0.glibc23.i386.rpm (had to trick the mysql site into giving it to me, it's written to make like easier, which, through the law of unintended consequences, makes life harder) by copying the URL for th 5.0.17 file and changing the 17 to 15 when I pasted it.

I just built my machine, so now it has libgd, oracle, postgresql, and mysql libs in it. Here's my configure script to set it up, if anyone wants it.

./configure \
--with-oci8-instant-client \
--with-pgsql \
--with-apxs2=/usr/sbin/apxs \
--with-ttf \
--enable-gd-native-ttf \
--with-jpeg \
--with-freetype \
--with-xpm \
--enable-memory-limit \
--with-gd \
--with-jpeg-dir=/usr/lib/ \
--with-ldap \
--with-ldap-sasl \
--with-mysqli=/usr/bin/mysql_config \
--with-zlib