mysql remote use local ip

150 views
Skip to first unread message

glop inous

unread,
Jun 28, 2013, 10:34:47 AM6/28/13
to play-fr...@googlegroups.com
Hi,

I want use a remote mysql server for my development. ( play! 2.1.1 (using Java 1.7.0_21 and Scala 2.10.0) )
I have this config : 
db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://remote/db"
db.default.user="username"
db.default.pawwsord="password"

But i have this log :
[debug] c.j.b.BoneCPDataSource - JDBC URL = jdbc:mysql://remote/db, ...
[warn] c.j.b.BoneCPConfig - JDBC password was not set in config!
[error] c.j.b.h.AbstractConnectionHook - Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: null
[error] application - 

! @6emimihh9 - Internal server error, for (GET) [/] ->

play.api.Configuration$$anon$1: Configuration error[Cannot connect to database [db]]
at play.api.Configuration$.play$api$Configuration$$configError(Configuration.scala:80) ~[play_2.10.jar:2.1.1]
at play.api.Configuration.reportError(Configuration.scala:558) ~[play_2.10.jar:2.1.1]
at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:251) ~[play-jdbc_2.10.jar:2.1.1]
at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:242) ~[play-jdbc_2.10.jar:2.1.1]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) ~[scala-library.jar:na]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) ~[scala-library.jar:na]
Caused by: java.sql.SQLException: Access denied for user 'username'@'local' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.25.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) ~[mysql-connector-java-5.1.25.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) ~[mysql-connector-java-5.1.25.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927) ~[mysql-connector-java-5.1.25.jar:na]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709) ~[mysql-connector-java-5.1.25.jar:na]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252) ~[mysql-connector-java-5.1.25.jar:na]


It's a bug or i have wrong config ?

Thank.

Marconi Lanna

unread,
Jun 28, 2013, 11:13:20 AM6/28/13
to play-fr...@googlegroups.com
You have a typo in "db.default.pawwsord", it should be "password"

glop inous

unread,
Jun 29, 2013, 1:14:35 AM6/29/13
to play-fr...@googlegroups.com
Problem solved, big thank :D.
I think that error message is strange ...

Again thank :)
Reply all
Reply to author
Forward
0 new messages