On Thu, Apr 10, 2014 at 11:30 AM, Andreas Meyer anmeyer@anup.de 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