Forum Activity for @claygordon

Implementing SSO and authentication

Using Jamroom

Michael –

I am asking my developer how he wants to proceed. I think the first step is to see if there is any overlap in the Jamroom/Ghost universe. There is already a OneAll module.

He is, of course, going to offer this on the Ghost side, and we can explore how many Ghost users are interested in a connection to Jamroom communities. If it’s just me? Probably not.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Michael -

Right now, all of the Database Options are set to off. (Global Config-Database Options)

Would it help to turn these on for a couple of days to see what we might find?

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Michael:

I have a lot of log tables. I just took a look at the Activity Log tab System Core - Global Config.

I have Developer Mode on. Not sure why.
Just before I took this screenshot (attached) PURGE was set to never.

I am going to set the purge to 1 day to force a purge ASAP then reset to 10 days and turn developer mode off.

What else should I consider?

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian -

The tech guy I work with – who also handles my Ghost development and hosting – is looking into local network/VM issues that may be affecting performance.

I don’t see an obvious system status dashboard so I am going to have to create a support ticket.

While it took a loooooooooooong time., table optimization was completed and I exited properly. One suggested upgrade to all of the checks would be to add an elapsed time in the completion dialog. Could be useful in diagnosing issues. The regular integrity check took about the amount of time I remember it taking.

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