fluent / fluent/fluent-plugin-sql

Unable to connnect to SQLServer dataserver parameter not Working

Aberta
#151 1 comentário 0 reações 0 responsáveis Ver no GitHub
enhancement
Linguagem predominante
Ruby
Estrelas
112
Forks
58
Métricas de merge de PRs
Nenhum PR com merge em 30d

Descrição

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

Guia de contribuição

Nenhum guia de contribuição indexado para este repositório

Direção de pesquisa

Nenhum arquivo-fonte ou teste é especificado. Comece pela configuração do SQL output plugin e pelo erro de conexão do TinyTDS; em seguida, rastreie como os parâmetros host e dataserver dele são passados para o SQLServer adapter. Considera-se concluído quando uma conexão documentada e funcional for estabelecida sem os erros de configuração relatados.

Escrita pelo modelo de indexação a partir do texto da issue.

Avaliação

Stack de tecnologia
ruby, sql
Domínio
backend, databases
Tipo de issue
Bug
Dificuldade
4/5
Tempo estimado
3-5 dias
Status de atividade
Pouca atividade
Clareza
Precisa de esclarecimento
Facilidade para iniciantes
35/100

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.