12.3.3 dbchangepassword.bat (changing the database password)
- Organization of this subsection
(1) Function
Changes the password for the database that is used by JP1/DH - Server.
You can use alphanumeric characters and the following symbols in this command:#
& | < > ( ) % ^ ; , ' \ ! ? # $ ~ - = @ + * . /
- #
-
Do not use any characters or symbols except the ones described above in a password. If you use any characters or symbols other than the ones described above, you might not be able to change the password any more.
Also, make sure that you make changes to the following configuration file and batch file after changing the password:
-
digikatsuwide.xml
- File path
-
installation-folder\misc\digikatsuwide\digikatsuwide\WEB-INF\digikatsuwide.xml
Description of changes
<persistence> <database> <password>password-after-change</password> </database>Example:
<persistence> <database> <password>Dh8%7uK0(z$a</password> </database> -
dbcreate.bat
- File path
-
installation-folder\setup_util\dbcreate.bat
Description of changes
set PGPASSWORD=password-after-change
Example:
set PGPASSWORD=Dh8%7uK0(z$a
(2) Executor
A user with a built-in Administrator account or with Administrator permissions executes the command from the command prompt.#
- #
-
Do not execute a command directly. Use the command prompt to execute a command.
(3) Format
dbchangepassword.bat password-before-change password-after-change
(4) Arguments
- password-before-change
-
Specify the current password.
If you use any of the following symbols, append a caret (^) escape character to the symbol, and then enclose the caret and symbol in double quotation marks:
& | < > ( ) % ^ ; , ' \
- password-after-change
-
Specify a new password.
If you use any of the following symbols, append a caret (^) escape character to the symbol, and then enclose the caret and symbol in double quotation marks:
& | < > ( ) % ^ ; ,
In addition, if you use one of the following symbols, append a backslash (\) escape character to the symbol:
' \
(5) Execution results
The database password is changed.
(6) Return codes
|
Return code |
Description |
Operation after an event occurrence |
Occurrence condition |
|---|---|---|---|
|
0 |
Normal |
-- |
The password is changed successfully. |
|
4 |
Warning |
Interrupts command processing. |
Execution of the command is canceled during password change confirmation response. |
|
8 |
Warning |
Interrupts command processing. |
No argument is specified. |
|
16 |
Warning |
Interrupts command processing. |
The number of specified arguments is incorrect. |
|
32 |
Error |
Interrupts command processing. |
The password change failed. |
(7) Output message (Output destination: stdout)
|
No. |
Message |
Return code |
Operation after an event occurrence |
Action to be taken by the operator |
Occurrence condition |
|---|---|---|---|---|---|
|
1 |
The DB password will be changed to ******. Are you sure? (y/n) |
-- |
Waits for user response. |
Select y to continue execution, or n to cancel execution. |
When a command is executed |
|
2 |
The password will be changed. |
-- |
Starts command execution. |
None |
When y is selected in No. 1 |
|
3 |
Successfully changed the password. Press any key. |
0 |
Terminates command execution. |
None |
When the password is changed successfully |
|
4 |
Specify an argument. Press any key and try again. |
8 |
Terminates command execution. |
Specify the current database password and new database password as the arguments, and then re-execute the command. |
When no argument is specified |
|
5 |
The number of arguments is invalid. Press any key and try again. |
16 |
Terminates command execution. |
Specify the current database password and new database password as the arguments, and then re-execute the command. |
When the number of specified arguments is incorrect |
|
6 |
Did not successfully change the password. Press any key and try again.# |
32 |
Terminates command execution. |
Check the content of the output error message, remove the cause of the error, and then re-execute the command. |
When the password change failed |
|
7 |
Canceled command execution. Press any key. |
4 |
Terminates command execution. |
If you selected n in No. 1, specify the new password, and then execute the command. |
When n is selected in No. 1 |
#: If an error occurs within the database, this error message is output after an error message is output by the database.
(8) Notes on using the command
Do not execute a command directly. Use the command prompt to execute a command.
If you have enabled UAC (User Account Control) in the operating system, use one of the following ways to execute a command:
-
Log in as a built-in Administrator user, start the command prompt, and then execute a command.
-
Log in as a user with Administrator permissions, start the command prompt by clicking Run as Administrator, and then execute a command.
-
Execute a command from a shortcut for the command prompt with the elevated privileges created at the time of JP1/DH - Server installation.#
- #
-
If you use a command prompt in this way in Windows Server 2012, Windows Server 2012 R2 or Windows Server 2016, you need to install Microsoft .NET Framework 3.5. For details about how to install Microsoft .NET Framework 3.5, see D. Installing .NET Framework 3.5.
Simultaneous executions of commands on the same machine are not supported.