Ok, I hooked up as much debugging as I could understand. It now logs all
connections and queries to /var/log/pgsql.
If I run a normal query, it logs it. When I connect through Courier, it
logs the connection but never any query. The login fails and leaves an
idle postgres process, preventing postgres from shutting down.
Has anybody had success with courier and postgres? It seems like courier
can't even make a query...
Thanks,
Mike
ricky wrote:
What worked well for me when setting it up with mysql was to turn on
database query logging. Set the follwing option true in postgresql.conf
for postgres to do the same. Then you should be able to see just what
is being asked of the database when a user logs in.
DEBUG_PRINT_QUERY (boolean)
Mike D'Agosta writes:
Hi,
I'm having difficulty authorizing my users via pgsql.
But before I post my problems in full, I'd like to know how to get
more verbose output from courier-imap. I am only able to see LOGIN
FAILED... not what user it's trying, what password it's trying, etc.
I'm looking in /var/log/maillog.
Is there some way to increase the verbosity?
Thanks,
3 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Re: PGSQL auth wi...
