Hi there,
I'm still trying to connect my postgresql database to elastic. I've got all the required files:
logstash.yml, pipelines.yml and p1.conf (in my local/etc/logstash). However I'm only getting Successfully started Logstash API endpoint and no result, if I run logstash --debug I get: stdout { codec => json_lines } ```]
So it's empty...
Here are some lines I'm also getting from the debug:
config LogStash::Inputs::Jdbc/@statement = "SELECT * from phpbb_banlist"
config LogStash::Inputs::Jdbc/@jdbc_validation_timeout = 3600
config LogStash::Inputs::Jdbc/@connection_retry_attempts = 1
config LogStash::Inputs::Jdbc/@connection_retry_attempts_wait_time = 0.5
[DEBUG][org.logstash.ackedqueue.io.MmapPageIOV2] PageIO recovery element index:0, readNextElement exception: Element invalid length
[DEBUG][logstash.javapipeline ] Starting pipeline {:pipeline_id=>"my-pipeline_1"}
[WARN ][org.logstash.instrument.metrics.gauge.LazyDelegatingGauge][my-pipeline_1] A gauge metric of an unknown type (org.jruby.RubyArray) has been create for key: cluster_uuids. This may result in invalid serialization. It is recommended to log an issue to the responsible developer/development team.
[INFO ][logstash.javapipeline ][my-pipeline_1] Starting pipeline {:pipeline_id=>"my-pipeline_1", "pipeline.workers"=>1, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50, "pipeline.max_inflight"=>125, "pipeline.sources"=>["/usr/local/etc/logstash/p1.conf"], :thread=>"#<Thread:0x2dc0c9bc run>"}
[logstash.javapipeline ][my-pipeline_1] Pipeline started {"pipeline.id"=>"my-pipeline_1"}
[DEBUG][logstash.javapipeline ] Pipeline started successfully {:pipeline_id=>"my-pipeline_1", :thread=>"#<Thread:0x2dc0c9bc run>"}
[DEBUG][org.logstash.execution.PeriodicFlush][my-pipeline_1] Pushing flush onto pipeline.
[INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:"my-pipeline_1"], :non_running_pipelines=>[]}
[DEBUG][logstash.agent ] Starting puma
[DEBUG][logstash.agent ] Trying to start WebServer {:port=>9600}
[DEBUG][logstash.api.service ] [api-service] start
[INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
[DEBUG][logstash.inputs.jdbc ][my-pipeline_1] loading ~/Desktop/postgresql-42.2.9.jar
[DEBUG][logstash.inputs.jdbc ] config LogStash::Inputs::Jdbc/@use_prepared_statements = false
[DEBUG][logstash.inputs.jdbc ] config LogStash::Inputs::Jdbc/@prepared_statement_name = ""
Maybe somebody can help me to sync my postgresql database with elastic (because it's taking forever this way), I've been searching the web for a solution for a long time. I was thinking the problem is the prepared statement being empty but my .conf file is all in order and as simple as can be.