Re: SSL connection issue via perl

From: George Woodring <george(dot)woodring(at)iglass(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SSL connection issue via perl
Date: 2016-01-05 14:04:13
Message-ID: CACi+J=QahGOJXXp8DCKa7Ua0nEOS+mGZcN=+bmwB+PJrCvHP4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just to add a final resolution to this thread, my solution was to add "use
Net::SSL" to the top of my script. Even though my script does not use SSL
directly, I think this must have helped in loading the libraries in an
order that let everything work.

Thanks for the help

iGLASS Networks
www.iglass.net

On Thu, Dec 31, 2015 at 2:29 PM, George Woodring <george(dot)woodring(at)iglass(dot)net
> wrote:

> OS: CentOS 6.6
> Postgres Version: 9.3.10
>
> I have a script that is worked for years that does the following
>
> - Connect to postgres and get a list of URLs to poll for status
> - close connection
> - Start threads to poll the URLs
> - cleanup threads and collect the results.
> - Connect to postgres and write the url status.
> - close connection
>
> We updated perl SSL libraries to the latest version, one of which was
> Net::SSLeay 1.35 -> 1.72
>
> Now the script dies without any feedback when attempting the 2nd
> connection. The only hint at the problem is
>
> /var/log/messages
> Dec 31 14:04:03 iprobe002 kernel: iPoller2.pl[16044] general protection
> ip:7f677fde112c sp:7fff5db9e328 error:0 in SSLeay.so[7f677fd6a000+94000]
>
> /var/log/postgresql
> Dec 31 14:04:03 iprobe002 postgres[16255]: [4-1] LOG: could not accept
> SSL connection: EOF detected
>
> I have worked around the immediate issue by keeping the 1st connection
> open for the entire script instead of making 2 connections, but I would
> like to try to find out what is going wrong.
>
> Any suggestions would be appreciated.
> Thanks,
> George
>
>
> iGLASS Networks
> www.iglass.net
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mohammed Ajil 2016-01-05 14:13:08 Getting the function definition from oid in before firing the function
Previous Message Riley Berton 2016-01-05 13:42:04 Re: BDR and TX obeyance