플라스크 시작
set APP_CONFIG_FILE=C:\projects\flask\config\development.py
flask run

캡처된 필드를 보고 지워진 클래스 채우기
경로
c:\projects\flask\security\models.py

class SystemEvents;
	__tablename__ = 'SystemEvents'
	id=db.Column(db.Integer,primary_key=True)
	customid=db.Column(db.BigInteger, nullable=True, default=None)
	receivedat=db.Column(db.Datetime(), nullable=True, default=None)
	devicereportedtime=db.Column(db.Datetime(), nullable=True, default=None)
	facility=db.Column(db.SmallInteger, nullable=True, default=None)
	priority=db.Column(db.SmallInteger, nullable=True, default=None)
	fromhost=db.Column(db.String(60), nullable=True, default=None)
	message=db.Column(db.Text, nullable=True, default=None)
	ntseverity=db.Column(db.Integer, nullable=True, default=None)
	importance=db.Column(db.Integer, nullable=True, default=None)
	eventsource=db.Column(db.String(60), nullable=True, default=None)
	eventuser=db.Column(db.String(60), nullable=True, default=None)
	eventcategory=db.Column(db.Integer, nullable=True, default=None)
	eventid=db.Column(db.Integer, nullable=True, default=None)
	eventbinarydata=db.Column(db.Text, nullable=True, default=None)
	maxavailable=db.Column(db.Integer, nullable=True, default=None)
	currusage=db.Column(db.Integer, nullable=True, default=None)
	minusage=db.Column(db.Integer, nullable=True, default=None)
	maxusage=db.Column(db.Integer, nullable=True, default=None)
	infounitid=db.Column(db.Integer, nullable=True, default=None)
	syslogtag=db.Column(db.String(60), nullable=True, default=None)
	eventlogtype=db.Column(db.String(60), nullable=True, default=None)
	genericfilename=db.Column(db.String(60), nullable=True, default=None)
	systemid=db.Column(db.Integer, nullable=True, default=None)

.95연결
c:\projects\flask\config\development.py

SQLALCHEMY_DATABASE_URI='mysql+pymysql://rsyslog:123456@192.168.0.95/Syslog'

.95 외부 접속 설정

xshell
.118

cmd
flask db init
flask db migrate
flask db upgrade

c:\projects\flask\security\views
syslog.py
c:\projects\flask\security\templates\syslog
index.html

###필터걸기
누가 로그인했는지만 확인할 수 있도록 하자

c:\projects\flask\security\views
syslog.py
datas = SystemEvents.query.filter(SystemEvents.FromHost=='IP100').filter(SystemEvents.Message.like('%Accepted%')).order_by(SystemEvents.ReceivedAt.desc()).paginate(page=page, per_page=per_page, error_out=True)


전주컴퓨터학원
외부 접속 안됨...
왜?
tcpwrapper 접근차단 때문