I had installed the jdbc plugin with the command logstash-plugin install .....
and I had set the JAVA_HOME with the command "setx JAVA_HOME "path of java file"
this the pipeline:
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/d02e3f25"
jdbc_user => "d02e3f25@"
jdbc_password => "XcY3pV29UCr4HpUY"
jdbc_driver_library => "C:/mysql-connector-java-8.0.11.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
statement => "SELECT * from accelerometre"
}
}
I know that it seems obvious as there is an "Access denied" message. But you didn't explicitly say it, so I have to ask: Did you make sure that the user and password are right and the user may access the datebase via the localhost?
(If these are your real credentials, the @ in the user name that doesn't appear in the error message is irritating me slightly.)
it was a mistake the @ in the user name,
I had changed the code because the user can't access to the database via the localhost because I log data from the server database.
I had changed the jdbc_connecting_string from localhost to SERVER, the jdbc_driver_library and the jdbc_driver_class adequate for connecting data from the server
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.