
-- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
--
-- Host: localhost    Database: Syslog
-- ------------------------------------------------------
-- Server version	5.7.25-0ubuntu0.16.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;



DROP DATABASE IF EXISTS Syslog;

CREATE DATABASE Syslog;
USE Syslog;


--
-- Table structure for table `SystemEvents`
--

DROP TABLE IF EXISTS `SystemEvents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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,
  `Message` text,
  `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,
  `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 '',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

CREATE INDEX systemEventsByTime ON Syslog.SystemEvents(ReceivedAt);
--
-- Dumping data for table `SystemEvents`
--

LOCK TABLES `SystemEvents` WRITE;
/*!40000 ALTER TABLE `SystemEvents` DISABLE KEYS */;
INSERT INTO `SystemEvents` VALUES (177,NULL,'2019-05-30 16:50:33','2019-05-30 16:50:33',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(178,NULL,'2019-05-30 16:50:33','2019-05-30 16:50:33',10,5,'ansible-client2','     kiro : TTY=pts/1 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/sh -c echo BECOME-SUCCESS-zpxjqkqyjglvfbqugnsnsaeyundwmssi ; /usr/bin/python3 /home/kiro/.ansible/tmp/ansible-tmp-1559224233.4644907-100086342009587/AnsiballZ_command.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(179,NULL,'2019-05-30 16:50:33','2019-05-30 16:50:33',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(180,NULL,'2019-05-30 16:50:34','2019-05-30 16:50:34',1,6,'ansible-client2',' ansible-command Invoked with creates=None warn=True strip_empty_ends=True argv=None removes=None stdin_add_newline=True _uses_shell=False executable=None _raw_params=mv /etc/rsyslog.d/mysql.conf /etc/rsyslog.d/10-mysql.conf stdin=None chdir=None',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'python3[13906]:',NULL,NULL,NULL,''),(181,NULL,'2019-05-30 16:50:34','2019-05-30 16:50:34',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(182,NULL,'2019-05-30 16:50:35','2019-05-30 16:50:35',10,5,'ansible-client2','     kiro : TTY=pts/1 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/sh -c echo BECOME-SUCCESS-tongfohaxghdglvuypivgotrkarkvbnf ; /usr/bin/python3 /home/kiro/.ansible/tmp/ansible-tmp-1559224234.3106248-112284592774112/AnsiballZ_systemd.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(183,NULL,'2019-05-30 16:50:35','2019-05-30 16:50:35',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(184,NULL,'2019-05-30 16:50:35','2019-05-30 16:50:35',1,6,'ansible-client2',' ansible-systemd Invoked with daemon_reexec=False state=restarted force=None no_block=False user=None enabled=None masked=None scope=None name=apache2 daemon_reload=False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'python3[13928]:',NULL,NULL,NULL,''),(185,NULL,'2019-05-30 16:50:35','2019-05-30 16:50:35',3,6,'ansible-client2',' Stopping LSB: Apache2 web server...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(186,NULL,'2019-05-30 16:50:35','2019-05-30 16:50:35',3,6,'ansible-client2','  * Stopping Apache httpd web server apache2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'apache2[13935]:',NULL,NULL,NULL,''),(187,NULL,'2019-05-30 16:50:37','2019-05-30 16:50:37',3,6,'ansible-client2','  *',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'apache2[13935]:',NULL,NULL,NULL,''),(188,NULL,'2019-05-30 16:50:37','2019-05-30 16:50:37',3,6,'ansible-client2',' Stopped LSB: Apache2 web server.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(189,NULL,'2019-05-30 16:50:37','2019-05-30 16:50:37',3,6,'ansible-client2',' Starting LSB: Apache2 web server...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(190,NULL,'2019-05-30 16:50:37','2019-05-30 16:50:37',3,6,'ansible-client2','  * Starting Apache httpd web server apache2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'apache2[13961]:',NULL,NULL,NULL,''),(191,NULL,'2019-05-30 16:50:37','2019-05-30 16:50:37',3,6,'ansible-client2',' AH00558: apache2: Could not reliably determine the server\'s fully qualified domain name, using 127.0.1.1. Set the \'ServerName\' directive globally to suppress this message',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'apache2[13961]:',NULL,NULL,NULL,''),(192,NULL,'2019-05-30 16:50:38','2019-05-30 16:50:38',3,6,'ansible-client2','  *',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'apache2[13961]:',NULL,NULL,NULL,''),(193,NULL,'2019-05-30 16:50:38','2019-05-30 16:50:38',3,6,'ansible-client2',' Started LSB: Apache2 web server.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(194,NULL,'2019-05-30 16:50:38','2019-05-30 16:50:38',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(195,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',10,5,'ansible-client2','     kiro : TTY=pts/1 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/sh -c echo BECOME-SUCCESS-mfrazmuyveobocgnfpdlajbtzsmvhdyo ; /usr/bin/python3 /home/kiro/.ansible/tmp/ansible-tmp-1559224238.7499602-75419379419013/AnsiballZ_systemd.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(196,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(197,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',1,6,'ansible-client2',' ansible-systemd Invoked with name=rsyslog user=None masked=None daemon_reload=False daemon_reexec=False force=None enabled=None state=restarted scope=None no_block=False',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'python3[14006]:',NULL,NULL,NULL,''),(198,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,6,'ansible-client2',' [origin software=\"rsyslogd\" swVersion=\"8.16.0\" x-pid=\"12857\" x-info=\"http://www.rsyslog.com\"] exiting on signal 15.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd:',NULL,NULL,NULL,''),(199,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,6,'ansible-client2',' [origin software=\"rsyslogd\" swVersion=\"8.16.0\" x-pid=\"14014\" x-info=\"http://www.rsyslog.com\"] start',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd:',NULL,NULL,NULL,''),(200,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,3,'ansible-client2','command \'KLogPermitNonKernelFacility\' is currently not permitted - did you already set it via a RainerScript command (v6+ config)? [v8.16.0 try http://www.rsyslog.com/e/2222 ]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd-2222:',NULL,NULL,NULL,''),(201,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,4,'ansible-client2','warning: ~ action is deprecated, consider using the \'stop\' statement instead [v8.16.0 try http://www.rsyslog.com/e/2307 ]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd-2307:',NULL,NULL,NULL,''),(202,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,6,'ansible-client2','rsyslogd\'s groupid changed to 108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd:',NULL,NULL,NULL,''),(203,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,6,'ansible-client2','rsyslogd\'s userid changed to 104',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd:',NULL,NULL,NULL,''),(204,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',3,6,'ansible-client2',' Stopping System Logging Service...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(205,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',3,6,'ansible-client2',' Stopped System Logging Service.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(206,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',3,6,'ansible-client2',' Starting System Logging Service...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(207,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',3,6,'ansible-client2',' Started System Logging Service.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(208,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,3,'ansible-client2','Could not open output pipe \'/dev/xconsole\':: No such file or directory [v8.16.0 try http://www.rsyslog.com/e/2039 ]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd-2039:',NULL,NULL,NULL,''),(209,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',5,4,'ansible-client2','action \'action 21\' suspended, next retry is Thu May 30 16:51:09 2019 [v8.16.0 try http://www.rsyslog.com/e/2007 ]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'rsyslogd-2007:',NULL,NULL,NULL,''),(210,NULL,'2019-05-30 16:50:39','2019-05-30 16:50:39',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(211,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',10,5,'ansible-client2','     kiro : TTY=pts/1 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/sh -c echo BECOME-SUCCESS-txvttrkrropwpuyfofdsjdprbbqeiwcj ; /usr/bin/python3 /home/kiro/.ansible/tmp/ansible-tmp-1559224239.866464-237491479327347/AnsiballZ_stat.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(212,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(213,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',1,6,'ansible-client2',' ansible-stat Invoked with get_checksum=True follow=False get_md5=None checksum_algorithm=sha1 path=/var/www/html/loganalyzer/config.php get_attributes=True get_mime=True',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'python3[14039]:',NULL,NULL,NULL,''),(214,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(215,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',10,5,'ansible-client2','     kiro : TTY=pts/1 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/sh -c echo BECOME-SUCCESS-fgaumdbzkoqsyqdebuytzipinkspdfxy ; /usr/bin/python3 /home/kiro/.ansible/tmp/ansible-tmp-1559224239.866464-237491479327347/AnsiballZ_copy.py',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(216,NULL,'2019-05-30 16:50:40','2019-05-30 16:50:40',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(217,NULL,'2019-05-30 16:50:41','2019-05-30 16:50:41',1,6,'ansible-client2',' ansible-copy Invoked with src=/home/kiro/.ansible/tmp/ansible-tmp-1559224239.866464-237491479327347/source content=NOT_LOGGING_PARAMETER unsafe_writes=None validate=None local_follow=None _original_basename=tmp0ljgytwe seuser=None checksum=da39a3ee5e6b4b0d3255bfef95601890afd80709 attributes=None owner=root backup=False setype=None force=True follow=False regexp=None mode=438 delimiter=None serole=None dest=/var/www/html/loganalyzer/config.php directory_mode=None remote_src=None group=root selevel=None',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'python3[14053]:',NULL,NULL,NULL,''),(218,NULL,'2019-05-30 16:50:41','2019-05-30 16:50:41',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(219,NULL,'2019-05-30 16:51:41','2019-05-30 16:51:41',4,6,'ansible-client2',' Received disconnect from 192.168.1.107 port 37510:11: disconnected by user',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sshd[1548]:',NULL,NULL,NULL,''),(220,NULL,'2019-05-30 16:51:41','2019-05-30 16:51:41',4,6,'ansible-client2',' Disconnected from 192.168.1.107 port 37510',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sshd[1548]:',NULL,NULL,NULL,''),(221,NULL,'2019-05-30 16:51:41','2019-05-30 16:51:41',10,6,'ansible-client2',' pam_unix(sshd:session): session closed for user kiro',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sshd[1517]:',NULL,NULL,NULL,''),(222,NULL,'2019-05-30 16:51:41','2019-05-30 16:51:41',4,6,'ansible-client2',' Removed session 3.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd-logind[906]:',NULL,NULL,NULL,''),(223,NULL,'2019-05-30 16:56:21','2019-05-30 16:56:21',3,6,'ansible-client2',' Starting Cleanup of Temporary Directories...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(224,NULL,'2019-05-30 16:56:21','2019-05-30 16:56:21',3,4,'ansible-client2',' [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path \"/var/log\", ignoring.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd-tmpfiles[14062]:',NULL,NULL,NULL,''),(225,NULL,'2019-05-30 16:56:21','2019-05-30 16:56:21',3,6,'ansible-client2',' Started Cleanup of Temporary Directories.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(226,NULL,'2019-05-30 17:00:42','2019-05-30 17:00:42',10,5,'ansible-client2','     kiro : TTY=pts/0 ; PWD=/home/kiro ; USER=root ; COMMAND=/usr/bin/mysql',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(227,NULL,'2019-05-30 17:00:42','2019-05-30 17:00:42',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(228,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',9,6,'ansible-client2',' Network configuration changed, trying to establish connection.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd-timesyncd[599]:',NULL,NULL,NULL,''),(229,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' Starting Update resolvconf for networkd DNS...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(230,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' sed: Ð½ÐµÐ²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ Ð¿Ñ€Ð¾Ñ‡Ð¸Ñ‚Ð°Ñ‚ÑŒ /run/systemd/netif/leases/*: ÐÐµÑ‚ Ñ‚Ð°ÐºÐ¾Ð³Ð¾ Ñ„Ð°Ð¹Ð»Ð° Ð¸Ð»Ð¸ ÐºÐ°Ñ‚Ð°Ð»Ð¾Ð³Ð°',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sh[14180]:',NULL,NULL,NULL,''),(231,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' DHCPDISCOVER on ens160 to 255.255.255.255 port 67 interval 3 (xid=0x6455e3c)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'dhclient[970]:',NULL,NULL,NULL,''),(232,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' DHCPREQUEST of 192.168.1.103 on ens160 to 255.255.255.255 port 67 (xid=0x3c5e4506)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'dhclient[970]:',NULL,NULL,NULL,''),(233,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' DHCPOFFER of 192.168.1.103 from 192.168.1.1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'dhclient[970]:',NULL,NULL,NULL,''),(234,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' DHCPACK of 192.168.1.103 from 192.168.1.1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'dhclient[970]:',NULL,NULL,NULL,''),(235,NULL,'2019-05-30 17:00:52','2019-05-30 17:00:52',3,6,'ansible-client2',' bound to 192.168.1.103 -- renewal in 11926 seconds.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'dhclient[970]:',NULL,NULL,NULL,''),(236,NULL,'2019-05-30 17:00:53','2019-05-30 17:00:53',3,6,'ansible-client2',' sed: Ð½ÐµÐ²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ Ð¿Ñ€Ð¾Ñ‡Ð¸Ñ‚Ð°Ñ‚ÑŒ /run/systemd/netif/leases/*: ÐÐµÑ‚ Ñ‚Ð°ÐºÐ¾Ð³Ð¾ Ñ„Ð°Ð¹Ð»Ð° Ð¸Ð»Ð¸ ÐºÐ°Ñ‚Ð°Ð»Ð¾Ð³Ð°',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sh[14180]:',NULL,NULL,NULL,''),(237,NULL,'2019-05-30 17:01:21','2019-05-30 17:01:21',3,6,'ansible-client2',' message repeated 28 times: [ sed: Ð½ÐµÐ²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ Ð¿Ñ€Ð¾Ñ‡Ð¸Ñ‚Ð°Ñ‚ÑŒ /run/systemd/netif/leases/*: ÐÐµÑ‚ Ñ‚Ð°ÐºÐ¾Ð³Ð¾ Ñ„Ð°Ð¹Ð»Ð° Ð¸Ð»Ð¸ ÐºÐ°Ñ‚Ð°Ð»Ð¾Ð³Ð°]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sh[14180]:',NULL,NULL,NULL,''),(238,NULL,'2019-05-30 17:01:22','2019-05-30 17:01:22',3,6,'ansible-client2',' Started Update resolvconf for networkd DNS.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'systemd[1]:',NULL,NULL,NULL,''),(239,NULL,'2019-05-30 17:01:40','2019-05-30 17:01:40',10,6,'ansible-client2',' pam_unix(sudo:session): session closed for user root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(240,NULL,'2019-05-30 17:02:48','2019-05-30 17:02:48',10,5,'ansible-client2','     kiro : TTY=pts/0 ; PWD=/home/kiro ; USER=root ; COMMAND=/bin/bash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,''),(241,NULL,'2019-05-30 17:02:48','2019-05-30 17:02:48',10,6,'ansible-client2',' pam_unix(sudo:session): session opened for user root by kiro(uid=0)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'sudo:',NULL,NULL,NULL,'');
/*!40000 ALTER TABLE `SystemEvents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SystemEventsProperties`
--

DROP TABLE IF EXISTS `SystemEventsProperties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SystemEventsProperties` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `SystemEventID` int(11) DEFAULT NULL,
  `ParamName` varchar(255) DEFAULT NULL,
  `ParamValue` text,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SystemEventsProperties`
