fluent-plugin-sql icon indicating copy to clipboard operation
fluent-plugin-sql copied to clipboard

td-agent not start after added database adaptor

Open fhai opened this issue 4 years ago • 1 comments

  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>

fhai avatar Mar 31 '20 16:03 fhai

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

kenhys avatar Aug 10 '21 02:08 kenhys