[chef] Re: COOK-1406 (postgresql/pg gem/openssl/libpq problem) still unresolved?

[Greg Symons < >]

The postgresql cookbook rescues the LoadError that occurs when pg fails due to the incompatible SSL to execute the script you linked to below. It's been doing that for quite a while; we've been using it for over a year. Granted, we're still on postgresql 9.1 and postgis 2.0 but for this specific problem it shouldn't make a difference. What version of the postgresql cookbook are you using?

Greg

On 03/24/14 17:19, Liam Kirsher wrote:

" type="cite"> Hi,

I'm trying to get the postgresql recipe to work.  Specifically, using postgis.  For various reasons related to postgis and the gdal lib, I pretty much have to use unbuntu 12.04, and Postgresql 9.3 and Postgis 2.1.
I keep running into COOK-1406, which is a mismatch between the openssl lib linked to by postgresql and chef pg gem.
The issue is marked as closed, but I seem to be running into exactly that issue.  Here's the abbreviated output.

---- Begin output of /opt/chef/embedded/bin/gem install pg -q --no-rdoc --no-ri -v "0.17.1" ----
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.

A comment on the issue by Jessica Bourne states

You actually shouldn't need to customize the bootstrap file to work around this, you can just specify any bootstrap file with -d aside from chef-full when first bootstrapping and it won't use omnibus.

However, when I try that like this

knife solo prepare 192.168.1.X -d ubuntu12.04-gems -x vagrant vagrant

The result is the same.

Joshua Timberman offered a workaround

I was able to get the pg gem to install in the Chef omnibus location with the "install.sh" here:

https://gist.github.com/3954641

However, that seems pretty clumsy. (Also, I think there's a way to include that install.h without running it by hand... what is it?)  I haven't tried it.

Anyway, that was back in Oct 2012. 

Is the postgresql recipe still broken?
Or, have I made some mistake in implementing the workaround listed by Jessica?
What should I do?

Thanks for your help!

Liam

-- 
Liam Kirsher
PGP: http://liam.numenet.com/pgp/