From: Mario Splivalo <mario.splivalo@megafon.hr>
To: pgsql-admin@postgresql.org
Subject: Re: ssl3 errors in replication.
Date: Thu, 02 Feb 2012 17:24:09 +0100
Message-ID: <4F2AB8A9.7040909@megafon.hr> (raw)
In-Reply-To: <4F2AB6BE.8030506@megafon.hr>
References: <4F2A3D03.20405@megafon.hr>
<25074.1328199374@sss.pgh.pa.us>
<4F2AB6BE.8030506@megafon.hr>
On 02/02/2012 05:15 PM, Mario Splivalo wrote:
> On 02/02/2012 05:16 PM, Tom Lane wrote:
>> Mario Splivalo <mario.splivalo@megafon.hr> writes:
>>> I have these errors in my log files, occurring very often:
>>> 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not
>>> receive data from WAL stream: SSL error: sslv3 alert unexpected message
>>
>> Google suggests that this might be caused by version or configuration
>> mismatches between openssl libraries on the master and slave machines.
>> One particular thing I'm wondering about is whether your openssl
>> libraries deal with the SSL renegotiation bug sanely (ie they've got
>> a fix for it that's less brain-dead than breaking the connection).
>
> Is there a way I can force replication over non-ssl channel? All those
> boxes are in my private network and ssl is a bit overhead there anyhow.
Reading the docs, it shouldn't use SSL when connecting.
Here is my recovery.conf on the slave:
standby_mode = 'on'
primary_conninfo = 'host=10.21.32.22 port=5432 user=replication
password=ueberseecret' # ded803
trigger_file = '/var/run/pg-trigger'
And here is excerpt from pg_hba.conf on master:
root@ded803:~# grep repl /etc/postgresql/9.1/main/pg_hba.conf | grep -v ^#
host replication replication 10.21.32.82/32 md5
host postgres replication 10.21.32.82/32 md5
(The second entry is for munin plugin on slave used to trend the slave lag.)
Mario
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@megafon.hr
Subject: Re: ssl3 errors in replication.
In-Reply-To: <4F2AB8A9.7040909@megafon.hr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox