MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| Syslog             |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)
#########################
MariaDB [(none)]> show create database Syslog;
+----------+-------------------+
| Database | Create Database   |
+----------+-------------------+
| Syslog   | CREATE DATABASE `Syslog` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |
+----------+--------------------+
1 row in set (0.00 sec)
##########################
MariaDB [(none)]> status
mysql  Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Connection id:          1793
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.3.29-MariaDB-0+deb10u1 Debian 10
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 23 min 21 sec

编辑/etc/mysql/mariadb.conf.d/下面的50-mysql-clients.cnf和50-server.cnf

编辑50-server.cnf
# this is only for the mysqld standalone daemon
[mysqld]
..........
..........
..........
# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
# utf8 4-byte character set. See also client.cnf
#
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
init_connect          = 'SET NAMES utf8mb4'
#character-set-server = utf8
#collation-server      =utf8_general_ci
#init_connect          = 'SET NAMES utf8'

编辑50-mysql-clients.cnf
[mysql]
# Default is Latin1, if you need UTF-8 set this (also in server section)
default-character-set = utf8mb4
#default-character-set = latin1
#default-character-set = utf8

如不是utf8：

Vim /usr/share/doc/rsyslog-7.4.7/mysql-createDB.sql
修改：create database syslog default character set utf8 collate utf8mb4; //utf8_general_ci

CREATE DATABASE /*!32312 IF NOT EXISTS*/`Syslog` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `Syslog`;
/*Table structure for table `SystemEvents` */
DROP TABLE IF EXISTS `SystemEvents`;
CREATE TABLE `SystemEvents` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`CustomerID` bigint(20) DEFAULT NULL,
`ReceivedAt` datetime DEFAULT NULL,
`DeviceReportedTime` datetime DEFAULT NULL,
`Facility` smallint(6) DEFAULT NULL,
`Priority` smallint(6) DEFAULT NULL,
`FromHost` varchar(60) DEFAULT NULL,
`FromIP` varchar(60) DEFAULT NULL,
`Message` text DEFAULT NULL,
`NTSeverity` int(11) DEFAULT NULL,
`Importance` int(11) DEFAULT NULL,
`EventSource` varchar(60) DEFAULT NULL,
`EventUser` varchar(60) DEFAULT NULL,
`EventCategory` int(11) DEFAULT NULL,
`EventID` int(11) DEFAULT NULL,
`EventBinaryData` text DEFAULT NULL,
`MaxAvailable` int(11) DEFAULT NULL,
`CurrUsage` int(11) DEFAULT NULL,
`MinUsage` int(11) DEFAULT NULL,
`MaxUsage` int(11) DEFAULT NULL,
`InfoUnitID` int(11) DEFAULT NULL,
`SysLogTag` varchar(60) DEFAULT NULL,
`EventLogType` varchar(60) DEFAULT NULL,
`GenericFileName` varchar(60) DEFAULT NULL,
`SystemID` int(11) DEFAULT NULL,
`processid` varchar(60) NOT NULL DEFAULT '',
`checksum` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13144 DEFAULT CHARSET=utf8mb4;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`Syslog` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `Syslog`;
/*Table structure for table `SystemEventsProperties` */
DROP TABLE IF EXISTS `SystemEventsProperties`;
CREATE TABLE `SystemEventsProperties` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SystemEventID` int(11) DEFAULT NULL,
`ParamName` varchar(255) DEFAULT NULL,
`ParamValue` text DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

重启mysqld服务

service mysql restart

将return htmlentities($mystr,ENT_NOQUOTES,$content['HeaderDefaultEncoding'],"utf-8");
修改为：return htmlentities($mystr,ENT_NOQUOTES,"utf-8");

重启httpd服务

service apache2 restart

auth();
function auth ()
{
     $valid_passwords = array ("admin" => "admin");
     $valid_users = array_keys($valid_passwords);
     $user = @$_SERVER['PHP_AUTH_USER'];
     $pass = @$_SERVER['PHP_AUTH_PW'];
     $validated = (in_array($user, $valid_users)) && ($pass == $valid_passwords[$user]);
     if (!$validated) {
       header('WWW-Authenticate: Basic realm="My Realm"');
       header('HTTP/1.0 401 Unauthorized');
       die ("<script>window.location.href='/';</script>");
     }
}