Is the mysql cookbook not getting the right version of the client?

Chef Infra (archive)
1

HI,
I’m using the mysql cookbook and when it tries to install the client via mysql::client recipe, the following errors out:

[2013-05-24T05:35:07+00:00] FATAL: Chef::Exceptions::Exec: package[mysql-client] (mysql::client line 46) had an error: Chef::Exceptions::Exec: apt-get -q -y install mysql-client=5.5.29-0ubuntu0.12.04.2 returned 100, expected 0

Turns out that this version does not exist.

@millisami
~ Sachin Sagar Rai
Ruby on Rails Developer
http://tfm.com.np
http://nepalonrails.com (http://nepalonrails.tumblr.com)
http://funsole.com
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)

2

I suspect that your package index on the server is stale, run apt-get update manually before running chef again and see if that helps you find the issue.

If it is just that the package index needed an update then you probably want to include something that does an apt-get update early in the chef run. If you're running Ubuntu, the apt cookbook's default recipe will do this for you.

Cat

On 24/05/2013, at 3:36 PM, Sachin Sagar Rai millisami@gmail.com wrote:

HI,
I'm using the mysql cookbook and when it tries to install the client via mysql::client recipe, the following errors out:

[2013-05-24T05:35:07+00:00] FATAL: Chef::Exceptions::Exec: package[mysql-client] (mysql::client line 46) had an error: Chef::Exceptions::Exec: apt-get -q -y install mysql-client=5.5.29-0ubuntu0.12.04.2 returned 100, expected 0

Turns out that this version does not exist.

@millisami
~ Sachin Sagar Rai
Ruby on Rails Developer
http://tfm.com.np
http://nepalonrails.com
http://funsole.com
Sent with Sparrow

3

Thanks @Catherine, I've added the apt in runlist and it seems to work.

But my question is doesn't this be included in the mysql cookbook itself?

And while that did work but I see this in log output:

[2013-05-24T06:55:37+00:00] INFO: AptPreference light-weight provider already initialized -- overriding!
/opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.4.0/lib/chef/provider/lwrp_base.rb:97: warning: already initialized constant AptPreference
[2013-05-24T06:55:37+00:00] INFO: AptRepository light-weight provider already initialized -- overriding!
/opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.4.0/lib/chef/provider/lwrp_base.rb:97: warning: already initialized constant AptRepository
[2013-05-24T06:55:37+00:00] INFO: AptPreference light-weight resource already initialized -- overriding!
/opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.4.0/lib/chef/resource/lwrp_base.rb:51: warning: already initialized constant AptPreference
[2013-05-24T06:55:37+00:00] INFO: AptRepository light-weight resource already initialized -- overriding!
/opt/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.4.0/lib/chef/resource/lwrp_base.rb:51: warning: already initialized constant AptRepository

I've this in the role:

name "web"
description "Web Server Role"
run_list(
"recipe[apt]",
"recipe[nginx]",
"recipe[mysql::client]"
)

@millisami
~ Sachin Sagar Rai
Ruby on Rails Developer
http://tfm.com.np
http://nepalonrails.com (http://nepalonrails.tumblr.com)
http://funsole.com
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)

On Friday, May 24, 2013 at 11:59 AM, Catherine Truscott wrote:

I suspect that your package index on the server is stale, run apt-get update manually before running chef again and see if that helps you find the issue.

If it is just that the package index needed an update then you probably want to include something that does an apt-get update early in the chef run. If you're running Ubuntu, the apt cookbook's default recipe will do this for you.

Cat

On 24/05/2013, at 3:36 PM, Sachin Sagar Rai <millisami@gmail.com (mailto:millisami@gmail.com)> wrote:

HI,
I'm using the mysql cookbook and when it tries to install the client via mysql::client recipe, the following errors out:

[2013-05-24T05:35:07+00:00] FATAL: Chef::Exceptions::Exec: package[mysql-client] (mysql::client line 46) had an error: Chef::Exceptions::Exec: apt-get -q -y install mysql-client=5.5.29-0ubuntu0.12.04.2 returned 100, expected 0

Turns out that this version does not exist.

@millisami
~ Sachin Sagar Rai
Ruby on Rails Developer
http://tfm.com.np (http://tfm.com.np/)
http://nepalonrails.com (http://nepalonrails.tumblr.com/)
http://funsole.com
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)