River for MySql

Elastic Stack Elasticsearch
1

Hi everyone,
I'm using the river plugin from
https://github.com/jprante/elasticsearch-river-jdbc Does anyone has
experience with it? I'm getting while the login process an access denied
message!
I configured my river like is expected in the documentation:

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://my_domain.com:3306/my_database",
"user" : "my_user",
"password" : "my_password",
"sql" : "select * from my_table"
}
}'

After running the river... it shows me an error as following:

[2014-11-13 10:59:24,928][ERROR][river.jdbc.SimpleRiverSource] while
opening read connection: jdbc:mysql://my_domain.com:3306/my_database Access
denied for user 'my_user'@'my_ip_address' (using password: YES)

java.sql.SQLException: Access denied for
user 'my_user'@'my_ip_address' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)

I'm using the correct domain address + correct username + correct password!
Thank you guys in advance for any help
cheers

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1f779e48-d3f5-4f7b-a067-d083d897818d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

Well i have solved the problem. Everything is working fine :slight_smile:
The db user was not allowed to use from the internet/intranet. So i added a
new db user with appropriate rights in mysql.
thx

Am Donnerstag, 13. November 2014 11:11:35 UTC+1 schrieb Ramy:

Hi everyone,
I'm using the river plugin from
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch Does anyone has
experience with it? I'm getting while the login process an access denied
message!
I configured my river like is expected in the documentation:

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://my_domain.com:3306/my_database",
"user" : "my_user",
"password" : "my_password",
"sql" : "select * from my_table"
}
}'

After running the river... it shows me an error as following:

[2014-11-13 10:59:24,928][ERROR][river.jdbc.SimpleRiverSource] while
opening read connection: jdbc:mysql://my_domain.com:3306/my_database
Access denied for user 'my_user'@'my_ip_address' (using password: YES)

java.sql.SQLException: Access denied for
user 'my_user'@'my_ip_address' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)

I'm using the correct domain address + correct username + correct password!
Thank you guys in advance for any help
cheers

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/e3c78ce4-c22d-4f3c-a244-21b9ff4325aa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.