TCP/IP is recommended.
> Date: Wed, 1 Oct 2008 02:31:27 -0400 > From: [EMAIL PROTECTED] > To: [email protected]; [EMAIL PROTECTED] > Subject: Re: Cannot connect to database > > http://www.transitorio.cl/weblog/resource/sadf.PNG > > it still throw the error. is it necessary to enable TCP/IP networking > in the MySQL wizard? i'm running it into the computer only > > > > On Wed, Oct 1, 2008 at 2:11 AM, Matt Raible <[EMAIL PROTECTED]> wrote: > > 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 <[EMAIL PROTECTED]> 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 > > _________________________________________________________________ Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
