[Dovecot] mailbox not acceced

[Osvaldo Alvarez Pozo]

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