Database Connection Properties
The imRAD use the MariaDB server[1]. If you run the show system mariadb command, it shows the version of the Database.
All Database Connection Properties are securely encrypted. If you want to see properties as plaintext, use the show dci command.
The imRAD consists of three types of Database Connection Properties.
| ID | Name | Description |
|---|---|---|
| 0 | MainDB | It is the properties for imRAD main database. If there are two systems for the purpose of the System Failover, one of them is the main system. In other words, an active system is the main system and it has the main database. |
| 2 | LocalDB | It is the properties for local database. |
| 3 | PeerDB | If you configure the System Failover, these properties are written. If not, no properties for the type 3 exist. |
Note that the leading five characters of the password are marked to * for the purpose of security.
LYSH@MyHostName# show dci 0 Host:127.0.0.1 Port:6710 User-id:lyon User-Password:*****y@nu24
Configuring Database Connection Properties
You can configure the host of Database Connection Properties. However, you don't need to configure because If you configure the System Failover, the properties for other types are set automatically. Therefore, If there's no problem, DO NOT configure the Database Connection Properties.
LYSH@MyHostName# configure configure# dci create 2 127.0.0.1 configure# exit LYSH@MyHostName# show dci 2
Connect to Database(MariaDB)
You can access a database directly if necessary by the mysql command.
If you want to access a database using "root", you must request an One Time Password (OTP) at http://issue.basein.net.