fluent/fluent-plugin-sql

td-agent not start after added database adaptor

fhai opened this issue · 1 comments

fhai commented
  1. installed td-agent-3.5.1
  2. installed sql input plugin by follow this link: https://github.com/fluent/fluent-plugin-sql
  3. installed postgres adaptor by follow this link: https://github.com/fluent/fluent-plugin-sql
  4. installed oracle adaptor by follow this link: https://github.com/rsim/oracle-enhanced
  5. both cases, cannot start td-agent after added postgres/oracle db info in td-agent config.
    no error message, just cannot start td-agent. no errror in td-agent logs, but seems not able to read in the db info.

below is my oracle db info in the td-agent config:

<source>
  @type sql
  adapter oracle_enhanced
  host idb00295.ute.fedex.com
  port 1526
  database GTM_TEST3_SVC1_L2    // or GTM_TEST3_SVC1.ute.fedex.com ??
  username pex
  password K6WDQWjHXQhXxWbxu9zgcdYug
  tag_prefix mydb  # optional, but recommended
  select_interval 60s  # optional
  select_limit 500     # optional
  state_file /var/run/fluentd/sql_state
  <table>
    table MESSAGE_TABLE
    update_column id
  </table>
</source>

How about the trace log of fluentd -vv -c td-agent.conf?