Hello list,

This weekend I looked the first time into the password plugin - very great
plugin! Makes Roundcube even better as it already is, congratulations to all
the contributors!

If someone's interested in using Roundcube to be able to change email
account's passwords managed by Confixx, here's a small how to:

1) Grant SQL permissions for Roundcube DB-user:
- SELECT in database confixx, table pop3, coloumns account and longpw
- UPDATE in database confixx, table pop3, coloumn longpw
- UPDATE in database confixx, table allgemein, coloumn newpwd

2) Activate the password plugin in Roundcube main.inc.php:
$rcmail_config['plugins'] = array('password');

3) Copy plugins/password/config.inc.php.dist to
plugins/password/config.inc.php
Change/Verify that driver is set to sql: $rcmail_config['password_driver'] =
'sql';
Use the following SQL query as password_query:
$rcmail_config['password_query'] = 'UPDATE confixx.pop3, confixx.allgemein
SET confixx.pop3.longpw=%c, confixx.allgemein.newpwd=2 WHERE (account=%u)';

A more documented howto with explanations can be found here:
http://www.claudiokuenzler.com/ithowtos/roundcube_change_password_confixx.php

Tested it with Roundcube 0.4-stable resp. SVN version r3897 and works fine.

cheers,
ck
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/8f4f07cd

Reply via email to