[MXS-3999] Query Editor New Connection To Drop Down List Show Only Required Option Created: 2022-02-15  Updated: 2022-10-28  Resolved: 2022-09-08

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Naresh Chandra Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

Attachments: PNG File image-2022-02-15-09-15-15-137.png    

 Description   

Implement a backend option for connection to in the query editor, show only what we set in the backend.
Currently we have drop down list is like below.
1. Listener
2. Server
3. Service

Instead of this we want to list only Server and hid the Listener and Service from the drop down list.

in the maxscale.cnf, can you add some parameter related to SQL editor, so that we can configure what we can show in the drop down list.

ex1: sql_connect_to=Server
ex2: sql_connect_to=Server,Service
ex3: sql_connect_to=Server,Service, Listner

Which connection they want they can configure like above. So that every time we dont need to select from the drop down list.



 Comments   
Comment by Duong Thien Ly [ 2022-02-15 ]

Hi naresh.chandra@copart.com, there was a ticket to pre-select listener as the default option: https://jira.mariadb.org/browse/MXS-3837
Depending on the user's usage, some people may prefer to connect directly to a Service or a Server. I would say the user can connect to any resource they want as they probably know what they are doing.
Apart from that, adding parameters to the conf file would just make things complex.

Comment by Naresh Chandra [ 2022-02-15 ]

Yeah Duong,

But for the developers, they may confuse between these options, if we can give backend option would be good so that we can configure it in the maxscale.conf file or GUI also would be good.

Comment by Duong Thien Ly [ 2022-02-17 ]

Hi naresh.chandra@copart.com, I think I can add a dropdown in the `Query configuration` dialog to let users configure which resources to be allowed. But, by default, it would still select all resources.

Comment by Naresh Chandra [ 2022-02-17 ]

Hi Duong,

Thanks for the update, but is it possible to set globally for all the sessions? I mean if set through admin user then it should reflect to all the users.

In the GUI, can you please provide the admin level configuration would be good. so that we don't need to let users do the configurations changes.

Comment by Duong Thien Ly [ 2022-02-17 ]

No, it's only user preferences.

Comment by Naresh Chandra [ 2022-02-17 ]

okay but, if every time user logins so every time he has to change right? or is it one time setting for every user?

For example if we login through AD credentials, so if he changed to server then after it should be always source as a server only right?

Comment by Duong Thien Ly [ 2022-02-17 ]

Everything options in the `Query Configuration` dialog are stored permanently. So even when they log out, it keeps the configuration.

Comment by Naresh Chandra [ 2022-02-17 ]

If that's permanent then it would be good. but I am suspecting that he/she logins through AD (LDAP) credentials then will it be permanent set the configuration or not I am getting doubt on the AD authentication?

and AD user has only read only access, he cant change any settings in the GUI I guess.

Comment by Duong Thien Ly [ 2022-02-17 ]

Currently, all the configurations are stored in localStorage of the browser. So I think I won't have any effect. These configurations are UI-related options, it doesn't interact with the API. So I think it should be fine.

Comment by Naresh Chandra [ 2022-02-17 ]

Okay, that's why I asked for global settings using the admin user. Anyhow we will see it.
Thanks for the clarification.

Comment by Naresh Chandra [ 2022-02-18 ]

Hi Duong,

Will it fix in the next release?

Comment by Duong Thien Ly [ 2022-02-18 ]

Hi naresh.chandra@copart.com, I think this could be in our summer release. But I'll leave it to our PM to decide.

Comment by Naresh Chandra [ 2022-02-18 ]

Hi Duong,

Thanks for the update.

Todd Stoffel, can you please fix this coming release?

Comment by Naresh Chandra [ 2022-09-20 ]

Hi Todd,

Can we try any other way or user level configuration settings? So, that every time no need to select from the drop down list.

Comment by Naresh Chandra [ 2022-10-28 ]

Hi Todd,

Can we have a check box initially and it will save under user preferences so that that every time no need to select from the drop-down list.

Generated at Thu Feb 08 04:25:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.