Fail to log data from server database to elasticsearch

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"
}
}

output {
elasticsearch {
hosts => ["localhost:9200"]
index => "carsssss"
document_type => "safe"

}
stdout{
    codec => rubydebug }

}

and after running a had these errors :


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

I get this error


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