Forum Activity for @claygordon

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian -

db_host is 127.0.0.1 – localhost, not remote. I am on a VPS.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian –

This is the first performance anxiety issue on Contabo. If this persists then I will definitely consider moving back.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian -

Thanks. We will take a look at that. Is there a clue in the attached screenshot?

Implementing SSO and authentication

Using Jamroom

As an FYI, my developer is working on a NodeJS service to make it possible to use OneAll with Ghost.

As this is not an JR plug-in, how would I let JR users know that the NodeJS service is available?

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

I got a notice from Uptime Robot this morning that my JR site (hosted on Contabo) was unreachable for nearly ten minutes.

We ran a server check and it seems to be running smoothly.
I did a database integrity check and it came back okay.

I am doing an optimize tables and the following appear to be taking a very long time each – I am wondering if any of the following message points to a source of the problem? And if yes, what to do about them.

optimizing table: jr_jrcore_log_201901 .... optimizing table: jr_jrcore_log_202401
optimizing table: jr_jrcore_log_debug (VERY long time, like forever).
optimizing table: jr_jruser_item_key
^It looks like I have sufficient free disk space.

After optimizing tables I am still getting a DB Performance check rating of 58.76 with a baseline of 6.5.

This was working fine the last time I checked – a couple of days ago.

Do I need to repair tables?

updated by @claygordon: 08/02/24 02:16:46PM

Implementing SSO and authentication

Using Jamroom

I have a Ghost site at domain.com and I want to implement SSO to my jamroom site at sub.domain.com. Ghost does not have the equivalent of Jamroom forums and I want to make the Jamroom forums available to all members (signups are turned off on my Jamroom site) – even as an archive the traffic is strong and there are about 12,000 posts in the Forum that, right now, are read-only for new visitors.

When someone signs up at ghost it will trigger a webhook event (members.added) and a middleware SSO app will listen to that request & pass it on to JR & a new members account and profile will be created. (There will be a custom sign-up link on the JR side that is passed to the Ghost signup form.)

We are looking at implementing a shared cookie approach as has been recommended but there are questsions about how the authentication mechanism on the jamroom side that I will be posting here. Any general direction on where to look (I have searched the documentation) will be helpful.
updated by @claygordon: 07/26/24 11:52:18AM

Create new user account from within ACP

Using Jamroom

Of course, I immediately found it after posting this.

Create new user account from within ACP

Using Jamroom

For the past couple of years my Jamroom site has been in read-only mode. I am in the process of implementing SSO with ghost and I need to create a new user account for a developer and assign it to the admin profile.

For the life of me I cannot find any button within ACP that will enable me to create a new user account.
updated by @claygordon: 06/23/24 01:28:09PM

System Core update stalled? (self-hosted)

Using Jamroom

Brian:
It turns out the issue was not that the update stalled, just a failure to communicate success. When I reloaded the page I got the success notice. I did an integrity check followed by resetting the caches and all appears okay.

I did not reset the PHP Opcache as it’s new (to me) and I am not sure it’s needed.

Joe – not sure it’s relevant but this instance of Jamroom is at Contabo.

System Core update stalled? (self-hosted)

Using Jamroom

After starting the update to 7.0 the icon is still twirling after about thirty minutes. The cancel button is not active and so I cannot cancel the update that way.

What are the consequences of just closing or reloading the page – and what should I look for on the server (and in what directory) to see if there is a temporary file that should be deleted?

The site is still loading properly in another window.
updated by @claygordon: 11/04/23 02:46:23PM