On Mon, Aug 07, 2006 at 10:53:55AM -0400, Jay Lee wrote: > > Courier is formatting the query and attempting to run it against the > postgres server but fails to get anything back. Either the connection > to Postgres is failing or Postgres is failing to return a result with > the query. Can you try connecting to postgres via command line and see > if you can run the query manually? Be sure to try it from the Courier > server and using the same username/pass that courier is using to try and > connect. >
OK. Running the query manually revealed that I made a typo in the GRANT statement in my script that created the tables and views. I have now granted that user the ability to select on that view. Here is the new output. Aug 7 10:58:52 arecibo imaplogin: Connection, ip=[::ffff:127.0.0.1] Aug 7 10:58:52 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGIN Aug 7 10:58:52 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], [EMAIL PROTECTED] Aug 7 10:58:52 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=secret Aug 7 10:58:52 arecibo imaplogin: authdaemon: starting client module Aug 7 10:58:52 arecibo authdaemond.pgsql: received auth request, service=imap, authtype=login Aug 7 10:58:52 arecibo authdaemond.pgsql: authpgsql: trying this module Aug 7 10:58:52 arecibo authdaemond.pgsql: SQL query: SELECT email, password, '', uid, gid, home, maildir, '', name, '' FROM composite WHERE email = '[EMAIL PROTECTED]' Aug 7 10:58:52 arecibo authdaemond.pgsql: supplied password 'secret' does not match encrypted password '$1$5ebe2294ecd0e0f08eab7690d2a6ee69' Aug 7 10:58:52 arecibo authdaemond.pgsql: authpgsql: REJECT - try next module Aug 7 10:58:52 arecibo authdaemond.pgsql: FAIL, all modules rejected Aug 7 10:58:52 arecibo imaplogin: authdaemon: REJECT Aug 7 10:58:57 arecibo imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1] Aug 7 10:58:57 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGIN Aug 7 10:58:57 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], [EMAIL PROTECTED] Aug 7 10:58:57 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=secret Aug 7 10:58:57 arecibo imaplogin: authdaemon: starting client module Aug 7 10:58:57 arecibo authdaemond.pgsql: received auth request, service=imap, authtype=login Aug 7 10:58:57 arecibo authdaemond.pgsql: authpgsql: trying this module Aug 7 10:58:57 arecibo authdaemond.pgsql: SQL query: SELECT email, password, '', uid, gid, home, maildir, '', name, '' FROM composite WHERE email = '[EMAIL PROTECTED]' Aug 7 10:58:57 arecibo authdaemond.pgsql: supplied password 'secret' does not match encrypted password '$1$5ebe2294ecd0e0f08eab7690d2a6ee69' Aug 7 10:58:57 arecibo authdaemond.pgsql: authpgsql: REJECT - try next module Aug 7 10:58:57 arecibo authdaemond.pgsql: FAIL, all modules rejected Aug 7 10:58:57 arecibo imaplogin: authdaemon: REJECT Aug 7 10:59:02 arecibo imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1] Aug 7 10:59:02 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGIN Aug 7 10:59:02 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], [EMAIL PROTECTED] Aug 7 10:59:02 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=secret Aug 7 10:59:02 arecibo imaplogin: authdaemon: starting client module Aug 7 10:59:02 arecibo authdaemond.pgsql: received auth request, service=imap, authtype=login Aug 7 10:59:02 arecibo authdaemond.pgsql: authpgsql: trying this module Aug 7 10:59:02 arecibo authdaemond.pgsql: SQL query: SELECT email, password, '', uid, gid, home, maildir, '', name, '' FROM composite WHERE email = '[EMAIL PROTECTED]' Aug 7 10:59:02 arecibo authdaemond.pgsql: supplied password 'secret' does not match encrypted password '$1$5ebe2294ecd0e0f08eab7690d2a6ee69' Aug 7 10:59:02 arecibo authdaemond.pgsql: authpgsql: REJECT - try next module Aug 7 10:59:02 arecibo authdaemond.pgsql: FAIL, all modules rejected Aug 7 10:59:02 arecibo imaplogin: authdaemon: REJECT Aug 7 10:59:07 arecibo imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1] Aug 7 10:59:07 arecibo imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGOUT Aug 7 10:59:07 arecibo imaplogin: LOGOUT, ip=[::ffff:127.0.0.1] Regards, -Roberto -- Roberto C. Sanchez http://familiasanchez.net/~roberto
signature.asc
Description: Digital signature
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Courier-imap mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
