[postmodern-devel] Authentication
Hi all, It seems it is not possible to connect to a local postgres server using the 'ident sameuser' authentication method - the two functions 'connect' and 'connect-toplevel' both require user and password arguments. I thought perhaps passing empty strings as user and password arguments might be the way to say "use the ident sameuser method" but alas, it raises the error: "Database error 28000: no PostgreSQL user name specified in startup packet" Perhaps this is a feature that is lacking, or am I missing something? Regards, Sebastian P.S. Apologies if this is a FAQ. A Gmane search of this list for 'ident sameuser' returned no results. -- Emacs' AlsaPlayer - Music Without Jolts Lightweight, full-featured and mindful of your idyllic happiness. http://home.gna.org/eap
Hi Sebastian, This is not a FAQ. Postmodern currently only implements MD5-password authentication. I never really looked into the other methods that Postgres supports. If you want to implement other methods, see cl-postgres/messages.lisp and http://www.postgresql.org/docs/current/interactive/protocol-flow.html#AEN797... . It doesn't say anything about 'sameuser' there though, so I'm not sure what the mechanism for that is. Cheers, Marijn
. It doesn't say anything about 'sameuser' there though, so I'm not sure what the mechanism for that is.
i think you cannot use that over the tcp connection cl-postgres supports, only through some C interface which probably goes through some unix sockets on the same machine. -- attila
participants (3)
-
Attila Lendvai -
Marijn Haverbeke -
Sebastian Tennant