A script enabled browser is required for this page to function properly.
Skip to main content
StorageTek Tape Analytics Administration Reference Guide, Version 1.0.2
E28379-03
Table of Contents Previous Next Index


Password Administration : Reset the STA Database Application Account Password

Reset the STA Database Application Account Password

Follow these procedures to reset the STA Database Application Account password.

Caution – The STA Database Application Account username and password MUST be synchronized on both STAServer/WebLogic and the MySQL database.

Note – In the following procedures, the example STA Database Application Account username is "staapp".

1.
“Change the WebLogic Data Source Connection Password”
2.
“Click the Connection Pool tab.”
3.
“Stop and Restart all STA Processes”
4.
“Verify STA Session Connectivity”

▼

Change the WebLogic Data Source Connection Password
1.
Point your browser to the WebLogic console login screen.

http://yourHostName:7001/console/

or

https://yourHostName:7002/console/

Note – Use the HTTP or HTTPS port number you selected during STA installation.

2.
Log in using the WebLogic Admin Console username and password you defined during STA installation.
3.
Select Data Sources in the center of the page.

4.
Click on the ORASTADBCONN data source name.

5.
Click the Connection Pool tab.

6.
In the upper left-hand corner, click the Lock & Edit button.

7.
Scroll down, and then enter and confirm the new password.

8.
Click Save at the TOP of the page.

9.
Click the Activate Changes button in the upper left-hand corner of the screen.

10.
Wait until the changes are activated, as indicated by the “All changes have been activated...” message.

11.
Log out of the WebLogic Administration Console.

▼

Change the MySQL STA Database Application Account Password
1.
Log in to the MySQL client as root user.
 
# mysql -uroot  -p
Password: root-password
2.
Enter the use mysql command.
 
mysql> use mysql;
3.
Retrieve the list of STA database usernames.
 
mysql> select distinct(user) from user order by user;
+---------+
| user    |
+---------+
|         |
| root    |
| staapp  |
| stadba  |
| starpts |
+---------+
5 rows in set (0.00 sec)
4.
Take note of the STA Database Application Account username (for example, staapp).
5.
Issue the following commands to change the password of the Database Application Account username.

Note – Replace new-password with the actual new password. Replace user-ID with the actual STA Database Application Account username. Use single quotes around these variables.

mysql> update user set password=PASSWORD('new-password') where user='user-ID';
mysql> commit;
mysql> flush privileges;

Caution – Be sure to make a note of the password you just entered.

6.
Exit out of the MySQL client.
 
mysql> quit;

▼

Stop and Restart all STA Processes
1.
As root on the server on which STA is installed, stop STA processes.
 
# STA stop
Stopping the WebLogic staServer....
Successfully stopped the WebLogic staServer
Stopping the WebLogic Administration Server....
Successfully stopped the WebLogic Administration Server
Stopping the STA Services Daemon (staservd)....
Successfully stopped the STA Services Daemon (staservd)
Stopping the STA database Server....
Successfully stopped the STA Database Server
2.
Start STA processes.
 
# STA start
Starting STA Database....
Successfully started the STA Database
Starting STA Services Daemon (staservd)....
Successfully started the STA Services Daemon (staservd)
Starting WebLogic Administration Server....
Successfully started the WebLogic Administration Server
Starting WebLogic staServer....
Successfully started the WebLogic staServer

Note – It may take 5-7 minutes for the WebLogic staServer to start up.

▼

Verify STA Session Connectivity
1.
Point your browser to the STA GUI login screen.

http://yourHostName:7021/STA/

or

https://yourHostName:7022/STA/

Note – Use the HTTP or HTTPS port number you selected during STA installation.

2.
Log in using the STA GUI Login username and password you defined during STA installation.
3.
If you see a fully-populated Dashboard screen (example below), you have successfully reset the STA Database Application Account password on both the WebLogic server and the MySQL database. If you see an error screen, go to Step 4.

4.
If you see an error screen (example below), then the password you defined for the WebLogic database connector does not match that of the STA database application account in the MySQL database. In such case, repeat the preceding procedures paying close attention to typing the passwords EXACTLY the same in the WebLogic Administration Console and MySQL client.

Table of Contents Previous Next Index Link to documentation
Copyright © 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices