Php5 / Mysql 4.1.9 Howto

system · March 14, 2006, 9:09pm

You’re on the right track int, but you need to do is to all of them at once

rpm -Uvh --force rpm1 rpm2 rpm3 etc

one very LONG command

int · March 14, 2006, 9:28pm

[root@server devel]# rpm -Uvh --force /usr/src/redhat/RPMS/i386/mysql-server-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-client-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-bench-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-devel-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-shared-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-max-4.1.12-100.rht90.iworx.i386.rpm
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.11-100.rht90.iworx

No go =(

system · March 14, 2006, 10:35pm

Take a look at this I found in Google

http://www.faqts.com/knowledge_base/view.phtml/aid/29818

IWorx-Socheat · March 15, 2006, 3:51am

Hi Int,

Also, the mysql-shared-compat package provides this library:

yum install mysql-shared-compat

Should do the trick.

Socheat

int · March 15, 2006, 4:41am

Thanks for the replies guys.

Here’s what happened:

[root@server devel]# yum install mysql-shared-compat
Gathering header information file(s) from server(s)
Server: Red Hat Linux 9 - Base
Server: Red Hat Linux 9 - Fedora Legacy - Updates
Server: InterWorx-CP - Generic
Server: InterWorx-CP - Red Linux 9
Server: Red Hat Linux 9 - Updates
Finding updated packages
Downloading needed headers
Resolving dependencies
Dependencies resolved
I will do the following:
[install: mysql-shared-compat 4.0.21-100.iworx.i386]
Is this ok [y/N]: y
Downloading Packages
Getting mysql-shared-compat-4.0.21-100.iworx.i386.rpm
mysql-shared-compat-4.0.2 100% |=========================| 481 kB 00:01
Running test transaction:
Test transaction complete, Success!
mysql-shared-compat 100 % done 1/1
Installed: mysql-shared-compat 4.0.21-100.iworx.i386
Transaction(s) Complete
[root@server devel]# rpm -Uvh --force /usr/src/redhat/RPMS/i386/mysql-server-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-client-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-bench-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-devel-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-shared-4.1.12-100.rht90.iworx.i386.rpm /usr/src/redhat/RPMS/i386/mysql-max-4.1.12-100.rht90.iworx.i386.rpm
Preparing… ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
mysqld: no process killed
1:mysql-server ########################################### [ 17%]
Restarting mysqld.
Stopping MySQL: [FAILED]
Starting MySQL: [ OK ]
2:mysql-client ########################################### [ 33%]
3:mysql-bench ########################################### [ 50%]
4:mysql-devel ########################################### [ 67%]
5:mysql-shared ########################################### [ 83%]
6:mysql-max ########################################### [100%]
Restarting mysqld.

It turns out it did not automatically restart mysql, I had to start the process from within InterWorx. Having done that, using the phpinfo.php page, it still shows MySQL as being version 3.23.58 (Client API version)

system · March 15, 2006, 10:47am

run rpm -qa | grep mysql

and paste the output.

int · March 15, 2006, 10:53am

[root@server devel]# rpm -qa | grep mysql
php-mysql-4.3.11-100.rht90.iworx
mysql-bench-4.1.12-100.rht90.iworx
mysql-shared-compat-4.0.21-100.iworx
mysql-iworx-4.0.21-3.rht90.iworx
mysql-client-4.1.12-100.rht90.iworx
mysql-devel-4.1.12-100.rht90.iworx
mysql-max-4.1.12-100.rht90.iworx
mysql-server-4.1.12-100.rht90.iworx
mysql-shared-4.1.12-100.rht90.iworx

That worries me since PHP was just updated from 4.3.11 to 5.1.2 on my server the other day. It’s working perfectly and so I was trying really hard not to mess with that

int · March 16, 2006, 10:55am

Any ideas guys? I would REALLY appreciate any help on this. This is the only thing stopping me from purchasing the Support engine I want so desperately.

IWorx-Chris · March 16, 2006, 11:00am

int, if you didn’t change PHP on your system it’s still linked against the old MySQL libs. The only way to get PHP to “see” the new MySQL is to link against it (or use an RPM that was previously linked against it).

So I’d recompile PHP at this point and it should link against the new MySQL libs you installed.

Chris

int · March 16, 2006, 12:02pm

Alright, got it. Thanks Chris

Fr3d · April 19, 2006, 3:19pm

I’m getting this when trying to compile PHP5:

Error: Missing Dependency: php = 4.3.11-100.rhe4x.iworx is needed by package php-mhash
Error: Missing Dependency: php = 4.3.11-100.rhe4x.iworx is needed by package php-mcrypt
Error: Missing Dependency: libmhash.so.2 is needed by package php-mhash

Installed PHP RPMs:

[root@yoda ~]# rpm -qa | grep php
php-mysql-4.3.11-100.rhe4x.iworx
php-4.3.11-100.rhe4x.iworx
php-pear-4.3.11-100.rhe4x.iworx
php-iworx-4.3.9-6.rhe4x.iworx
php-snmp-4.3.11-100.rhe4x.iworx

Any ideas?

system · June 27, 2006, 8:02pm

this how to not work chris, you should update or delete.

Bets regards.

Justec · June 28, 2006, 8:59am

Maybe you could give Chris some more info as to why its not working for you.

system · June 28, 2006, 11:20am

on centos 4.3 , the original post of chris not work.

I added that to /etc/yum.conf

Then run
yum upgrade

And that return error:

yum upgrade
Setting up Upgrade Process
Setting up repositories
Cannot open/read repomd.xml file for repository: interworx-php5-mysql4.1
failure: repodata/repomd.xml from interworx-php5-mysql4.1: [Errno 256] No more mirrors to try.
Error: failure: repodata/repomd.xml from interworx-php5-mysql4.1: [Errno 256] No more mirrors to try.

Fr3d · June 28, 2006, 6:03pm

You can’t download the .rpms for PHP5 and MySQL 4.1 anymore - at least not from IWorx. You need to download the .srpms (source rpms), compile them and then you can install them

I think the instructions for that are on one of the pages of this thread too

newmind · July 3, 2006, 5:04pm

Re: PHP5 Upgrade || Getting -devel RPMs…

Hey all.

Newbie here with an easy question.

Where do I get the -devel RPMs that Chris mentions one will likely need when upgrading to PHP5?

I’ve got a CentOS 4.3 box and I get the following error when attempting to “rpmbuild --rebuild --with rhe4x http://updates.interworx.info/iworx/SRPMS/experimental/php-5.0.4-100.iworx.src.rpm”

Installing http://updates.interworx.info/iworx/SRPMS/experimental/php-5.0.4-100.iworx.src.rpm
error: Failed build dependencies:
libgcrypt-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
bzip2-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libc-client-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
db4-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
expat-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
freetype-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
gdbm-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
gmp-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
aspell-devel >= 0.50.0 is needed by php-5.0.4-100.rhe4x.iworx.i386
libjpeg-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libpng-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
pam-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libstdc+±devel is needed by php-5.0.4-100.rhe4x.iworx.i386
ncurses-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
pcre-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libmcrypt-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
postgresql-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
unixODBC is needed by php-5.0.4-100.rhe4x.iworx.i386
unixODBC-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libxslt-devel >= 1.0.18-1 is needed by php-5.0.4-100.rhe4x.iworx.i386
libxml2-devel >= 2.4.14-1 is needed by php-5.0.4-100.rhe4x.iworx.i386
cyrus-sasl-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
openldap-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
readline-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
libmhash-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
net-snmp-devel is needed by php-5.0.4-100.rhe4x.iworx.i386
elfutils-devel is needed by php-5.0.4-100.rhe4x.iworx.i386

Thanks for feedback…

IWorx-Paul · July 3, 2006, 9:04pm

Hi newmind,

Usually it’s as easy as
yum install <dependency name here>

example:

yum install libgcrypt-devel bzip2-devel etc

you can do one at a time or many at once.

Paul

newmind · July 4, 2006, 7:44am

Thanks, Paul.

I’ll give it a shot this evening…

–Noah

newmind · July 4, 2006, 5:26pm

I notice that there are 2 SRPMs for PHP5: 5.0.4 & 5.1.2.

Will Iworx Chris’s “rpmbuild --rebuild --with rhe4x http://updates.interworx.info/iworx/SRPMS/experimental/php-5.0.4-100.iworx.src.rpm”

work for 5.1.2, or should I just use 5.0.4?

Thanks,

–Noah

system · July 31, 2006, 4:50am

Hi guys!

I want to upgrade php to the 5th version on CentOS 3.7 (final).

I can ask my admin to do it, but need to be sure that he will not break
the Iworx box accidentally.

Can you point me to some tutorial? I read few forum posts, but
found nothing about CentOS 3.7