Skip to end of metadata
Go to start of metadata

 

Overview

This document explains the procedure for changing the password of the sys account.

 

Version

ALTIBASE HDB version 4 or later

 

Procedure

To change the password for the sys account, follow the three steps below.

 

1. Execute the alter user command

Connect to the Altibase server as the sys user and change the password with the alter user command.

 

2. Execute altipasswrd

Execute while the Altibase server is online.

Example of executing altipasswd

altipasswd is...

Icon
  • When the ALTIBASE HDB server is in shutdown stage, it checks the sys account password by referring to the syspassword file. 
  • Executing altipasswd changes the syspassword file. This file is located under the $ALTIBASE_HOME/conf directory.

3. Modify the script containing the sys password

The three scripts below contain the sys password.

So, when changing the sys password, these scripts also need to be modified.

  • server script
    Change the password after the -p option in the $ALTIBASE_HOME/bin/server script to the new password.

  • is script
    Change the password after the -p option in the $ALTIBASE_HOME/bin/is script to the new password.

  • il script
    Change the password after the -p option in the $ALTIBASE_HOME/bin/il script to the new password.

Solution

What to do if an "Invalid password" error occurs when starting the server

a. Open the $ALTIBASE_HOME/bin/server script and check if the password has been modified in the lower part.

ADMIN="${ALTIBASE_HOME}/bin/isql -u sys -p manager -sysdba -noprompt"

ISQL="${ALTIBASE_HOME}/bin/isql -s localhost -u sys -p manager -silent"

 

b. If an invalid password error occurs even though the above is applied with the changed password, it is possible that the sys password was changed only with the alter user command and altipasswd was not executed.

In this case, execute altipasswd, apply the changed password, and then try to start the server.

 


  • No labels