Trouble in setting up JFORUM with Eclipse as a Tomcat Project

[Deepaks Deshpande]

Hi Guys,

I am trying to set up JForum as a Tomcat Project in Eclipse . I don't seem to see any errors related to libraries and also with classpaths. I am getting the following error . Just in case anybody has been able to resolve this problem, please let me know how do i go about solving the same.

Thanks in advance.

  

17:33:13,191  INFO [JForumBaseServlet   ] Starting JForum. Debug mode is true
17:33:13,206  INFO [ConfigLoader        ] Using cache engine: net.jforum.cache.DefaultCacheEngine
17:33:13,213  INFO [ConfigLoader        ] Creating an instance of net.jforum.repository.BBCodeRepository
17:33:13,214  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.RankingRepository
17:33:13,216  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.SmiliesRepository
17:33:13,219  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.ForumRepository
17:33:13,223  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.TopicRepository
17:33:13,225  INFO [ConfigLoader        ] Creating an instance of  net.jforum.SessionFacade
17:33:13,226  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.PostRepository
17:33:13,227  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.Tpl
17:33:13,229  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.RolesRepository
17:33:13,230  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.SecurityRepository
17:33:13,231  INFO [ConfigLoader        ] Creating an instance of  net.jforum.repository.BanlistRepository
17:33:13,343  INFO [FileMonitor         ] Watching /home/Deepak/Eclipse_Workspaces/Workspace/Forum/WEB-INF/config/languages/en_US.properties
17:33:13,367  INFO [ConfigLoader        ] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
17:33:13,413  INFO [FileMonitor         ] Watching /home/Deepak/Eclipse_Workspaces/Workspace/Forum/WEB-INF/config/database/generic/generic_queries.sql
17:33:13,413  INFO [FileMonitor         ] Watching /home/Deepak/Eclipse_Workspaces/Workspace/Forum/WEB-INF/config/database/mysql/mysql.sql
17:33:13,414  INFO [FileMonitor         ] Watching /home/Deepak/Eclipse_Workspaces/Workspace/Forum/WEB-INF/config/SystemGlobals.properties
17:33:13,515  INFO [MLog                ] MLog clients using log4j logging.
17:33:13,563  INFO [C3P0Registry        ] Initializing c3p0-0.9.1-pre9 [built 23-September-2006 01:47:24; debug? true; trace: 10]
17:33:13,668  INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 120000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 350225, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 350225, idleConnectionTestPeriod -> 3600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/jforum?user=root&password=&autoReconnect=true&useNewIO=false&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=false&dumpQueriesOnException=true&jdbcCompliantTruncation=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 180, usesTraditionalReflectiveProxies -> false ]
17:33:33,652  WARN [ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@626028 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
17:33:33,654  WARN [ThreadPoolAsynchronousRunner] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@626028 -- APPARENT DEADLOCK!!! Complete Status: 
	Managed Threads: 3
	Active Threads: 3
	Active Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1286180 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@192974 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f0a2a0 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
	Pending Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@144c5bb
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@11890d
Pool thread stack traces:
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1522)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1522)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1522)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


17:34:33,662  WARN [ThreadPoolAsynchronousRunner] Task com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1286180 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
17:34:33,663  WARN [ThreadPoolAsynchronousRunner] Task com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@192974 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
17:34:33,663  WARN [ThreadPoolAsynchronousRunner] Task com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f0a2a0 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
Oct 14, 2010 5:35:13 PM org.apache.catalina.core.ApplicationContext log
SEVERE: StandardWrapper.Throwable
net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:468)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
	at net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
	at net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
	at net.jforum.JForum.init(JForum.java:95)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	... 19 more
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	... 19 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: The pool timed out while waiting to acquire a resource -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1157)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:405)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:351)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:466)
	... 16 more
Oct 14, 2010 5:35:13 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Allocate exception for servlet jforum
com.mchange.v2.resourcepool.TimeoutException: The pool timed out while waiting to acquire a resource -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1157)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:405)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:351)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:466)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
	at net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
	at net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
	at net.jforum.JForum.init(JForum.java:95)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)
17:35:38,776  WARN [BasicResourcePool   ] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@192974 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused'.

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2769)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:129)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2838)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:129)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
17:35:38,781  WARN [BasicResourcePool   ] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f0a2a0 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused'.

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

[Ernest Friedman-Hill]

All the error messages seem to indicate that attempts to connect to your database are either timing out or simply being refused, which suggests that you've configured things incorrectly -- it's as if the system is configured to try to cross a firewall to get to your database. Is your mysql database server running on the local machine, or on some other machine that's actually reachable? Can you talk to the database server using the "mysql" command-line client?

If it's not the JForum configuration, maybe it's the configuration of your computer. If you're running this on Windows, maybe it's the blasted "Windows Firewall" thing that's preventing you from accessing the server.

[Deepaks Deshpande]

I have tried connecting JForum with the database (PostgreSQL) and it works perfectly if i do it from the webapps folder of TOMCAT, but when i do the same by using JFORUM with in a tomcat project in eclipse i get this error. Can somebody tell me the directory structure for JForum in a tomcat project for eclipse? Do i need to change some thing in the Deployment Descriptor(Web.xml)..? Can somebody guide me on this..?