DB Initialization with MySQL 4.1.7

Next topic

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