ForumException.java:85)

[Migrated From Jforum.net]

new installation to url: http://localhost:8080/escortforum/nstall/install.page?module=install&action=welcome

Throws an exception:
(ForumException.java:85) at net.jforum.JForum.service(JForum.java:285) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534)
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Sorry. Was annoymous when posted.
[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

The exception tells nothing, but the url seems invalid:

you put

http://localhost:8080/escortforum/nstall/install.page?module=install&action=welcome

but it is missing an "i" in "/nstall/install.page?". Should be "/install/install.page?". It was just a typo when writting the message? If so, then I can't say much about the error.
If you have no luck, then try manual installation: http://www.jforum.net/install_no_wizard.htm

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

That was a typo but I have done the manual install and after a few fat fingering mistakes :roll: it now comes up fine. Thanks
[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

Ok so another dumb question. ops: After a manual install how do I get to the admin page to administer the forum? There is no Admin Control Panel link that I can find.

A second issue. is that the Back to Home page goes to the context jforum even if you have redefined the context.
[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

donniev wrote:Ok so another dumb question. ops: After a manual install how do I get to the admin page to administer the forum? There is no Admin Control Panel link that I can find.

Login as Admin / admin ( note that the username is with capital A ). The link appears in the bottom of the page.

donniev wrote:
A second issue. is that the Back to Home page goes to the context jforum even if you have redefined the context.

Yeah, that's a little bug in the html. You can edit the file templates/default/forum_base.htm and put the correct link.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Nope that link is not there either for Admin/admin or admin/admin

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

The admin user auth works fine? Did you run the xxx_dump.sql file? ( which database are you using? )

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

yes it will auth with Admin/admin and admin/admin
There is one row in jforum_users with a user name Admin
I notice that user_level is null
also the security hash is null
I can alter any of those outside of app if necessary.
The db is mysql and yes I did populate the tables
Here are some non zero rowcounts:
groups 1, role_values 11, roles 22, smilies 26. iuser_groups 1
All other tables are not populated


This is data for the admin user.



user_id user_active username user_password user_session_time user_session_page user_lastvisit user_regdate user_level user_posts user_timezone user_style user_lang user_dateformat user_new_privmsg user_unread_privmsg user_last_privmsg user_emailtime user_viewemail user_attachsig user_allowhtml user_allowbbcode user_allowsmilies user_allowavatar user_allow_pm user_allow_viewonline user_notify user_notify_pm user_popup_pm rank_id user_avatar user_avatar_type user_email user_icq user_website user_from user_sig user_sig_bbcode_uid user_aim user_yim user_msnm user_occ user_interests user_actkey gender themes_id deleted user_viewonline security_hash
1 (null) Admin 21232f297a57a5a743894a0e4a801fc3 0 0 (null) 2005-01-12 13:09:22 (null) 0 (null) %d/%M/%Y %H:%i 0 0 (null) (null) false true false true true true true true true true true 1 (null) 0 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) true (null)


[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

user_level and security_hash are ok to have null values.

Check the id of the Admin user in jforum_users and see if there is a row in jforum_user_groups relating that user_id with the group "Administrators". Also, run the following query in the mysql console:

SELECT * FROM jforum_roles WHERE role_name = 'perm_administration';

and see if there is an entry where the field "user_id" is equal to the id of the Admi OR an entry where the field "group_id" is equal to the id present in jforum_user_groups.

One last question: which jforum version are you using?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Check the id of the Admin user in jforum_users and see if there is a row in jforum_user_groups relating that user_id with the group "Administrators".

No. the group is Administration not Administrators

SELECT * FROM jforum_roles WHERE role_name = 'perm_administration';

There is no column role_name, There is a column name but that query returns an empty set. browsing the table shows that there is no role of that name







[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

forgot to give you the version number. 2.02
[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

Anonymous wrote:on';

There is no column role_name, There is a column name but that query returns an empty set. browsing the table shows that there is no role of that name

So we've found the bug. The queries are in WEB-INF/config/database/mysql_db_dump.sql. I don't know why this file didn't was imported.

So, you can insert the roles by hand:

INSERT INTO jforum_roles ( name, group_id, type ) VALUES ('perm_administration', 2, 1);

( considering that "2" is the Administration group id ).

Restart Tomcat and try.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

ok that worked sort of :lol: column is role_type not type and the groupid is 1 not two

I see the admin panel now

This is in the mysql_datadump.sql

INSERT INTO jforum_roles (group_id, name, role_type) VALUES (@GENERAL_GROUP_ID, 'perm_administration', 0);
INSERT INTO jforum_roles (group_id, name, role_type) VALUES (@ADMIN_GROUP_ID, 'perm_administration', 1);

neither one of those seems to have gotten executed.
do I need to put the other one in? There is only one row in jforums_groups - Administration



[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

Hm, so the dump failed to execute some queries.

Well, I suggest you to have the group "General" at least, but with the id 1 and the Administrator group as id 2. This is the default for jforum, and if you have the ids changed, you may have problems when upgrading, in the future.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I did a fresh install in another context using the wizzard and everything was populated correctly. I suspect that it was operator error on my part in the manual process but I have no clue as to where. So if the wizard executes the same sql scripts everything is ok. If it populates differently then I suppose the scripts could have a bug. Thanks for your help. Actually the learning about the details of the database setup was worth the time spent (for me at least
:lol: )
http://cariforum.cari-bird.org/cariforum/
[originally posted on jforum.net by donniev]

[Migrated From Jforum.net]

Niiiiiiiiiiiice

Keep an eye on JForum! The next version will have good improvements over the existing one!

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Hello I get the same exception. I am running tomcat with enabled SecurityManager.

The Site-Url is: http://dev.planetes.de:8180/forum/install/install.page
The ecxeption:

(ForumException.java:85) at net.jforum.InstallServlet.service(InstallServlet.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:239) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:500) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:266) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:157) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:140) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534)

What is wrong?

Thorsten
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Try manual installation too, please. The error handler is not so good, which makes harder to find these bugs.
I'm working to try to improve the installer.

Rafael
[originally posted on jforum.net by Rafael Steil]