two unrelated issues, lastlogin, and an out of memory fatal error

[David Mehler]

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 at 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 at 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 at 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 at 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 at mrstuudio.ee
> www.mrstuudio.ee
>
>
>
>