--

LOCK TABLES `SystemEventsProperties` WRITE;
/*!40000 ALTER TABLE `SystemEventsProperties` DISABLE KEYS */;
/*!40000 ALTER TABLE `SystemEventsProperties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_charts`
--

DROP TABLE IF EXISTS `logcon_charts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_charts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DisplayName` varchar(255) NOT NULL,
  `chart_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `chart_type` int(11) NOT NULL,
  `chart_width` int(11) NOT NULL,
  `chart_field` varchar(255) NOT NULL,
  `chart_defaultfilter` varchar(1024) NOT NULL,
  `maxrecords` int(11) NOT NULL,
  `showpercent` tinyint(1) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='This table contains all configured charts';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_charts`
--

LOCK TABLES `logcon_charts` WRITE;
/*!40000 ALTER TABLE `logcon_charts` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_charts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_config`
--

DROP TABLE IF EXISTS `logcon_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_config` (
  `propname` varchar(32) NOT NULL,
  `propvalue` varchar(255) DEFAULT NULL,
  `propvalue_text` text,
  `is_global` tinyint(1) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table to store global and user specific configurations';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_config`
--

LOCK TABLES `logcon_config` WRITE;
/*!40000 ALTER TABLE `logcon_config` DISABLE KEYS */;
INSERT INTO `logcon_config` VALUES ('database_installedversion','10',NULL,1,NULL,NULL),('ViewDefaultLanguage','en',NULL,1,NULL,NULL),('ViewDefaultTheme','default',NULL,1,NULL,NULL),('ViewUseTodayYesterday','1',NULL,1,NULL,NULL),('ViewEnableDetailPopups','1',NULL,1,NULL,NULL),('EnableContextLinks','1',NULL,1,NULL,NULL),('EnableIPAddressResolve','1',NULL,1,NULL,NULL),('MiscShowDebugMsg','0',NULL,1,NULL,NULL),('MiscShowDebugGridCounter','0',NULL,1,NULL,NULL),('MiscShowPageRenderStats','1',NULL,1,NULL,NULL),('MiscEnableGzipCompression','1',NULL,1,NULL,NULL),('SuppressDuplicatedMessages','0',NULL,1,NULL,NULL),('TreatNotFoundFiltersAsTrue','0',NULL,1,NULL,NULL),('InlineOnlineSearchIcons','1',NULL,1,NULL,NULL),('ViewMessageCharacterLimit','0',NULL,1,NULL,NULL),('ViewStringCharacterLimit','30',NULL,1,NULL,NULL),('ViewEntriesPerPage','50',NULL,1,NULL,NULL),('ViewEnableAutoReloadSeconds','0',NULL,1,NULL,NULL),('AdminChangeWaitTime','',NULL,1,NULL,NULL),('PopupMenuTimeout','3000',NULL,1,NULL,NULL),('PrependTitle','',NULL,1,NULL,NULL),('SearchCustomButtonCaption','Id like to feel sad',NULL,1,NULL,NULL),('SearchCustomButtonSearch','error',NULL,1,NULL,NULL),('DefaultViewsID','',NULL,1,NULL,NULL),('DefaultSourceID','7',NULL,1,NULL,NULL),('DefaultFont','Arial',NULL,1,NULL,NULL),('DefaultFontSize','100',NULL,1,NULL,NULL),('DebugUserLogin','0',NULL,1,NULL,NULL),('MiscDebugToSyslog','0',NULL,1,NULL,NULL),('MiscMaxExecutionTime','30',NULL,1,NULL,NULL),('UseProxyServerForRemoteQueries','',NULL,1,NULL,NULL),('HeaderDefaultEncoding','ISO-8859-1',NULL,1,NULL,NULL),('DisableAdminUsers','',NULL,1,NULL,NULL),('InjectHtmlHeader','',NULL,1,NULL,NULL),('InjectBodyHeader','',NULL,1,NULL,NULL),('InjectBodyFooter','',NULL,1,NULL,NULL),('PhplogconLogoUrl','',NULL,1,NULL,NULL);

