Forums / Install & configuration / DB Initialization with MySQL 4.1.7

DB Initialization with MySQL 4.1.7

Author Message

Matteo Garzulino

Saturday 16 April 2005 6:24:03 am

Hi,

I'm new to eZ publish and I'm having a problem during its configuration.

This is my actual system:

- Windows Xp Pro;
- MySQL 4.1.7;
- Apache Server 1.3.33;
- PHP 4.3.11;
- eZ publish 3.5.1.

Apache, PHP, MySQL installations were fine and everything works.

MySQL runs on localhost:3306 and Apache on localhost too.

Even the eZ Setup Wizard starts fine and it let me choose which database server i want to

use with a radio button (MySQL or PostgreSQL); the problem comes at "Database

Initialization" step; I fill the form with these infos:

Type: MySQL
Servername: localhost
Username: <my_user>
Password: <my_password>
Socket: <blank> //No infos filled here

The wizard reloads the same page with this error: "The database would not accept the

connection, please review your settings and try again."

Naturally MySQL server is running (as a Service), <my_user> and <my_password> works

correctly on MySQL Command Prompt, and the user as all privileges on the database i created

to use with eZ (with "grant all on <database>.*..." MySQL statement).

I can't find any solutions about this problem on eZ publish documentation (in particular way

in "Installation.pdf")..did anyone already have the same problem or does anyone could

suggest me something?

I already look at others posts in the forum about this problem but I can't solve it.

Thank you all,

Matteo.

Łukasz Serwatka

Monday 18 April 2005 12:49:23 am

You can make simple test:

Create file "test.php" with

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?> 

Access via URL localhost/test.php to see the results.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Matteo Garzulino

Tuesday 19 April 2005 6:05:26 am

Thanks Lukasz for your tip!

Problem was caused by this MySQL error: "Client does not support authentication protocol requested by server; consider upgrading MySQL client".

I solved the problem changing the user's password using this statement:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Probably PHP 4.3.11 doesn't support new hashing algorithm used by MySQL 4.1 to manage the
passwords. I think this problem doesn't exist on PHP 5.0.

Anyway this problem and his solutions are well described in MySQL Documentation.

I hope this will help anyone who could have the same nconvenience i had.

Bye,

Matteo.

Łukasz Serwatka

Tuesday 19 April 2005 6:08:51 am

You`re welcome :)

It is also good to enable debug output in site.ini if you will have problems with installation next time.

[DebugSettings]
DebugOutput=enabled

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog