JDBC Connect Error

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


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

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

@magnusbaeck Thank you for your reply.

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

		jdbc_streaming {
			jdbc_connection_string => "jdbc:mysql://"
			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"

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

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