Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Component/s: postgresql
-
Labels:None
Description
When using the postgresql cookbook on an omnibus install, it fails with this error:
[Tue, 03 Jul 2012 18:18:12 -0700] INFO: Processing gem_package[pg] action install (postgresql::client line 42) [Tue, 03 Jul 2012 18:18:18 -0700] ERROR: gem_package[pg] (postgresql::client line 42) has had an error [Tue, 03 Jul 2012 18:18:18 -0700] ERROR: Running exception handlers [Tue, 03 Jul 2012 18:18:18 -0700] FATAL: Saving node information to /var/chef/cache/failed-run-data.json [Tue, 03 Jul 2012 18:18:18 -0700] ERROR: Exception handlers complete [Tue, 03 Jul 2012 18:18:18 -0700] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out [Tue, 03 Jul 2012 18:18:18 -0700] FATAL: Mixlib::ShellOut::ShellCommandFailed: gem_package[pg] (postgresql::client line 42) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1' ---- Begin output of /opt/chef/embedded/bin/gem install pg -q --no-rdoc --no-ri -v "0.14.0" ---- STDOUT: Building native extensions. This could take a while... STDERR: ERROR: Error installing pg: ERROR: Failed to build gem native extension. /opt/chef/embedded/bin/ruby extconf.rb checking for pg_config... yes Using config values from /usr/bin/pg_config checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for pg_config_manual.h... yes checking for PQconnectdb() in -lpq... no checking for PQconnectdb() in -llibpq... no checking for PQconnectdb() in -lms/libpq... no Can't find the PostgreSQL client library (libpq) *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/opt/chef/embedded/bin/ruby --with-pg --without-pg --with-pg-dir --without-pg-dir --with-pg-include --without-pg-include=${pg-dir}/include --with-pg-lib --without-pg-lib=${pg-dir}/lib --with-pg-config --without-pg-config --with-pg_config --without-pg_config --with-pqlib --without-pqlib --with-libpqlib --without-libpqlib --with-ms/libpqlib --without-ms/libpqlib Gem files will remain installed in /opt/chef/embedded/lib/ruby/gems/1.9.1/gems/pg-0.14.0 for inspection. Results logged to /opt/chef/embedded/lib/ruby/gems/1.9.1/gems/pg-0.14.0/ext/gem_make.out ---- End output of /opt/chef/embedded/bin/gem install pg -q --no-rdoc --no-ri -v "0.14.0" ---- Ran /opt/chef/embedded/bin/gem install pg -q --no-rdoc --no-ri -v "0.14.0" returned 1
Related ticket: http://help2.opscode.com/admin.php?pg=request&reqid=12522
Issue Links
- is depended on by
-
COOK-1534
postgresql::ruby recipe to handle rubygem install, add database::postgresql recipe
-
Activity
- All
- Comments
- History
- Activity
- Transitions Summary
So what best way to fix this problem now? Inoperability of postgresql cookbooks is prevent setup servers by chef 
Ubuntu 12.04 LTS
knife-solo v0.012 (https://github.com/matschaffer/knife-solo)
Is there any work being done on this issue ? Postgresql cookbook seems to be unsable at the moment. Id really like to avoid having tons of execute resources as a workaround…using pg gem during chef run would be perfection…but at the moment impossible.
Basically the problem is simple. I don't know how Opscode are building the embedded ruby which comes with Omnibus install, but it looks like they're building them against not standard OS libraries. I had a go at installing the pg gem linking it against OS libs and all goes through just fine:
$ ruby --version ruby 1.9.3p194 (2012-04-20 revision 35410) [x86_64-linux]
$ gem --version 1.8.23
$ sudo gem install pg Building native extensions. This could take a while... Successfully installed pg-0.14.1 1 gem installed Installing ri documentation for pg-0.14.1... Installing RDoc documentation for pg-0.14.1...
The quintessential problem here is that the OpenSSL library Opscode's ruby is trying to link against when bulding 'pg' is different than the one that PostgreSQL was built with - this means that the omnibus ruby must be built against non-standard OS libraries ?? - meaning this is not built on actual versions of OS which he omnibus install.sh picker on http://www.opscode.com/chef/install/ is trying to suggest.
Would be awesome if the embedded ruby build was fixed with this regard. There is a few blockers which would be awesome if they were fixed.
Also one of the workarounds here is to use Opscode packages for chef-client. I would STRONGLY advise AGAINST that as the Opscode pacakge ship with ruby 1.8 - I guess I don't need to add more to this 
Interesting thing though is that Opscode package come with ruby 1.8 and omnibus with 1.9.3..
Using the Ubuntu 12.04 Precise EC2 ami and installing via Rubygems, the postgresql::server recipe succeeds.
knife ec2 server create -I ami-b89842d1 -G btm -S btm -x ubuntu -r "recipe[apt],recipe[apt::update],recipe[postgresql::server]" -d ubuntu12.04-gems --bootstrap-version 10.12.0However, using the omnibus install (chef-full template), the postgresql::server recipe fails building the pg gem.
knife ec2 server create -I ami-b89842d1 -G btm -S btm -x ubuntu -r "recipe[apt],recipe[apt::update],recipe[postgresql::server]" -d chef-full --bootstrap-version 10.12.0