Mysql gem problem


#1

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


#2

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: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


#3

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:
https://github.com/opscode/cookbooks/commit/ae5098cb65c7006f366605974cee526b49ad803b

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: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


#4

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:
https://github.com/opscode/cookbooks/commit/ae5098cb65c7006f366605974cee526b49ad803b

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:inload_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:inload_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


#5

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:
https://github.com/opscode/cookbooks/commit/ae5098cb65c7006f366605974cee526b49ad803b

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:inload_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:inload_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