search cancel

Special Characters in Passwords for SQL server connections in DEVTEST

book

Article ID: 187507

calendar_today

Updated On:

Products

CA Cloud Test Mobile CA Application Test

Issue/Introduction

We are required to change Passwords for connections to SQL Server.

These are generated by DB team and when generated they have special characters.They used these 2... "=" and ",". 

Are there any special characters that can't be used with CA Devtest for IAM/Enterprise Dashboard/ and Registry?

I know item is encrypted but the property setting lisadb.pool.common.password_enc=pswd...  makes it look interesting.

I did not find anything in users manual. 
Please clarify? 

Environment

Release : 10.4

Component : CA Service Virtualization

Resolution

We have verified the above credentials in DevTest and it is working fine without any issue. We don't have any restrictions on the credential's character "=" and ","

For example:

standalone.xml For IAM:

====================
....
.....

<datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true">

   <connection-url>jdbc:sqlserver://[SERVER]:1433;databaseName=sviam</connection-url>

   <driver>mssql</driver>

   <security>

      <security-domain>EncryptDBPassword</security-domain>

   </security>

</datasource>

....

....

<security-domain name="EncryptDBPassword" cache-type="default">

    <authentication>

       <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">

           <module-option name="username" value="svtest"/>

           <module-option name="password" value="-5bae6265eb6a8fcdd0cbc8eed84e75f5"/>

           <module-option name="managedConnectionFactoryName" value="SecuredKeycloakDS"/>

        </login-module>

    </authentication>

</security-domain>


Note: password: sv=test,123





dradis.properties for ED:

====================

lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

lisadb.pool.common.url=jdbc:sqlserver://[SERVER]:1433;databaseName=svlisa

lisadb.pool.common.user=svtest

lisadb.pool.common.password=sv=test,123



site.properties for Registry:

======================

lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

lisadb.pool.common.url=jdbc:sqlserver://[SERVER]:1433;databaseName=svlisa

lisadb.pool.common.user=svtest

lisadb.pool.common.password=sv=test,123

Additional Information

There is no problem using any of the following characters in the SQL Server password: $>^<
If the password contains a % (percent) symbol in it, then while specifying the password in dradis.properties file, replace % with %%
For example if the password of the DB user in SQL Server is v%Rn&$>^%<Fw
Instead of specifying the password in drasis.propertries file as
dradis.db.password=v%Rn&$>^%<Fw
Specify the following:
dradis.db.password=v%%Rn&$>^%%<Fw