[opencms-dev] install.html is wrong

[Martin Kuba]

Hi,

I am still strugling with installation of OpenCMS 6a2.
I tried to start from scratch, and I noticed that the install.html
distributed with it is wrong.

It lists "3. Install MySQL" and later
"5. Install OpenCms using the Setup-Wizard" , but that fails
with

Tables could not be created!
Error connecting to database using: jdbc:mysql://localhost:3306/opencms
-------------------------------------------
java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user: 'opencmsuser at localhost' (Using password: YES)"
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)

logicaly because the database user does not exist in that moment.

Then next point is "6. Now your OpenCms system is ready"
which is not true, because the instalation failed, and then
the last point is "7. Security issues" which creates the user.

So the point number 7. should go after point 3.

Also the way to create a user in point 7 which is

use mysql;
insert into user values ('localhost', 'opencmsuser', \
	password('XXXXX'),'N','N','N','N','N','N','N','N','N',
\
'N','N','N','N','N');
insert into db values ('localhost', 'opencms', 'oopencmsuser', \
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
flush privileges;

does not work, it fails with:

ERROR 1136: Column count doesn't match value count at row 1

According to MySQL manual, a new user account should be added by:

GRANT ALL PRIVILEGES ON opencms.* TO 'opencms'@'localhost' IDENTIFIED BY 'XXXXX' WITH GRANT OPTION;

I tried this with MySQL 4.0.18, which is the default for
OpenCMS.

Martin
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Supercomputing Center Brno             Martin Kuba
Institute of Computer Science    email: makub at ics.muni.cz
Masaryk University             http://www.ics.muni.cz/~makub/
Botanicka 68a, 60200 Brno, CZ     mobil: +420-603-533775
--------------------------------------------------------------