New Versions of Confluence and Jira out!

drop the appropriate jdbc driver into /confluence/WEB-INF/lib
mistake from below

its nice starting fresh, deleting away the old mess
was never in production so nothing really to keep
must figure a way to backup stuff, need a strategy
got an worthwhile exercise, will be following open course ware's business
courses
and will append my own experience and views into confluence
happy to help out a friend in the construction line
tomorrow is a busy day
got av training or something like that at church
i watched quite a lot of youtube today
president bush address the un
then iran
then richard dawkins reading his new preface for the paperback version of the god delusion
i need clear language
i hope that the play i'm going to watch later with han doesn't suck
what, no exit?
what if i can't take care of the one i love?
thats why i'm single, i can't provide for you

Configuring Confluence

confluence-init.properties modified conf/server.xml using ports 8015 and 8090

in my special note form

before:
...
Server port="8000"
...
classname="org.apache.coyote.tomcat4.CoyoteConnector"
port="8080"
minProcessors="5"
maxProcessors="75"
enableLookups="false"
redirectorPort="8444"
acceptCount="10"
debug="0"
connectionTimeouts="20000"
useURIValidationHack="false"
URIEncoding="UTF-8" end

After:
...
Server port="8015"
...
classname="org.apache.coyote.tomcat4.CoyoteConnector"
port="8090"
minProcessors="5"
maxProcessors="75"
enableLookups="false"
redirectorPort="8444"
acceptCount="10"
debug="0"
connectionTimeouts="20000"
useURIValidationHack="false"
URIEncoding="UTF-8" end

mysql-connector-java-3.1.14-bin.jar filed under common/lib
CREATE DATABASE blehblehbleh CHARACTER SET UTF8 COLLATE utf8_general_ci;
jdbc:mysql://localhost/blehblehbleh?autoReconnect=true&useUnicode=true&characterEncoding=UTF8

works fine great!

Configuring Jira

I'm following the procedures found on the Atlassian Confluence web site. I need to download the appropriate JDBC connectors here and download the latest supported (by atlassian) version of MySQL (I'm currently using windows).

Here goes:
see this link:
http://www.atlassian.com/software/jira/docs/latest/databases/mysql.html
or click here.

1. create database jira character set utf8;
2. in {JIRA_HOME}\conf\server.xml
3. driverClassName="com.mysql.jdbc.Driver"
4. url="jdbc:mysql://localhost/jira?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
5. following should be no more
6. driverClassName="org.hsqldb.jdbcDriver"
7. url="jdbc:hsqldb:${catalina.home}/database/jiradb"
8. minEvictableIdleTimeMillis="4000"
9. timeBetweenEvictionRunsMillis="5000"
10. maxActive="20" //it doesn't mention anywhere that this should be deleted too, but deleted anyway
11. changed atlassian-jira/WEB-INF/classes/entityengine.xml
12. like this mysql"
13. deleted schema-name="PUBLIC"
14. kept helper-class="org.ofbiz.core.entity.GenericHelperDAO" and the rest
15. finished, lets see if it works.

Review procedure:

1. CREATE DATABASE jira CHARACTER SET UTF8 COLLATE utf8_general_ci; seems to be better
2. it should complement the use of this statement in server.xml:
3. url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"

Error messages:

1. No errors! All tables were created, no problem, just a lot of complaining at first that tables did not exist.
2. Setup complete with no error messages.