Upgrade Guide for PHP and MySQL

Customization Hacks / Tools / Tips / Tricks
21

Just installed a new vps and upgraded it to IW 3x (RC) mentioned in another thread today. I’m using centos 4. Trying to upgrade php to 5.2x and getting errors:

[root@none ~]# yum install libmhash-devel libmcrypt-devel
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
Parsing package install arguments
No Match for argument: libmhash-devel
Nothing to do

[root@none ~]# rpmbuild --rebuild --with cos4x http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm
Installing http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm
error: Failed build dependencies:
libmhash-devel is needed by php-5.2.0-100.iworx.i386

Can someone please explain why it shows installed, then not?

22

Yum doesn’t say it’s installed, it says there’s no match for “libmhash-devel” and that there’s nothing to do:

No Match for argument: libmhash-devel
Nothing to do

You can find libmhash RPMs on the DAG repository:
http://dag.wieers.com/rpm/packages/libmhash/

You’ll want both the libmhash and libmhash-devel package, and be sure to grab the RPMs that have “el4”, as that’s the correct oscode for CentOS 4.x.

Hope that helps.

23

Sorry, been a long long day

I upgraded mysql fine, but php is still giving me a hard time after I downloaded and installed both libmhash/devel (yes, el4)

[root@none ~]# yum -c http://mirror.steadfast.net/misc/iworx/rpmforge.repo.shtml?cos4x install libmhash-devel libmcrypt-devel
Setting up Install Process
Setting up repositories
update 100% |=========================| 951 B 00:00
http://apt.sw.be/(none)/en/i386/dag/repodata/repomd.xml: [Errno 14] HTTP Error 404: Not Found
Trying other mirror.
Cannot open/read repomd.xml file for repository: rpmforge
failure: repodata/repomd.xml from rpmforge: [Errno 256] No more mirrors to try.
Error: failure: repodata/repomd.xml from rpmforge: [Errno 256] No more mirrors to try.

[root@none ~]# yum install rpmbuild --rebuild --nobuild --with cos4x http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm 2>&1 | grep "needed" | awk '{ print \$1 }' | xargs
Error: Need to pass a list of pkgs to install

24

You’re doing it wrong — you’re supposed to download that file, and change the (none) to i386. :wink:

Just go to http://dag.wieers.com/packages/libmcrypt & http://dag.wieers.com/packages/libmhash and download the correct ones for your OS. That’s the easiest way, given all that…

25

These instructions were a great primer for learning how to build an RPM from source- does anyone have some advice for patching these rpms? As in- how do I patch this PHP 5.2 build to 5.2.2?

Somewhat of a newbie, I think I understand I need to download the patch from php.net, then place it in the proper location in the directory tree and edit the spec file, with the understand that there may be addtional dependencies that will cause the build to fail until I resolve them. Am I even close to getting this right? :slight_smile:

26

Yes you exactly have to do this.

In the spec file change the version
place in the good place the php.tar (replace the old one to 5.2.2 one)

Give a try

Sometimes everything is fine, sometimes you’ll have to patch some files !

So yes you are in the good direction
Pascal

27

[QUOTE=pascal;11987]And more OSCOMMERCE IS NOT COMPATIBLE WITH MYSQL5 due to JOIN changement !!!

So all the clients that use OsCommerce have to patch their softs ![/QUOTE]
So there is a fix for OScommerce on PHP5/MySQL5? I have built a custom website for a client using OScommerce (with lots of customizations) and I am planning to move to PHP5/MySQL5 when CentOS5 is supported.

28

Hello,
I am trying to install PHP 4.4.4 using these instructions and I get this error:

