1.logstash问题报错的解决

1.

根据截图可知：ouput是输出到elasticsearch,具体的IP.你可以自己设定。我设定的是本地环境。也就是localhost：9200.

input{绑定应用以及端口，beats{}详细的去解析一下。

}先百度学习一下beats{}这个具体指的是什么东西。

方法：

查阅官方文档：

官网连接如下：

https://www.elastic.co/guide/en/logstash/current/introduction.html

具体输入的内部构造原理如下：

处理大数据的输入集如下操作：

注意一点logsash.conf也就是配置文件必须是ANSI文件格式的，不然会报错。

报错的错误如下：

ch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [http://localhost:9200/][Manticore::SocketException] Connection refused: connect"}
Tue Nov 13 11:28:00 CST 2018 WARN: Establishing SSL connection without server&＃39;s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn&＃39;t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to &＃39;false&＃39;. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[2018-11-13T11:28:00,194][INFO ][logstash.inputs.jdbc     ] (0.001014s) SELECT version()
[2018-11-13T11:28:00,197][INFO ][logstash.inputs.jdbc     ] (0.000978s) SELECT version()
[2018-11-13T11:28:00,200][ERROR][logstash.inputs.jdbc     ] Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &＃39;;) AS `t1` LIMIT 1&＃39; at line 1: SELECT count(*) AS `count` FROM (SELECT * from areacheckdaily;) AS `t1` LIMIT 1

logstash的配置文件默认文件编码必须要注意。