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
>
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 |