@girish strange that you don’t see that error on a fresh instance, that’s how I reproduced the problem before to compare a fresh DB with my used ones and noticed it on the fresh one too. I’ll look into that further. Thanks 😊

@privsec 512mb is the highest I've got any of mine set, and that's mostly just me ramping up things for Nextcloud in the hope it somehow speeds it up. In reality it's not even using half of that. Most I've got on any WordPress website is 256MB. But again, seemingly not even using half of that most of the time. So strange that you're went up so insanely high.

BTW, once configured to use Cloudron mail, you can track the activity in the mail server event log - https://docs.cloudron.io/email/#event-log

Perfect! I ran some tests today with tweaking various numbers and looked at recommendations online too. It's mostly a copy of yours @imc67 in the end but with a lower MaxConnectionsPerChild. Ran a bunch of different tests with different numbers but concluded that was the best bang for the buck so-to-speak given the 4 GB memory max set on each WP app.

It's a mix of default values from the Ubuntu install and the default Apache values in the original package too (for the 256 MaxRequestWorkers for example). I'm pleased with the results. 🙂

Here's what I have for reference now, and I used ab (Apache Benchmark) to run some performance tests and had significant improvements over the defaults. Thought I'd share the testing results in case anyone was interested.

New mpm_prefork.conf I'm using:

# Restart the app if you make changes to this file <IfModule mpm_prefork_module> # On startup, start these many servers StartServers 5 # At any given time, keep atleast these many servers MinSpareServers 5 # At any given time, keep atmost these many idle servers (this is always >= MinSpareServers+1) MaxSpareServers 10 # Maximum number of servers at any given instant. Requests will be queued after this MaxRequestWorkers 256 # Recycle process after handling these many requests. This protected against accidental memory leaks MaxConnectionsPerChild 500 </IfModule>

Resources:

https://httpd.apache.org/docs/2.4/mod/prefork.html https://exampleconfig.com/view/apache-ubuntu20-04-etc-apache2-mods-available-mpm_prefork-conf https://www.woktron.com/secure/knowledgebase/133/How-to-optimize-Apache-performance.html https://www.maketecheasier.com/optimizing-apache-part-1/

Results from ab with default settings that come with Cloudron's WP package: (note the rather large spread between min and max request times)

