search

fluent / fluent-plugin-sql

SQL input/output plugin for Fluentd
108 stars 59 forks source link

td-agent not start after added database adaptor #81

Open fhai opened 4 years ago

fhai commented 4 years ago
  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>
kenhys commented 3 years ago

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