problem installing ezpublish-3.7.2,please help

Tuesday 15 November 2005 10:16:49 am

i have installed:
mysql 5.0.15
apache 1.3.34
php-4.4.1
ubuntu 5.10.

i have fixed mysql, apache and php to play ball.

i have gone through the ez wizard for installation and im
stuck at the creating sites page with the following errormessage:
---------------------------------------------------
# EZSW-004Failed inserting data to mysql
Unknown table 'ezapprove_items' in information_schema
# EZSW-040Failed to initialize site package plain
----------------------------------------------------

if i try to press the retry button, my ez/var/log/error.log file logs the following:
-----------------------------------------------------
id int(11) NOT NULL AUTO_INCREMENT,
workflow_process_id int(11) NOT NULL DEFAULT '0',
PRIMARY KEY ( id )
) TYPE=InnoDB
[ Nov 15 2005 17:58:39 ] [127.0.0.1] Failed inserting the SQL:
CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL DEFAULT '0',
id int(11) NOT NULL AUTO_INCREMENT,
workflow_process_id int(11) NOT NULL DEFAULT '0',
PRIMARY KEY ( id )
) TYPE=InnoDB
[ Nov 15 2005 17:58:56 ] [127.0.0.1] Connection error: Couldn't connect to database. Please try again later or inform the system administrator.
Access denied for user 'root'@'localhost' (using password: NO)
--------------------------------------------------------

can anyone enlighten me on what ive done wrong ? ive followed the ez installation procedure to the letter.

if i login to the mysql database as root from a term, with the password ive set, it works just fine.

and why is it tryin to access the database withouth a password? i spesifically set the password on a page within the installation wizard.

any and all help is appriciated.

regards

kenneth

Wednesday 16 November 2005 7:48:56 am

i logged into my mysql database as the root user and issued the following commands:
UPDATE mysql.user SET Password = OLD_PASSWORD('my_chosen_password') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;

i then stopped the server and started it again with the following parameters:
/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/opinion.pid --skip-locking --old-password

i then pressed the retry button in the ez installation wizard... and i got the same error message again.

im missing something, but what ?

please help

Wednesday 16 November 2005 10:41:02 am

Look at this:

http://ez.no/community/forum/install_configuration/error_message__1

There is propably a bug when you use MySQL 5.0.15