UNLOCK TABLES;

--
-- Table structure for table `logcon_dbmappings`
--

DROP TABLE IF EXISTS `logcon_dbmappings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_dbmappings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DisplayName` varchar(64) NOT NULL,
  `Mappings` varchar(1024) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_dbmappings`
--

LOCK TABLES `logcon_dbmappings` WRITE;
/*!40000 ALTER TABLE `logcon_dbmappings` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_dbmappings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_fields`
--

DROP TABLE IF EXISTS `logcon_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_fields` (
  `FieldID` varchar(64) NOT NULL,
  `FieldDefine` varchar(64) NOT NULL,
  `FieldCaption` varchar(255) NOT NULL,
  `FieldType` int(11) NOT NULL,
  `Sortable` tinyint(1) NOT NULL,
  `DefaultWidth` int(11) NOT NULL,
  `FieldAlign` varchar(32) NOT NULL,
  `SearchField` varchar(64) NOT NULL,
  `SearchOnline` tinyint(1) NOT NULL,
  `Trunscate` int(11) NOT NULL,
  PRIMARY KEY (`FieldID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='This table stores custom fields';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_fields`
--

LOCK TABLES `logcon_fields` WRITE;
/*!40000 ALTER TABLE `logcon_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_groupmembers`
--

DROP TABLE IF EXISTS `logcon_groupmembers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_groupmembers` (
  `userid` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  `is_member` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpertable to store which users are in which group';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_groupmembers`
--

LOCK TABLES `logcon_groupmembers` WRITE;
/*!40000 ALTER TABLE `logcon_groupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_groupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_groups`
--

DROP TABLE IF EXISTS `logcon_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_groups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `groupname` varchar(32) NOT NULL,
  `groupdescription` varchar(255) NOT NULL,
  `grouptype` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table for phplogcon groups';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_groups`
--

LOCK TABLES `logcon_groups` WRITE;
/*!40000 ALTER TABLE `logcon_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_savedreports`
--

DROP TABLE IF EXISTS `logcon_savedreports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_savedreports` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `reportid` varchar(255) NOT NULL,
  `sourceid` int(11) NOT NULL,
  `customTitle` varchar(255) NOT NULL,
  `customComment` text NOT NULL,
  `filterString` text NOT NULL,
  `customFilters` text NOT NULL,
  `outputFormat` varchar(64) NOT NULL,
  `outputTarget` varchar(64) NOT NULL,
  `outputTargetDetails` text NOT NULL,
  `scheduleSettings` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table to store saved reports';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_savedreports`
--

LOCK TABLES `logcon_savedreports` WRITE;
/*!40000 ALTER TABLE `logcon_savedreports` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_savedreports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_searches`
--

DROP TABLE IF EXISTS `logcon_searches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_searches` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DisplayName` varchar(255) NOT NULL,
  `SearchQuery` varchar(1024) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COMMENT='Stores custom user searches';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_searches`
--

LOCK TABLES `logcon_searches` WRITE;
/*!40000 ALTER TABLE `logcon_searches` DISABLE KEYS */;
INSERT INTO `logcon_searches` VALUES (1,'Syslog Warnings and Errors','filter=severity%3A0%2C1%2C2%2C3%2C4&search=Search',NULL,NULL),(2,'Syslog Errors','filter=severity%3A0%2C1%2C2%2C3&search=Search',NULL,NULL),(3,'All messages from the last hour','filter=datelastx%3A1&search=Search',NULL,NULL),(4,'All messages from last 12 hours','filter=datelastx%3A2&search=Search',NULL,NULL),(5,'All messages from last 24 hours','filter=datelastx%3A3&search=Search',NULL,NULL),(6,'All messages from last 7 days','filter=datelastx%3A4&search=Search',NULL,NULL),(7,'All messages from last 31 days','filter=datelastx%3A5&search=Search',NULL,NULL);
/*!40000 ALTER TABLE `logcon_searches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_sources`
--

DROP TABLE IF EXISTS `logcon_sources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_sources` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `SourceType` tinyint(4) NOT NULL,
  `MsgParserList` varchar(255) NOT NULL,
  `MsgNormalize` tinyint(1) NOT NULL DEFAULT '0',
  `MsgSkipUnparseable` tinyint(1) NOT NULL DEFAULT '0',
  `ViewID` varchar(64) NOT NULL,
  `LogLineType` varchar(64) DEFAULT NULL,
  `DiskFile` varchar(255) DEFAULT NULL,
  `DBTableType` varchar(64) DEFAULT NULL,
  `DBType` tinyint(4) DEFAULT NULL,
  `DBServer` varchar(255) DEFAULT NULL,
  `DBName` varchar(64) DEFAULT NULL,
  `DBUser` varchar(64) DEFAULT NULL,
  `DBPassword` varchar(255) DEFAULT NULL,
  `DBTableName` varchar(64) DEFAULT NULL,
  `DBEnableRowCounting` tinyint(1) DEFAULT NULL,
  `DBRecordsPerQuery` int(11) NOT NULL DEFAULT '100',
  `defaultfilter` varchar(1024) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table to store datasources in phplogcon';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_sources`
--

LOCK TABLES `logcon_sources` WRITE;
/*!40000 ALTER TABLE `logcon_sources` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_sources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_users`
--

DROP TABLE IF EXISTS `logcon_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_users` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `is_readonly` tinyint(1) NOT NULL DEFAULT '0',
  `last_login` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COMMENT='Table for the phplogcon users';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_users`
--

LOCK TABLES `logcon_users` WRITE;
/*!40000 ALTER TABLE `logcon_users` DISABLE KEYS */;
INSERT INTO `logcon_users` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',1,0,1559224826);
UPDATE `logcon_users` SET password = MD5('111111') WHERE username = 'admin';
/*!40000 ALTER TABLE `logcon_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logcon_views`
--

DROP TABLE IF EXISTS `logcon_views`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logcon_views` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DisplayName` varchar(255) NOT NULL,
  `Columns` text NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `groupid` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores custom defined user views.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logcon_views`
--

LOCK TABLES `logcon_views` WRITE;
/*!40000 ALTER TABLE `logcon_views` DISABLE KEYS */;
/*!40000 ALTER TABLE `logcon_views` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


DROP USER IF EXISTS 'db_log_user'@'localhost';
CREATE USER 'db_log_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON Syslog.* TO 'db_log_user'@'localhost';

DROP EVENT IF EXISTS Syslog.ClearOldData;

DELIMITER ;;

CREATE EVENT ClearOldData
  ON SCHEDULE
    EVERY 6 HOUR
  ENABLE
DO
  BEGIN
DELETE FROM
  Syslog.SystemEvents
WHERE ReceivedAt < NOW()- INTERVAL 1 MONTH;
END; ;;

DELIMITER ;

-- Dump completed on 2019-05-30 17:03:43
