4.2.0 upgrade question regarding MySQL

[T_R_J]

T_R_J [http://community.zenoss.org/people/T_R_J] created the discussion

"4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73187#73187

--------------------------------------------------------------
Hi all,

I'm in the process of attempting to upgrade 4.2.0 to 4.2.3 using the autodeploy script when it shows me this:


It appears that the distro-supplied version of MySQL is at least partially installed,
or a prior installation attempt failed.


Please remove these packages, as well as their dependencies (often postfix), and then
retry this script:


MySQL-shared-5.5.28-1.linux2.6.x86_64
MySQL-server-5.5.28-1.linux2.6.x86_64
MySQL-client-5.5.28-1.linux2.6.x86_64



My current Zenoss is running without issue now, I don't think it's wise to blow away my existing MySQL to satisfy this script.  Help?


Thanks!
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73187#73187]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73205#73205

--------------------------------------------------------------
TRJ,

yum remove MySQL* and yum remove mysql*  then try again.

Best,
--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73205#73205]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[nilie]

nilie [http://community.zenoss.org/people/nilie] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73206#73206

--------------------------------------------------------------
Isn't this going to nuke the database ? Wouldn't it be wise for the autodeploy script to detect an existing installation and upgrade it ?
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73206#73206]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[T_R_J]

T_R_J [http://community.zenoss.org/people/T_R_J] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73191#73191

--------------------------------------------------------------
Exactly... This is my fear.
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73191#73191]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73223#73223

--------------------------------------------------------------
T_R_J,

It shouldn't delete the data from /var/lib/mysql/data, no, but it wouldn't hurt to back it up to be sure.

--Shane Scott (Hackman238)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73223#73223]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[nilie]

nilie [http://community.zenoss.org/people/nilie] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73242#73242

--------------------------------------------------------------
It seems to me that running the auto-install script for updating 4.2.0 to 4.2.3 is suboptimal, maybe a distinct script for a minor update would be a better idea.
In my case updating Zenoss was as simple as :
1. Stopping Zenoss
2. Upgrading rabbitmq-server (new version required)
3. Running yum update with the 4.2.3 rpm (much gentle than yum install)
4. Starting Zenoss
I did the same thing on the remote collector but it was a little bit trickier because Zenoss update requires MySQL to be up and running even though it is not used at all (I had it stopped in order to spare the system resources).
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73242#73242]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Andrew Kirch]

Andrew Kirch [http://community.zenoss.org/people/akirch] created the discussion

"Re: 4.2.0 upgrade question regarding MySQL"

To view the discussion, visit: http://community.zenoss.org/message/73243#73243

--------------------------------------------------------------

--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73243#73243]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]