HELP PLEASE! Unknown Source, getAllByName, DriverManager.getConnection :: MySQL

Openfire Openfire Support
1

Hello everyone, sorry I am a bit of a n00b to MySQL, PHP, and Openfire. I am running WHS (Windows Home Server) with MySQL 5.0.51a, PHP v. 5.2.6.

I am able to run the setup for OpenFire but when I get to the page “http://192.168.1.ex#:9090/setup/setup-datasource-standard.jsp”

I enter the correct info with the tab “MySQL” selected from the dropdown, JDBC Driver Class: com.mysql.jdbc.Driver, Database URL: jdbc:mysql://[localhost]:3306/[real-database-name], and my user/pass for the database.

I get this: “A connection to the database could not be made. View the error message by opening the “\logs\error.log” log file, then go back to fix the problem.”

I looked at the error log and i don’t understand why it is saying “Unknown Source” for 6 lines of the code. Can anyone please help me understand what it is not picking up on and how to fix it?

Also on a side note the “ofuser”" table with the username and plainPassword, does this have any significance? I tried changing it to my login and password I used for the database connection to localhost with out and success. Also should this be changed to be a secure type of SQL password?

Thank you so much in advance!!!

ERROR LOG:

2011.04.14 12:52:00 Prototype

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.UnknownHostException

MESSAGE: [localhost]

STACKTRACE:

java.net.UnknownHostException: [localhost]

at java.net.InetAddress.getAllByName(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

2

Ok, so I switched it to Default, Embedded since i read that was a easier setup and now I can get to the login but after logging in I get this:

Exception:

java.lang.ExceptionInInitializerError
     at org.jivesoftware.admin.LoginLimitManager.getInstance(LoginLimitManager.java:48)
     at org.jivesoftware.openfire.admin.login_jsp._jspService(login_jsp.java:143)
     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1216)
     at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:39)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1187)
     at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:74)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1187)
     at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:50)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1187)
     at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:78)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1187)
     at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:164)
     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1187)
     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:425)
     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494)
     at org.eclipse.jetty.server.session.SessionHandler.handle(SessionHandler.java:182)
     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:933)
     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:362)
     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867)
     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
     at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245)
     at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)
     at org.eclipse.jetty.server.Server.handle(Server.java:334)
     at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559)
     at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007)
     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747)
     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209)
     at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406)
     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462)
     at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436)
     at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
     at org.jivesoftware.util.TaskEngine.scheduleAtFixedRate(TaskEngine.java:228)
     at org.jivesoftware.admin.LoginLimitManager.(LoginLimitManager.java:83)
     at org.jivesoftware.admin.LoginLimitManager.(LoginLimitManager.java:33)
     at org.jivesoftware.admin.LoginLimitManager$LoginLimitManagerContainer.(LoginLimitManager.java:39)
     ... 36 more

Any help please?