aspose file tools*
The moose likes JForum and the fly likes Installing from Source, using HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Installing from Source, using HSQLDB" Watch "Installing from Source, using HSQLDB" New topic
Author

Installing from Source, using HSQLDB

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
So I downloaded the source from CVS, created a jforum-custom.conf with a single line:
, as per the instructions here. When I build and deploy the project, and hit http://localhost:8080/jforum, I get the following error:



...well, I won't bore you with the details. Suffice it to say that the ConfigLoader is looking for a config entry called dao.driver. For some reason, in WEB-INF/config/database/hsqldb, there is no hsqldb.properties file with the required property, so it looks like I can't use HSQLDB. I'm sure someone has probably run into thes problem before. How do I fix it?

As well, how do I run the DB initialization scripts if I'm using HSQLDB? There are no admin tools (that I know of)...

thanks,
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Okay, so I fixed that. Now I'm getting the following error:

net.jforum.exceptions.ForumStartupException: Error while starting jforum - net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: Error selectAll()
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:107)
at net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:782)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
at net.jforum.JForum.init(JForum.java:113)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: net.jforum.exceptions.DatabaseException: Error selectAll()
... 23 more
Caused by: java.sql.SQLException: Table not found in statement [SELECT categories_id, title, display_order, moderated FROM jforum_categories ORDER BY display_order]
... 23 more

org.hsqldb.jdbc.Util.throwError(Unknown Source)
org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
net.jforum.dao.generic.GenericCategoryDAO.selectAll(GenericCategoryDAO.java:107)
net.jforum.repository.ForumRepository.loadCategories(ForumRepository.java:782)
net.jforum.repository.ForumRepository.start(ForumRepository.java:128)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
net.jforum.JForum.init(JForum.java:113)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


Which is normal, since I haven't yet figured out how to run the HSQLDB initialization script, to build and populate the database. Can anyone help?
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Okay, I figured out how to run hsqldb_db_struct.sql, using an ANT script. I also ran hsqldb_data_dump.sql, without difficulty.

I don't know how to run the hsqldb.sql script, though. I receive the following error:

