EEE Web Service Config - Revision history

Nivin at 06:20, 2 June 2020

2020-06-02T06:20:21Z

← Older revision		Revision as of 06:20, 2 June 2020
Line 1:		Line 1:
	Presently the web.config file for the EEE web service contains the connection string used to connect to the EEE database and any application-specific settings. For this reason, this file is usually left unchanged after initial install.		Presently (as of EEE v1.86) the web.config file for the EEE web service contains the connection string used to connect to the EEE database and any application-specific settings. For this reason, this file is usually left unchanged after initial install.

	However as the web service is serviced and updated, changes are required to the web.config file which cannot be easily deployed to an environment that already has the aforementioned environment-specific settings within.		However as the web service is serviced and updated, changes are required to the web.config file which cannot be easily deployed to an environment that already has the aforementioned environment-specific settings within.

Nivin: /* Web.config */

2020-06-02T06:18:21Z

Web.config

← Older revision		Revision as of 06:18, 2 June 2020
Line 16:		Line 16:
	<configuration>		<configuration>
	…		…
	<appSettings ~~file~~="Settings.config" />		<appSettings configSource="Settings.config" />
	<connectionStrings ~~file~~="Connections.config">		<connectionStrings configSource="Connections.config" />
	…		…
	</configuration>		</configuration>

Nivin: /* Connections.config */

2020-06-02T05:22:34Z

Connections.config

← Older revision		Revision as of 05:22, 2 June 2020
Line 26:		Line 26:
	<nowiki><!-- *************************** CONNECTIONS **************************** -->		<nowiki><!-- *************************** CONNECTIONS **************************** -->
	<!-- EEE Database Connection --></nowiki>		<!-- EEE Database Connection --></nowiki>
	<add connectionString="Data Source=.;Initial Catalog=~~eeeDev~~;Integrated Security=True;Application Name=EEE Web Service;" name="EEEConnectionString"/>		<add connectionString="Data Source=.;Initial Catalog=eee;Integrated Security=True;Application Name=EEE Web Service;" name="EEEConnectionString"/>
	</connectionStrings>		</connectionStrings>

Nivin: /* Connections.config */

2020-06-02T05:22:21Z

Connections.config

← Older revision		Revision as of 05:22, 2 June 2020
Line 24:		Line 24:
	Must contain the connection strings. Move this node here from the Web.config file.		Must contain the connection strings. Move this node here from the Web.config file.
	<connectionStrings>		<connectionStrings>
	<!-- *************************** CONNECTIONS **************************** -->		<nowiki><!-- *************************** CONNECTIONS **************************** -->
	<!-- EEE Database Connection -->		<!-- EEE Database Connection --></nowiki>
	<add connectionString="Data Source=.;Initial Catalog=eeeDev;Integrated Security=True;Application Name=EEE Web Service;" name="EEEConnectionString"/>		<add connectionString="Data Source=.;Initial Catalog=eeeDev;Integrated Security=True;Application Name=EEE Web Service;" name="EEEConnectionString"/>
	</connectionStrings>		</connectionStrings>

Nivin: /* Settings.config */

2020-06-02T05:20:05Z

Settings.config

← Older revision		Revision as of 05:20, 2 June 2020
Line 38:		Line 38:


	In a future version of EEE, the updates to the EEE web service will start overwriting the web.config file with the latest version released with the update. The EEE Service Release Installer (EEEPatch) will warn users ~~when the web.config file will be replaced~~, but the separate Connections.config and Settings.config files are missing.		In a future version of EEE, the updates to the EEE web service will start overwriting the web.config file with the latest version released with the update. The EEE Service Release Installer (EEEPatch) will warn users this is about to happen, but the separate Connections.config and Settings.config files are missing.

Nivin: /* Settings.config */

2020-06-02T05:19:12Z

Settings.config

