Skip site navigation (1) Skip section navigation (2)

Re: 8.3 problems with sspi authentication

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Matthias Mohr <Matthias(at)Mohrenclan(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.3 problems with sspi authentication
Date: 2008-02-27 09:27:25
Message-ID: 20080227092725.GG5916@svr2.hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
I am using it, and it works very well for me. I've only been using it on
domain attached machines though - but often using it to access the server
only locally.

Do you have any non-microsoft software installed on the machine that could
be interefering somehow. Like AV or other "security" products?

The error you're getting is something like "function not supported", which
shouldn't happen...

Eh, unless, you do have sspi in your pg_hba.conf, right, not gssapi?

//Magnus

On Wed, Feb 27, 2008 at 10:08:15AM +0100, Matthias Mohr wrote:
> It seems that nobody else has problems with the sspi authentication :-(
> Is somebody even using the sspi authentication for Windows?
> Did it work without problems?
> What environments do you use (domain, active directory, local windows user, 
> ...)?
> 
> There must be some reason why it doesn't work here!
> But I need more informations on where I can have a look at to find a 
> solution for my problem.
> 
> with regards,
> Matthias
> 
> ----- Original Message ----- 
> From: "Matthias Mohr" <Matthias(at)mohrenclan(dot)de>
> To: <pgsql-bugs(at)postgresql(dot)org>; "Christian Ullrich" <chris(at)chrullrich(dot)net>
> Sent: Sunday, February 24, 2008 10:12 AM
> Subject: Re: [BUGS] 8.3 problems with sspi authentication
> 
> 
> >Hi Christian,
> >
> >thanks for your answer
> >>>I tried to use the new sspi authentication in PostgreSQL 8.3 to directly
> >>>use a Windows user for PostgreSQL authentication. So for a test I changed
> >>[...]
> >>>I'm using Windows XP Professional with SP2 and a lot of additional
> >>
> >>Do you have "Simple File Sharing" enabled? If so, the client user is 
> >>always
> >>authenticated as Guest. The Guest user is usually disabled, which makes
> >>authentication fail.
> >No, "Simple File Sharing" is not enabled.
> >
> >And even the PostgreSQL service itself is unable to start when I enable 
> >SSPI...
> >
> >BTW, I use a German language version of Windows XP Pro if that matters.
> >
> >with regards,
> >Matthias
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 1: if posting/reading through Usenet, please send an appropriate
> >      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >      message can get through to the mailing list cleanly
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

In response to

Responses

pgsql-bugs by date

Next:From: Pieter JansenDate: 2008-02-27 09:56:30
Subject: Re: panic? return of the btree-bug
Previous:From: Matthias MohrDate: 2008-02-27 09:08:15
Subject: Re: 8.3 problems with sspi authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group