fluent / fluent/fluent-plugin-sql

Unable to connnect to SQLServer dataserver parameter not Working

未关闭
#151 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
enhancement
主要语言
Ruby
星标
112
派生
58
PR 合并指标
30 天内没有已合并 PR

描述

So I've been working with this plugin for some days and finally achieved sending logs to a local sqlserver container.
Now that Im trying in prepo I'm not able to connecto to the database.
And so I startted with
```

@type copy

@type stdout


@type sql
log_level info
host 172........\sql2019pre
port 1433
chema_search_path piscinalogs
database db_Poseidon
adapter sqlserver
username "#{ENV['USER']}"
password "#{ENV['PASSWORD']}"
state_file /var/run/fluentd/sql_state

table logs
column_mapping 'time:timestamp,level:level,mensaje:message,Container_Name:containerName,App_Name:appName,Env:enviroment'
# This is the default table because it has no "pattern" argument in
# The logic is such that if all non-default blocks
# do not match, the default one is chosen.
# The default table is required.
flush_interval 10s

```
This configuration did not work since it returns
``fluentd | 2024-08-29 09:42:24 +0000 [warn]: #0 failed to flush the buffer. retry_times=0 next_retry_time=2024-08-29 09:42:26 +0000 chunk="620cf46e28eacdbcecf964d3ed2978be" error_class=TinyTds::Error error="Server name not found in configuration files"
``
Then I investigated how activerecords connects to database and encounter that they used the param: ``dataserver``
When removing the ``host`` param in order to introduce the ``dataserver`` param :
```

@type copy

@type stdout


@type sql
log_level info
dataserver 172.......\sql2019pre
port 1433
chema_search_path piscinalogs
database db_Poseidon
adapter sqlserver
username "#{ENV['USER']}"
password "#{ENV['PASSWORD']}"
state_file /var/run/fluentd/sql_state

table logs
column_mapping 'time:timestamp,level:level,mensaje:message,Container_Name:containerName,App_Name:appName,Env:enviroment'
# This is the default table because it has no "pattern" argument in
# The logic is such that if all non-default blocks
# do not match, the default one is chosen.
# The default table is required.
flush_interval 10s

```
It returns:
``fluentd | 2024-08-29 09:45:42 +0000 [error]: config error file="/fluentd/etc/fluent.conf" error_class=Fluent::ConfigError error="'host' parameter is required" ``
And so I decided to let both parameters
```

@type copy

@type stdout


@type sql
host 172......
dataserver 172.......\sql2019pre
port 1433
chema_search_path piscinalogs
database db_Poseidon
adapter sqlserver
username "#{ENV['USER']}"
password "#{ENV['PASSWORD']}"
state_file /var/run/fluentd/sql_state

table logs
column_mapping 'time:timestamp,level:level,mensaje:message,Container_Name:containerName,App_Name:appName,Env:enviroment'
# This is the default table because it has no "pattern" argument in
# The logic is such that if all non-default blocks
# do not match, the default one is chosen.
# The default table is required.
flush_interval 10s

```
It returns: `` fluentd | 2024-08-29 09:48:34 +0000 [warn]: #0 failed to flush the buffer. retry_times=4 next_retry_time=2024-08-29 09:48:48 +0000 chunk="620cf5c1a09d87697d7c0f92760ef3fb" error_class=TinyTds::Error error="Unable to connect: Adaptive Server is unavailable or does not exist (172......)"
``
Im quite lost at this point

贡献指南

这个仓库没有索引到贡献指南

调研方向

No source files or tests are named. Start with the SQL output plugin configuration and the TinyTDS connection error, then trace how its host and dataserver parameters are passed to the SQLServer adapter; done means establishing a documented, working connection without the reported configuration errors.

由索引模型根据 Issue 内容生成。

评估

技术栈
ruby, sql
领域
backend, databases
Issue 类型
缺陷
难度
4/5
预计耗时
3-5 天
活跃度
冷清
描述清晰度
需要澄清
新手友好度
35/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。