# River for MySql

**URL:** <https://discuss.elastic.co/t/river-for-mysql/20720>\
**Category:** Elasticsearch\
**Created:** [November 13, 2014, 10:11am UTC](https://discuss.elastic.co/t/river-for-mysql/20720 "2014-11-13T10:11:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramy](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@Ramy](https://discuss.elastic.co/u/Ramy)\
**Post date:** [November 13, 2014, 10:11am UTC](https://discuss.elastic.co/t/river-for-mysql/20720/1 "2014-11-13T10:11:35Z")

</div>

Hi everyone,  
I'm using the river plugin from  
[https://github.com/jprante/elasticsearch-river-jdbc](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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/1f779e48-d3f5-4f7b-a067-d083d897818d%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Ramy](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@Ramy](https://discuss.elastic.co/u/Ramy)\
**Post date:** [November 13, 2014, 10:59am UTC](https://discuss.elastic.co/t/river-for-mysql/20720/2 "2014-11-13T10:59:01Z")

</div>

Well i have solved the problem. Everything is working fine 🙂  
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](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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/e3c78ce4-c22d-4f3c-a244-21b9ff4325aa%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:50am UTC](https://discuss.elastic.co/t/river-for-mysql/20720/3 "2017-07-06T00:50:18Z")

</div>