Hello! Todd Lyons <[email protected]> schrieb am 11.04.14 um 06:26:03 Uhr:
> Untested, but try making two SQL commands: > > $rcmail_config['password_query'] = 'UPDATE mailbox SET password=%p > WHERE username=%u AND password=%o LIMIT 1; UPDATE sasl SET password=%p > WHERE username=%u AND password=%o LIMIT 1;' > > Although I do have to ask, why do you have two tables with identical > information? This is the perfect case for all backend services to be > using a common table for the user/pass with a JOIN to tie other bits > of data together with that auth info. I'm blind. This is how postfix queries the sasl table: pwcheck_method: auxprop auxprop_plugin: sql mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5 sql_engine: mysql sql_hostnames: 127.0.0.1 sql_user: xxx sql_passwd: xxx sql_database: mailxxx sql_select: SELECT password FROM sasl WHERE username = '%u@%r' so I just had to change the querie to the table 'mailbox'. How easy it can be. Thanks for the help and this nice piece of software! Andreas _______________________________________________ Roundcube Users mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/users
