Linux: (03.04.02) Hướng dẫn cài đặt MariaDB v10.4 CentOS 7 (64bit) trước khi cài đặt FreeRADIUS

 

Mục tiêu thực hành:

- Khởi động và kiểm tra trạng thái MariaDB trên CentOS 7.

- Cài đặt và khởi động MariaDB để cấu hình Database Server.

- Cấu hình Database cho FreeRADIUS.

Các bước triển khai:

Khởi động và kiểm tra trạng thái MariaDB trên CentOS 7.

[root@localhost run]# systemctl start mariadb

[root@localhost run]# systemctl status mariadb

● mariadb.service - MariaDB database server

   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

   Active: active (running) since Thu 2021-05-06 11:04:20 +07; 1min 13s ago

  Process: 27471 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)

  Process: 27388 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

 Main PID: 27470 (mysqld_safe)

   CGroup: /system.slice/mariadb.service

           ├─27470 /bin/sh /usr/bin/mysqld_safe --basedir=/usr

           └─27635 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --s...

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: MySQL manual for more instructions.

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: Please report any problems at http://mariadb.org/jira

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: The latest information about MariaDB is available at http://mariadb.org/.

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: You can find additional information about the MySQL part at:

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: http://dev.mysql.com

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: Consider joining MariaDB's strong and vibrant community:

May 06 11:04:18 localhost.localdomain mariadb-prepare-db-dir[27388]: https://mariadb.org/get-involved/

May 06 11:04:18 localhost.localdomain mysqld_safe[27470]: 210506 11:04:18 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

May 06 11:04:18 localhost.localdomain mysqld_safe[27470]: 210506 11:04:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

May 06 11:04:20 localhost.localdomain systemd[1]: Started MariaDB database server.

[root@localhost run]# 

- Add MariaDB official repo content to CentOS 7.

sudo tee /etc/yum.repos.d/MariaDB.repo<<EOF 

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.4/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

EOF

Cài đặt và khởi động MariaDB để cấu hình Database Server.

- Cài đặt MariaDB.

sudo yum -y install MariaDB-server MariaDB-client

- Start and enable MariaDB to run on boot.

sudo systemctl start --now mariadb

[root@localhost yum.repos.d]# systemctl status mariadb

● mariadb.service - MariaDB 10.4.19 database server

   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

  Drop-In: /etc/systemd/system/mariadb.service.d

           └─migrated-from-my.cnf-settings.conf

   Active: active (running) since Mon 2021-05-17 22:56:41 EDT; 21s ago

     Docs: man:mysqld(8)

           https://mariadb.com/kb/en/library/systemd/

  Process: 2828 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

  Process: 2785 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)

  Process: 2783 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

 Main PID: 2796 (mysqld)

   Status: "Taking your SQL requests now..."

   CGroup: /system.slice/mariadb.service

           └─2796 /usr/sbin/mysqld

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [Note] Server socket created on IP: '::'.

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' ...TE','POST

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system ta...cheduler.

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_p...n't exist

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [Note] Reading of all Master_info entries succeeded

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [Note] Added new Master_info '' to hash table

May 17 22:56:41 localhost.localdomain mysqld[2796]: 2021-05-17 22:56:41 0 [Note] /usr/sbin/mysqld: ready for connections.

May 17 22:56:41 localhost.localdomain mysqld[2796]: Version: '10.4.19-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

May 17 22:56:41 localhost.localdomain systemd[1]: Started MariaDB 10.4.19 database server.

Hint: Some lines were ellipsized, use -l to show in full.

[root@localhost yum.repos.d]# 

Cấu hình Database cho FreeRADIUS.

[root@localhost ~]# mysql -u root

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 16

Server version: 10.4.19-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE radius;

Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> GRANT ALL ON radius.* TO radius@localhost IDENTIFIED BY "admin2021";

Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> \q

Bye

[root@localhost ~]# 

Mọi thắc mắc các bạn vui lòng liên hệ với mình thông qua kênh Zalo (Jade Bùi) 076.877.2021.