EditDiscussionPage history

Difference between revisions of "Configuring Dedicated Log Server"

Line 14: Line 14:
  
 
=== Configuring Dedicated Log Server  ===
 
=== Configuring Dedicated Log Server  ===
 +
==== Installing database server ====
 
1. Install MariaDB 10.0 higher Database server. MySQL 5.7 or higher is also available. It doesn't matter which operating systems of the database server.
 
1. Install MariaDB 10.0 higher Database server. MySQL 5.7 or higher is also available. It doesn't matter which operating systems of the database server.
  
Line 19: Line 20:
  
 
3. Copy the SQL file into your log server(i.e. Dedicated Log server) and import it into your database by using the <code>mysql</code> command.<br>
 
3. Copy the SQL file into your log server(i.e. Dedicated Log server) and import it into your database by using the <code>mysql</code> command.<br>
−
''Note that if the operating system of your server is the Windows system, you must run the Command Prompt as administrator.''
+
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 user or password before importing the SQL file, modify the query of line 27 after opening the download file by using an editor such as notepad. For example, a new query might be the below.
−
[[File:imradlog_sql.png|400px]]
 
 
<pre>
 
<pre>
−
# mysql -u<user> -p<password> < <your_directory>/imradlog.sql
+
CREATE USER IF NOT EXISTS 'myuser'@'%' IDENTIFIED BY 'mypassword';
 
</pre>
 
</pre>
−
If you successfully import the SQL file, it creates a user account, databases, and tables.
 
  
−
또는 imRAD 장비에서만 접속이 가능하게 계정을 생성할 수 있습니다.
+
The below picture is a part of the SQL.<br>
 +
[[File:imradlog_sql.png|600px]]
 +
 
 +
To import the SQL file, enter the <code>mysql</code> command. the <user> and <passowrd> is the existing account of the database in the dedicated log server.<br>
 +
''Note that if the operating system of your server is the Windows system, you must run the Command Prompt as administrator.''
 
<pre>
 
<pre>
−
mysql> CREATE USER 'newuser'@'imRAD-IP-Address' IDENTIFIED BY 'user_password';
+
# mysql -u<user> -p<password> < <your_directory>/imradlog.sql
−
mysql> GRANT type_of_permission ON database_name.table_name TO 'username'@'imRAD-IP-Address';
 
−
mysql> flush privileges;
 
−
</pre>
 
−
 
 
−
newuser, user-password 그리고 imRAD-IP-Address는 사용 환경에 맞게 변경하세요.
 
  
−
3. 데이터베이스 및 테이블 생성
+
# mysql  -uroot -pmypaddword < c:\imradlog.sql # Windows
−
환경설정 > 로그 전용 서버> 대상 로그에서 쿼리 파일(imradlog.sql)를 다운로드 하여<br> 서버로 복사 후 다음과 같이 로그 데이터베이스에 Import 합니다.<br>
+
# mysql -uroot -pmypaddword < /home/user/imradlog.sql # linux
−
이 멸영은 리눅스 프롬프트나 윈도우즈 cmd 환경에서 실행해야 합니다.
 
−
<pre>
 
−
mysql -unewuser -puser_password < imradlog.sql
 
 
</pre>
 
</pre>
−
 
+
<br>
 +
4. Configuring Connection properties
 
5. imRAD 환경설정 > 로그 전용 서버 <br>
 
5. imRAD 환경설정 > 로그 전용 서버 <br>
 
5-1. 로그 서버 설정
 
5-1. 로그 서버 설정

Revision as of 16:16, 12 May 2021

You can use a dedicated Log Server that can store more logs than the imRAD local database. If you configure it, the management interface reads logs from the dedicated Log Server and displays them.

Log Table Local Database Log Server Log name
IP/MAC address history 3 months 48 months DHCP Lease
RADIUS Accounting 3 months 48 months RADIUS Accounting
RADIUS post-auth 3 months 48 months RADIUS Postauth

Configuring Dedicated Log Server

Installing database server

1. Install MariaDB 10.0 higher Database server. MySQL 5.7 or higher is also available. It doesn't matter which operating systems of the database server.

2. Open the "Dedicated Log server" page that is located in the "Environment" menu of the management interface. And then, download an SQL file by clicking the icon on the top right of the "Target log" table and save it on your computer.

3. Copy the SQL file into your log server(i.e. Dedicated Log server) and import it into your database by using the mysql 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 user or password before importing the SQL file, modify the query of line 27 after opening the download file by using an editor such as notepad. For example, a new query might be the below. 

CREATE USER IF NOT EXISTS 'myuser'@'%' IDENTIFIED BY 'mypassword';

The below picture is a part of the SQL.
Imradlog sql.png

To import the SQL file, enter the mysql command. the <user> and <passowrd> is the existing account of the database in the dedicated log server.
Note that if the operating system of your server is the Windows system, you must run the Command Prompt as administrator. 

# mysql -u<user> -p<password> < <your_directory>/imradlog.sql

# mysql  -uroot -pmypaddword < c:\imradlog.sql			# Windows
# mysql  -uroot -pmypaddword < /home/user/imradlog.sql		# linux


4. Configuring Connection properties 5. imRAD 환경설정 > 로그 전용 서버
5-1. 로그 서버 설정


5-2. 대상 로그
전송 할 로그를 사용 하도록 선택하세요.


모든 과정이 끝나면 해당 서비스(Logexp)는 로컬 데이터베이스의 로그를 전용 서버로 전송합니다.