[Dovecot] mailbox not acceced

[mouss]

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