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.
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.
postmodern-devel@common-lisp.net
-
Attila Lendvai -
Marijn Haverbeke -
Sebastian Tennant