[opencms-dev] help with installation

Tue Sep 13 01:06:10 CEST 2005

Seems to me that you need to give proper permissions to the mysql user you are 
using...

On Monday 12 September 2005 05:34 pm, Jorge Vasquez wrote:
> 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
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 