LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 05-04-2010, 06:08 PM   #1
Nintendo
LQ Newbie
 
Registered: May 2010
Posts: 9

Rep: Reputation: 0
Upgrading php and mySQL.


So, I tried upgrading mySQL and PHP using up2date and what did it do? Downgraded me from mySQL 4.0.26-standard to 3.23.58 and did nothing with PHP.

Is there a n00bie guide some where for *upgrading* php and mySQL?

PHP Version 4.4.4
MySQL 4.0.26-standard and now downgraded to 3.23.58
Ensim Basic 4.0.3-22.rhel.3ES (Yes, I know, It's very out dated!!)

I try to upgrade back to where I was at and I get...

Code:
[root@mail admin]# rpm -Uvh --nodeps MySQL*.rpm
warning: MySQL-client-4.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
package MySQL-shared-compat-4.0.26-0 is already installed
package MySQL-devel-4.0.26-0 is already installed
package MySQL-shared-4.0.26-0 is already installed
so I try upgrading and get

Code:
[root@mail admin]# rpm -Uvh --nodeps MySQL*-5.0.89-0.i386.rpm
error: MySQL-client-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-client-5.0.89-0.i386.rpm cannot be installed
error: MySQL-devel-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-devel-5.0.89-0.i386.rpm cannot be installed
error: MySQL-server-5.0.89-0.i386.rpm: rpmReadSignature failed: region trailer: BAD, tag 61 type 7 offset 48 count 16
error: MySQL-server-5.0.89-0.i386.rpm cannot be installed
How do you upgrade mySQL and get it to work? Which URLs do I get at

ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-5.0/

for the version rhel.3ES. Or, if I have to, how do you totally delete mySQL and then totally re-install it?

For php, which files do I get at

http://mirror.cheetaweb.com/redhat/3ES/i386/RPMS.php51/
 
Old 05-04-2010, 10:10 PM   #2
wmakowski
Member
 
Registered: Oct 2003
Location: Ohio
Distribution: Fedora 18, 19, RHL 5.2
Posts: 546

Rep: Reputation: 43
I don't have access to a RHEL 3ES system, but will venture a few suggestions for you. I assume that you won't be able to get the latest versions of MySQL or PHP using up2date since you have an older product.

For MySQL, take a look at their Download area and Documentation for the release you choose. The download area has rpm's of their latest release for RHEL 3ES and the documentation has a section on upgrading to walk you through it.

For PHP I would go over to the PHP site and look into downloading and installing from the tar ball. PHP will most likely end up being installed in /usr/local. You'll need to remove the version that Red Hat supplies so you are accessing the version that you just installed. The documentation has information on Migrating from one version of PHP to another.

-----
Bill
 
Old 05-04-2010, 11:06 PM   #3
Nintendo
LQ Newbie
 
Registered: May 2010
Posts: 9

Original Poster
Rep: Reputation: 0
It also helps when you find a page with just links for your exact type of server. I got mySQL upgraded now, from 3.23.58 to 5.0.24.
Code:
rpm -Uvh MySQL-*5.0.24-0.glibc23.i386.rpm
warning: MySQL-client-5.0.24-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-shared-compat    ########################################### [ 25%]
   2:MySQL-server           ########################################### [ 50%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mail.cmgscc.com password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQLCouldn't find MySQL manager or server[FAILED]
MySQL fixing privileges successful!!!
   3:MySQL-client           ########################################### [ 75%]
   4:MySQL-devel            ########################################### [100%]
[root@mail admin]# /sbin/service mysql stop
Stopping MySQL:                                            [  OK  ]
[root@mail admin]# /sbin/service mysql start
Starting MySQL:                                            [  OK  ]
[root@mail admin]# /sbin/shutdown -r now

Broadcast message from root (pts/0) (Tue May  4 20:26:35 2010):

The system is going down for reboot NOW!
 
  


Reply

Tags
mysql, php, upgrade


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrading Apache, PHP and MySQL eskaiem Linux - Software 3 06-26-2009 08:00 AM
Upgrading Apache, PHP and MySQL gurl4sh25 Linux - Software 7 09-14-2007 05:23 AM
Upgrading PHP..and maybe MySQL too? Vort3x Mandriva 4 11-23-2004 05:40 PM
Upgrading PHP,.. and maybe MySQL too? Vort3x Linux - Software 1 10-29-2004 11:35 AM
PHP and MySQL after upgrading Redhat Shinjuku Linux - Software 5 05-02-2003 12:37 PM


All times are GMT -5. The time now is 08:21 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration