[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: SSPI authentication failed for user "xxx"
From: Albert Praveen <albertpraveen () live ! com>
Date: 2023-05-29 6:18:12
Message-ID: BY5PR14MB40363204B6BF1F36A7F45B89D44A9 () BY5PR14MB4036 ! namprd14 ! prod ! outlook ! com
[Download RAW message or body]
Hello,
Following the upgrade from version 12.5 to 12.14, you have encountered an issue where \
the windows application fails to connect, and the log messages indicate the \
following:
FATAL: SSPI authentication failed for user "xxx".
DETAIL: Connection matched pg_hba.conf.
The application establishes a successful connection when the connection string \
contains: "Host=localhost;Port=18083;Database=DBName;Username=xxx;Timeout=60;Command \
Timeout=60;Integrated Security=True;"
However, it fails when the string contains "SSL Mode=Require;Trust Server \
Certificate=True;", and reverting back to version 12.5 resolves the issue.
It is worth noting that pgAdmin uses the same usermap and connection is successful. \
You have also attempted to add the Active Directory user to the usermap, but the \
connection remains unsuccessful.
We appreciate your detailed explanation of the situation and will provide assistance \
accordingly.
Thanks
Albert Praveen
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} \
</style> </head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof"> Hello,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof ContentPasted0"> Following the upgrade from \
version 12.5 to 12.14, you have encountered an issue where the windows application \
fails to connect, and the log messages indicate the following: <div><br \
class="ContentPasted0"> </div>
<div class="ContentPasted0">FATAL: SSPI authentication failed for user \
"xxx".</div> <div class="ContentPasted0">DETAIL: Connection matched \
pg_hba.conf.</div> <div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">The application establishes a successful connection when \
the connection string contains:</div> <div \
class="ContentPasted0">"Host=localhost;Port=18083;Database=DBName;Username=xxx;Timeout=60;Command \
Timeout=60;Integrated Security=True;"</div> <div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">However, it fails when the string contains "SSL \
Mode=Require;Trust Server Certificate=True;", and reverting back to version 12.5 \
resolves the issue.</div> <div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">It is worth noting that pgAdmin uses the same usermap and \
connection is successful. You have also attempted to add the Active Directory user to \
the usermap, but the connection remains unsuccessful.</div> <div><br \
class="ContentPasted0"> </div>
We appreciate your detailed explanation of the situation and will provide assistance \
accordingly.<br> </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof ContentPasted0"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof ContentPasted0"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof ContentPasted0"> Thanks</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);" class="elementToProof ContentPasted0"> Albert Praveen</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic