heroku et postgreSQL
Bonjour, je cherche à mettre en ligne une application (un site web) qui tourne actuellement en local sur mon serveur configuré comme dit sur le site d'heroku (variable database_url notamment)
en local le site fonctionne parfaitement mais lorsque j'essaye de le mettre sur le serveur j'ai un soucis avec la base de données:
celui-ci correspond à ce que j'obtiens en console:Envoyé par git push heroku master
2013-04-22T10:02:03.638859+00:00 app[web.1]: [error] c.j.b.h.AbstractConnectionHook - Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: null
2013-04-22T10:02:03.652432+00:00 app[web.1]: at play.api.Configuration$.play$api$Configuration$$configError(Configuration.scala:80)
2013-04-22T10:02:03.654366+00:00 app[web.1]: at play.api.db.BoneCPPlugin.onStart(DB.scala:242)
2013-04-22T10:02:03.657521+00:00 app[web.1]: at play.utils.Threads$.withContextClassLoader(Threads.scala:18)
2013-04-22T10:02:03.652557+00:00 app[web.1]: at play.api.Configuration.reportError(Configuration.scala:558)
2013-04-22T10:02:03.656283+00:00 app[web.1]: at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:63)
2013-04-22T10:02:03.657640+00:00 app[web.1]: at play.api.Play$.start(Play.scala:62)
2013-04-22T10:02:03.652906+00:00 app[web.1]: at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:251)
2013-04-22T10:02:03.653032+00:00 app[web.1]: at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:242)
2013-04-22T10:02:03.657812+00:00 app[web.1]: at play.core.StaticApplication.<init>(ApplicationProvider.scala:54)
2013-04-22T10:02:03.652176+00:00 app[web.1]: Configuration error: Configuration error[Cannot connect to database [default]]
2013-04-22T10:02:03.653187+00:00 app[web.1]: at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)
2013-04-22T10:02:03.658098+00:00 app[web.1]: at play.core.server.NettyServer$$anonfun$main$5.apply(NettyServer.scala:259)
2013-04-22T10:02:03.651871+00:00 app[web.1]: Oops, cannot start the server.
2013-04-22T10:02:03.654237+00:00 app[web.1]: at scala.collection.AbstractTraversable.map(Traversable.scala:105)
2013-04-22T10:02:03.658610+00:00 app[web.1]: at scala.Option.map(Option.scala:145)
2013-04-22T10:02:03.654111+00:00 app[web.1]: at scala.collection.TraversableLike$class.map(TraversableLike.scala:244)
2013-04-22T10:02:03.657271+00:00 app[web.1]: at play.api.Play$$anonfun$start$1.apply(Play.scala:63)
2013-04-22T10:02:03.657392+00:00 app[web.1]: at play.api.Play$$anonfun$start$1.apply(Play.sca
la:63)
2013-04-22T10:02:03.658221+00:00 app[web.1]: at play.core.server.NettyServer$$anonfun$main$5.apply(NettyServer.scala:258)
2013-04-22T10:02:03.667159+00:00 app[web.1]: ... 22 more
2013-04-22T10:02:03.657973+00:00 app[web.1]: at play.core.server.NettyServer$.createServer(NettyServer.scala:228)
2013-04-22T10:02:03.666885+00:00 app[web.1]: at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:244)
2013-04-22T10:02:03.658737+00:00 app[web.1]: at play.core.server.NettyServer$.main(NettyServer.scala:258)
2013-04-22T10:02:03.658951+00:00 app[web.1]: at play.core.server.NettyServer.main(NettyServer.scala)
2013-04-22T10:02:03.653318+00:00 app[web.1]: at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)
2013-04-22T10:02:03.657141+00:00 app[web.1]: at play.api.Play$$anonfun$start$1.apply$mcV$sp(Play.scala:63)
2013-04-22T10:02:03.653859+00:00 app[web.1]: at scala.collection.immutable.List.foreach(List.scala:309)
2013-04-22T10:02:03.656422+00:00 app[web.1]: at scala.collection.immutable.List.foreach(List.scala:309)
2013-04-22T10:02:03.659128+00:00 app[web.1]: Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "toxyxzmipgytkk"
2013-04-22T10:02:03.659292+00:00 app[web.1]: at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293)
2013-04-22T10:02:03.659496+00:00 app[web.1]: at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
2013-04-22T10:02:03.659678+00:00 app[web.1]: at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
2013-04-22T10:02:03.663788+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
2013-04-22T10:02:03.664088+00:00 app[web.1]: at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
2013-04-22T10:02:03.664218+00:00 app[web.1]: at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
2013-04-22T10:02:03.664344+00:00 app[web.1]: at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)
2013-04-22T10:02:03.664508+00:00 app[web.1]: at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
2013-04-22T10:02:03.664677+00:00 app[web.1]: at org.postgresql.Driver.makeConnection(Driver.java:393)
2013-04-22T10:02:03.664803+00:00 app[web.1]: at org.postgresql.Driver.connect(Driver.java:267)
2013-04-22T10:02:03.664945+00:00 app[web.1]: at java.sql.DriverManager.getConnection(DriverManager.java:620)
2013-04-22T10:02:03.665104+00:00 app[web.1]: at java.sql.DriverManager.getConnection(DriverManager.java:200)
2013-04-22T10:02:03.665262+00:00 app[web.1]: at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256)
2013-04-22T10:02:03.665384+00:00 app[web.1]: at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305)
2013-04-22T10:02:03.665512+00:00 app[web.1]: at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:150)
2013-04-22T10:02:03.665634+00:00 app[web.1]: at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:112)
2013-04-22T10:02:03.655897+00:00 app[web.1]: at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:63)
2013-04-22T10:02:05.228423+00:00 heroku[web.1]: Process exited with status 255
2013-04-22T10:02:05.240642+00:00 heroku[web.1]: State changed from starting to crashed
mais pas à ce que j'ai sur le site:DATABASE_URL: postgres://toxyxzmipgytkk:mhR1-hDILAThvsAYR8JPYEk-U-@ec2-23-21-105-133.compute-1.amazonaws.com:5432/da953ameos8d4k
JAVA_OPTS: -Xmx384m -Xss512k -XX:+UseCompressedOops
JAVA_TOOL_OPTIONS: -Djava.net.preferIPv4Stack=true
PATH: .jdk/bin:.sbt_home/bin:/usr/local/bin:/usr/bin:/bin
REPO: /app/.sbt_home/.ivy2/cache
SBT_OPTS: -Xmx384m -Xss512k -XX:+UseCompressedOops
ce qui donnerai:User huxauxytcmltaw
Port 5432
Password Hide
postgres://huxauxytcmltaw:[pass]@ec2-54-225-84-29.compute-1.amazonaws.com:5432/d73blb7i8m2ksn
du coup je me demande comment ça se fait qu'il existe une différence entre la valeur réel et celle proposée dans la data_url ayant été créé par heroku lors de la création de l'app...
Répondre avec citation
Partager