Forum Activity for @claygordon

Clay Gordon
@claygordon
04/26/24 09:41:20AM
752 posts

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?
PerformanceCheckResults4Dasboard.png PerformanceCheckResults4Dasboard.png - 146KB
Clay Gordon
@claygordon
04/26/24 09:39:15AM
752 posts

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?
Clay Gordon
@claygordon
04/26/24 09:24:43AM
752 posts

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?
PerformanceCheckResults2Dasboard.png PerformanceCheckResults2Dasboard.png - 109KB

updated by @claygordon: 08/02/24 02:16:46PM
Clay Gordon
@claygordon
03/26/24 08:58:39AM
752 posts

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
Clay Gordon
@claygordon
03/24/24 09:44:47AM
752 posts

Create new user account from within ACP


Using Jamroom

Of course, I immediately found it after posting this.
Clay Gordon
@claygordon
03/24/24 09:43:40AM
752 posts

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
Clay Gordon
@claygordon
08/03/23 07:55:24AM
752 posts

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.
Clay Gordon
@claygordon
08/02/23 11:41:35AM
752 posts

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
Clay Gordon
@claygordon
06/29/23 03:19:11PM
752 posts

SSO Jamroom integration with Ghost


Jamroom Developers

Brian – I am slowly refamiliarizing myself with Global and Quota config options.

Say, for the Image Galleries module I deselect “Allowed on Profile." This would allow members of the quota to SEE galleries already published by clicking on the Images button in the top nav but would not allow them to upload.

There is also a media upload module so I could turn off uploading, but I want people to upload images into Forums posts.
  5