网事随记
运行goaccess输出到nginx，Tomcat日志文件applog.txt通过ftp定时上传至/var/ftp/ goaccess /var/ftp/applog.txt -o /usr/share/nginx/html/index.html -p /usr/local/etc/goaccess-tomcat.conf --real-time-html --daemonize --geoip-database=/usr/share/GeoIP/GeoLiteCity.dat 查看goaccess后台运行状态，服务端与浏览器默认通过TCP7890端口实现实时传输
rsa local-key-pair create dsa local-key-pair create aaa local-user sgs password cipher admin local-user sgs privilege level 3 local-user sgs service-type ssh stelnet server enable ssh user sgs authenticatio
[Quidway] snmp-agent [Quidway] snmp-agent sys-info version v3 [Quidway] acl 2001 [Quidway-acl-basic-2001] rule 5 permit source 1.1.1.2 0.0.0.0 [Quidway-acl-basic-2001] rule 6 deny source 1.1.1.1 0.0.0.0 [Quidway] snmp-agent mib-view included testview iso [Quidway] snmp-agent group v3 testgroup privacy write-view testview notify-view testview acl 2001 [Quidway] snmp-agent usm-user v3 testuser testgroup authentication-password md5 87654321 privacy-password des56 87654321
left join：左连接，返回左表中所有的记录以及右表中符合条件的记录。right joi：右连接，返回右表中所有的记录以及左表中符合条件的记录。一般情况下，left join要比inner join返回的行数多。inner join：内连接（等值连接），返回两个表中连接字段相等的行。
