mysql,php issues on new install

[dave9000]

Figured I would post this so it may help someone having this problem.

There is a bug in the liblinker in mysql-devel 4.1.16 or higher. When trying to compile apache,php the compile will error out with liblinker: can not find /usr/lib/mysql/libz.la. The only known fix if you have this issue is to downgrade the mysql-devel-4.1.x to version 4.1.13. We had this issue this morning on a fresh install and upon researching using google its a known bug affecting RHEL3,4 and CentOS 3,4. The bug also is found in mysql 5.0.16. I repeat the only known fix available at this time is to downgrade the mysql-devel rpm to 4.1.13 or install from the src rpm and recompile apache and php.

[dave9000]

Here is a little more information

If you upgrade to mysql 4.1.18 which is in the EDGE version of cpanel apache and php will not compile.

I had upgraded to EDGE before I did my apache phpsuexec recompile and had to back down mysql-devel to 4.1.13 to get a clean compile.

If you do your apache compiile before upgrading to 4.1.18 then you can upgrade to 4.1.18 and everything will work

[chirpy]

Not nice.

I had a similar issue and had to rename /var/lib/mysql/ out of the way, compile apache, then put that directory back and it worked OK.

[BianchiDude]

How do you down grade?

[dave9000]

http://downloads.mysql.com/archives/...ibc23.i386.rpm

grab this rpm from the mysql website and upload to your server

then do rpm -Uvh --force /<path to >/MySQL-devel-4.1.13-0.glibc23.i386.rpm

service mysql restart

then /scripts/easyapache

this will fix the libz.la error

[BianchiDude]

Thanks dude!

[dave9000]

your welcome

[cguimont]

Thanks for that hint. It worked

[binary1]

Ah!

Finaly I can get back to sleep. many, many, many, many, thanx. phew!

Word.

[rpmws]

we had a similiar issue going to 5.1.2 and and mysql 5.18. Basically httpd wouldn't start. It was complaining about mysql libs. I ran buildapache again and same issue. Nick helped me with this and we wound up installing mysql 5.21 from a generic RPM and apache would then start. The initial error I was getting when restarting httpd was:

Cannot load /usr/local/apache/libexec/libphp5.so into server:
/usr/local/apache/libexec/libphp5.so: symbol zlibVersion, version
libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time
reference

Mostly this was due to buildapache failing to continue to compile past the apache part and it would die before php started to compile.

At some point soon if not already new sPanel builds will be out for mysql's > 5.18 >not sure if this error is related in the 4.X tree. What I think is buildapache was changed slightly on May12th and my prior builds would run. After using the May12th version it would have the above problem. Something in buildapache makes the problem in mysql show itself. We found the bugs listed at mysql.com that referenced my issue and it was fixed in the later versions.

[neojones]

Hey Dave,

Thanks for the tip. Was really helpful. Cheers

[JamieW]

http://downloads.mysql.com/archives/...ibc23.i386.rpm

grab this rpm from the mysql website and upload to your server

then do rpm -Uvh --force /<path to >/MySQL-devel-4.1.13-0.glibc23.i386.rpm

service mysql restart

then /scripts/easyapache

this will fix the libz.la error

Thank you! That's exactly what I needed to fix that problem!

[jackie46]

Figured I would post this so it may help someone having this problem.

There is a bug in the liblinker in mysql-devel 4.1.16 or higher. When trying to compile apache,php the compile will error out with liblinker: can not find /usr/lib/mysql/libz.la. The only known fix if you have this issue is to downgrade the mysql-devel-4.1.x to version 4.1.13. We had this issue this morning on a fresh install and upon researching using google its a known bug affecting RHEL3,4 and CentOS 3,4. The bug also is found in mysql 5.0.16. I repeat the only known fix available at this time is to downgrade the mysql-devel rpm to 4.1.13 or install from the src rpm and recompile apache and php.

Hmm, im running 4.1.18 on RHEL3 with Php; v4.2.2 with no issues whatsoever.

[MeGaMASTER]

This appear to be a bug with MySQL 4.1.18. Installing the latest MySQL-devel build (4.1.19) fix the problem. cPanel should update their MySQL version more often.