Hello!
Todd Lyons tlyons@ivenue.com schrieb am 11.04.14 um 06:26:03 Uhr:
$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;'
Thank you, I'll try that this evening! Looks good! I tried with one update querie over the two tables with funny results ;)
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.
Yes you are right. It is because first I put the SASL users in a table some month ago. The dovecot useraccounts were in a plain password file. The users complained they can not change their password so I decided to put the users also into another table some days ago. This is the reason for I have two tables now.
I will put them together in one. Sadly I don't know SQL very well so I will have my fun with creating the join you mentioned.
...Todd
Andreas