Hello!
Todd Lyons tlyons@ivenue.com 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