[opencms-dev] help with installation

[Jorge Vasquez]

Greetings to all, I am new to openCMS and have been trying to install
it all day without being successful.
My environment is as follows:
-tomcat:  5.5.11 
-mysql: v 4.1.11
-JDK:  j2sdk1.4.2_02
-Operating System:  Windows XP SP2

During the installation I was having problems with the table creation,
related to the database users so I decided to run the table creation
scripts directly into mySQL, after this I saw some errors in the
module creation also related to the users.
I don't understand very well what each parameter in opencms.properties
file stands for...
Below is my file to see if I am not setting specific attributes:
#
# Configuration of the driver manager
#################################################################################
driver.vfs=db
driver.project=db
driver.user=db
driver.workflow=db
driver.backup=db



#
# Declaration of database pools
#################################################################################
db.pools=default

#
# Configuration of the default database pool
#################################################################################
# name of the JDBC driver
db.pool.default.jdbcDriver=org.gjt.mm.mysql.Driver

# URL of the JDBC driver
db.pool.default.jdbcUrl=jdbc:mysql://localhost:3306/opencms

# 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=

# 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

# the query to validate connections
db.pool.default.testQuery=

# 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

#
# 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=mysql_41

db.vfs.driver=org.opencms.db.mysql.CmsVfsDriver
db.vfs.pool=opencms:default
db.vfs.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.project.driver=org.opencms.db.mysql.CmsProjectDriver
db.project.pool=opencms:default
db.project.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.user.driver=org.opencms.db.mysql.CmsUserDriver
db.user.pool=opencms:default
db.user.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.workflow.driver=org.opencms.db.mysql.CmsWorkflowDriver
db.workflow.pool=opencms:default
db.workflow.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.backup.driver=org.opencms.db.mysql.CmsBackupDriver
db.backup.pool=opencms:default
db.backup.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.cos.pool=opencms:default

#
# Ethernet address used for UUID generation
# Server name used for various messages
#################################################################################
server.ethernet.address=fb:5c:9b:f6:ff:ff
server.name=OpenCmsServer

#
# Enable/Disable OpenCms Setup Wizard
# The wizard sets the flag to false after the setup.
# To use the wizard again, reset it manually to true.
# By setting no value, wizard can always be used.
#################################################################################
wizard.enabled=false


Finally, after finishing the installation and attempting to enter the URL:

http://localhost:8080/opencms/opencms/index.jsp

Sep 12, 2005 5:08:08 PM org.apache.catalina.core.StandardHostValve custom
SEVERE: Exception Processing ErrorPage[errorCode=500,
location=/opencms/system/handler/handle500.html]
org.opencms.main.CmsInitException: Critical error during OpenCms
initialization: Unable to initialize connection pool "default". Is the
database up and running?
	at org.opencms.main.OpenCmsCore.getInstance(OpenCmsCore.java:268)
	at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:117)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	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 org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:465)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
	at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
	at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
	at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:134)
	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.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
	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:534)


-------------------------------------------------

I know that I am kind of lost here but I don't seem to find detailed
information related to the iinstallation of openCMS, I just read the
page:
http://www.opencms.org/opencms/en/development/installation/index.html
I followed all the steps there but still I got the problems mentioned before.

I will happily appreciate any help and ideas or reference guides for
the installation.

Thanks to all,

-- 
Jorge Andres Vasquez
Ingeniería
3AM