Error for install

[Migrated From Jforum.net]

when i install JForum2.1.7.
it show this error::
Please give write access for the user who is running the webserver to the file 'index.htm' and for the directory 'WEB-INF/config' and its subdirectories before continuing.

but i don't know which user is running the webserver .
and how set the permission for "index.htm".

now ..who know it..
can you tell me?

thanks everybody~!
[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

please refer to this post
https://coderanch.com/t/576949
[originally posted on jforum.net by andowson]

[Migrated From Jforum.net]

Thanks. andowson
but i think i have a mistake.
my environment is window 2003 + jdk1.5 + tomcat5.5.
you see ...
the jforum can running on it?

I'm sorry for my expression..my english is't well..
[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

See https://coderanch.com/t/576958 #14432 (which is an expanded version of the one andowson referred you to..)
[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

Thanks...
I will try it again....

[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

OH...
I will crazy....
I try it again but failed...
.....
show the same error...
....
but i give it the read and write permission..
..
And I don't know a little...
..
That's it have not a "__index.redirect" file in the package jforum-2.1.7 which i download.
....
Frist..I work on window2003server.
but i don't know which user running the appweb server..
so i have not add the permission with the file.
..

[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

Thank you everybody....
...
I success for install the jforum.
thanks..
..
and that is my mistake...
....
i have not take a file"_index.redriect" on the web rootdirectory.
...
now .it's Ok....
..but .
...i use the admin account enter the jforum
..it dones't...

[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

OK..

I haved enter..
..
Thanks
[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

Hi all,
I've just installed jforum 2.1.17 on tomcat 5.5.12 and MySql 4.1.12
Il try to access to the forum http://localhost/jforum-2.1.7/forums/list.page
but the following is displayed on the screen:

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:232) at net.jforum.exceptions.ExceptionWriter.handleExceptionData(ExceptionWriter.java:110) at net.jforum.JForum.handleException(JForum.java:287) at net.jforum.JForum.service(JForum.java:208) 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.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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) 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(Thread.java:595)

In tomcat console the following error is diplayed:

[b]ERROR [ExceptionWriter     ] net.jforum.exceptions.DatabaseException: java.sql.SQL
Exception: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICI
T) for operation 'UNION'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
 at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStat
ement.java:76)
        at 
net.jforum.dao.generic.security.GenericGroupSecurityDAO.loadRoles(GenericGroupSecuri
tyDAO.java:139)   at net.jforum.dao.generic.security.GenericGroupSecurityDAO.loadRolesByUserGroups(Generi



cGroupSecurityDAO.java:217)[/b]

Any suggestion?

[originally posted on jforum.net by dorothy]

[Migrated From Jforum.net]

Probably I found the problem
mySql variables are:

"character_set_client","utf8"
"character_set_connection","utf8"
"character_set_database","utf8"
"character_set_results","utf8"
"character_set_server","latin1"
"character_set_system","utf8"
"character_sets_dir","/usr/share/mysql/charsets/"
"collation_connection","utf8_general_ci"
"collation_database","utf8_general_ci"
"collation_server","latin1_swedish_ci"
"concurrent_insert","ON"
"connect_timeout","5"

I think that the problem is due to "collation_server","latin1_swedish_ci" and
"character_set_server","latin1"

So it's necessary change collation_server and chart set server variable to UTF-8?

[originally posted on jforum.net by dorothy]

[Migrated From Jforum.net]

Yes .
I thank so.

and now .
how about you jforum?

do you success?
[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

I saw this happen for some users in the past, and I'm trying to remember what it was.

For now, you can take a look at this google search. It may help you.

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

[Migrated From Jforum.net]

haha....
....
I used to use the google.com or baidu.com for study!
That is well for study!
[originally posted on jforum.net by c.code]

[Migrated From Jforum.net]

i had the same problem, and after about five million hours of trying everything and cursing at jforum i made it work

i added this to the database.connection.string:
&connectionCollation\=utf8_general_ci

i did it in SystemGlobals.properties and in jforum-custom.conf and in mysql.properties, because i dont understand the difference between all those configuration files please make jforum 3 easier to install!!! otherwise it's great
[originally posted on jforum.net by peacekeeper]

[Migrated From Jforum.net]

Thanks very much to Monroe!I've fixed my problem according to your dicrection.
I use the version2.1.7 and encountered the same problem as c.code.Just copy the file "__index.redirect" to the root directory of the forum.The file can be found in the version2.1.6.
[originally posted on jforum.net by CarlElit]

[Migrated From Jforum.net]

I had to re-create the database jforum. I used the following:

CREATE DATABASE jforum DEFAULT CHARACTER SET utf8;

~magnus1
[originally posted on jforum.net by magnus1]