# Kibana n'affiche pas l'index

**URL:** <https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841>\
**Category:** Discussions en français\
**Created:** [June 22, 2022, 8:02am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841 "2022-06-22T08:02:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Merveille\_Kimfuta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/merveille_kimfuta/32/101718_2.png) [@Merveille\_Kimfuta](https://discuss.elastic.co/u/Merveille_Kimfuta)\
**Post date:** [June 22, 2022, 8:02am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/1 "2022-06-22T08:02:13Z")

</div>

Bonjour,

"Indexlogstash" n'est pas proposé dans la liste des index dans Kibana alors qu'il est bien dans logstash.conf :

output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
user =\> "elastic"  
password =\> "rien"  
index =\> "indexforlogstash"  
}  
}

Il n'est pas affiché non plus dans "[http://localhost:9200/\_cat/indices?v](http://localhost:9200/_cat/indices?v)" :

 ![hghhghg](https://us1.discourse-cdn.com/elastic/original/3X/6/8/68c943dac5cfdf40c95442001b7447a32b25433c.jpeg)

Le dossier log de Kibana est vide.

Pouvez-vous m'aider s'il vous plaît ?

 ![Ckjkjapture](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1c4cad0a02e5ab1f75ed3b9717f0947d3dbf604b.jpeg)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 22, 2022, 9:27am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/2 "2022-06-22T09:27:38Z")

</div>

Il y a quoi en input?

---

<div class="post-metadata">

**Author:** ![Merveille\_Kimfuta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/merveille_kimfuta/32/101718_2.png) [@Merveille\_Kimfuta](https://discuss.elastic.co/u/Merveille_Kimfuta)\
**Post date:** [June 22, 2022, 9:34am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/3 "2022-06-22T09:34:13Z")

</div>

input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:sqlserver://10.70.165.149\QAITF\_CALIPSO:1441;integratedSecurity=true;"  
jdbc\_user =\> "qaitfmar\_moe"  
jdbc\_password =\> "MAkPjiT"  
jdbc\_driver\_library =\> "C:\ELK Stack\logstash-8.2.2-windows-x86\_64\logstash-8.2.2\logstash-core\lib\jars\mssql-jdbc-10.2.1.jre8.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
statement =\> "SELECT TOP(1000) \* FROM data.Table WITH(NOLOCK) WHERE Id \> :sql\_last\_value ORDER BY Id ASC"  
tracking\_column =\> "id"  
tracking\_column\_type =\> "numeric"  
use\_column\_value =\> true  
last\_run\_metadata\_path =\> "./Log/.logstash\_jdbc\_last\_run"  
schedule =\> "\*/30 \* \* \* \* \*"  
}  
}

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 22, 2022, 10:11am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/4 "2022-06-22T10:11:18Z")

</div>

Je te conseille de formater tes posts (la partie code) en markdown ou avec le bouton `</>`.

Ajoute un output stdout pour vérifier qu'il y a bien des événements générés.  
Si ce n'est pas le cas, vérifie la partie input. Inutile d'aller voir dans Kibana ou Elasticsearch dans ce cas. 😉

---

<div class="post-metadata">

**Author:** ![Merveille\_Kimfuta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/merveille_kimfuta/32/101718_2.png) [@Merveille\_Kimfuta](https://discuss.elastic.co/u/Merveille_Kimfuta)\
**Post date:** [June 23, 2022, 5:50am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/5 "2022-06-23T05:50:43Z")

</div>

Je n'ai pas bien compris. J'ai ajouté stdout mais comment vérifier que les événements ont été générés ?

```auto
input {
stdin {}
jdbc {
 jdbc_connection_string => "jdbc:sqlserver://10.70.165.149\QAITF_CALIPSO:1441;integratedSecurity=false;"
 jdbc_user => "qaitfmar_moe"
 jdbc_password => "rien5"
 jdbc_driver_library => "C:\ELK Stack\logstash-8.2.2-windows-x86_64\logstash-8.2.2\logstash-core\lib\jars\mssql-jdbc-10.2.1.jre8.jar"
 jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
 statement => "SELECT TOP(1000) * FROM data.Table WITH(NOLOCK) WHERE Id > :sql_last_value ORDER BY Id ASC"
 tracking_column => "id"
 tracking_column_type => "numeric"
 use_column_value => true
 schedule => "*/30 * * * * *"
 }
}

output { 
 stdout{} 
 elasticsearch {
  hosts => ["http://localhost:9200"]
  user => "elastic"
  password => "rien"
  index => "indexforlogstash"
  ssl => false
  ssl_certificate_verification => false
 
  
} 
}

```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 23, 2022, 6:47am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/6 "2022-06-23T06:47:41Z")

</div>

Les messages qui sortent apparaissent dans la console.

Pourquoi as-tu stdin dans les inputs ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 21, 2022, 6:47am UTC](https://discuss.elastic.co/t/kibana-naffiche-pas-lindex/307841/7 "2022-07-21T06:47:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.