PHP4 <> MySQL 3.23.xx ain't friends.

[Anon]

It seems that I can compile php4.04 (no errors, no problems), I can also run phpinfo(); and assorted scripts that don't use a database. Though when I try to access a MySQL 3.23.28gamma (rpms from mysql.com) database I get: -

child pid 19329 exit signal Segmentation fault (11)

with compile string

./configure --enable-versioning --with-xml --with-gd --with-t1lib --with-ttf --with-apxs=/usr/sbin/apxs --with-mysql --enable-trans-sid --with-magic-quotes

if I compile with this string

./configure --enable-versioning --with-xml --with-gd --with-t1lib --with-ttf --with-apxs=/usr/sbin/apxs --with-mysql=/usr --enable-trans-sid --with-magic-quotes

I get a segfault and apache 1.3.14 dies.

Running:

Redhat 7.0
Apache 1.3.14
Mysql 3.23.28gamma (have tried with 3.23.24)
Midgard 1.4beta6 (have tried without this)

Any ideas or if you need more information as I am only new to this.

[Anon]

This is most likely because the MySQL RPMs are using pthreads (which isn't normally the default but seems to be with the RPMs only).

Try compiling MySQL from scratch, and then rebuilding PHP.

For reference:

http://marc.theaimsgroup.com/?l=php-general&m=95730973100384&w=2