[opencms-dev] help with installation

Tue Sep 13 01:01:06 CEST 2005

Most of these installation problems are because the MySQL 
username/password/host combination are not valid. In these cases I recommend 
that you use the root MySQL user for both setup and normal running first. 
When you get OpenCms installed and running you can then experiment with 
creating a separate user for running OpenCms.

I am assuming that the MySQL database is running on the same computer as 
your Tomcat
installation (ie on "localhost"). If you have a default MySQL installation 
usually you can access the database as the "root" user using a null 
password.

To test if that is the case enter from command prompt: (make user mysql is 
in your command path!)

mysql --user=root mysql

If you get an access denied error, it probably means that a password has 
been set for root. You will need this password before you can proceed. Test 
by entering: 
mysql --user=root --password=myPassword mysql

Next follow the instructions for installing OpenCms. When you get to the 
screen asking for database information, use username "root" for both setup 
and normal operation. Leave the password blank (if it's a null password), or 
enter the root password if it has been set.

Hopefully this will get you to a point where you have a working OpenCms 
installation.
Backup your WEB-INF/config/opencms.properties.

Next read the MySQL doc and create a OpenCms user with appropriate 
permissions. Edit opencms.properties until it works :-). You can always fall 
back to the backup if things don't work.

I hope this helps. If it still does not work, please send me the error 
message you get when you follow normal installation procedures.

Joe.

You can then try creating a MySQL user to access the database. 
On 9/12/05, Jorge Vasquez <jorgeandresvasquez at gmail.com> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050913/fbfd5102/attachment.htm>