5 messages in net.sourceforge.lists.courier-sqwebmailRe: [sqwebmail] Bug Report: sqwebmail...
FromSent OnAttachments
XantiusFeb 12, 2005 7:21 pm 
Brian CandlerFeb 13, 2005 2:00 am 
Brian CandlerFeb 13, 2005 3:37 am 
XantiusFeb 13, 2005 7:24 am 
Brian CandlerFeb 14, 2005 1:15 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [sqwebmail] Bug Report: sqwebmail can't change passwords in mysql dbActions...
From:Brian Candler (B.Ca@pobox.com)
Date:Feb 14, 2005 1:15:23 am
List:net.sourceforge.lists.courier-sqwebmail

On Sun, Feb 13, 2005 at 08:24:31AM -0700, Xantius wrote:

In any case, it turns out that when I reinstalled, I didn't give my mysql user update permissions. The proper query WAS being sent, so watching debug stuff wasn't helping much.

It should have helped you lots - it showed that the right update was being sent, and therefore the problem lay elsewhere.

You should also have got "setpass SQL failed" in your authentication debugging log:

[from authmysqllib.c]

if (courier_authdebug_login_level >= 2) dprintf("setpass SQL: %s", sql_buf); if (mysql_query (mysql, sql_buf)) { dprintf("setpass SQL failed"); rc= -1; auth_mysql_cleanup(); }

This code could probably be improved to log the actual mysql error, which would be 'insufficient privileges' or somesuch.

Brian.