[chef] Re: postgresql::server recipe not working under debian lenny

[Joshua Timberman < >]

Hello!

This is related to a problem in the way the postgresql cookbook attempted to 
determine the version of postgresql to use. The cookbook is now updated on 
the Cookbooks site and the github repository: cookbook version 0.10.1.


On Jul 6, 2010, at 3:56 AM, Vasiliy G Tolstov wrote:

> Installing postgresql-server under debian with postgresql cookbook form
> github brings this error:
> 
> Processing
> template[/etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf]
>  on debian
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG:
> template[/etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf]
>  using Chef::Provider::Template
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: looking for template
> pg_hba.conf.erb in cookbook "postgresql"
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: Not storing
> cookbooks/postgresql/templates/default/pg_hba.conf.erb, as the cache is
> up to date.
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: Current content's checksum:  
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: Rendered content's checksum:
> c04bf20b3362afb244179161b27b244ddcec46b2ce7459f464144d02ba28beb7
> [Tue, 06 Jul 2010 05:53:35 -0400] INFO: Writing updated content for
> template[/etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf]
>  to /etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: setting owner
> on /tmp/chef-rendered-template20100706-20268-pyiumh-0 to 106
> [Tue, 06 Jul 2010 05:53:35 -0400] DEBUG: setting group
> on /tmp/chef-rendered-template20100706-20268-pyiumh-0 to 109
> [Tue, 06 Jul 2010 05:53:35 -0400] ERROR:
> template[/etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf]
>  (/var/cache/chef/cookbooks/postgresql/recipes/server.rb:33:in `from_file') 
> had an error:
> No such file or directory
> - /tmp/chef-rendered-template20100706-20268-pyiumh-0
> or /etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf
> /usr/lib/ruby/1.8/fileutils.rb:505:in `rename'
> /usr/lib/ruby/1.8/fileutils.rb:505:in `mv'
> /usr/lib/ruby/1.8/fileutils.rb:1395:in `fu_each_src_dest'
> /usr/lib/ruby/1.8/fileutils.rb:1411:in `fu_each_src_dest0'
> /usr/lib/ruby/1.8/fileutils.rb:1393:in `fu_each_src_dest'
> /usr/lib/ruby/1.8/fileutils.rb:494:in `mv'
> /usr/lib/ruby/1.8/chef/provider/template.rb:55:in `action_create'
> /usr/lib/ruby/1.8/chef/mixin/template.rb:48:in `render_template'
> /usr/lib/ruby/1.8/tempfile.rb:188:in `open'
> /usr/lib/ruby/1.8/chef/mixin/template.rb:45:in `render_template'
> /usr/lib/ruby/1.8/chef/provider/template.rb:144:in `render_with_context'
> /usr/lib/ruby/1.8/chef/provider/template.rb:46:in `action_create'
> /usr/lib/ruby/1.8/chef/runner.rb:50:in `send'
> /usr/lib/ruby/1.8/chef/runner.rb:50:in `run_action'
> /usr/lib/ruby/1.8/chef/runner.rb:107:in `converge'
> /usr/lib/ruby/1.8/chef/runner.rb:106:in `each'
> /usr/lib/ruby/1.8/chef/runner.rb:106:in `converge'
> /usr/lib/ruby/1.8/chef/resource_collection.rb:94:in
> `execute_each_resource'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call_iterator_block'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:85:in
> `step'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:104:in
> `iterate'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:55:in
> `each_with_index'
> /usr/lib/ruby/1.8/chef/resource_collection.rb:92:in
> `execute_each_resource'
> /usr/lib/ruby/1.8/chef/runner.rb:80:in `converge'
> /usr/lib/ruby/1.8/chef/client.rb:334:in `converge'
> /usr/lib/ruby/1.8/chef/client.rb:108:in `run'
> /usr/lib/ruby/1.8/chef/application/client.rb:215:in `run_application'
> /usr/lib/ruby/1.8/chef/application/client.rb:207:in `loop'
> /usr/lib/ruby/1.8/chef/application/client.rb:207:in `run_application'
> /usr/lib/ruby/1.8/chef/application.rb:62:in `run'
> /usr/bin/chef-client:26
> [Tue, 06 Jul 2010 05:53:35 -0400] ERROR: Running exception handlers
> [Tue, 06 Jul 2010 05:53:35 -0400] ERROR: Exception handlers complete
> [Tue, 06 Jul 2010 05:53:35 -0400] ERROR: Re-raising exception:
> Errno::ENOENT - No such file or directory
> - /tmp/chef-rendered-template20100706-20268-pyiumh-0
> or /etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf
> /usr/lib/ruby/1.8/fileutils.rb:505:in `rename'
>  /usr/lib/ruby/1.8/fileutils.rb:505:in `mv'
>  /usr/lib/ruby/1.8/fileutils.rb:1395:in `fu_each_src_dest'
>  /usr/lib/ruby/1.8/fileutils.rb:1411:in `fu_each_src_dest0'
>  /usr/lib/ruby/1.8/fileutils.rb:1393:in `fu_each_src_dest'
>  /usr/lib/ruby/1.8/fileutils.rb:494:in `mv'
>  /usr/lib/ruby/1.8/chef/provider/template.rb:55:in `action_create'
>  /usr/lib/ruby/1.8/chef/mixin/template.rb:48:in `render_template'
>  /usr/lib/ruby/1.8/tempfile.rb:188:in `open'
>  /usr/lib/ruby/1.8/chef/mixin/template.rb:45:in `render_template'
>  /usr/lib/ruby/1.8/chef/provider/template.rb:144:in
> `render_with_context'
>  /usr/lib/ruby/1.8/chef/provider/template.rb:46:in `action_create'
>  /usr/lib/ruby/1.8/chef/runner.rb:50:in `send'
>  /usr/lib/ruby/1.8/chef/runner.rb:50:in `run_action'
>  /usr/lib/ruby/1.8/chef/runner.rb:107:in `converge'
>  /usr/lib/ruby/1.8/chef/runner.rb:106:in `each'
>  /usr/lib/ruby/1.8/chef/runner.rb:106:in `converge'
>  /usr/lib/ruby/1.8/chef/resource_collection.rb:94:in
> `execute_each_resource'
>  /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call'
>  /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call_iterator_block'
>  /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:85:in
> `step'
>  /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:104:in
> `iterate'
>  /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:55:in
> `each_with_index'
>  /usr/lib/ruby/1.8/chef/resource_collection.rb:92:in
> `execute_each_resource'
>  /usr/lib/ruby/1.8/chef/runner.rb:80:in `converge'
>  /usr/lib/ruby/1.8/chef/client.rb:334:in `converge'
>  /usr/lib/ruby/1.8/chef/client.rb:108:in `run'
>  /usr/lib/ruby/1.8/chef/application/client.rb:215:in `run_application'
>  /usr/lib/ruby/1.8/chef/application/client.rb:207:in `loop'
>  /usr/lib/ruby/1.8/chef/application/client.rb:207:in `run_application'
>  /usr/lib/ruby/1.8/chef/application.rb:62:in `run'
>  /usr/bin/chef-client:26
> [Tue, 06 Jul 2010 05:53:35 -0400] ERROR: Errno::ENOENT
> [Tue, 06 Jul 2010 05:53:35 -0400] FATAL: No such file or directory
> - /tmp/chef-rendered-template20100706-20268-pyiumh-0
> or /etc/postgresql/#<Chef::Node::Attribute:0x7f5f6cb2a278>/main/pg_hba.conf
> /usr/lib/ruby/1.8/fileutils.rb:505:in `rename'
> /usr/lib/ruby/1.8/fileutils.rb:505:in `mv'
> /usr/lib/ruby/1.8/fileutils.rb:1395:in `fu_each_src_dest'
> /usr/lib/ruby/1.8/fileutils.rb:1411:in `fu_each_src_dest0'
> /usr/lib/ruby/1.8/fileutils.rb:1393:in `fu_each_src_dest'
> /usr/lib/ruby/1.8/fileutils.rb:494:in `mv'
> /usr/lib/ruby/1.8/chef/provider/template.rb:55:in `action_create'
> /usr/lib/ruby/1.8/chef/mixin/template.rb:48:in `render_template'
> /usr/lib/ruby/1.8/tempfile.rb:188:in `open'
> /usr/lib/ruby/1.8/chef/mixin/template.rb:45:in `render_template'
> /usr/lib/ruby/1.8/chef/provider/template.rb:144:in `render_with_context'
> /usr/lib/ruby/1.8/chef/provider/template.rb:46:in `action_create'
> /usr/lib/ruby/1.8/chef/runner.rb:50:in `send'
> /usr/lib/ruby/1.8/chef/runner.rb:50:in `run_action'
> /usr/lib/ruby/1.8/chef/runner.rb:107:in `converge'
> /usr/lib/ruby/1.8/chef/runner.rb:106:in `each'
> /usr/lib/ruby/1.8/chef/runner.rb:106:in `converge'
> /usr/lib/ruby/1.8/chef/resource_collection.rb:94:in
> `execute_each_resource'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:116:in
> `call_iterator_block'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:85:in
> `step'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:104:in
> `iterate'
> /usr/lib/ruby/1.8/chef/resource_collection/stepable_iterator.rb:55:in
> `each_with_index'
> /usr/lib/ruby/1.8/chef/resource_collection.rb:92:in
> `execute_each_resource'
> /usr/lib/ruby/1.8/chef/runner.rb:80:in `converge'
> /usr/lib/ruby/1.8/chef/client.rb:334:in `converge'
> /usr/lib/ruby/1.8/chef/client.rb:108:in `run'
> /usr/lib/ruby/1.8/chef/application/client.rb:215:in `run_application'
> /usr/lib/ruby/1.8/chef/application/client.rb:207:in `loop'
> /usr/lib/ruby/1.8/chef/application/client.rb:207:in `run_application'
> /usr/lib/ruby/1.8/chef/application.rb:62:in `run'
> /usr/bin/chef-client:26
> [Tue, 06 Jul 2010 05:53:35 -0400] FATAL: Sleeping for 60 seconds before
> trying again
> 
> attributes/default.rb:
> 
> set[:postgresql][:version] = value_for_platform(
>  "ubuntu" => {
>    "8.04" => "8.3",
>    "8.10" => "8.3",
>    "9.10" => "8.3",
>    "10.04" => "8.4",
>    "default" => "8.4"
>  },
>  "debian" => {
>    "5.0.4" => "8.3",
>    "default" => "8.3"
>  },
>  "fedora" => {
>    "10" => "8.3",
>    "11" => "8.3",
>    "12" => "8.3",
>    "13" => "8.4",
>    "14" => "8.4",
>    "default" => "8.4"
>  },
>  ["redhat", "centos"] => {
>    "default" => "8.3"
>  }
> )
> 
> case platform
> when "redhat","centos","fedora","suse"
>  set[:postgresql][:dir]     = "/var/lib/pgsql/data"
> when "debian","ubuntu"
>  set[:postgresql][:dir]     =
> "/etc/postgresql/#{node.postgresql.version}/main"
> else
>  set[:postgresql][:dir]     =
> "/etc/postgresql/#{node.postgresql.version}/main"
> end
> 
> 
> 
> 
> 
> -- 
> Vasiliy G Tolstov 
> <
 >
> Selfip.Ru
> 

-- 
Opscode, Inc
Joshua Timberman, Senior Solutions Engineer
C: 720.334.RUBY E: