[sork] Passwd Problems - Cannot Change password, no UPDATE applied

[Simon Brereton]

> -----Original Message-----
> From: Simon 
> Sent: Wednesday, October 21, 2009 2:17 PM


> > -----Original Message-----
> > From: sork-bounces at lists.horde.org [mailto:sork-
> bounces at lists.horde.org]
> > On Behalf Of Eric Jon Rostetter
> > Sent: Wednesday, October 21, 2009 12:06 PM
> 
> 
> > > So, the db lookup is checking against form entry and failing.
> >
> > Yeah, either it isn't getting a value (username or password is wrong;
> I
> > think
> > we can rule out permissions, firewalls, etc. since you get a sql log
> > entry)
> > or getting the wrong value (doesn't match form value, or encryption
> type
> > is wrong, or encoding is wrong), or your sql query is wrong (maybe
> needs
> > a custom sql query instead of the default one).
> 
> That's what I meant below when I said the custom sql queries were in
> backends.php (but commented out).  I presume if they aren't commented,
> then they override the ones in main.php?  In anycase, I've tried with
> and without custom queries and I see the same thing in the logs.  I
> think we can rule that out.
> 
> You do raise one issue - for some reason when mysql create databases -
> unless I specify UTF-8 - it defaults to latin1_swedish_ci - do you think
> this could be the issue?  (On a side note, I'd love to stop mysql from
> doing that..).

So, I've changed the database to UTF-8 (not that it should have mattered).  Same result.

I've tested that the password Firefox is putting in is correct by the simple expedient of trying to "change" the password with the (current) correct password.  Passwd correctly sees these two strings as the same. 

So, we're back looking at what the DB says.  I've tested the query - the default one and the customised one in backends.php - I still have no idea what passwd is seing, but these queries return the correct result in the mysql cli interface (basically, I've just pasted them from the log).  I did note that the log contains a call to the horde before it makes a call using the sql backend I set up.  Is this normal?

091022 19:59:45     576 Connect     root at localhost on
                    576 Init DB     horde
                    576 Init DB     horde
                    576 Init DB     horde
                    576 Query       SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'simon at lydiard.net' AND (pref_scope = 'passwd' OR pref_scope = 'horde') ORDER BY pref_scope
                    577 Connect     postfix at localhost on
                    577 Init DB     Mail
                    577 Init DB     Mail
                    577 Query       SELECT Password  FROM MailAccounts  WHERE EmailAdd = 'simon at lydiard.net'
                    576 Quit
                    577 Quit

I've tried encrypting both.

I've tried adding the BD to the SELECT/UPDATE queries (just in case something in $deamon wasn't working properly.

I'm at a loss to see what else I can do - I wish there was a way to add debug lines to main.php so I could see the variable being returned to mail.php.


Any more hints/tips are welcome.

Thanks.

Simon