roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Raible" <mrai...@gmail.com>
Subject Re: Cannot connect to database
Date Wed, 01 Oct 2008 06:11:23 GMT
Can you connect to your database from the command line? If you're
using MySQL, "mysql -u root -p" should allow you to connect. It looks
to me like your DB isn't running.

Matt

On Wed, Oct 1, 2008 at 12:04 AM, raúl fuenzalida <aeon.lancer@gmail.com> wrote:
> hi!, don't know what i did wrong, help please:
>
>
>
> A database error occurred, probably because your database connection
> is misconfigured. You will have to fix this problem and then restart
> or redeploy Roller before you can proceed. Here's what happened when
> Roller tried to establish a connection:
>
>    * SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES
>    * -- Using JDBC driver class: com.mysql.jdbc.Driver
>    * -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb
>    * -- Using JDBC username: scott
>    * -- Using JDBC password: [hidden]
>    * SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver]
>    * ERROR: unable to obtain database connection. Likely problem: bad
> connection parameters or database unavailable.
>
> Why did that happen?
>
> In case the clues above are not enough to help you figure out what is
> going wrong, here are some more details. The root cause of the problem
> is an exception of type
> [com.mysql.jdbc.exceptions.jdbc4.CommunicationsException]
>
> To help you debug the problem, here is the stack trace for that exception:
>
>    [com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> Last packet sent to the server was 0 ms ago.
>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
>        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
>        at java.lang.reflect.Constructor.newInstance(Unknown Source)
>        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
>        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
>        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
>        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
>        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
>        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
>        at java.lang.reflect.Constructor.newInstance(Unknown Source)
>        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
>        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
>        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
>        at java.sql.DriverManager.getConnection(Unknown Source)
>        at java.sql.DriverManager.getConnection(Unknown Source)
>        at org.apache.roller.weblogger.business.DatabaseProvider.getConnection(DatabaseProvider.java:177)
>        at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabaseProvider.java:141)
>        at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:171)
>        at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
>        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
>        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
>        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
>        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
>        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
>        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
>        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
>        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
>        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
>        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
>        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
>        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
>        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>        at java.lang.reflect.Method.invoke(Unknown Source)
>        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: java.net.ConnectException: Connection refused: connect
>        at java.net.PlainSocketImpl.socketConnect(Native Method)
>        at java.net.PlainSocketImpl.doConnect(Unknown Source)
>        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
>        at java.net.PlainSocketImpl.connect(Unknown Source)
>        at java.net.SocksSocketImpl.connect(Unknown Source)
>        at java.net.Socket.connect(Unknown Source)
>        at java.net.Socket.connect(Unknown Source)
>        at java.net.Socket.<init>(Unknown Source)
>        at java.net.Socket.<init>(Unknown Source)
>        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
>        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
>        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
>        ... 39 more]
>



-- 
http://raibledesigns.com
Mime
View raw message