Configuring Dedicated Log Server - Revision history

Shin at 05:15, 14 May 2021

2021-05-14T05:15:17Z

Shin: /* Installing database server */

2021-05-14T02:24:30Z

Installing database server

Shin: /* Importing an SQL file */

2021-05-13T01:17:27Z

Importing an SQL file

Shin: /* Importing an SQL file */

2021-05-13T01:16:06Z

Importing an SQL file

Shin: /* Importing an SQL file */

2021-05-12T09:41:06Z

Importing an SQL file

Shin: /* Importing an SQL file */

2021-05-12T09:38:06Z

Importing an SQL file

Shin: /* Importing an SQL file */

2021-05-12T09:37:31Z

Importing an SQL file

Shin at 09:24, 12 May 2021

2021-05-12T09:24:12Z

Shin: /* Importing an SQL file */

2021-05-12T08:58:58Z

Importing an SQL file

Shin: /* Importing an SQL file */

2021-05-12T08:07:40Z

Importing an SQL file

@@ Line 26: / Line 26: @@
 if you are familiar with the MySQL syntax, you can also change the user and the remote access by editing lines between 27 and 30 before importing.
-''Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the [[ImRAD services(daemons) | logexp]] service automatically changes the default to the new password that you specify on the "Dedicated Log server" page.
+{{note|Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the [[ImRAD services(daemons) | logexp]] service automatically changes the default to the new password that you specify on the "Dedicated Log server" page.}}
 The below picture is a part of the SQL.<br>
 [[File:imradlog_sql2.png|600px]]
-To import the SQL file, enter the <code>mysql</code> command. The <user> should be "root" and the <password> is the password of the "root" of the database in the dedicated log server.  ''Note that if the operating system of your server is the Microsoft Windows, you must run the Command Prompt as administrator.''
+To import the SQL file, enter the <code>mysql</code> command. The <user> should be "root" and the <password> is the password of the "root" of the database in the dedicated log server.  {{note|Note that if the operating system of your server is the Microsoft Windows, you must run the Command Prompt as administrator.}}
 <pre>
 # mysql -u<user> -p<password> < <path>/imradlog.sql

@@ Line 16: / Line 16: @@
 ===== Installing database server =====
 Install MariaDB 10.0 or higher Database server on your server. MySQL 5.7 or higher is also available. It doesn't matter which operating systems of the database server.
-''Note that if you have already a MariaDB or MySQL server, you can use the server as a log server.''
+{{Note|Note that if you have already a MariaDB or MySQL server, you can use the server as a log server.}}
 ===== Downloading an SQL file =====

@@ Line 31: / Line 31: @@
 [[File:imradlog_sql2.png|600px]]
-To import the SQL file, enter the <code>mysql</code> command. the <user> should be "root" and the <password> is the password of the "root" of the database in the dedicated log server.  ''Note that if the operating system of your server is the Microsoft Windows, you must run the Command Prompt as administrator.''
+To import the SQL file, enter the <code>mysql</code> command. The <user> should be "root" and the <password> is the password of the "root" of the database in the dedicated log server.  ''Note that if the operating system of your server is the Microsoft Windows, you must run the Command Prompt as administrator.''
 <pre>
 # mysql -u<user> -p<password> < <path>/imradlog.sql

@@ Line 24: / Line 24: @@
 Copy the downloaded SQL file into your log server(i.e. Dedicated Log server) and import it into your database by using the <code>mysql</code> command.
 If you import the SQL file, it will create a user account, databases, and tables. The default user is "'''lyonlog'''" and the password is "'''1111'''". The default password will be changed after configuring connection properties.
-if you are familiar with the MySQL syntax, you can also change the user and remote access by editing lines between 27 and 30 before importing.
+if you are familiar with the MySQL syntax, you can also change the user and the remote access by editing lines between 27 and 30 before importing.
 ''Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the [[ImRAD services(daemons) | logexp]] service automatically changes the default to the new password that you specify on the "Dedicated Log server" page.

@@ Line 26: / Line 26: @@
 if you are familiar with the MySQL syntax, you can also change the user and remote access by editing lines between 27 and 30 before importing.
-''Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the [[ImRAD services(daemons) | logexp]] service automatically changes the default to the new password that you specify on the "Dedicated Log server" page.''
+''Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the [[ImRAD services(daemons) | logexp]] service automatically changes the default to the new password that you specify on the "Dedicated Log server" page.
 The below picture is a part of the SQL.<br>

@@ Line 23: / Line 23: @@
 ===== Importing an SQL file =====
 Copy the downloaded SQL file into your log server(i.e. Dedicated Log server) and import it into your database by using the <code>mysql</code> command.
-If you import the SQL file, it will create a user account, databases, and tables. The default user is "'''lyonlog'''" and the password is "'''sxdtLy@log24'''". if you want to change the password before importing the SQL file, modify the query of line 27 after opening the download file by using an editor such as notepad or vi. For example, a new query might be changed like the below.
+If you import the SQL file, it will create a user account, databases, and tables. The default user is "'''lyonlog'''" and the password is "'''1111'''". The default password will be changed after configuring connection properties.
-<pre>
+if you are familiar with the MySQL syntax, you can also change the user and remote access by editing lines between 27 and 30 before importing.
-CREATE USER IF NOT EXISTS 'lyonlog'@'%' IDENTIFIED BY 'mynewpassword';
-</pre>
+''Note that '''DO NOT CHANGE THE DEFAULT PASSWORD''' because the logexp service automatically changes the default to the new password that you specify in the "Dedicated Log server" page.''
-''Note that we recommend that you should change the default password for security reasons.''
 The below picture is a part of the SQL.<br>
-[[File:imradlog_sql.png|600px]]
+[[File:imradlog_sql2.png|600px]]
 To import the SQL file, enter the <code>mysql</code> command. the <user> should be "root" and the <password> is the password of the "root" of the database in the dedicated log server.  ''Note that if the operating system of your server is the Microsoft Windows, you must run the Command Prompt as administrator.''