作者:一只幸福的汪星人 | 来源:互联网 | 2023-07-25 18:47
环境
版本:logstash 7.1.1,elasticsearch 7.1.1
配置
logstash配置文件如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| input {
jdbc {
jdbc_driver_library => "/home/inspur/elasticsearch/lib/ojdbc14-10.2.0.1.0.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@10.47.0.238:1521:orcl"
jdbc_user => "lgzr"
jdbc_password => "lgzr"
schedule => "* * * * *"
statement => "select * from SR_INFOR t where SR_INFOR_ID >:sql_last_value"
jdbc_paging_enabled => true
jdbc_page_size => "1"
clean_run => true
use_column_value => true
tracking_column => "SR_INFOR_ID"
}
}
output {
elasticsearch {
hosts => ["http://10.47.0.96:9200/"]
index => "data_archives_jdbc"
}
} |
问题
在elasticearch head插件界面查看,logstash并没有数据生成,日志文件只有启动日志。请问为何logstash不把数据库中的数据发送到elasticsearch?