hello guys,
my grok debugger pattern output doesn't look like the kibana output !! any idea !
here is in kibana :
i think is a multiline problem! i added the multiline codec in the input of logstash also i tried with filebeat.yml but not working!
hello guys,
my grok debugger pattern output doesn't look like the kibana output !! any idea !
i think is a multiline problem! i added the multiline codec in the input of logstash also i tried with filebeat.yml but not working!
Based on what you have shown I find it hard to see what the problem is. It might help if you show the full JSON of a ducument that has been incorrectly parsed.
2019-03-11 11:12:40,670 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-28144: Echec de l'exécution du gestionnaire d'audit détaillé
ORA-20417: ERROR SECURITY DATA
ORA-06512: à "PRODUCTION_AUDIT", ligne 39
ORA-06512: à ligne 1
and this is the pattern used that correctly match in grok debugger:
%{TIMESTAMP_ISO8601:timestamp} %{LOGLEVEL:Loglevel} \[(?<classname>[^\]]+)\] %{GREEDYDATA:Error}(?<msg>[^\)]+)
What does the resulting JSON documents in Elasticsearch look like?
{
"_index": "filebeat-2019.04.08",
"_type": "doc",
"_id": "ZQJe_GkBGmfQmneQJD3j",
"_version": 1,
"_score": null,
"_source": {
"prospector": {},
"classname": "org.hibernate.util.JDBCExceptionReporter",
"beat": {},
"@version": "1",
"Loglevel": "ERROR",
"timestamp": "2019-03-11 09:12:16,070",
"Error": "ORA-28144: Echec de l'exécution du gestionnaire d'audit détaill",
"@timestamp": "2019-04-08T09:51:57.219Z",
"msg": "é",
"log": {
"file": {},
"flags": [
"multiline"
]
},
"input": {},
"host": {
"os": {}
}
},
"fields": {
"@timestamp": [
"2019-04-08T09:51:57.219Z"
]
},
"sort": [
1554717117219
]
}
it should look like this :
{
"timestamp": [
"2019-03-11 11:12:40,670"
],
"Loglevel": [
"ERROR"
],
"classname": [
"org.hibernate.util.JDBCExceptionReporter"
],
"Error": [
"ORA-28144: Echec de l'exécution du gestionnaire d'audit détaillé"
],
"msg": [
"\nORA-20417: ERROR SECURITY DATA\nORA-06512: à "GID_PRODUCTION.GID_SEC_AUDIT_PKG", ligne 39\nORA-06512: à ligne 1"
]
}
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.