Debian Jessie 2.8.0 libdbi-drivers cannot find libpq.so

[Josh Stompro]

While installing EG 2.8.0 on Debian Jessie AMD64, I see the following problem when installing the libdbi-drivers dependency.

The configure step errors out with

checking for PostgreSQL support... no
configure: error: Invalid PostgreSQL directory - libraries not found.

The sources are downloaded from:
# The libdbi sources can be fetched from sourceforge.net. They are stored on
# the open-ils.org site now for ease of direct linking
export LIBDBI=libdbi-0.8.3
export LIBDBI_DRIVERS=libdbi-drivers-0.8.3
export LIBDBI_HOST=http://open-ils.org/~denials/evergreen

What seemed to work for me was to edit the configure file of the libdbi-drivers to add the new path to libpq.so. Jessie AMD64 puts it under "/usr/lib/x86_64-linux-gnu/", adding that to pgsql_libdirs allows the configure to complete. (After commenting out the untar step for libdbi-drivers also so the changes don't get overwritten.)

Is 0.8.3 the only version that currently works, can the version shipping with Jessie be used, libdbi 0.9.0-4 and libdbd-pgsql 0.9.0-3?

Josh

[Jason Stephenson (jstephenson)]

I believe so, on 2.7.1+. See:

https://bugs.launchpad.net/evergreen/+bug/1366964

[Josh Stompro (u-launchpad-stompro-org)]

I removed the 0.8.3 dbi/dbd-pgsql from my 2.8.0 install and installed the packaged versions from jessie and things seem to work just fine.

Here is a branch that changes the Jessie dependency install to install the package versions, and updates the section in the install docs for DBI.

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/lp1445182_jessie_libdbi_build

Josh

[Ben Shum (bshum)]

Pushed this change to master and backported to rel_2_8 and rel_2_7 for better Debian Jessie support. Thanks Josh!

[Dan Wells (dbw2)]

Hello all,

I know this bug was for Jessie, but I finally updated my Debian box from Squeeze to Wheezy (7.8), and am seeing this same issue there. Has anyone else run into this on Wheezy?

Thanks,
Dan

[Yamil (ysuarez)]

Dan,

I had this issue with with Wheezy and trying to install EG 2.7.5 with PG 9.2, so it would match my production server.

Here is the initial email I posted to the dev list...
http://libmail.georgialibraries.org/pipermail/open-ils-dev/2015-October/009961.html

Blake (aka bmagic), who has been helping me with this, pointed this bug out. I followed his suggestions to manually put in this patch from this bug report mentioned earlier....
http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/lp1445182_jessie_libdbi_build

Thanks to the patch I was able to successfully install EG 2.7.5, but with PG 9.2 with the concerto data set.

Good luck,
Yamil