yum install rpmbuild --rebuild --nobuild --with rhe4x http://mirror.steadfast.net/misc/iworx/php-4.4.4-100.iworx.src.rpm 2>&1 | grep "needed" | awk '{ print \$1}' | xargs
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
Parsing package install arguments
Resolving Dependencies
–> Populating transaction set with selected packages. Please wait.
—> Downloading header for libc-client-devel to pack into transaction set.
libc-client-devel-2002e-1 100% |=========================| 14 kB 00:00
—> Package libc-client-devel.i386 0:2002e-14 set to be updated
—> Downloading header for postgresql-devel to pack into transaction set.
postgresql-devel-7.4.17-1 100% |=========================| 49 kB 00:00
—> Package postgresql-devel.i386 0:7.4.17-1.RHEL4.1 set to be updated
–> Running transaction check
–> Processing Conflict: libc-client-devel conflicts imap-devel
–> Processing Dependency: postgresql = 7.4.17-1.RHEL4.1 for package: postgresql-devel
–> Processing Dependency: postgresql-libs = 7.4.17-1.RHEL4.1 for package: postgresql-devel
–> Restarting Dependency Resolution with new changes.
–> Populating transaction set with selected packages. Please wait.
—> Downloading header for postgresql-libs to pack into transaction set.
postgresql-libs-7.4.17-1. 100% |=========================| 12 kB 00:00
—> Package postgresql-libs.i386 0:7.4.17-1.RHEL4.1 set to be updated
—> Downloading header for postgresql to pack into transaction set.
postgresql-7.4.17-1.RHEL4 100% |=========================| 104 kB 00:00
—> Package postgresql.i386 0:7.4.17-1.RHEL4.1 set to be updated
–> Running transaction check
–> Processing Conflict: libc-client-devel conflicts imap-devel
–> Finished Dependency Resolution
Error: libc-client-devel conflicts with imap-devel

Could someone please tell me why there are conflicting packages and how to fix this?

29

Hi

I’d do

rpm -e imap-devel
yum install libc-client-devel
yum install postgresql-devel-7.4.17-1

then install the PHP4.4.4

rpmbuild --rebuild --with oscode urlofphpsrcrpm

Pascal

30

rpmbuild --rebuild --with rhe4x http://mirror.steadfast.net/misc/iworx/php-4.4.4-100.iworx.src.rpm

Pascal

31

Problem…

[root@server ~]# yum install `rpmbuild --rebuild --nobuild --with rhe4x http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm 2>&1 | grep "needed" | awk '{ print $1 }' | xargs`
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for libgcrypt-devel to pack into transaction set.
libgcrypt-devel-1.2.0-3.i 100% |=========================| 3.8 kB    00:00     
---> Package libgcrypt-devel.i386 0:1.2.0-3 set to be updated
---> Downloading header for libc-client-devel to pack into transaction set.
libc-client-devel-2002e-1 100% |=========================|  14 kB    00:00     
---> Package libc-client-devel.i386 0:2002e-14 set to be updated
---> Downloading header for postgresql-devel to pack into transaction set.
postgresql-devel-7.4.17-1 100% |=========================|  49 kB    00:00     
---> Package postgresql-devel.i386 0:7.4.17-1.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Conflict: libc-client-devel conflicts imap-devel
--> Processing Dependency: postgresql = 7.4.17-1.RHEL4.1 for package: postgresql-devel
--> Processing Dependency: postgresql-libs = 7.4.17-1.RHEL4.1 for package: postgresql-devel
--> Processing Dependency: libgpg-error-devel for package: libgcrypt-devel
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for postgresql-libs to pack into transaction set.
postgresql-libs-7.4.17-1. 100% |=========================|  12 kB    00:00     
---> Package postgresql-libs.i386 0:7.4.17-1.RHEL4.1 set to be updated
---> Downloading header for libgpg-error-devel to pack into transaction set.
libgpg-error-devel-1.0-1. 100% |=========================| 2.6 kB    00:00     
---> Package libgpg-error-devel.i386 0:1.0-1 set to be updated
---> Downloading header for postgresql to pack into transaction set.
postgresql-7.4.17-1.RHEL4 100% |=========================| 104 kB    00:00     
---> Package postgresql.i386 0:7.4.17-1.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Conflict: libc-client-devel conflicts imap-devel
--> Finished Dependency Resolution
Error: libc-client-devel conflicts with imap-devel
32

