Changing the database user password, Executing sql queries from the cli – Brocade Network Advisor SAN User Manual v12.3.0 User Manual
Page 77
Brocade Network Advisor SAN User Manual
25
53-1003154-01
PostgreSQL database
1
4. On the Set up ODBC connection screen, complete the following steps.
a. Click Browse.
The datasource saved in the odbc.ini file is populated in the Datasource dialog box.
b. Select the datasource and click OK on the Datasource dialog box.
c. Click Next.
5. On the Set up user authentication screen, complete the following steps.
a. Enter the database user name in the User name field.
b. Select the Password required check box.
c. Click Test Connection to test the connection.
The Authentication Password dialog box displays.
d. Enter the database password in the Password field and click OK.
e. Click OK on the Connection Test dialog box.
If an error message (file not found while testing the connection) displays, copy the lib files
from the
f.
Click Next.
6. On the Save and proceed screen, click Finish.
Executing SQL queries from the CLI
To execute SQL queries from the command line interface (CLI) , complete the following steps.
1. Choose one of the following options:
•
On Windows systems, launch the dbsql.bat script in the Install_Home\bin\ directory.
•
On UNIX systems, launch the dbsql script in the Install_Home\bin\ directory.
2. Execute your query from the command window.
3. Close the command window.
Changing the database user password
To change the read/write or read only database password, complete the following steps in the
Install_Home/bin directory.
1. Open a command window.
2. Type dbpassword
User_Name Password New_Password Confirm_Password
and press Enter.
Where
User_Name
is your user name,
Password
is your current password, and
New_Password
and
Confirm_Password
are your new password. The read/write user name and password
defaults are dcmadmin and passw0rd (zero), respectively. The read only user name and
password defaults are dcmuser and password (all lowercase), respectively.
If the password changed successfully, the following message displays:
Password changed successfully.