Application settings
You must set the following configuration in the web.config file to consume from client service:
-
Open the web.config file, search for <services baseUri> section, and set value for baseUri as:
baseUri ="https://<ServerName>/<VirtualDirectoryName>" />
For example, if your server name is <appserver with domain>, and the virtual directory name is <virtual_directory>, then the <baseUri> must be: <services baseUri=" https://<appserver with domain>/<virtual_directory>/">
Password encryption
Database user passwords are currently stored as plain text in configuration files. To store encrypted passwords, proceed as follows:
-
Launch SQL*Plus and connect to your database as M_SYS.
-
Execute this command to get the encrypted password of M_SERVICE user:
select M_PCK_DB.epa('PASSWORD') from dual;
For example:
SQL> select M_PCK_DB.epa('PASSWORD') from dual;
M_PCK_DB.EPA('PASSWORD')
-------------------------------------------------
aw7ZXJ234XD
-
Additionally, the encrypted password is stored in the web.config file, which can be found at:
<Product root>\Web\SRDAPI\Web.config
For SRDDBContext connection string, replace password=m_webapi with password2=aw7ZXJ234XD
Each time the M_WEBAPI password changes, this procedure must be applied again.
The encryption of the connection string is performed on <connectionString> section in the web.config file.
-
Open the command prompt in the administrator mode.
-
Change the directory using cd.. command, and execute the following commands:
-
%windir%\Microsoft.NET\Framework64\v4.0.30319
-
>aspnet_regiis -pef "connectionStrings" "D:\SRD713" . Your password is now encrypted.
-
D:\SRD713 is the web.config file location.
To decrypt the password, use > aspnet_regiis -pdf "connectionStrings" "D:\SRD713".