Osvaldo Alvarez Pozo wrote:
i changed permissions, but no results
So i added a field to the table mailbox like this:
alter table mailbox add last_login datetime NOT NULL default
'-00-00 00:00:00';
That's not a strictly valid date. better use a real date ('1970-01-01
00:00:00' for insta
On Mon, 11 Feb 2008, Osvaldo Alvarez Pozo wrote:
i changed permissions, but no results
Are you sure the connection is opened correctly? If I were debugging this
on my machine I'd:
1) Add something to check that the MySQL connection is fine:
mysql postfix -e "select now()" > /root/dovecot-
i changed permissions, but no results
So i added a field to the table mailbox like this:
alter table mailbox add last_login datetime NOT NULL default
'-00-00 00:00:00';
for the moment I run two cron jobs
1 egrep "dovecot: (imap|pop3)-login" /var/log/mail.log >/var/log/maillog
2 /root/account
On Mon, 11 Feb 2008, Osvaldo Alvarez Pozo wrote:
Hi
did another test if I run from the console
mysql postfix -e "update mailbox set last_log = now() WHERE username
= '[EMAIL PROTECTED]'"
the field last_log gets updated.
but no way to make it work from /etc/dovecot.dovecot.conf
Sounds like a p
Hi
did another test if I run from the console
mysql postfix -e "update mailbox set last_log = now() WHERE username
= '[EMAIL PROTECTED]'"
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 <[EMAIL PROTECTED]> w
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
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
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 not
On Mon, 11 Feb 2008, Hugo Monteiro wrote:
Osvaldo Alvarez Pozo wrote:
Hi
I wonder how can I know if a mailbox is not beeing consulted. I mean I
have severals mailboxs but I know some account are not used. I like to
know how to determine wich mail accounts are not beeing used. Is there
any way i
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
Osvaldo Alvarez Pozo wrote:
Hi
I wonder how can I know if a mailbox is not beeing consulted. I mean I
have severals mailboxs but I know some account are not used. I like to
know how to determine wich mail accounts are not beeing used. Is there
any way in dovecot to know the las time a user loged
Osvaldo Alvarez Pozo wrote:
Hi
I wonder how can I know if a mailbox is not beeing consulted. I mean I
have severals mailboxs but I know some account are not used. I like to
know how to determine wich mail accounts are not beeing used. Is there
any way in dovecot to know the las time a user loged
12 matches
Mail list logo
