[GENERAL] more SSL crash woes....

2008-04-09 Thread Jeff Amiel
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)" As the proud author of this previous post: http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php I never found a real answer except to disable SSL on the connections between my

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Tom Lane
Jeff Amiel <[EMAIL PROTECTED]> writes: > Sure enough...I put a #ERROR at the top of the 'old/incorrect' ssl..h and > did a make clean/make and errored out. > So I was building with 0.9.8 libraries...but 0.9.7 header files. Fascinating. I read your previous mail and was about to reply that /usr/l

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Jeff Amiel
Tom Lane wrote: One idea: you are linking to /usr/local/ssl/lib/libssl.so, but is it possible that when you compile PG it is finding the header files for some other version? Sure enough...I put a #ERROR at the top of the 'old/incorrect' ssl..h and did a make clean/make and errored out. So

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Jeff Amiel
Tom Lane wrote: One idea: you are linking to /usr/local/ssl/lib/libssl.so, but is it possible that when you compile PG it is finding the header files for some other version? yes...if I could figure out how the include path is being set on the postgresql build. I'm looking at the config.log

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Tom Lane
Jeff Amiel <[EMAIL PROTECTED]> writes: > Now their are 2 subscriber nodes that connect to this node for slony > replication... > One is running the same version (libssl 0.9.8e) but one is running > 0.9.7e-p1 2. > could this be an issue? Seems unlikely, that would mean that openssl failed to pre

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Jeff Amiel
Jeff Amiel wrote: Now their are 2 subscriber nodes that connect to this node for slony replication... One is running the same version (libssl 0.9.8e) but one is running 0.9.7e-p1 2. could this be an issue? Note that both nodes are set to 'hostnossl' in the pg_hba.conf -- Sent via pgsql-g

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Jeff Amiel
Tom Lane wrote: The previous thread suggested that you might have a problem with different bits of code being linked to different versions of libssl. Did you ever resolve that? Given the lack of other reports, I'm pretty suspicious that it's something like that, rather than a real bug in either

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Alvaro Herrera
Jeff Amiel wrote: > Stack trace looks eerily familiar: > > Core was generated by `/usr/local/pgsql/bin/postgres -D /db'. > Program terminated with signal 11, Segmentation fault. > #0 0xfee8ec23 in sk_value () from /usr/local/ssl/lib/libcrypto.so.0.9.8 > > *grumble* Did you try installing the O

Re: [GENERAL] More SSL crash woes

2008-04-08 Thread Tom Lane
Jeff Amiel <[EMAIL PROTECTED]> writes: > As the proud author of this previous post: > > href="http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php";> class="yshortcuts" > id="lw_1207670543_0">http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php (Non-HTML posts are pr

[GENERAL] More SSL crash woes

2008-04-08 Thread Jeff Amiel
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)" As the proud author of this previous post: http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php I never found a real answer except to disable SSL on the connections betwee