Hi did another test if I run from the console mysql postfix -e "update mailbox set last_log = now() WHERE username = 'info@lab.fr'" the field last_log gets updated. but no way to make it work from /etc/dovecot.dovecot.conf
On Feb 11, 2008 8:21 PM, Osvaldo Alvarez Pozo <nebano@gmail.com> wrote:
I did some test & the value of $UID is zero. how could I recover the value of the logged user? Thanks.
On Feb 11, 2008 6:57 PM, mouss <mouss@netoyen.net> wrote:
Hugo Monteiro wrote:
Osvaldo Alvarez Pozo wrote:
i was looking your mail and as I have a data base i added a field to de data base I modified the script so it lokks like this.
#!/bin/sh echo "update mailbox set last_log = now() WHERE username = '$USER'" | mysql postfix exec /usr/dovecot/libexec/dovecot/pop3
but nothing gets written to the field. I think there is a problem with the value of variable $USER, as this is a shell script. Any Ideas?
You should be using $UID and not $USER.
and mysql postfix -e "update ...." instead of echo "..." | mysql ...