← Older revision		Revision as of 05:19, 2 June 2020
Line 33:		Line 33:
	<appSettings>		<appSettings>
	<add key="SQLCommandTimeout" value="110"/>		<add key="SQLCommandTimeout" value="110"/>
	<!-- Set to 1 to log the full result into XmlInterfaceLog. 0 to save length only. -->		<nowiki><!-- Set to 1 to log the full result into XmlInterfaceLog. 0 to save length only. --></nowiki>
	<add key="XmlInterfaceLogFullResult" value="0"/>		<add key="XmlInterfaceLogFullResult" value="0"/>
	</appSettings>		</appSettings>

Nivin at 05:17, 2 June 2020

2020-06-02T05:17:17Z

← Older revision		Revision as of 05:17, 2 June 2020
Line 13:		Line 13:
	== Web.config ==		== Web.config ==
	Must contain references to the new files:		Must contain references to the new files:
	~~<code>~~		<?xml version="1.0"?>
	<?xml version="1.0"?>		<configuration>
	<configuration>		…
	…		<appSettings file="Settings.config" />
	<appSettings file="Settings.config" />		<connectionStrings file="Connections.config">
	<connectionStrings file="Connections.config">		…
	…		</configuration>
	</configuration>
	~~</code~~>

			== Connections.config ==
			Must contain the connection strings. Move this node here from the Web.config file.
			<connectionStrings>
			<!-- *************************** CONNECTIONS **************************** -->
			<!-- EEE Database Connection -->
			<add connectionString="Data Source=.;Initial Catalog=eeeDev;Integrated Security=True;Application Name=EEE Web Service;" name="EEEConnectionString"/>
			</connectionStrings>

			== Settings.config ==
			Must contain the application settings. Move this node here from the Web.config file.
			<appSettings>
			<add key="SQLCommandTimeout" value="110"/>
			<!-- Set to 1 to log the full result into XmlInterfaceLog. 0 to save length only. -->
			<add key="XmlInterfaceLogFullResult" value="0"/>
			</appSettings>


	In a future version of EEE, the updates to the EEE web service will start overwriting the web.config file with the latest version released with the update. The EEE Service Release Installer (EEEPatch) will warn users when the web.config file will be replaced, but separate config files ~~were not found for connection str~~		In a future version of EEE, the updates to the EEE web service will start overwriting the web.config file with the latest version released with the update. The EEE Service Release Installer (EEEPatch) will warn users when the web.config file will be replaced, but the separate Connections.config and Settings.config files are missing.

Nivin at 04:59, 2 June 2020

2020-06-02T04:59:43Z

← Older revision		Revision as of 04:59, 2 June 2020
Line 1:		Line 1:
	~~Test~~		Presently the web.config file for the EEE web service contains the connection string used to connect to the EEE database and any application-specific settings. For this reason, this file is usually left unchanged after initial install.

			However as the web service is serviced and updated, changes are required to the web.config file which cannot be easily deployed to an environment that already has the aforementioned environment-specific settings within.

			In order to better address this issue going forward, application settings and connection string will be required to be saved to separate individual files. The web.config file will only have a reference to those files which means it can be easily updated/replaced independently during an update.

			The required structure is 3 x files:

			* Web.config
			* Connections.config
			* Settings.config

			== Web.config ==
			Must contain references to the new files:
			<code>
			<?xml version="1.0"?>
			<configuration>
			…
			<appSettings file="Settings.config" />
			<connectionStrings file="Connections.config">
			…
			</configuration>
			</code>




			In a future version of EEE, the updates to the EEE web service will start overwriting the web.config file with the latest version released with the update. The EEE Service Release Installer (EEEPatch) will warn users when the web.config file will be replaced, but separate config files were not found for connection str

Nivin: Nivin moved page Eee-web-service-config to EEE Web Service Config

2020-06-02T04:42:20Z

Nivin moved page Eee-web-service-config to EEE Web Service Config

← Older revision	Revision as of 04:42, 2 June 2020
(No difference)

Nivin: EEE: SQL Query Executor security considerations

2020-06-02T04:38:41Z

EEE: SQL Query Executor security considerations

New page

Test