Hello
I have to modify a system made a long time ago in Play 2.0.4 and I’m having problems accessing mysql. I know it’s a very old version; The next step may be to update it and make some changes to make it a responsive website.
I had to install Java 7 and mysql 5.6.42 which I think were the ones I had installed on the development machine used at that time.
This app was made by another company and I made a little modification a while ago, I’m not an expert in play.
The mistake is:
Can not connect to database [default]
In F:\Pl\acol\conf\application.conf at line 26.
in the application.conf:
db.default.driver = com.mysql.jdbc.Driver
db.default.url = “jdbc:mysql://localhost:3306/acol”
db.default.user = root
db.default.password = abcd
In Build.scala I have:
val appDependencies = Seq(
// Add your project dependencies here,
“mysql” % “mysql-connector-java” % “5.1.+”,
“commons-lang” % “commons-lang” % “2.5”,
“org.jasypt” % “jasypt” % “1.9.+”,
“org.mybatis” % “mybatis” % “3.0.+”,
//“ads” % “ads-connector-java” % “9.10”,
“org.apache.commons” % “commons-email” % “1.2”
)
I have access to said database from an external utility such as sqlyog. The user and the password are fine.
The log is:
f:\Pl\acol>play run
[info] Loading project definition from F:\Pl\acol\project
[info] Set current project to acol (in build file:/F:/Pl/acol/)
[info] Updating {file:/F:/Pl/acol/}acol…
[info] Resolving org.hibernate.javax.persistence#hibernate-jpa-2.0-api;1.0.1.Fin
[info] Done updating.
— (Running the application from SBT, auto-reloading is enabled) —
[info] play - Listening for HTTP on port 9000…
(Server started, use Ctrl+D to stop and go back to the console…)
[info] Compiling 37 Scala sources and 41 Java sources to F:\Pl\acol\target\scala
-2.9.1\classes…
[warn] Note: Some input files use or override a deprecated API.
[warn] Note: Recompile with -Xlint:deprecation for details.
[warn] Note: Some input files use unchecked or unsafe operations.
[warn] Note: Recompile with -Xlint:unchecked for details.
[error] c.j.b.h.AbstractConnectionHook - Failed to obtain initial connection Sle
eping for 0ms and trying again. Attempts left: 0. Exception: null
[error] application -
! @7a7gmj129 - Internal server error, for request [GET /] ->
play.api.Configuration$$anon$1: Configuration error [Cannot connect to database
[default]]
at play.api.Configuration$.play$api$Configuration$$configError(Configura
tion.scala:71) ~[play_2.9.1.jar:2.0.4]
at play.api.Configuration.reportError(Configuration.scala:258) ~[play_2.
9.1.jar:2.0.4]
at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:249) ~[pla
y_2.9.1.jar:2.0.4]
at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:240) ~[pla
y_2.9.1.jar:2.0.4]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike
.scala:194) ~[scala-library.jar:0.11.3]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike
.scala:194) ~[scala-library.jar:0.11.3]
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (usi
ng password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql
-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-co
nnector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-co
nnector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) ~[mysql-con
nector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(My
sqlIO.java:1714) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224) ~[mysql-connect
or-java-5.1.47.jar:5.1.47]
Can I help me?
I thank you very much, any help is appreciated