●58일차(20250306058.php)
+) 만들어지지 않음 models.py에 SystemEvents의 모든 테이블을 적어주지 않음
> 모든 테이블을 적어주고 57일차작업을 다시 해주면 데이터베이스가 만들어지면서 웹에 데이터가 들어옴

[models.py]
class SystemEvents(db.Model):
    __tablename__ = 'SystemEvents'
    ID = db.Column(db.Integer, primary_key=True)
    CustomerID = db.Column(db.BigInteger, nullable=True)
    ReceivedAt = db.Column(db.DateTime(), nullable=True)
    DeviceReportedTime = db.Column(db.DateTime(), nullable=True)
    Facility = db.Column(db.SmallInteger, nullable=True)
    Priority = db.Column(db.SmallInteger, nullable=True)
    FromHost = db.Column(db.String(60), nullable=True)
    Message = db.Column(db.Text, nullable=False)
    NTSeverity = db.Column(db.Integer, nullable=True)
    Importance = db.Column(db.Integer, nullable=True)
    EventSource = db.Column(db.String(60), nullable=True)
    EventUser = db.Column(db.String(60), nullable=True)
    EventCategory = db.Column(db.Integer, nullable=True)
    EventID = db.Column(db.Integer, nullable=True)
    EventBinaryData = db.Column(db.Text, nullable=True)
    MaxAvailable = db.Column(db.Integer, nullable=True)
    CurrUsage = db.Column(db.Integer, nullable=True)
    MinUsage = db.Column(db.Integer, nullable=True)
    MaxUsage = db.Column(db.Integer, nullable=True)
    InfoUnitID = db.Column(db.Integer, nullable=True)
    SysLogTag = db.Column(db.String(60), nullable=True)
    EventLogType = db.Column(db.String(60), nullable=True)
    GenericFileName = db.Column(db.String(60), nullable=True)
    SystemID = db.Column(db.Integer, nullable=True)

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)
> syslog.py에 필터를 걸어주면 원하는 데이터만 볼 수 있다


192.168.0.100은 외부에서 접속이 불가능하다
> tcpwrapper 접근 차단해놓음

내 서버에 접근하려면
http://jeonjucom.kr:8011
ssh jeonjucom.kr:22011
ftp jeonjucom.kr:21011