Hello Aki and everyone,

"Increase memory, your cache takes more memory than you have anticipated."

What setting do I need to update in dovecot? I hope your not talking about the vps it has 4GB of ram.

Thanks. Dave.

On 4/12/18, Reio Remma reio@mrstuudio.ee wrote:

Hey,

maybe it's like Aki said, you need more memory. :) Other than that I can't think of anything. :/

Good luck, Reio

On 12.04.18 2:42, David Mehler wrote:

...

Hello,

Thanks a lot. That did it.

Do you have any idea as to my other issue, the fatal out of memory one?

Thanks. Dave.

On 4/11/18, Reio Remma reio@mrstuudio.ee wrote:

...

Hello, try:

SELECT userid, FROM_UNIXTIME(last_login) FROM users;

Reio

On 11.04.2018 21:39, David Mehler wrote:

...

Hi,

Can I get the database display to display those timestamps in a particular format?

Thanks. Dave.

On 4/11/18, Reio Remma reio@mrstuudio.ee wrote:

...

On 11.04.18 18:23, David Mehler wrote:

...

Hello Aki,

Thanks for your suggestion. I followed it and the wiki at:

https://wiki.dovecot.org/Plugins/LastLogin

Good news, I get a record in the users table, with the username that just logged in. This is good. Bad news is I got unexpected output from the last_login time stamp. Here's the table and the user:

mysql> describe users; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | userid | varchar(255) | NO | PRI | NULL | | | last_login | int(11) | YES | | NULL | | +------------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)

mysql> select * from users; +------------------------+------------+ | userid | last_login | +------------------------+------------+ | user@domain.com | 1523459718 | +------------------------+------------+ 1 row in set (0.01 sec)

The issue is the 1523459718 I was expecting something like a time stamp. Is this fixable? Also, can I use last_login to see on which IP the user last logged in from? SELECT FROM_UNIXTIME(1523459718)

Maybe that will help?

Good luck, Reio

-- Tervitades Reio Remma

MR Stuudio 25 aastat

*MR Stuudio OÜ* Tondi 17b, 11316, Tallinn Tel +372 650 4808 Mob +372 56 22 00 33 reio@mrstuudio.ee www.mrstuudio.ee