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