Database initialization

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