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 ... > > > >
