Simon Haslam wrote:
Success!!! (I think!) Thanks for the tip Gabe - your workaround got me over
the 500 error! Thanks too to Dave and the others who have posted
suggestions.
So, let me recap what I had to do to install Roller 4.0 from scratch on
Oracle Application Server 10.1.3.3 and an Oracle 10g database on Linux
(hopefully I've not forgotten anything):
1) unzip Roller, e.g. into your Oracle account's home directory and create a
WAR file
2) create a separate roller_data directory (again I put it in ~oracle), copy
in the themes directory from Roller and also create empty directories called
"resources" and "search-index".
3) create a roller-custom.properties file, preferably outside the roller
deployment directory (at the moment I've got it my jdk classes directory but
will look to put it somewhere more sensible). The file should contain at
least the following:
installation.type=manual
database.configurationType=jdbc
database.jdbc.driverClass=oracle.jdbc.driver.OracleDriver
database.jdbc.connectionURL=jdbc:oracle:thin:@yourhost:yourport:yoursid
database.jdbc.username=yourrolleruser
database.jdbc.password=yourpassword
mail.configurationType=properties
mail.hostname=yoursmtphost
uploads.dir=/home/oracle/roller_data/resources
themes.dir=/home/oracle/roller_data/themes
search.index.dir=/home/oracle/roller_data/search-index
log4j.appender.roller.File=/home/oracle/roller_data/roller.log
note: there's still work to be done here, e.g. I'd like use container
managed JNDI connection pooling. The above settings got me running though.
JNDI DataSource can be accomplished by deploying roller as an EAR on
Oracle-OC4J (10.x).
Place the following 3 files in the EAR META-INF directory. Edit accordingly:
application.xml:
<?xml version="1.0"?>
<!DOCTYPE application PUBLIC "-//Sun Microsystems, Inc.//DTD J2EE
Application 1.2//EN" "http://java.sun.com/j2ee/dtds/application_1_2.dtd";>
<application>
<display-name>Oracle generated application roller</display-name>
<module>
<web>
<web-uri>roller.war</web-uri>
<context-root>/roller</context-root>
</web>
</module>
</application>
data-sources.xml:
<?xml version="1.0" standalone='yes'?>
<data-sources
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/data-sources-10_1.xsd";
schema-major-version="10"
schema-minor-version="1"
>
<managed-data-source name="jdbc/rollerdb"
connection-pool-name="rollerdb Connection Pool"
jndi-name="jdbc/rollerdb" ejb-location="jdbc/rollerdb"/>
<connection-pool name="rollerdb Connection Pool">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource"
user="scott"
password="coolgeek"
url="jdbc:oracle:thin:@localhost:1521:orcl">
</connection-factory>
</connection-pool>
</data-sources>
orion-application.xml:
<?xml version = '1.0' encoding = 'utf-8'?>
<orion-application
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/orion-application-10_0.xsd";
schema-major-version="10"
schema-minor-version="0"
component-classification="internal">
<data-sources path="./data-sources.xml"/>
<mail-session location="mail/Session" ejb-location="mail/Session"
smtp-host="localhost"/>
</orion-application>
Before packaging the roller.war into the EAR, unpackage it and edit
roller-custom.properties like so:
installation.type=manual
hibernate.dialect=org.hibernate.dialect.OracleDialect
uploads.dir=~/appservers/private/roller_roller_data/uploads
search.index.dir=~/appservers/private/roller_roller_data/search-index
planet.aggregator.cache.dir=~/appservers/private/roller_roller_data/planetcache
database.configurationType=jndi
database.jndi.name=jdbc/rollerdb
mail.configurationType=jndi
mail.jndi.name=mail/Session
log4j.appender.roller.File=~/appservers/private/roller_roller.log
Hope this helps.
--
Regards
Gabe Wong
NGASI AppServer Manager
JAVA AUTOMATION and SaaS Enablement
<a href=http://www.ngasi.com>http://www.ngasi.com</a>
NEW! 8.0 - Centrally manage multiple physical servers
