[opencms-dev] 5.0.b1 Installation problems

[Andrea Cisternino]

Hi everybody,

First of all thanks to all those that have made OpenCMS possible, it
really seems a great tool.

I'm having some installation problems with 5.0 beta1. This is my
configuration:

- Linux RedHat 7.3. Fairly standard
- Blackdown Java-Linux version 1.3.1_02b FCS
- Tomcat 4.1.10
- MySQL 3.23.52-1 (RPMs from MySQL web site)

After installing Tomcat I tested it in stand-alone mode and everything
is OK. The tomcat server is run using a 'tomcat' user id with the

   su -l tomcat /opt/jakarta/tomcat/bin/startup.sh

command. All the /opt/jakarta/tomcat tree is owned by this user.

MySQL is OK as well. It is already working with a PHP cms and I can
manage it using phpMyAdmin without problems.

As far as opencms is concerned there is no trace of it in any of the
mysql tables (i.e. no opencms user nor database) whenever I start the
opencms installation process.

Following the installation manual I copied the opncms.war file in the
webapps directory of my tomcat installation (located in
/opt/jakarta/tomcat) and connected to the
http://localhost:8080/opencms/ocsetup/ url. After selecting the
standard installation I proceed to the following page and here I find
the first problems. The meaning of the two lines:

Database Server Connection
OpenCms Connection

is not very clear. I suppose that "Database Server Connection" is used
to connect to the mysql server (I type 'root' and the root password
for my mysql database). What is the meaning of "OpenCms Connection"???
Here I type the same values as above (there's time to change them
later,) leave everything else as is and proceed.

After less than one second I get an error page saying:

                 Creating database ... Failed

Could no connect to database via: jdbc:mysql://localhost:3306/
java.sql.SQLException: Server configuration denies access to data
source

-------------------------------------------
java.lang.NullPointerException

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

                 Creating tables ... Failed

Could no connect to database via: jdbc:mysql://localhost:3306/opencms
java.sql.SQLException: Server configuration denies access to data
source

followed by 38 

-------------------------------------------
java.lang.NullPointerException


The strange thing is that the mysql log file doesn't show any
connection attempt. The WEB-INF/logs/opencms.log is empty as well.

I also tried to create the opencms user, database and tables
beforehand directly in mysql and then unchecking the "Create database
and tables" option but while I was able to continue in the
installation process, it hung later during the "Import Workspace"
phase.

My comments: a brief explanation of what the two types of connection
are and of the meaning of the "Import Workspace" phase would clear
some issues and reassure the user trying to install OpenCMS (reading
the "big" manual usually comes after installing the package :-)

How can I help?

Thanks in advance to everybody.
-- 
 (o_    Andrea Cisternino
 //\    STMicroelectronics Linux Team, Bristol, UK
 V_/_   "Black holes are where God divided by zero"