Passwd + MySQL

[email protected] Sun, 18 Oct 2009 12:38:24 +0200
Newsgroups gmane.comp.horde.sork
Message-ID <[email protected]>
Hello,

my authentication to Horde IMP is working fine using Dovecot + MySQL,  
but I cannot succeed with password management via Horde Sork Passwd.
I suspect wrong Horde and/or Passwd configuration or queries errors.

In my Passwd backends.php I have :

(...)
   'driver' => 'sql',
          'params' => array(
              'phptype'    => 'mysql',
              'hostspec'   => 'localhost',
              'username'   => 'xxxxx',
              'password'   => 'xxxxx',
              'encryption' => 'md5-hex',
              'database'   => 'xxxxx',
              'table'      => 'xxxxx',
              'user_col'   => 'userid',
              'pass_col'   => 'password',
              'show_encryption' => true,
              'query_lookup' => 'SELECT password FROM users WHERE  
userid = %u;',
              'query_modify' => 'UPDATE users SET password = %e WHERE  
userid = %u;',

Questions :

- Horde Authentication should be setup (via 'sql + custom queries') to  
the MySQL used by Dovecot, correct ?
- same for Passwd as written herebefore, correct ?

Please could you post your files conf.php and backends.php file for  
Passwd and Horde ?

My versions are:

Horde-3.3.5
Imp-h3-4.3.5
Passwd-h3-3.1.1

Many thanks.

Bye,
Bruno



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

-- 
Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]