Page 1 of 1

Servoy Properties Returning After Reboot

PostPosted: Mon Mar 08, 2021 11:45 pm
by joe26
Hi guys,

I have some servoy_server.properties options returning after a restart of the server.

A phantom database complete with settings that are in the original .war file for the server, but doesn't exist on the target server. Applications are uploaded as .servoy exported Solutions.

The extra database can be removed from the properties file indicated in the JAVA options of Apache (below), and returns after a reboot. Where else is this stored?

Other settings are not overwritten by the file indicated at Settings file for this server: \\WRDS\HMEFILES\STSX\.servoy\server\servoy_server.properties
Code: Select all
server.3.URL=jdbc\:sqlserver\://localhost\:1433;instance\=STSX;DatabaseName\=stsservoy;SelectMethod\=cursor
server.3.catalog=<none>
server.3.connectionValidationType=0
server.3.dataModelCloneFrom=stsservoy
server.3.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.3.enabled=true
server.3.maxConnectionsActive=30
server.3.maxConnectionsIdle=10
server.3.maxPreparedStatementsIdle=100
server.3.password=xxx
server.3.prefixTables=false
server.3.queryProcedures=false
server.3.schema=<none>
server.3.serverName=stsservoy2
server.3.skipSysTables=false
server.3.userName=sa

As well as SSL keystore and password settings, etc.

What are the settings in the deployed.properties file do? I've not had to touch these in the past few installs.
Code: Select all
isOverwriteDeployedDBServerProperties=false
isOverwriteDeployedServoyProperties=false

thanks,
--Joe.

Re: Servoy Properties Returning After Reboot

PostPosted: Tue Mar 09, 2021 10:27 am
by jcompagner
if you want to fully override the existing saved properties on the server you need to have these 2 on true:

isOverwriteDeployedDBServerProperties=true
isOverwriteDeployedServoyProperties=true

else we remember them, if you have saved changes of that server.

Or are you talking the other way around?
you adjusted:
\WRDS\HMEFILES\STSX\.servoy\server\servoy_server.properties

and you expect that that is then fully leading?
Thats also not the case because the servoy.properties inside the war (.war/WEB-INF/servoy.properties) are first loaded then those (\WRDS\HMEFILES\STSX\.servoy\server\servoy_server.properties) are copied over them (so they are kind of merged)

Re: Servoy Properties Returning After Reboot

PostPosted: Tue Mar 09, 2021 5:04 pm
by joe26
Thanks, Johan.

Those settings are only temporary overrides, correct? Meaning it doesn't reset the server to remember the last used settings.

--Joe.

Re: Servoy Properties Returning After Reboot

PostPosted: Tue Mar 09, 2021 5:14 pm
by jcompagner
i am not sure what you are talking about
but for example

isOverwriteDeployedServoyProperties=true

then if "\\WRDS\HMEFILES\STSX\.servoy\server\servoy_server.properties" that file is there
and that file is older then the servoy.properties in the WAR file (so a new deploy)
then that file is completely deleted and you start fully with only the servoy.properties file from the WAR file

Re: Servoy Properties Returning After Reboot

PostPosted: Fri Mar 12, 2021 5:19 pm
by joe26
Johan,

Once the override is complete, can it be reverted back to FALSE?

So that future ROOT.war files use the servoy_server.properties file?

Thanks!

Re: Servoy Properties Returning After Reboot

PostPosted: Fri Mar 12, 2021 5:50 pm
by jcompagner
then in that future ROOT.war don't have those properties set to true