Hi Guys Do you know where all the Server Admin settings are stored. Are they put into a MySQL DB, somewhere? The reason I ask , is because we have 600 DSNs which I have successfully imported using:

ConfigImport()

The problem is, it doesn't seem to record any of these settings:

"allowAlter":true,
"allowCreate":true,
"allowDelete":true,
"allowDrop":true,
"allowGrant":false,
"allowInsert":true,
"allowRevoke":false,
"allowSelect":true,
"allowStoredProcs":true,
"allowUpdate":true,

All these settings are TRUE in the Server Admin I want to go into the DB and change them. I don't fancy having to manually change 600 DSNs manually across 6 PRE PROD/PROD boxes. UPDATE: I have actually found the DSNs in:

lucee-server.xml

But, there are no Allowed Operations attributes in the

<data-source>

node? And when we run some of the databases, the connections fail. After we manually set REVOKE/GRANT to FALSE, the connections succeed. It seems that by default, all these operations are set to TRUE, which doesn't seem to agree with: https://github.com/lucee/Lucee/blob/3a563f215bc6060f0410a36099f5310300f0cf75/core/[…]c/main/java/resource/component/org/lucee/cfml/Administrator.cfc When I manually change the values of REVOKE/GRANT in the Lucee Server Admin to FALSE, and I check the XML in:

lucee-server.xml

There is no mention of REVOKE/GRANT anywhere? So Lucee must be storing this data in a Database somewhere?

the only storage is in the xml file, there's no database involved. most likely the configImport command doesn't yet support those options

Can I use: https://github.com/lucee/Lucee/blob/3a563f215bc6060f0410a36099f5310300f0cf75/core/[…]c/main/java/resource/component/org/lucee/cfml/Administrator.cfc

UpdateDatasource()

instead, to add the Allowed Operations? It seems that if I run this method:

<cfadmin action="updateDatasource" name="" type="" newName="" host="" database="" port="" username="" password="" allowedRevoke="false" allowedGrant="false" />

That might work?

yep, it's all using the same functions, just that configImport needs to be updated, can you file a bug?

The weird thing is that Lucee doesn't seem to store the Allowed Operations anywhere, but the checkboxes in the Lucee Server Admin reflect the state, correctly? So, where are they reading the values from?

@pothys-mitrahsoft?

Unless the

Allowed Operations

values are stored in the Application scope? Which seems a bit ropey? But you can only change the values manually, using the GUI. If I can find out where the raw values are being stored, I may be able to change 600 values more easily, using find/replace with regex etc

no it's only stored in the xml.

I promise you the A*llowed Operation* values are not stored in the XML. I have checked very methodically, once I changed the values via the GUI

@zackster yup, the A*llowed Operation* values not stored in lucee-server.xml file

Do you know where they are stored?

allow="511" is this bit packed?

Yes. I see allow=“511” in lucee-server.xml data source XML node

Why has it been done like this? Why not just have an attribute called

grant=“false”

or

revoke=“true”

. It’s not very intuitive?

it's old skool n faster, anyway that's how it is

Do you know what value for all true, except for revoke & grant?

the logic in the last link from pothys does some bit bashing with these values https://github.com/lucee/Lucee/blob/5.3/loader/src/main/java/lucee/runtime/db/DataSource.java#L40

OK. I understand now...

Do I have to restart Lucee, if I change

lucee-server.xml

lucee checks for updates every 60s i think

I will do this, either this evening or tomorrow, as we have to deploy our

ACF -> Lucee

fixes to production, very soon. Tight schedule. I will let you know the results... Thank you for fixing this. 🙏

no, it's not merged, you you need to drop it into the deploy folder

In CommandBox, once I have dropped the snapshot into:

C:\Users\ADMCharlesr\.CommandBox\server\F52F378669CF969E685912784C2D3D37-luceeCfconfigTest\lucee-5.3.9.166\WEB-INF\lucee-server\deploy

Should I restart the server or do I need to install the snapshot via the Lucee Server admin:

it should automatically pick it up within 60s

So this looks correct?

perfect

OK. Here we go...

wooohooo, thanks for testing!

No worries. My team will be very pleased...🙂

can you comment on the ticket, if you haven't already?

I am not sure whether this is relevant to your fix, but I did get an error when it tried to insert a MSSQL DSN All the PostGreSQL DSN were successfully added, but 268 MSSQL were not added? Now this may be because I was trying to add PRE PROD DSNs in a Dev environment, or it maybe that I don't have the correct driver? But I thought I should mention this, even though your fixed worked for 5 DSNs...

diff problem

Yes. That's what I thought... That's why I didn't mention, it immediately...