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.<br>
<br>
I am assuming that the MySQL database is running on the same computer as your Tomcat<br>
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.<br>
<br>
To test if that is the case enter from command prompt: (make user mysql is in your command path!)<br>
<br>
mysql --user=root mysql<br>
<br>
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: <br>
mysql --user=root --password=myPassword mysql<br>
<br>
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.<br>
<br>
Hopefully this will get you to a point where you have a working OpenCms installation.<br>
Backup your WEB-INF/config/opencms.properties.<br>
<br>
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.<br>
<br>
I hope this helps. If it still does not work, please send me the error
message you get when you follow normal installation procedures.<br>
<br>
Joe.<br>
<br>
You can then try creating a MySQL user to access the database. <br><div><span class="gmail_quote">On 9/12/05, <b class="gmail_sendername">Jorge Vasquez</b> <<a href="mailto:jorgeandresvasquez@gmail.com">jorgeandresvasquez@gmail.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Greetings to all, I am new to openCMS and have been trying to install<br>
it all day without being successful.<br>My environment is as follows:<br>-tomcat: 5.5.11<br>-mysql: v 4.1.11<br>-JDK: j2sdk1.4.2_02<br>-Operating System: Windows XP SP2<br><br>During the installation I was having problems with the table creation,
<br>related to the database users so I decided to run the table creation<br>scripts directly into mySQL, after this I saw some errors in the<br>module creation also related to the users.<br>I don't understand very well what each parameter in
opencms.properties<br>file stands for...<br>Below is my file to see if I am not setting specific attributes:<br>#<br># Configuration of the driver manager<br>#################################################################################
<br>driver.vfs=db<br>driver.project=db<br>driver.user=db<br>driver.workflow=db<br>driver.backup=db<br><br><br><br>#<br># Declaration of database pools<br>#################################################################################
<br>db.pools=default<br><br>#<br># Configuration of the default database pool<br>#################################################################################<br># name of the JDBC driver<br>db.pool.default.jdbcDriver=org.gjt.mm.mysql.Driver
<br><br># URL of the JDBC driver<br>db.pool.default.jdbcUrl=jdbc:mysql://localhost:3306/opencms<br><br># optional parameters for the URL of the JDBC driver<br>db.pool.default.jdbcUrl.params=<br><br># user name to connect to the database
<br>db.pool.default.user=opencms<br><br># password to connect to the database<br>db.pool.default.password=<br><br># the URL to make the JDBC DriverManager return connections from the DBCP pool<br>db.pool.default.poolUrl=opencms:default
<br><br># the maximum number of objects that can be borrowed from the pool<br>db.pool.default.maxActive=25<br><br># the maximum amount of time before throwing an exception when the<br>pool is exhausted<br>db.pool.default.maxWait=2000
<br><br># the maximum number of objects that can sit idled in the pool<br>db.pool.default.maxIdle=10<br><br># the query to validate connections<br>db.pool.default.testQuery=<br><br># action to take when the pool is exhausted {grow|block|fail}
<br>db.pool.default.whenExhaustedAction=block<br><br># connections will be validated before they are borrowed from the pool<br>db.pool.default.testOnBorrow=false<br><br>#<br># Configuration for statement pooling<br>#################################################################################
<br>db.statements.default.pooling=true<br>db.statements.default.maxActive=200<br>db.statements.default.maxWait=2000<br>db.statements.default.maxIdle=100<br>db.statements.default.whenExhaustedAction=block<br><br>#<br># Configuration of the database driver manager
<br>#################################################################################<br>db.name=mysql_41<br><br>db.vfs.driver=org.opencms.db.mysql.CmsVfsDriver<br>db.vfs.pool=opencms:default<br>db.vfs.sqlmanager=org.opencms.db.mysql.CmsSqlManager
<br><br>db.project.driver=org.opencms.db.mysql.CmsProjectDriver<br>db.project.pool=opencms:default<br>db.project.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.user.driver=org.opencms.db.mysql.CmsUserDriver<br>db.user.pool=opencms:default
<br>db.user.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.workflow.driver=org.opencms.db.mysql.CmsWorkflowDriver<br>db.workflow.pool=opencms:default<br>db.workflow.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br>
<br>db.backup.driver=org.opencms.db.mysql.CmsBackupDriver<br>db.backup.pool=opencms:default<br>db.backup.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.cos.pool=opencms:default<br><br>#<br># Ethernet address used for UUID generation
<br># Server name used for various messages<br>#################################################################################<br>server.ethernet.address=fb:5c:9b:f6:ff:ff<br>server.name=OpenCmsServer<br><br>#<br># Enable/Disable OpenCms Setup Wizard
<br># The wizard sets the flag to false after the setup.<br># To use the wizard again, reset it manually to true.<br># By setting no value, wizard can always be used.<br>#################################################################################
<br>wizard.enabled=false<br><br><br>Finally, after finishing the installation and attempting to enter the URL:<br><br><a href="http://localhost:8080/opencms/opencms/index.jsp">http://localhost:8080/opencms/opencms/index.jsp
</a><br><br>Sep 12, 2005 5:08:08 PM org.apache.catalina.core.StandardHostValve custom<br>SEVERE: Exception Processing ErrorPage[errorCode=500,<br>location=/opencms/system/handler/handle500.html]<br>org.opencms.main.CmsInitException
: Critical error during OpenCms<br>initialization: Unable to initialize connection pool "default". Is the<br>database up and running?<br> at org.opencms.main.OpenCmsCore.getInstance(OpenCmsCore.java:268)<br>
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:117)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)<br> at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:465)<br> at org.apache.catalina.core.ApplicationDispatcher.doForward
(ApplicationDispatcher.java:398)<br> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)<br> at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
<br> at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)<br> at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)<br> at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:134)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)<br> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<br> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java
:80)<br> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<br> at java.lang.Thread.run(Thread.java:534)<br><br><br>-------------------------------------------------<br><br>
I know that I am kind of lost here but I don't seem to find detailed<br>information related to the iinstallation of openCMS, I just read the<br>page:<br><a href="http://www.opencms.org/opencms/en/development/installation/index.html">
http://www.opencms.org/opencms/en/development/installation/index.html</a><br>I followed all the steps there but still I got the problems mentioned before.<br><br>I will happily appreciate any help and ideas or reference guides for
<br>the installation.<br><br>Thanks to all,<br><br>--<br>Jorge Andres Vasquez<br>Ingenierķa<br>3AM<br><br><br>_______________________________________________<br>This mail is send to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br><a href="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</a><br></blockquote></div><br>