Forums / Install & configuration / Database initialization

Database initialization

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

eZ debug

Timing: Jan 31 2025 07:23:22
Script start
Timing: Jan 31 2025 07:23:22
Module start 'content'
Timing: Jan 31 2025 07:23:22
Module end 'content'
Timing: Jan 31 2025 07:23:22
Script end

Main resources:

Total runtime0.2446 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0064 587.9453180.8359
Module start 'content' 0.00640.0076 768.7813102.0078
Module end 'content' 0.01410.2305 870.7891530.2813
Script end 0.2445  1,401.0703 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00351.4478200.0002
Check MTime0.00130.5456200.0001
Mysql Total
Database connection0.00080.314010.0008
Mysqli_queries0.190878.01371410.0014
Looping result0.00110.46881390.0000
Template Total0.230194.110.2301
Template load0.00090.369510.0009
Template processing0.229293.699710.2292
Override
Cache load0.00060.261210.0006
Sytem overhead
Fetch class attribute can translate value0.00060.243310.0006
XML
Image XML parsing0.00020.082210.0002
General
dbfile0.01355.5242200.0007
String conversion0.00000.001630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs