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

eZ debug

Timing:	Jan 19 2025 03:31:35
Script start
Timing:	Jan 19 2025 03:31:35
Module start 'layout'
Timing:	Jan 19 2025 03:31:35
Module start 'content'
Timing:	Jan 19 2025 03:31:36
Module end 'content'
Timing:	Jan 19 2025 03:31:36
Script end

Main resources:

Total runtime	1.0073 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0081	589.1719	152.6250
Module start 'layout'	0.0081	0.0031	741.7969	39.4453
Module start 'content'	0.0111	0.9948	781.2422	667.5078
Module end 'content'	1.0059	0.0014	1,448.7500	16.1719
Script end	1.0073		1,464.9219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0042	0.4147	16	0.0003
Check MTime	0.0014	0.1371	16	0.0001
Mysql Total
Database connection	0.0013	0.1320	1	0.0013
Mysqli_queries	0.9372	93.0417	70	0.0134
Looping result	0.0007	0.0716	68	0.0000
Template Total	0.9575	95.1	2	0.4788
Template load	0.0028	0.2800	2	0.0014
Template processing	0.9547	94.7799	2	0.4774
Template load and register function	0.0001	0.0130	1	0.0001
states
state_id_array	0.0015	0.1529	1	0.0015
state_identifier_array	0.0023	0.2277	2	0.0011
Override
Cache load	0.0024	0.2413	45	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0868	4	0.0002
Fetch class attribute name	0.0014	0.1417	9	0.0002
XML
Image XML parsing	0.0016	0.1629	4	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0017	9	0.0000
General
dbfile	0.0011	0.1121	30	0.0000
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
11	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
4	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 30 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs