Hi did another test if I run from the console mysql postfix -e "update mailbox set last_log = now() WHERE username = '[EMAIL PROTECTED]'" 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 ... > > > > > > > > >
