Increase timerange to fetch data older than 90 day

Issue-ID:ACUMOS-2453

Change-Id: Ia1f82e75818b65fe7fe49f85d01385e2b5a88a6f
Signed-off-by: GUPTA <pg0057291@techmahindra.com>

diff --git a/elk-stack/kibana/config/kibana.yml b/elk-stack/kibana/config/kibana.yml
index 779b5a7..54c3525 100644 (file)
--- a/elk-stack/kibana/config/kibana.yml
+++ b/elk-stack/kibana/config/kibana.yml
@@ -22,4 +22,5 @@
 server.name: kibana
 server.host: "0"
 elasticsearch.url: http://elasticsearch:9200
+elasticsearch.requestTimeout: 120000
 

diff --git a/elk-stack/logstash/pipeline/logstash.conf b/elk-stack/logstash/pipeline/logstash.conf
index 3d8654d..230f654 100644 (file)
--- a/elk-stack/logstash/pipeline/logstash.conf
+++ b/elk-stack/logstash/pipeline/logstash.conf
@@ -78,7 +78,18 @@ jdbc {
           sql_log_level => "error"
        tags => ["database"]
       }
-
+jdbc {
+          jdbc_driver_library => "${ACUMOS_ELK_JDBC_DRIVER_LIBRARY}"
+       jdbc_driver_class => "${ACUMOS_ELK_JDBC_DRIVER_CLASS}"
+          jdbc_connection_string => "${ACUMOS_ELK_JDBC_CONNECTION_STRING}"
+       jdbc_user => "${ACUMOS_ELK_JDBC_USERNAME}"
+       jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
+       jdbc_validate_connection => true
+          schedule => "* * * * *"
+       statement => "select solution.name,CONCAT(user.first_name,' ',user.last_name) from c_solution solution inner join c_user user on user.USER_ID = solution.USER_ID"
+       sql_log_level => "error"
+       tags => ["database"]
+      }
 
 
   beats {