quick help with the guide

I am using InterWorx-CP v2.1.3 [Unlimited Domain] on CentOs 4.5 and I tried following the instructions and ran in to problems with MySQL right away. When I run

rpm -Uhv --nodeps /usr/src/redhat/RPMS/uname -i/mysql*-4.1.12-100.*

I get:

[root@storm3 ~]# rpm -Uhv --nodeps /usr/src/redhat/RPMS/uname -i/mysql*-4.1.12-100.*
Preparing… ########################################### [100%]
package mysql-devel-4.1.20-2.RHEL4.1 (which is newer than mysql-devel-4.1.12-100.rhe4x.iworx) is already installed
package mysql-server-4.1.20-2.RHEL4.1 (which is newer than mysql-server-4.1.12-100.rhe4x.iworx) is already installed
file /usr/share/man/man1/mysql.1.gz from install of mysql-client-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-client-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-client-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/man/man1/mysqldump.1.gz from install of mysql-client-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-client-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/bin/mysql_config from install of mysql-devel-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /etc/my.cnf from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/info/mysql.info.gz from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/charsets/Index.xml from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/charsets/latin1.xml from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/charsets/latin5.xml from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/danish/errmsg.sys from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/danish/errmsg.txt from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/serbian/errmsg.sys from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
file /usr/share/mysql/serbian/errmsg.txt from install of mysql-server-4.1.12-100.rhe4x.iworx conflicts with file from package mysql-4.1.20-2.RHEL4.1
[root@storm3 ~]#

Should I just force the install? Any help would be greatly appreciated.

Thanks!

Craig

33

[quote=hubbadubba;12081]Socheat recommended these instructions as a possible solution to my problem with PHP 5 coexisting with Interworx in CentOS 4.4

Testing environment:[LIST=1]

  • Two machines with clean installs of CentOS 4.4
  • Joomla 1.5 and Modernbill 5
  • 1st machine without Interworx and using CentOSPlus repo version of PHP 5.1.6-3 and MySQL 5.0.27 works great,
  • 2nd virtual machine using Interworx and either CentOSPlus repo version of PHP 5.1.6-3 and MySQL 5.0.27, or following the instructions in the link above (both 5.1.6 and 5.2) all fail.
  • failure is defined as: I can't install Modernbill 5 or Joomla 1.5- trying to access Joomla install page gives this error:[LIST=1]
  • With the Steadfast instructions:[/LIST]With the CentOSPlus repo enabled and display errors turned on I get a stream of: Quote: Warning: preg_match: internal pcre_fullinfo() error -3 [/LIST][/quote] How did u fix this problem?

    i have the same problem on centos 4.5 php 5.1.6 interworx 2.X.
    I moved my invision forum and get same msg u were getting.

    thank u

    • 34

    I used the steadfast instructions to build PHP from source- there must be something missing in the CentOS Extras build.

    35

    i am stuck here
    3.Now it’s time to build the RPMs you will need, again replacing oscode and url as required: rpmbuild --rebuild --with oscode url

    

