On Thu, Apr 10, 2014 at 11:30 AM, Andreas Meyer <[email protected]> wrote: > Am 10.04.2014 20:18, schrieb A.L.E.C: >> On 04/10/2014 07:29 PM, Andreas Meyer wrote: >>> >>> but that does not work. Then I tried the following but that >>> also did not work. >>> $rcmail_config['password_query'] = 'UPDATE mailbox, sasl SET password=%p >>> WHERE username=%u AND password=%o LIMIT 1'; >> >> Create function/trigger >> http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html > > oh my god, that's to much for me.
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. ...Todd -- The total budget at all receivers for solving senders' problems is $0. If you want them to accept your mail and manage it the way you want, send it the way the spec says to. --John Levine _______________________________________________ Roundcube Users mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/users
