[chef] RE: Re: Re: Re: Resource is marked as updated, although it should not be

["Kadel-Garcia, Nico" < >]

Mixing and matching MySQL components from the same yum repositories is a 
*nightmare*. Every different MySQL RPM packager elected to use a different 
naming convention, including the standards violating use of mixed case by Sun 
early in the process, don't get me *started* on what Percona did by putting 
"-51", "-55", and "-56" suffixes on their packages, and generally it's pretty 
messy. And the default CentOS/RHEL/Scientific Linux mysql client is embedded 
in the "mysql" package, which is also the server package, and which no other 
MySQL package set does. I'm afraid it's messy. 

It looks like the 'MySQL-server' package is an Oracle published package, 
possibly installed in your local yum repository for another project. I urge 
you to take any third-party Oracle MySQL components and put them in a 
separate yum repository, and enable it for yum access only as needed. 
Otherwise, you're prey to this.

Ripping out the inappropriate MySQL packages and getting the right ones in 
place can be awkward: 'postfix' had a dependency on mysql-libs, for example,  
and replacing one major MySQL version with a different version, such as going 
from 5.1 to 5.5 or 5.6, can require rebuilding the mysql gem in /opt/chef.

--
Nico Kadel-Garcia
Senior Systems Consultant
Email: 

 
Cell Phone: +1.339.368.2428



-----Original Message-----
From: Julian C. Dunn 
[mailto:
 
 
Sent: Monday, June 30, 2014 9:42 PM
To: 

 
Subject: [chef] Re: Re: Re: Resource is marked as updated, although it should 
not be

I think the key is probably this line:

'MySQL-server' providing 'mysql=5.0.67-13.20.1' is already installed.

I don't know where this 'MySQL-server' package is from. Is it Oracle's? It 
must 'provide' the virtual package / capability 'mysql'.

- Julian

On Mon, Jun 30, 2014 at 8:29 AM,  
<
 >
 wrote:
> zypper search -i mysql before the chef run shows the same as after. 
> The reason ist, that mysql is already installed by another package. I 
> took a look in 
> https://github.com/opscode/chef/blob/master/lib/chef/provider/package/
> zypper.rb
>
> The command chef fires executed:
> zypper --non-interactive --no-gpg-checks install 
> --auto-agree-with-licenses
> mysql=5.0.67-13.20.1
> Loading repository data...
> Reading installed packages...
> 'MySQL-server' providing 'mysql=5.0.67-13.20.1' is already installed.
> Resolving package dependencies...
>
> Nothing to do.
>
> The return value of this command is 0. The info 'mysql=5.0.67-13.20.1' 
> is already installed is wrong. Installed is another version by the shown 
> package.
> You can reproduce this when you install 
> MySQL-client-5.5.27-1.sles11.i586.rpm
>  MySQL-server-5.5.27-1.sles11.x86_64.rpm before the first chef run.



-- 
[ Julian C. Dunn 
<
 >
          * Sorry, I'm    ]
[ WWW: http://www.aquezada.com/staff/julian    * only Web 1.0  ;]
[ gopher://sdf.org/1/users/keymaker/           * compliant!    ;]
[ PGP: 91B3 7A9D 683C 7C16 715F 442C 6065 D533 FDC2 05B9       ]