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