Forums / Install & configuration / Database initialization

Database initialization

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Chunlin Wang

Thursday 16 August 2007 5:23:47 pm

I'm trying to install ez3.9 to a computer running windows vista, running into this during setup:
"The database would not accept the connection, please review your settings and try again."
I tried everything I could find from this forums: 1. making sure mysqld is running; 2. changing password as someone suggested and making sure it took effect; 3. changing servername to 127.0.0.1. Nothing works. Is there anything else I should try?

Łukasz Serwatka

Thursday 16 August 2007 11:19:55 pm

Hi Chunlin,

Enabled debug output in settings/site.ini.[DebugSettings].DebugOutput=enabled Then you should see source of your problem. eZ Publish works fine on Vista for sure.

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

Chunlin Wang

Saturday 18 August 2007 5:14:59 am

Thanks. I turned on debugging. I also made change in site.ini: [DatabaseSettings].password="valid password".
Now error message reads:
eZMySQLDB
Connection error: Couldn't connect to database. Please try again later or inform the system administrator.Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Does this mean I have to upgrade MySQL? This db came from bundled package.

Chunlin Wang

Saturday 18 August 2007 5:23:56 am

Warning:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\ezpublish\ezpublish\lib\ezdb\classes\ezmysqldb.php on line 131
which is a php function:
mysql_connect ( [string $server [, string $username [, string $password [, bool $new_link [, int $client_flags]]]]] ).

Basically it says no connection.

Bruce Morrison

Sunday 19 August 2007 8:27:47 pm

Hi

Looks like you have a mismatch between the mysql client library & the server. A quick google for "Client does not support authentication protocol requested by server" gives

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

 MySQL 5.0 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients. If you upgrade the server from 4.0, attempts to connect to it with an older client may fail with the following message:

shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client

Suggested solutions can be found at the URL

http://www.whoopis.com/howtos/mysql-auth-fix.html may also be of help

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Sébastien Antoniotti

Wednesday 21 November 2007 8:23:34 am

Hi,

I Have the same problem, when running a 3.9.4 on my local computer who access a remote database.

On the frontend I get this :

Fatal error: Undefined class name 'ezcontentobjecttreenode' in D:\wamp\www\test\kernel\content\ezcontentfunctioncollection.php on line 586
Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.

and in top of the debug :

Warning: PHP  	Nov 21 2007 17:14:59

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\wamp\www\test\lib\ezdb\classes\ezmysqldb.php on line 131

Error: eZMySQLDB  	Nov 21 2007 17:14:59

Connection error: Couldn't connect to database. Please try again later or inform the system administrator.
Client does not support authentication protocol requested by server; consider upgrading MySQL client

And if I run the admin siteaccess I get this :

kernel::50

    * No database connection could be made, the system might not behave properly.

Connection error: Couldn't connect to database. Please try again later or inform the system administrator.
Client does not support authentication protocol requested by server; consider upgrading MySQL client

The problem is that I can't modifiy the password encryption (old password, etc.) on the remote database, I need to make modifications into my local PHP config (I think I need to upgrade the PHP client no ?) but I don't know how to do this !

My PHP version is 4.4.7, the MySQL version is 5.0.45 and apache is 2.0.58.

Thanks in advance for any help !

eZ Publish Freelance
web : http://www.webaxis.fr