Buildfile: C:\projects\jforum\WEB-INF\config\database\hsqldb\build.xml
db.build:
[sql] Executing file: C:\projects\jforum\WEB-INF\config\database\hsqldb\hsqldb.sql
[sql] Failed to execute: UserModel.lastUserRegistered = SELECT TOP 1 user_id, username FROM jforum_users ORDER BY user_regdate DESC UserModel.selectAllByLimit = SELECT LIMIT ? ? user_email, user_id, user_posts, user_regdate, username, deleted, user_karma, \ user_from, user_website, user_viewemail FROM jforum_users ORDER BY user_id UserModel.lastGeneratedUserId = SELECT MAX(user_id) from jforum_users UserModel.selectAllByGroup = SELECT LIMIT ? ? user_email, u.user_id, user_posts, user_regdate, username, deleted, user_karma, \ user_from, user_website, user_viewemail \ FROM jforum_users u, jforum_user_groups ug \ WHERE u.user_id = ug.user_id \ AND ug.group_id = ? \ ORDER BY user_id UserModel.selectById = SELECT u.*, \ (SELECT COUNT(1) FROM jforum_privmsgs pm \ WHERE pm.privmsgs_to_userid = u.user_id \ AND pm.privmsgs_type = 1) AS private_messages \ FROM jforum_users u \ WHERE u.user_id = ? UserModel.isUsernameRegistered = SELECT COUNT(1) as registered FROM jforum_users WHERE LCASE(username) = LCASE(?) UserModel.login = SELECT user_id FROM jforum_users WHERE LCASE(username) = LCASE(?) AND user_password = ? PostModel.lastGeneratedPostId = SELECT max(post_id) from jforum_posts PostModel.selectAllByTopicByLimit = SELECT LIMIT ? ? p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.attach, \ enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, pt.post_subject, pt.post_text, username, p.need_moderate \ FROM jforum_posts p, jforum_posts_text pt, jforum_users u \ WHERE p.post_id = pt.post_id \ AND topic_id = ? \ AND p.user_id = u.user_id \ AND p.need_moderate = 0 \ ORDER BY post_time ASC PostModel.selectByUserByLimit = SELECT LIMIT ? ? p.post_id, topic_id, forum_id, p.user_id, post_time, poster_ip, enable_bbcode, p.attach, \ enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, status, pt.post_subject, pt.post_text, username, p.need_moderate \ FROM jforum_posts p, jforum_posts_text pt, jforum_users u \ WHERE p.post_id = pt.post_id \ AND p.user_id = u.user_id \ AND p.user_id = ? \ AND p.need_moderate = 0 \ AND forum_id IN(:fids \ ORDER BY post_time DESC PollModel.lastGeneratedPollId = SELECT MAX(vote_id) FROM jforum_vote_desc ForumModel.lastGeneratedForumId = SELECT MAX(forum_id) from jforum_forums TopicModel.selectAllByForumByLimit = SELECT LIMIT ? ? t.*, p.user_id AS last_user_id, p.post_time, 0 AS attach \ FROM jforum_topics t, jforum_posts p \ WHERE t.forum_id = ? \ AND p.post_id = t.topic_last_post_id \ AND p.need_moderate = 0 \ ORDER BY t.topic_type DESC, t.topic_last_post_id DESC TopicModel.selectRecentTopicsByLimit = SELECT LIMIT 0 ? t.*, p.user_id AS last_user_id, p.post_time, 0 AS attach \ FROM jforum_topics t, jforum_posts p \ WHERE p.post_id = t.topic_last_post_id \ AND t.user_id = ? \ AND p.need_moderate = 0 \ ORDER BY t.topic_last_post_id DESC \ TopicModel.lastGeneratedTopicId = SELECT MAX(topic_id) from jforum_topics TopicModel.selectByUserByLimit = SELECT LIMIT ? ? t.*, p.user_id AS last_user_id, p.post_time, 0 AS attach \ FROM jforum_topics t, jforum_posts p \ WHERE p.post_id = t.topic_last_post_id \ AND t.user_id = ? \ AND p.need_moderate = 0 \ AND t.forum_id IN(:fids \ ORDER BY t.topic_last_post_id DESC PrivateMessagesModel.lastGeneratedPmId = SELECT max(privmsgs_id) from jforum_privmsgs SearchModel.cleanSearchResults = DELETE FROM jforum_search_results WHERE session_id = ? OR datediff('hh',search_time,current_timestamp) < 1 SearchModel.cleanSearchTopics = DELETE FROM jforum_search_topics WHERE session_id = ? OR datediff('hh',search_time,current_timestamp) < 1 SearchModel.searchByWord = SELECT post_id FROM jforum_search_wordmatch wm, jforum_search_words w \ WHERE wm.word_id = w.word_id \ AND LCASE(w.word) = LCASE(?) SearchModel.getPostsToIndex = SELECT LIMIT ? ? p.post_id, pt.post_text, pt.post_subject \ FROM jforum_posts p, jforum_posts_text pt \ WHERE p.post_id = pt.post_id \ AND p.post_id BETWEEN ? AND ? SmiliesModel.lastGeneratedSmilieId = SELECT max(smilie_id) from jforum_smilies PermissionControl.lastGeneratedRoleId = SELECT max(role_id) from jforum_roles CategoryModel.lastGeneratedCategoryId = SELECT max(categories_id) from jforum_categories AttachmentModel.lastGeneratedAttachmentId = SELECT MAX(attach_id) FROM jforum_attach

BUILD FAILED
C:\projects\jforum\WEB-INF\config\database\hsqldb\build.xml:6: java.sql.SQLException: Unexpected token: USERMODEL in statement [ UserModel.lastUserRegistered]

Total time: 719 milliseconds
.

When I attempt to load the web app in a browser, I get:
net.jforum.exceptions.ForumStartupException: Error while starting jforum - net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: Error getLastUserInfo()
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.checkAvailable(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:600)
at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
at net.jforum.JForum.init(JForum.java:113)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: net.jforum.exceptions.DatabaseException: Error getLastUserInfo()
... 26 more
Caused by: java.sql.SQLException: No data is available
... 26 more

org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.checkAvailable(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:600)
net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
net.jforum.JForum.init(JForum.java:113)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


Guaranteed this is caused just by my inability to run the DB configuration scripts...
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Before doing anything, it would be more judicious to install official version 2.1.6, to use it then to possibly try to apply the CVS's patchs

Just for info, hsqldb.properties is only a template used to generate real <your_dababase_name>.properties file, this is done in install
Sure jforum-custom.conf have to contain many more than just :
database.driver.name = hsqldb


[originally posted on jforum.net by redhand]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks, redhand!

Yeah, I figured that out by browsing around the forums. Here's the various .properties file contents, if that might shed some light on the problem:

jforum-custom.conf:


and WEB-INF/config/hsqldb/jforum.properties:


Am I missing something? Is there some documentation that could help me set this up from source?

Something else I forgto to mention: When I try to browse the site, I'm just browsing to http://localhost:8080/jforum. Should I be hitting the InstallAction first? How do I do that? I think if I download the installation package, this is set up as default, but not when I check it out from CVS. Is that correct?
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
redhand wrote:Before doing anything, it would be more judicious to install official version 2.1.6, to use it then to possibly try to apply the CVS's patchs


Hi redhand. I tried doing this, but when I compiled and deployed the CVS version, I receive the following:

Expression templateName is undefined on line 5, column 14 in exception.html. The problematic instruction: ---------- ==> ${templateName} [on line 5, column 12 in exception.html] in include "${templateName}/message.htm" [on line 5, column 1 in exception.html] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression templateName is undefined on line 5, column 14 in exception.html. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.Expression.getStringValue(Expression.java:118) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.renderElementToString(Environment.java:1461) at freemarker.core.StringLiteral.getStringValue(StringLiteral.java:95) at freemarker.core.Include.accept(Include.java:110) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.process(Environment.java:176) at freemarker.template.Template.process(Template.java:231) at net.jforum.exceptions.ExceptionWriter.handleExceptionData(ExceptionWriter.java:108) at net.jforum.JForum.service(JForum.java:231) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source)


Now I really have no idea what THAT's about. template.dir is correctly set in SystemGlobals.properties. Is it possible an exception is redirecting to exception.html before SystemGlobals.properties is fully loaded?
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Turns out this was showing up because the database structure is different in CVS from the release db structure. There is no upgrade path in the HSQLDB directory.

So I re-ran the HSQLDB initialization scripts, and now I receive the following:
net.jforum.exceptions.ForumStartupException: Error while starting jforum - net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: Error getLastUserInfo()
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.checkAvailable(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:600)
at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
at net.jforum.JForum.init(JForum.java:113)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: net.jforum.exceptions.DatabaseException: Error getLastUserInfo()
... 26 more
Caused by: java.sql.SQLException: No data is available
... 26 more

org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.checkAvailable(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
org.hsqldb.jdbc.jdbcResultSet.getString(Unknown Source)
net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:600)
net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:101)
net.jforum.JForum.init(JForum.java:113)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)

It looks like JForum can't find any user data, although the jforum.properties and jforum.log files in the hsqldb folder clearly show that the Anonymous and Admin users were correctly inserted...
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I finally figured it out! Somehow, I was downloading part of 2.1.7 and part of 2.1.6. DAB structures weren't matching up, classes weren't in the right packages, etc. I refreshed from CVS, and everything is hunky-dory!

Only thing is, I don't know the admin password (since it's stored in MD5 hash). What is the default admin password in CVS?
[originally posted on jforum.net by roach]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Default password is set by install system, so I don't what is stored in your database. You can easily set what you want by computing any md5 hash
[originally posted on jforum.net by redhand]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
roach wrote:I finally figured it out! Somehow, I was downloading part of 2.1.7 and part of 2.1.6. DAB structures weren't matching up, classes weren't in the right packages, etc. I refreshed from CVS, and everything is hunky-dory!

Only thing is, I don't know the admin password (since it's stored in MD5 hash). What is the default admin password in CVS?


http://www.coderanch.com/t/576346 #11173
[originally posted on jforum.net by Serge Maslyukov]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I can't figure out what's the real cause here.
it seems to me like script ies either not running.or database is not getting formed properly.
the other thing i don't know where its getting formed.
can any one give any hints what can be the cause.
this whole application is working fine in my production server.
where we found some bug to resolve that i tried working it in local machine.
But i am getting these errors so main oage itself not at all coming up.

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
java.lang.Thread.run(Thread.java:534)


root cause

net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: java.sql.SQLException: Table not found: JFORUM_CATEGORIES in statement [SELECT categories_id, title, display_order, moderated FROM jforum_categories ORDER BY display_order]
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:102)
net.jforum.JForum.init(JForum.java:112)
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
java.lang.Thread.run(Thread.java:534)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.9

please suggest something here.
vijendra
[originally posted on jforum.net by vijendra]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Installing from Source, using HSQLDB