[root@##### /]# rpmbuild --rebuild --with rhe4x http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm
Installing http://mirror.steadfast.net/misc/iworx/php-5.2.0-100.iworx.src.rpm
Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.29095
+ umask 022
+ cd /usr/src/redhat/BUILD
+ cd /usr/src/redhat/BUILD
+ rm -rf php-5.2.0
+ /bin/gzip -dc /usr/src/redhat/SOURCES/php-5.2.0.tar.gz
+ tar -xf -
+ STATUS=0
+ '[' 0 -ne 0 ']'
+ cd php-5.2.0
++ /usr/bin/id -u
+ '[' 0 = 0 ']'
+ /bin/chown -Rhf root .
++ /usr/bin/id -u
+ '[' 0 = 0 ']'
+ /bin/chgrp -Rhf root .
+ /bin/chmod -Rf a+rX,u+w,g-w,o-w .
+ perl -pi -e 's|/usr/lib|/usr/lib|' php.ini-dist
+ rm -f ext/standard/tests/file/bug21131.phpt
+ rm -f ext/pspell/tests/01pspell_basic.phpt ext/standard/tests/file/bug22414.phpt ext/session/tests/019.phpt ext/standard/tests/math/pow.phpt ext/standard/tests/math/round.phpt ext/standard/tests/math/abs.phpt ext/iconv/tests/ob_iconv_handler.phpt
+ mkdir build-cgi build-apache
+ '[' -f /var/tmp/php-5.2.0-gcc ']'
+ '[' -x /usr/bin/gcc-3.2.3 ']'
+ '[' -x /usr/bin/gcc-3.2.2 ']'
+ '[' -x /usr/bin/gcc-3.2.1 ']'
+ '[' -x /usr/bin/gcc-3.2 ']'
+ '[' -x /usr/bin/gcc-3.1.1 ']'
+ echo gcc
+ '[' -f /var/tmp/php-5.2.0-show_flags ']'
+ cat
++ cat /var/tmp/php-5.2.0-gcc
+ chmod u+x /var/tmp/php-5.2.0-show_flags
+ /var/tmp/php-5.2.0-show_flags


RPM RELEASE: 100.rhe4x.iworx
OS TYPE IS : RedHat Enterprise 4.x
GCC IS     : gcc
CCFLAGS    : -O2 -g -march=i386 -mcpu=i686
LDFLAGS    : -O2 -g -march=i386 -mcpu=i686


+ '[' -f /var/tmp/php-5.2.0-show_flags ']'
+ rm -f /var/tmp/php-5.2.0-show_flags
+ exit 0
Executing(%build): /bin/sh -e /var/tmp/rpm-tmp.74077
+ umask 022
+ cd /usr/src/redhat/BUILD
+ cd php-5.2.0
+ '[' -n /var/tmp/php-5.2.0-root -a /var/tmp/php-5.2.0-root '!=' / ']'
+ rm -rf /var/tmp/php-5.2.0-root
+ mkdir -p /var/tmp/php-5.2.0-root
+ '[' -f /var/tmp/php-5.2.0-gcc ']'
+ rm -f /var/tmp/php-5.2.0-gcc
+ export EXTENSION_DIR=/usr/lib/php5
+ EXTENSION_DIR=/usr/lib/php5
+ touch acinclude.m4
+ export 'CFLAGS=-O2 -g -march=i386 -mcpu=i686 -fomit-frame-pointer -fPIC'
+ CFLAGS='-O2 -g -march=i386 -mcpu=i686 -fomit-frame-pointer -fPIC'
+ pushd build-cgi
/usr/src/redhat/BUILD/php-5.2.0/build-cgi /usr/src/redhat/BUILD/php-5.2.0
+ build --enable-force-cgi-redirect
+ mkdir Zend
+ cp ../Zend/zend_language_parser.c ../Zend/zend_language_parser.h ../Zend/zend_language_scanner.c ../Zend/zend_language_scanner.h ../Zend/zend_ini_parser.c ../Zend/zend_ini_parser.h ../Zend/zend_ini_scanner.c ../Zend/zend_ini_scanner.h Zend
+ ln -sf ../configure
+ ./configure --prefix=/usr --bindir=/usr/bin --mandir=/usr/share/man --localstatedir=/var --libdir=/usr/lib --datadir=/usr/share --includedir=/usr/include --sysconfdir=/etc --cache-file=../config.cache --with-config-file-path=/etc --with-config-file-scan-dir=/etc/php.d --disable-debug --disable-rpath --with-bz2 --with-db4=/usr --with-curl --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --with-gd --with-gdbm --with-gettext --with-ncurses=shared --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-expat-dir=/usr --with-xml --with-xsl --with-xmlrpc=shared --with-readline --with-pcre=/usr --with-zlib --with-layout=GNU --with-pear=/usr/share/pear --with-imap=shared --with-imap-ssl --with-kerberos --with-ldap=shared --with-mcrypt=shared --with-mhash=shared --with-pdo-mysql=/usr --with-pdo-pgsql=/usr --with-mysql=shared,/usr --with-mysqli --with-unixODBC=shared,/usr --with-pgsql=shared --with-snmp=shared,/usr --enable-mbstr-enc-trans --enable-mbregex --enable-mbstring=shared --enable-exif --without-oci8 --enable-bcmath --enable-ftp --enable-soap --enable-magic-quotes --enable-safe-mode --enable-sockets --enable-sysvsem --enable-sysvshm --enable-discard-path --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --enable-memory-limit --enable-bcmath --enable-shmop --enable-calendar --enable-dbx --enable-dio --enable-mcal --enable-inline-optimization --enable-gd-native-ttf --enable-pic --disable-wddx --with-dom=shared,/usr --with-dom-xslt=/usr --with-dom-exslt=/usr --enable-force-cgi-redirect
creating cache ../config.cache
checking for Cygwin environment... no
checking for mingw32 environment... no
checking for egrep... grep -E
checking for a sed that does not truncate output... /bin/sed
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for gcc... gcc
checking whether the C compiler (gcc -O2 -g -march=i386 -mcpu=i686 -fomit-frame-pointer -fPIC ) works... yes
checking whether the C compiler (gcc -O2 -g -march=i386 -mcpu=i686 -fomit-frame-pointer -fPIC ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking whether gcc and cc understand -c and -o together... yes
checking how to run the C preprocessor... gcc -E
checking for AIX... no
checking whether ln -s works... yes
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking for re2c... no
configure: warning: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for bison... no
checking for byacc... no
checking for bison version... invalid
configure: warning: bison versions supported for regeneration of the Zend/PHP parsers: 1.28 1.35 1.75 1.875 2.0 2.1 2.2 2.3 (found: none).
checking for flex... lex
checking for yywrap in -ll... no
checking lex output file root... ./configure: line 3276: lex: command not found
configure: error: cannot find output from lex; giving up
error: Bad exit status from /var/tmp/rpm-tmp.74077 (%build)


RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.74077 (%build)
    36

    Not sure what to suggest- I pulled the link to steadfast from this Interworx thread this thread: http://www.interworx.com/forums/showthread.php?t=1961&highlight=steadfast

    There is a lot of troubleshooting and discussion of their intrictions which you might find helpful.

    37

    [quote=hubbadubba;13581]Not sure what to suggest- I pulled the link to steadfast from this Interworx thread this thread: http://www.interworx.com/forums/showthread.php?t=1961&highlight=steadfast

    There is a lot of troubleshooting and discussion of their intrictions which you might find helpful.[/quote]

    what a bad luck i just moved to new vps and having only problems on it:(

    38

    I may have missed this from your previous posts, but you are running PHP5 on your current InterWorx VPS correct? How did you get PHP5 installed? Which distribution are you using?

    39

    Sorry, just noticed this:

    [QUOTE=cape;13578]checking lex output file root… ./configure: line 3276: lex: command not found
    configure: error: cannot find output from lex; giving up
    error: Bad exit status from /var/tmp/rpm-tmp.74077 (%build)[/QUOTE]

    yum install flex

    should fix that problem.

    40

    Yes i am running 5.1.6 interowrx ofcourse 3:)

    Hosting install php along with mysql 5.0.27 on centos 4.5

    Now i am having problems with invision board and looks like i am having problems with my db as well