Re: PASSWD with MySQL, Postfix, VirtualDomains/Users
Jan Schneider <[email protected]>
| Newsgroups | gmane.comp.horde.sork |
|---|---|
| Message-ID | <[email protected]> |
Zitat von Gustavo Verduzco Vazquez <[email protected]>: > Quoting Jan Schneider <[email protected]>: > >> Sounds like this query should do what you want: >> >> 'UPDATE users SET password = ENCRYPT(\'%p\') WHERE email = \'%U\'' >> >> Jan. > > Hi Jan! > > Thanks for your answer! I replaced the query in backends.php but I am > still unable to change the password. I get a generic error on the What error? Where? > screen but I can't find anything on the logs, mysql.log, auth.log, > horde.log. Is there a way or a log that I can check to track down the > problem? > > If I am updating the password on the database with the SQL ENCRYPT > function via the query, which encryption option should I use on the > params array? I've tried with md5-hex and plain without success! Should be plain, since you do the encryption in the query, not in PHP code. Jan. -- Do you need professional PHP or Horde consulting? http://horde.org/consulting/ -- Sork mailing list - Join the hunt: http://horde.org/bounties/#sork Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]