|
Welcome Guest | Login | |
|
Index
| Recent Threads
| Who's Online
| User List
| Register
| Search
| Help
| 
|
Synyx created an OpenCms 7.0.4 Live CD, based on SLAX Linux, which is now available.
If you want to order a free CD copy, please write, including your postal address, to 
 |
OpenCms Forum » List all forums » Forum: Questions about Installation » Thread: OpenCms 6.02 beta on JBoss 4.03 SP1 Installation problem |
|
Thread Status: Normal Total posts in this thread: 4 |
[Add To My Favorites] [Watch this Thread] [Post new Thread] |
| Author |
|
steph_levy
Stranger
|
Hi, I am trying to install OpenCms 602 beta on JBoss 4.03 SP1 on a windows XP system with an Oracle 9i database. I have run the setup wizard several times and it completes with no error. But I never could login with Admin/admin on the index.jsp page (404 error like page show). So I restarted JBoss and when I try to login to http://localhost:8080/opencms/opencms/index.jsp I get the message : "javax.servlet.ServletException: Critical error during OpenCms initialization: The OpenCms setup wizard is still enabled". I changed the flag wizard.enabled=false in opencms.properties but what every time the application is restarted ? Now I get the error "org.opencms.main.CmsInitException: Critical error during OpenCms initialization: Unable to initialize connection pool "default". Is the database up and running?" while I can access the database with TOAD. Has anyone met the same problems or knows what goes wrong ? Thank you. Stephane |
||
|
Arrasz
Advanced Member  Joined: Mar 9, 2003 Posts: 1279 Status: Offline |
For Oracle you have to move toe db-driver jar to /webapps/opencms/WEB-INF/lib by yourself. It's not included in distribution because of licence problems ;) Regards Achim ---------------------------------------- -- /** * Joachim Arrasz * OpenSource Solutions * Synyx GmbH & Co. KG Karlstr. 68 76137 Karlsruhe * @phone +49(0)721 66 24 866 * @eMail arrasz@synyx.de * @www http://www.synyx.de */ |
||
|
|
steph_levy
Stranger
|
Thank you Achim for your answer : I copied the obdbc14.jar file in the right directory. But what I still don't understand is how and when the opencms.properties is modified with the set up information that were entered : what is the "default" connection pool that OpenCms is unsuccessfully trying to use and how to use another one ? As I deploy the opencms.war directly in JBoss /deploy folder, I would have to repackage the WAR file with the updated opencms.properties file, is this the normal behavior ? Thank you for your help. Stephane |
||
|
|
steph_levy
Stranger
|
I finally physically deployed the opencms.war into a /opencms.war folder under /deploy. I had to uncomment the following paragraph in the web.xml <context-param> <param-name>WebApplicationContext</param-name> <param-value>opencms.war</param-value> </context-param> Then I modified the opencms.properties file like this (where [serverName] is my database server name and [SID] my database SID) : ... # # Declaration of database pools ################################################################################# db.pools=default # # Configuration of the default database pool ################################################################################# # name of the JDBC driver db.pool.default.jdbcDriver=oracle.jdbc.driver.OracleDriver # URL of the JDBC driver db.pool.default.jdbcUrl=jdbc:oracle:thin:@[serverName]:1521:[SID] # optional parameters for the URL of the JDBC driver db.pool.default.jdbcUrl.params= # user name to connect to the database db.pool.default.user=opencms # password to connect to the database db.pool.default.password=opencms # the URL to make the JDBC DriverManager return connections from the DBCP pool db.pool.default.poolUrl=opencms:default # the maximum number of objects that can be borrowed from the pool db.pool.default.maxActive=25 # the maximum amount of time before throwing an exception when the pool is exhausted db.pool.default.maxWait=2000 # the maximum number of objects that can sit idled in the pool db.pool.default.maxIdle=10 # action to take when the pool is exhausted {grow|block|fail} db.pool.default.whenExhaustedAction=block # connections will be validated before they are borrowed from the pool db.pool.default.testOnBorrow=false # the query to validate connections # MSQL version (also MS SQL): SELECT 1 # Oracle version : SELECT 'validationQuery' FROM DUAL db.pool.default.testQuery= # # Configuration for statement pooling ################################################################################# db.statements.default.pooling=true db.statements.default.maxActive=200 db.statements.default.maxWait=2000 db.statements.default.maxIdle=100 db.statements.default.whenExhaustedAction=block # # Configuration of the database driver manager ################################################################################# db.name=oracle db.vfs.driver=org.opencms.db.oracle.CmsVfsDriver db.vfs.pool=opencms:default db.vfs.sqlmanager=org.opencms.db.oracle.CmsSqlManager db.project.driver=org.opencms.db.oracle.CmsProjectDriver db.project.pool=opencms:default db.project.sqlmanager=org.opencms.db.oracle.CmsSqlManager db.user.driver=org.opencms.db.oracle.CmsUserDriver db.user.pool=opencms:default db.user.sqlmanager=org.opencms.db.oracle.CmsSqlManager db.workflow.driver=org.opencms.db.oracle.CmsWorkflowDriver db.workflow.pool=opencms:default db.workflow.sqlmanager=org.opencms.db.oracle.CmsSqlManager db.backup.driver=org.opencms.db.oracle.CmsBackupDriver db.backup.pool=opencms:default db.backup.sqlmanager=org.opencms.db.oracle.CmsSqlManager db.cos.pool=opencms:default ... Stephane |
||
|
| [Show Printable Version of Thread] [Post new Thread] |
