Difference between revisions of "CLI - Database"

Revision as of 11:27, 20 April 2021

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.

↑ https://en.wikipedia.org/wiki/MariaDB

[1] ttps://en.wikipedia.org/wiki/MariaDB

[1]

@@ Line 1: / Line 1: @@
-You can manually change the IP address of a database. The imRAD has four types of databases.
+__FORCETOC__
+=== Database Connection Properties ===
+The imRAD use the MariaDB server<ref>https://en.wikipedia.org/wiki/MariaDB</ref>. If you run the <code>show system mariadb</code> 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 <code>show dci</code> command.<br>
+The imRAD consists of three types of Database Connection Properties.
+{| class="wikitable"
+! style='width:50px' | ID !! Name !! Description
+|-
+| style='text-align:center' | 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.
+|-
+| style='text-align:center' | 2 || LocalDB || It is the properties for local database.
+|-
+| style='text-align:center' | 3 || PeerDB || If you configure the [[System Failover]], these properties are written. If not, no properties for the type 3 exist.
+|-
+|}
-<pre>
+Note that the leading five characters of the password are marked to * for the purpose of security.
-LYSH@MyHostName# configure
+<pre>LYSH@MyHostName# show dci 0
-configure# dci create -h
+  Host:127.0.0.1
-usage: dci create [-h] type host
+  Port:6710
+  User-id:lyon
-positional arguments:
+   User-Password:*****y@nu24
-   type        MainDB(0), LogDB(1), LocalDB(2), PeerDB(3)
+</pre>
-  host        host
-optional arguments:
-  -h, --help  show this help message and exit
-</pre>
+=== 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.
 <pre>
 LYSH@MyHostName# configure
@@ Line 20: / Line 32: @@
 LYSH@MyHostName# show dci 2
 </pre>
+=== Connect to Database(MariaDB) ===
+You can access a database directly if necessary by the <code>mysql</code> command.
+If you want to access a database using "root", you must request an One Time Password (OTP) at http://issue.basein.net.