sampath1
December 2, 2019, 11:02am
6
Hi all,
Still this feature under investigation?
Is there a way to mask/hide the jdbc_password parameter.
Config File:
input {
jdbc {
jdbc_driver_library => "C:\Program Files\DbVisualizer\jdbc\oracle\ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@TEST :1244:TESTDB"
jdbc_user => "user_id"
#jdbc_password => ""
jdbc_validate_connection => true
jdbc_fetch_size => 1000
schedule => "* * * * *"
statement => "Select EMP_ID from Employee_data"
}
}
output {
elasticsear…
opened 07:32AM - 02 Dec 19 UTC
Hi,
I am new to this Logstash.
I don't want to specify plain text "username"… and "password" in logstash.conf for the Database input plugin. Is there any way to do that?
Is there any possible way to encrypt or hide the DB "username" and "password." in log stash config code?
Elastic Search Version 7.0.0
Logstash version 7.0.0
logstash.conf file
input {
jdbc {
jdbc_connection_string => "jdbc:postgresql://DbIP:port/DatabaseName"
jdbc_user => "dbuser"
jdbc_password => "**dbpassword**"
jdbc_driver_class => "org.postgresql.Driver"
jdbc_driver_library => "/home/Downloads/postgresql-42.1.4.jar"
jdbc_validate_connection => true
statement => 'select *from order_tbl'
use_column_value => true
tracking_column_type =>"numeric"
tracking_column => "ford_id"
clean_run => true
}
}
output {
elasticsearch {
user => ESUser
password => ESPassword
ssl => true
sniffing => true
index => "1_999"
document_type => "1_999"
document_id => "%{ford_id}"
hosts => ["https://ESIp:Port"]
}
}