JerryNorton
asked on
Openser installation problem with postgres
Using Openser on Redhat ES4.0.
Postgres 8.1.3 was installed post Linux install (put into /usr/local/pgsql).
Following openser installation, we have error when starting openser:
I get "ERROR:core:sr_load_module : could not open module </usr/local/lib/openser/mo dules/post gres.so>: /usr/local/lib/openser/mod ules/postg res.so: undefined symbol: PQescapeByteaConn"
My postgres installation is done outside of the distro installation. I do not see an option to help the configure / make process find the actual pqxx lib and the pgsql install locations...I assume it found them, but maybe not. openserdbctl worked perfectly.
Postgres 8.1.3 was installed post Linux install (put into /usr/local/pgsql).
Following openser installation, we have error when starting openser:
I get "ERROR:core:sr_load_module
My postgres installation is done outside of the distro installation. I do not see an option to help the configure / make process find the actual pqxx lib and the pgsql install locations...I assume it found them, but maybe not. openserdbctl worked perfectly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks everyone. Problem found to be openser needed the most recent libpq.so from postgres, found in 8.2.x. Installing from rpm wouldn't help (redhat behind on that front). Also, am I the only person that has systems with interdependencies? everyone seems to be willing to upgrade without worrying about compatibility ... regression testing ... etc.
Am splitting the points but if anyone reads this, note that the solution is not quite here. As i could not fiind anywhere on openser's site that includes a required revision level for any module.
Am splitting the points but if anyone reads this, note that the solution is not quite here. As i could not fiind anywhere on openser's site that includes a required revision level for any module.
ASKER
Thanks for trying
ASKER
That was a likely culprit, but I actually did change the Makefile and compile (it says to do this in the instructions, so I wasn't being all that clever).
In /usr/local/lib/modules there is a postgres.so
If I do: strings postgres.so | grep PQ I see
PQescapeByteaConn
and
%s [%d] ERROR:postgres:%s: PQescapeBytea failed
(along with the other usual suspects).