Mysql gem problem

Hi all,

I’m trying to run the “wordpress” chef recipe from the opscode
cookbooks, but I get the following error:

[Tue, 24 May 2011 09:10:36 -0700] DEBUG: Re-raising exception:
LoadError - no such file to load – mysql
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:inrequire’
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in from_file' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/cookbook_version.rb:472:inload_recipe’
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/…/lib/chef/mixin/language_include_recipe.rb:40:in
include_recipe' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/language_include_recipe.rb:27:ineach’
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/…/lib/chef/mixin/langu: stdout
[default] /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require': stderr [default] : : stderr [default] no such file to load -- mysql: stderr [default] (: stderr [default] LoadError: stderr [default] ) : stderr [default] from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:inrequire’
: stderr
[default] from
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in
`from_file’

Any idea on why this is happening?

Regards,

Roberto Aloi

Roberto,
This bug has actually been fixed in version 0.8.0 of the wordpress cookbook which will be released later this week.

If you would like to grab the changes early please take look at this commit:

Seth

--
Opscode, Inc.
Seth Chisamore, Senior Technical Evangelist
IRC, Skype, Twitter, Github: schisamo

On Tuesday, May 24, 2011 at 12:33 PM, Roberto wrote:
Hi all,

I'm trying to run the "wordpress" chef recipe from the opscode
cookbooks, but I get the following error:

[Tue, 24 May 2011 09:10:36 -0700] DEBUG: Re-raising exception:
LoadError - no such file to load -- mysql
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in require'
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in from_file' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/cookbook_version.rb:472:in load_recipe'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/language_include_recipe.rb:40:in
include_recipe' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/language_include_recipe.rb:27:in each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/langu: stdout
[default] /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require': stderr [default] : : stderr [default] no such file to load -- mysql: stderr [default] (: stderr [default] LoadError: stderr [default] ) : stderr [default] from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in require'
: stderr
[default] from
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in
`from_file'

Any idea on why this is happening?

Regards,

Roberto Aloi

Hello!

The wordpress cookbook has been updated to 0.8.1 which can be downloaded from:

http://community.opscode.com/cookbooks/wordpress

Or with knife:

% knife cookbook site install wordpress

--
Opscode, Inc.
Joshua Timberman, Director of Training and Services
IRC, Skype, Twitter, Github: jtimberman

On Tuesday, May 24, 2011 at 7:24 PM, Seth Chisamore wrote:

Roberto,
This bug has actually been fixed in version 0.8.0 of the wordpress cookbook which will be released later this week.

If you would like to grab the changes early please take look at this commit:
wordpress v0.8.0, cleanup and upgrade · chef-boneyard/cookbooks@ae5098c · GitHub

Seth

--
Opscode, Inc.
Seth Chisamore, Senior Technical Evangelist
IRC, Skype, Twitter, Github: schisamo

On Tuesday, May 24, 2011 at 12:33 PM, Roberto wrote:
Hi all,

I'm trying to run the "wordpress" chef recipe from the opscode
cookbooks, but I get the following error:

[Tue, 24 May 2011 09:10:36 -0700] DEBUG: Re-raising exception:
LoadError - no such file to load -- mysql
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in require'
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in from_file' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/cookbook_version.rb:472:in load_recipe'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/language_include_recipe.rb:40:in
include_recipe' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/language_include_recipe.rb:27:in each'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/mixin/langu: stdout
[default] /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in
gem_original_require': stderr [default] : : stderr [default] no such file to load -- mysql: stderr [default] (: stderr [default] LoadError: stderr [default] ) : stderr [default] from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:29:in require'
: stderr
[default] from
/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:55:in
`from_file'

Any idea on why this is happening?

Regards,

Roberto Aloi

Hi,

On Wed, May 25, 2011 at 2:24 AM, Seth Chisamore schisamo@opscode.com wrote:

Roberto,
This bug has actually been fixed in version 0.8.0 of the wordpress cookbook which will be released later this week.

If you would like to grab the changes early please take look at this commit:
wordpress v0.8.0, cleanup and upgrade · chef-boneyard/cookbooks@ae5098c · GitHub

Thanks, this seemed to solve the original issue. Using version 0.8.1,
though, I get the following:

[Wed, 25 May 2011 02:46:15 -0700] FATAL: Failed to read the private
key /etc/chef/client.pem:
...
[Wed, 25 May 2011 02:46:15 -0700] ERROR: execute[create wordpressdb
database] (/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:76:in
from_file') had an error: I cannot read /etc/chef/client.pem, which you told me to use to sign requests! /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:62:in load_signing_key'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:33:in
initialize' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest.rb:48: stdout [default] /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:62:in load_signing_key': stderr
[default] : : stderr
[default] I cannot read /etc/chef/client.pem, which you told me to use
to sign requests!: stderr
[default] (: stderr
[default] Chef::Exceptions::PrivateKeyMissing: stderr
[default] )
: stderr
[default] from
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:33:in
`initialize'
: stderr
[default]

I'm a bit lost here, cause I'm using Chef Solo as provisioner and not
Chef Server. Could someone clarify me how this authentication is
supposed to work?

Thanks again,

Roberto

Ah! I'm not the only one suffering this issue. There's already a pull
request for this:

Regards,

Roberto

On Wed, May 25, 2011 at 10:53 AM, Roberto prof3ta@gmail.com wrote:

Hi,

On Wed, May 25, 2011 at 2:24 AM, Seth Chisamore schisamo@opscode.com wrote:

Roberto,
This bug has actually been fixed in version 0.8.0 of the wordpress cookbook which will be released later this week.

If you would like to grab the changes early please take look at this commit:
wordpress v0.8.0, cleanup and upgrade · chef-boneyard/cookbooks@ae5098c · GitHub

Thanks, this seemed to solve the original issue. Using version 0.8.1,
though, I get the following:

[Wed, 25 May 2011 02:46:15 -0700] FATAL: Failed to read the private
key /etc/chef/client.pem:
...
[Wed, 25 May 2011 02:46:15 -0700] ERROR: execute[create wordpressdb
database] (/tmp/vagrant-chef/cookbooks-0/wordpress/recipes/default.rb:76:in
from_file') had an error: I cannot read /etc/chef/client.pem, which you told me to use to sign requests! /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:62:in load_signing_key'
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:33:in
initialize' /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest.rb:48: stdout [default] /usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:62:in load_signing_key': stderr
[default] : : stderr
[default] I cannot read /etc/chef/client.pem, which you told me to use
to sign requests!: stderr
[default] (: stderr
[default] Chef::Exceptions::PrivateKeyMissing: stderr
[default] )
: stderr
[default] from
/usr/lib/ruby/gems/1.8/gems/chef-0.9.12/bin/../lib/chef/rest/auth_credentials.rb:33:in
`initialize'
: stderr
[default]

I'm a bit lost here, cause I'm using Chef Solo as provisioner and not
Chef Server. Could someone clarify me how this authentication is
supposed to work?

Thanks again,

Roberto

--
Roberto Aloi

Blog: http://aloiroberto.wordpress.com
Twitter: @prof3ta