Unable to disable a PlaySQL connection: It says "Please select a dialect"

Description

We raised a ticket with you last year regarding our installation of PlaySQL and the fact we wanted to restrict access to it. With your help we successfully changed the configuration so that PlaySQL could only be used by Confluence spaces that had connections explicitly defined, and each space had their own schema in the PlaySQL database.

We discovered recently that PlaySQL has once again become available to all users. I suspect this happened following a routine upgrade and that some values got set back to default settings. We are now trying to set PlaySQL up again so that it is not available to spaces by default and that it can only be used by spaces we have defined connections for.

My understanding is that to disable PlaySQL for general use I need to go into the PlaySQL setup and then into the Database(manual configuration) tab. In here we have a number of contexts. There is a 'Default Values' context, a 'Global Connections' context, and then a context for each of the spaces we have explicitly defined as being allowed to use PlaySQL. I think that what I need to do is 'Disable' the 'Global Connections' context so that any new spaces which try to access PlaySQL do not succeed. (If I've got this wrong and there is another way I should be disabling PlaySQL for general use, apart from the contexts I have defined, then can you let me know what it is please).

When I try to disable the Global Connections context it fails. I go into 'Edit' and then select 'the 'type' box. This has the value of 'Use JNDI Connection'. I'm selecting 'Disable' instead, and then clicking on 'Submit'. Instead of disabling this context I just get the message 'please select a dialect'. I've tried this only some of the other contexts and get the same message. Can you please confirm that what I am doing is the right way to disable PlaySQL from general use, and how I can disable a context. I've attached some screen shots showing the message.
Thanks

Environment

None

Observations

None

Activity

Show:
Adrien Ragot (Old account)
May 30, 2017, 12:05 PM

Finally. Thank you for the feedback!

Julian Flatt
May 30, 2017, 10:38 AM

Thanks Adrien

This has fixed the issue. I've successfully downloaded and enabled v2.12.4 and then used that to 'disable' the Global Connection.

Happy this issue can now be closed.

Thanks

Adrien Ragot (Old account)
May 28, 2017, 4:49 PM

Hi Julian,
For the spreadsheets to work, Confluence needs to show 3 active plugins:

I believe PSEA wasn't active on your installation. Can you check it is enabled? If you don't have it at all, please upgrade to Play SQL Base 2.12.4 (just published) which contains it by default.

Thank you,
Adrien

Julian Flatt
May 26, 2017, 9:31 AM

Hi Adrien

I've updated to v2.12.3 in our test environment. the update worked OK but the addon failed to enable. If I try to manually enable it following the update it still fails. The logs are showing the following error :-
2017-05-26 10:19:04,951 ERROR [http-nio-8090-exec-7] [plugin.osgi.factory.OsgiPluginInstalledHelper] availableForTraversal Cannot determine required plugins, cannot resolve bundle 'com.playsql.base-plugin'
– referer: http://10.64.17.248:8090/plugins/servlet/upm | url: /rest/plugins/1.0/com.playsql.playsql-base-plugin-key | traceId: 57f9f8239a105f16

I've tried this via the 'update' button and also by manually downloading / uploading the new version. Both fail to enable.

Do you have any ideas what the problem could be?

Thanks

Julian

Adrien Ragot (Old account)
May 25, 2017, 10:31 AM

Julian, I've just released Play SQL Base 2.12.3, you can upgrade it from inside your Confluence administration. Tell me if it works well for you.

Resolved

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Julian Flatt