Return
-
Title
Where is the login info for SharePlex database user saved in Shareplex 8.6 or higher? -
Description
Where is the login info for SharePlex database user saved in SharePlex 8.6 or higher?
-
Cause
General information. -
Resolution
Starting with SharePlex 8.6, the login credentials of SharePlex user are written to and stored in the file named connections.yaml located in /vardir/data subdirectory of SharePlex (where vardir refers to the Variable directory of SharePlex). Here is a sample entry:
alvsupu07 # cat connections.yaml
o.SYAM:
password: 5787d4def4
user: SHA86
In the above, the first line has SID info. The second line has encrypted password and the third line has the name of the SharePlex user that makes connections to the database.
-
Additional Information
It should be noted that in prior versions of SharePlex the login info was stored in the file named paramdb which is also located in the same directory, namely /vardir/data. While paramdb still exists, it now stores the SharePlex parameters which are other than the default, as well as the license key of SharePlex.