11 Feb
2008
11 Feb
'08
6:57 p.m.
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 ...