@marcusquinn said in IndieWeb plugin(s) - interesting concept for WordPress -> MicroPub:

What is the IndieWeb?

The IndieWeb is a people-focused alternative to the "corporate web".

Your content is yours

Yeah, pretty much the idea behind adopting and deploying FOSS apps also.
And all indie folks in soul should also be member of this very interesting forum, namely Indie Hackers.

Just stumbled on this, thought people might find interesting.

👍
EDIT: Forgot to mention, that plugin is a great find @marcusquinn

@girish said in Set php.ini memory allocation to match Cloudron memory allocated:

@micmc If it helps: setting memory limit for an app (at the Cloudron level) is like creating a virtual server with that much memory. So, if you allocate 2GB, it's like creating a 2GB server. Inside this 2GB server, there is apache running.

Wow, that's amazing!
And, with the rest of the explanation, it makes it more clear of how this works and how we can better know what we are doing while trying to cope with apps' memory.

I am using this one too - very happy with it 🙂

Allright, thanks !!

There is a new version with one of two issues patched

@girish From 150 to 256, from 256 to 512, now 1024 Mb... Now I deactivated Wordpress Redis Plugin and stopped service under App > Services.

Yeah, deep in the rabbit hold on research on this. There's nothing that distracts me more than something that has a score attached to it 😂 (not competitive all all 🙂 )

Trying to get a clean sheet of green on this:

https://inspectwp.com

Given WordPress is perhaps the most popular self-hosted app of all, be great to have the Cloudron setup as perfect as possible, particularly for WordPress. So many more expensive options out there charging per site. Lots of wins possible from being able to proclaim the best WP setup possible 🙂

@girish Thank's Girish

@girish said in Multiple WP sites sharing wp_users db table:

@ChicagoGregg said in Multiple WP sites sharing wp_users db table:

I would like to share the WP users between the two.

Is this something supported by WP ? How can it share users but not anything else? It writes to db1 for users and db2 for other things like posts/comments ?

Sure, this is done currently on WP sites even when cloudron isn't in the mix. For simplicity of this thread, I was just referring it to wp_users, but it also requires usermeta.

I wonder how the bigger sites using WP also have their topology laid out with MySQL DB's clustered, and even with something like Kubernetes.

I would love to find a tech paper somewhere on this. And then, when it comes to having a larger website that is load balanced across disparate physical locations, how Cloudron could (if possible) be laid out to handle the workload. I'm thinking that it would be difficult and, in these situations, it might be best to simply have a dedicated host running, for example, Docker, Portainer, Kubernetes, MySQL (clustered), etc.

==========

Ok, it might be that I'm the guinea pig for this to test to and validate this works as expected.

I've found the below two articles to be very valuable.

How to Share Logins and Users Between Multiple WordPress Sites - https://kinsta.com/blog/share-logins-wordpress/

The Ultimate Guide to WordPress User Roles and Capabilities - https://kinsta.com/blog/wordpress-user-roles/

After reading the above two, I think the WP sites would have to use the same MySQL database, but have a different DB table prefix for each site (for the non-wp_users and wp_usermeta tables). The WP hook that the first article references is essentially to clone the user capabilities from one site to another within the same MySQL database upon modification.

Basically, here is what I'm working on.

Site #1 - Primary website (domain.org) that hosts the home page / landing page. Introduces the visitor to the society, its features, how the public/private memberships work, how to join, etc. This also will likely handle some administrative-related functions (including plugins), e.g. CRM, Support/Ticketing system, newsletter blasts, etc. This might also be the primary interface for where user roles, metadata, etc. are administered (TBD).

Site #2 - Social website part of the society (domain.social). This runs the social platform, event calendar, etc. It will also have such WP plugins like AutomatorWP and WP Fusion (amongst others).

Site #3 (TBD) - Media platform (domain.tv). This will handle a "media" related matters... Very similar to such sites like YouTube, Rumble, Bitchute, Odyssey, etc. and/or providing a "Netflix-like" type site. Users, based on their membership level, would be able to access this site. The users would likely also be "synchronized" to this site.

For now, I will be working on checking into the feasibility and implications for Site #1 and Site #2 "synchronization".

I will find out also what drawbacks, if any, exist for such things like having AutomatorWP (Site #2) trigger certain events and if it would (could) be picked up by the CRM (Site #1).

I would love to keep the administrative-related functions separate from Site #2 and Site #3. No need to have additional bloat where not needed.

So, within the next month, I plan on getting all this in place. I will do some testing and validation in the next few weeks.

If anyone has information, tips, etc. please do chime in!

Looking forward to checking this out. 🙂

-gregg

On an unrelated note, there's an option in WP dash > Updates to have it auto-install new releases. I noticed some of my sites have that enabled and some don't. It's not a problem, but I mention it because maybe that should be disabled/hidden somehow since this should be handled by the packaging updates.

image.png

Edit: just noticed your latest reply, so I guess WP was auto-updating most of my sites and I thought the packaging was doing that.

Yet, it's very simple to install so I can't see why you went through all the hops.
Just install the plugin, then put in the SMTP credentials found in credentials.txt in the app root in "Other SMTP", done. Host is Mail, port 2525 no SSL nor TLS.

@girish said in ECONNREFUSED:

@MarchinBunny there was a malware in WordPress. Something like https://stackoverflow.com/questions/76268370/wordpress-error-because-mo-files-inside-wp-include .

Exactly, what I expected right from the start of the thread.

But there are lots of plugins in your site, it could be anything.

And, yes some malware could be running in the background for years before one find out.

@jagan Yes as you can only use one theme at a time.

@RazielKanos said in Malware in my Wordpress:

Once a system was infected it is best to set up everything new

And above all, DO NOT install themes and/or plugins which provenance is doubtful.
In WordPress this is 99% the source of 'malware' problems.

@therealwebmaster See https://docs.cloudron.io/apps/wordpress-developer/#php-settings

@RazielKanos 👍 or rename to say .htaccess-backup, then compare new to old.

@marcusquinn I use these commands, via Terminal MySQL Access:

//display active users select user_login, user_nicename, display_name from wp_users; //change user_nicename UPDATE wp_users SET user_nicename = 'myusername' WHERE user_nicename = 'admin'; //change user_login UPDATE wp_users SET user_login = 'myusername' WHERE user_login = 'admin'; //change display_name UPDATE wp_users SET display_name = 'myusername' WHERE display_name = 'admin'; //change user email UPDATE `wp_users` SET `user_email` = "myemail@email.com" WHERE `wp_users`.`user_login` = "myusername"; //change admin password UPDATE WORDPRESSDATABASE.wp_users SET user_pass = MD5('NEWPASSWORD') WHERE user_login = 'myusername';

@girish Thanks, that makes some memory-saving sense, too. My specific issue was just at having the addon enabled, but the plugin disabled, as it makes sense to have it on a live site that isn't being developed, but not during development.