JDBC Connect Error

Elastic Stack Logstash
1

How can I sove this Error..? using password?? Is there an option for using password in the Reference?

Error:

[ERROR][logstash.pipeline ] Pipeline aborted due to error {:pipeline_id=>"main", :exception=>#<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: Access denied for user 'root'@'1.247.39.243' (using password: YES)>, :backtrace=>...

2

Are you specifying a password in your jdbc input? Is it the right one? What does your configuration look like?

3

@magnusbaeck Thank you for your reply.

Yes.. password is correct. My configuration is this :

if(![tcpCid]){
		jdbc_streaming {
			jdbc_connection_string => "jdbc:mysql://182.162.136.33:3306/Jecheon"
			jdbc_driver_library => "C:\logstash-6.2.3\logstash-6.2.3\lib\mysql-connector-java-5.1.46\mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar"
	
			jdbc_user => "root"
			jdbc_password => "jkcore997300**"

			statement => "SELECT CID FROM TB_PVC WHERE LORA_DEVID = :parsedSr"
			target => "matchingCid"

			jdbc_driver_class => "com.mysql.jdbc.Driver"
		}
	}
4

@magnusbaeck Oh.. I'm so sorry. Password isn't correct.. Thank you