Concurrency Level: 50 Time taken for tests: 12.391 seconds Complete requests: 1000 Failed requests: 0 Total transferred: 84813000 bytes HTML transferred: 84205000 bytes Requests per second: 80.70 [#/sec] (mean) Time per request: 619.574 [ms] (mean) Time per request: 12.391 [ms] (mean, across all concurrent requests) Transfer rate: 6684.04 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 227 291 36.4 287 401 Processing: 220 281 122.2 252 1039 Waiting: 144 190 120.0 161 954 Total: 451 572 127.3 546 1285 Percentage of the requests served within a certain time (ms) 50% 546 66% 570 75% 584 80% 594 90% 624 95% 818 98% 1091 99% 1261 100% 1285 (longest request)

Results after tweaking to the above new configuration: (note that the max request time here is about 60% faster still than original config results and overall a much more consistent behaviour too!)

Concurrency Level: 50 Time taken for tests: 11.358 seconds Complete requests: 1000 Failed requests: 0 Total transferred: 84813000 bytes HTML transferred: 84205000 bytes Requests per second: 88.04 [#/sec] (mean) Time per request: 567.899 [ms] (mean) Time per request: 11.358 [ms] (mean, across all concurrent requests) Transfer rate: 7292.24 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 230 287 26.9 283 389 Processing: 220 252 17.3 249 329 Waiting: 144 160 10.0 157 217 Total: 467 539 33.0 538 649 Percentage of the requests served within a certain time (ms) 50% 538 66% 550 75% 559 80% 567 90% 584 95% 599 98% 618 99% 622 100% 649 (longest request)

@d19dotca that was too easy. Thanks a lot!

@jdaviescoates

That did the trick. Thanks for the prompt feedback and suggestion!

@girish okay I’ll try that, thanks for looking into it Girish! It’s definitely odd and I’m surprised I only recently discovered this concern. Some of them definitely existed before Cloudron days and came over as part of the “all in one migration” plugin which I have a feeling overwrite the database to match the original source, so likely is part of the reason there. Some newer ones also have it though but thinking further I think it’s because it was an issue in the template one I spun up new site builds from.

I’ll try converting and hopefully that’ll help with some stuff. Will report back on whether it’s successful or not 🙂

@WiseMetalhead if you can write to support@cloudron.io, we can take a look. Hard to tell what is going wrong with the screenshot.

@girish yeah, i was just freaking out into the forum. nobody else to talk to about this stuff in my world 😅 explanation in the other thread - but i think ... THINK i have that issue solved.

@girish i put in a self made plugin with nothing but a drop table command and it didn't fire off immediately so i thought it didnt work .. but when i went back a few hours later to dig thru those logs .. they were gone! 🤷🏽‍♂️ i also turned off wp-cron and scheduled everything manually at a more modest rate - and since I haven't had any issues.

bece7023-9ebf-4d16-ad58-824ce432eea1-image.png

except this 👆🏽 its listing myhouseofhearing.ca at 1.2GB and i CANT figure out why. looking through WinSCP or File Manager, there's nothing in there that ought to be so big!
im going to run -prune on the docker later this evening, and hope that clears up too, but im out of ideas for the wp site!

are there any 3rd party apps i could install to get a more accurate look at the filesystem and resource usage??

@adpiadmin ah cool, I will mark this as solved then.

@subven
88a0c3ba-7f31-4ec8-9f1a-5de551e2869d-image.png

@jdaviescoates said in What to do if old theme is not compatible with new php?:

Also, in my case the specific file which is no longer compatible appears to simplexlsx.class.php and I'm not sure the site is actually making use of that anywhere (it seems it is a Excel reader and we aren't using anything to do with Excel anywhere on the website), so can't help wondering if I could just delete that file...

Ah, tried that on the cloned version of the app I'm debugging things with and of course (as I half expected) I then got a load of errors for files that refer to that file... so I deleted those references too...

And now it seems to be working fine!

So for now I'll just do the same thing on the actual app and then update.

Perhaps in the future I'll need to do the scrape to static HTML thing... but no immediate need now (but still interested in easy ways to accomplish that).

@subven said in Wordpress Update Message:

@robi make a clone from a backup and update the cloned site. Take a look at the live log while opening the site. It will tell you exactly where it breaks and why. For me it was because of outdated themes and old plugins and I fixed 6/8 sites so far.

Excellent insight!
Thanks 🙂

@privsec Filter admin access by IP address, check this article:

Securing WordPress admin area and wp-login.php via VPN

Let me know

@necrevistonnezr Can you try php -v ?

root@74a6cc7a-143b-4085-a8c8-ecd1555d8cc7:/app/code# php -v PHP 8.1.12 (cli) (built: Oct 28 2022 17:39:37) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.12, Copyright (c) Zend Technologies with the ionCube PHP Loader v12.0.2, Copyright (c) 2002-2022, by ionCube Ltd. with Zend OPcache v8.1.12, Copyright (c), by Zend Technologies

It shows above that it's there .

@subven said in smtp mailer config lost after restore from backup:

@girish AFAIK passwords in environment variables change after restart (from what I remember regarding the LAMP app) so what is the point in hardcoding them into something like a plugin? You could use the variable for SMTP_PASSWORD in your config file though.

Assuming you mean the Cloudron part, the Cloudron environment variables are kept "constant" over the life cycle of an app. Initially, our idea was to change these periodically automatically for security but it seems people put the database values into into other apps which breaks. So, we didn't implement it.

As for putting it in the plugin, the smtp plugin we use reads the password from the database and does not use config.php - https://plugins.trac.wordpress.org/browser/smtp-mailer/trunk/main.php#L725 .

@jdaviescoates said in Is xmlrpc.php file necessary for wordpress?:

I highly recommend installing WordFence on every single WordPress install.

@jdaviescoates Very good advice 👏 They keep secured all Wordpress instances, even before of owner plugin updates, when they find any threat.

@nebulon I unzipped before uploading the content via drag & drop into the file manager window.

I used the All in One Migration plugin that has always worked great before (but think this is the first time I've used it with a wordpress.com site)

And yeah, whilst I had saved permalinks on goopagain, perhaps a good ol' go hit save on permalinks over on goop might've done the trick 🤷