@d19dotca I fixed this now. It cleans up certs which expired 6 months ago.

@d19dotca said in Loading Event Log page throws ER_OUT_OF_SORTMEMORY: Basically the real settings are coming from /etc/mysql/mysql.cnf, right? Yes, they are the same file as you found out. In any case, the change I made is good because ORDER BY <xx> should always have xx indexed in the database to lower memory use.

@robi That's the icon!

@girish Thanks for that command. It is indeed strange and I haven't seen it on other Cloudrons, so something must have got stuck with this one. Not a big deal, but it's nice to have that message not displaying any more.

@rcdncn An update. I goofed and it's working now. My first try I navigated to app/data/.htaccess and there was no <IfModule mod_php7.c> I noticed that there is both and htaccess and a .htaccess and I was in the incorrect file.

@nj Use this: https://omm.ovh.net/ , very fast and no any data amount limitations.

@girish Cool, thank you kindly. It's just for incoming mail to those addresses for the time being, but I may add auto-responders from them as well at some point. For interest, I'm setting up all sorts of automations in EspoCRM, so tasks@domain.com will create a Task record and auto-reply to confirm it's been created. Doing similar for other data objects to.

@girish I think that would be a good change. I also think I should have gone through the Troubleshooting document sooner : https://docs.cloudron.io/troubleshooting/ Thanks!

@ethanxrosen right, first migrate to 18 - https://docs.cloudron.io/guides/upgrade-ubuntu-18/ and then 20.

@d19dotca Sadly, they do match. I'm guessing it's something with my current setup that's acting funny. I'll ignore it for now since I plan on migrating either to the new Contabo server that I got or upgrading my current one at DO to Ubuntu 20.04. I just thought it was a wrong setting on my part. Thank you for looking into this and for sharing the custom spam rules! I know you've put a lot of time into that [image: 1620396102638-2443c4d7-ec13-4149-add3-28e1e7ad48ed-image.png]

@mastadamus right, the spamlists won't work if those lookups get blocked. Currently, if the lookups fail, the mail server will simply go ahead and try to detect spam via spamassassin. It's just one of the metrics for spam detection. I guess it's fine if it's working OK for you without it .

Ok, I solved it. I had to delete all my DNS settings that previously existed and then reset them. Once I did this within milliseconds Cloudron started working. Whew, I was sweating bullets there for a minute.

@d19dotca Yes, I think you're right, thank you. I need to look into that. Or move some long term storage files ("archive") into Minio. That might just be moving the problem, but dividing the problem might be a partial solution.

added a Feature Request for #2 -- please upvote https://forum.cloudron.io/topic/5027/pop3-gmail-polling-support

@girish that fixed the issue. Thanks!

@girish thanks for the guidance, that's exactly what I was looking for

@d19dotca Okay, that is a bit confusing, but I will only be able to figure it out once I try it. I appreciate everyone's help and responses.

@nebulon Yes before rebooting I tried to umount-remount but it seems it has been impossible due to an error... So I decided to restart. About auto-remounting it will be an amazing feature

@derin If email works, you can just click Reset password in the login page and you will get an email with the reset link. If email is wrong or does not work, you can SSH into the server and run cloudron-support --admin-login. This will give you a one time use password (will also print the username to use). You can then go to Profile and change the password. Note that you have to run the command again to get a new password when changing the password.