Forums / Install & configuration / problem installing ezpublish-3.7.2,please help

problem installing ezpublish-3.7.2,please help

Author Message

kenneth johansen

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

Gurudutt Verma

Tuesday 15 November 2005 12:08:17 pm

Hi

See following links might be helpful.

http://ez.no/community/forum/install_configuration/problem_with_install_3_7_0/re_problem_with_install_3_7_0__2

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

All the best

kenneth johansen

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

kenneth johansen

Wednesday 16 November 2005 7:56:56 am

forgot to mention that the update user and flush commands went well.

Jozef Pavlik

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