<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
we have a problem between radiator 4.9 and postgresql 9.1 on many
machines and have had this problem with Radiator 4.7, 4.8 and
postgressql 8.3, 8.4.<br>
The Problem occurs from 100k Session at a rate of less ~1% while an
update or insert statement from Radiator, the connection is local!<br>
<br>
Logfile Radiator with SSL:<br>
<tt>"Wed Feb 22 09:43:45 2012: ERR: Execute failed for 'select
d.DEVICELOGINPASSWORD, d.DEVICEIP from device d where
d.DEVICELOGINNAME = 'xy' and d.DEVICEENABLED = 'Y'': SSL-Error:
sslv3 alert bad record mac"</tt><br>
<br>
Logfile Postgres with SSL:<br>
<tt>2012-02-22 09:37:09 CET LOG: 08P01: SSL-Fehler: decryption
failed or bad record mac</tt><tt><br>
</tt><tt>2012-02-22 09:37:09 CET ORT: secure_read, be-secure.c:277</tt><tt><br>
</tt><tt>2012-02-22 09:37:09 CET LOG: 08006: konnte Daten vom Client
nicht empfangen: Die Verbindung wurde vom Kommunikationspartner
zurückgesetzt</tt><tt> (no data from client, connection was reset)<br>
</tt><tt>2012-02-22 09:37:09 CET ORT: pq_recvbuf, pqcomm.c:769</tt><tt><br>
</tt><tt>2012-02-22 09:37:09 CET LOG: 08P01: unerwartetes EOF auf
Client-Verbindung</tt><tt> (unexpected EOF from client)<br>
</tt><tt>2012-02-22 09:37:09 CET ORT: SocketBackend, postgres.c:332</tt><br>
<br>
<br>
After debugging this problem we changed the connection method from
IP to Socket without ssl and get the same problem but now without a
ssl error message.<br>
Logfile Radiator Soket:<br>
<tt>"</tt><tt>Wed Feb 22 11:24:46 2012: ERR:</tt><code><span
class="pln"> server closed the connection unexpectedly This
probably means the server terminated abnormally
before </span><span class="kwd">or</span><span class="pln"> </span><span
class="kwd">while</span><span class="pln"> processing the
request</span><span class="pun">.</span></code><tt>"</tt><br>
<br>
Logfile Postgres Soket:<br>
<tt>2012-02-22 11:24:46 CET LOG: 00000: Verbindung empfangen:
Host=[local]</tt><tt> (incomming connection)<br>
</tt><tt>2012-02-22 11:24:46 CET ORT: BackendInitialize,
postmaster.c:3279</tt><tt><br>
</tt><tt>2012-02-22 11:24:46 CET LOG: 00000: Verbindung
authorisiert: Benutzer=radius Datenbank=radius (connection
authorized)</tt><tt><br>
</tt><tt>2012-02-22 11:24:46 CET ORT: BackendInitialize,
postmaster.c:3357</tt><tt><br>
</tt><tt>2012-02-22 11:24:46 CET LOG: 00000: Dauer: 2.930 ms
(duration)</tt><br>
<br>
Sorry for the old and german logentries, but maybe you have some
ideas how to investigate this problem with more details.<br>
<br>
Thanks, Eike<br>
<br>
<br>
<br>
<br>
</body>
</html>