Changing the dba Password

If required, change the SQL Anywhere database password for the dba user in the consolidated database (CDb) or the clusterdb database.

Use caution when changing the passwords for the dba. If passwords get out of sync, Sybase Unwired Platform does not work as expected. The dba password in the CDb need not be the same as the dba password in the clusterdb database.

This topic uses the passwords "secret" and "secret2" as examples. You can set the passwords to whatever values you want.

Perform the following tasks for each server in the cluster, except where otherwise noted.

Shut down all instances of Unwired Server in the cluster.
Shut down the UAF Agent on each cluster machine by changing to \UnwiredPlatform-1_2\UAF-2_6\bin, and running:
```
uafshutdown -U supAdmin -P s3pAdmin
```
On any of the cluster machines, launch Interactive SQL by changing to \UnwiredPlatform-1_2\Servers\SQLAnywhere11\bin32, and running:
```
dbisql
```
Note: Make the changes in this tool once only. The next time the cluster is synchronized, the changes are distributed to each server in the cluster.
1. Change the dba password in the CDb. Select ODBC Data Source Name, click Browse, and select uaml_<your cluster name>, then click OK.
2. In the dialog, enter the following:
```
grant connect to dba identified by secret2
```
3. To execute the command, click the right arrow.
4. To close this session, select SQL > Disconnect .
5. To open a new connection, select SQL > Connect .
6. Change the dba password in the clusterdb database. Select ODBC Data Source Name, click Browse, and select clusterdb_<your cluster name>, then click OK.
7. In the dialog, enter the following:
```
grant connect to dba identified by secret
```
8. To execute the command, click the right arrow.
Change to \UnwiredPlatform-1_2\UAF-2_6\plugins\com.sybase.uepadminplugin.
In a text editor, open agent-plugin.xml, and for the uep.server.list property, set the third value to the password you set for the clusterdb database; for example, "secret".
```
<set-property property="uep.server.list" value="('abcXP', 'dba', 'secret', ' ')" />
```
Change to \UnwiredPlatform-1_2\Servers\UnwiredServer.
In a text editor, open createdsn.bat, search for "uid=dba;pwd=" and change the password that follows the equal sign. There are three instances you must change, two for clusterdb and one for uaml.
Save the file, then on a command line, run:
```
createdsn
```
In the ODBC Administrator, verify the new entries:
1. Select Control Panel > Administrative Tools > Data Sources (ODBC) .
2. Select the System DSN tab.
3. Double-click uaml_<your cluster name>, then click Test Connection. You should see a message box that says "Connection Successful." Click OK twice to return to the System DSN tab.
4. Double-click clusterdb_<your cluster name>, then click Test Connection. Again, you should see "Connection Successful." Click OK twice, then close the ODBC Administrator.
Using a text editor, open updateProps.bat, and add "-p secret", as shown below, where "secret" is the dba password for the clusterdb:
```
com.sybase.ep.utils.ClusterRegistration -p secret
```
Save and close the file, then on a command line, run:
```
updateProps -v
```
Change to \UnwiredPlatform-1_2\Servers\UnwiredServer\config.

Using a text editor, open default-data-sources.xml, and change the password values for the uaml and clusterdb dataSource definitions. In the following example, the uaml password is set to "secret2" and the clusterdb password is set to "secret".

<setProperties dataSource="uaml" merge="false">
      <property name="databaseType" value="Sybase_ASA"/>
      <property name="user" value="${default-asa-user}"/>
      <property name="password" value="secret2"/>
      <property name="portNumber" value="4747"/>
      <property name="serverName" value="localhost"/>
      <property name="maxPoolSize" value="0"/>
      <property name="serviceName" value="uaml"/>
      <property name="jdbc:ALTERNATE_SERVER_NAME" value="this_cluster_name_uaml"/>    
    </setProperties>
.
.
<setProperties dataSource="clusterdb" merge="false">
      <property name="databaseType" value="Sybase_ASA"/>
      <property name="user" value="${default-asa-user}"/>
      <property name="password" value="secret"/>
      <property name="portNumber" value="4747"/>
      <property name="serverName" value="localhost"/>
      <property name="serviceName" value="clusterdb"/>
      <property name="maxPoolSize" value="0"/>
      <property name="jdbc:ALTERNATE_SERVER_NAME" value="this_cluster_name_clusterdb"/>  
      <property name="commitProtocol" value="optimistic"/>  
    </setProperties>

Save and close the file.
Change to \UnwiredPlatform-1_2\Servers\UnwiredServer, and run:
```
updateProps -r
```
Restart the UAF Agent. Change to \UnwiredPlatform-1_2\UAF-2_6\bin, and run:
```
uafstartup
```
Restart Unwired Server.