fluent-plugin-sql
fluent-plugin-sql copied to clipboard
td-agent not start after added database adaptor
- installed td-agent-3.5.1
- installed sql input plugin by follow this link: https://github.com/fluent/fluent-plugin-sql
- installed postgres adaptor by follow this link: https://github.com/fluent/fluent-plugin-sql
- installed oracle adaptor by follow this link: https://github.com/rsim/oracle-enhanced
- 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
?