Broken site - mysql authentication failed?

Next topic

Author	Message
Cefn Hoile	Thursday 22 September 2005 3:53:20 am A colleague just pointed out that the site at http://that.labs.bt.com has broken. It has been running for some time, but now I get Fatal error: Call to a member function on a non-object in /var/www/html/that.labs.bt.com/ezpublish/kernel/common/eztreemenuoperator.php on line 180 Fatal error: eZ publish did not finish its request I think this may be because the username and password that the scripts were using to access the mysql database could have been revoked or changed. Therefore any data requests are coming back empty, when they shouldn't. How can I set the correct database config in ezpublish? How can I verify that ezpublish has the correct database config? I think this was originally configured by an interactive install, and since the index page won't load, I'm not sure now where to set this right. When I try to run the cron jobs I get this... /usr/local/php-cli/bin/php -C runcronjobs.php Error initializing script: database error: Access denied for user: 'root@localhost' (Using password: YES). ...as if the username and password stored in settings/site.ini is not being accessed. I have verified the username, password and database name which are stored in the site.ini file by interactive login to mysql. If there's a better approach - for example to just install the latest version over the current one (3.5.1) then I'll consider that too. But I suspect this could make things worse still if the current one is not properly configured.
Cefn Hoile	Thursday 22 September 2005 7:55:49 am OK, I couldn't work out how to do it manually, but went through the following procedure which worked OK in the end. index.php will take you through a setup sequence if you change CheckValidity in settings/override/site.ini.append to true. This will then recreate the original interactive setup session when you next visit index.php and this sesson will prompt you for mysql mail and admin account information. To get the site to function again I had to choose the same templating settings (in my case the 'forum' template), and this process then ended up writing mysql username and password information into settings/siteaccess/forum and settings/siteaccess/forum_admin in files called site.ini.append.php I suppose this was where the original values were, and could potentially have been edited, but I couldn't find that at the time - assumed it would be in some sitewide config. One key thing to remember is to choose not to add any capabilities when you configure it, and to ask it to preserve data without adding any.

Author

Message

Thursday 22 September 2005 3:53:20 am

A colleague just pointed out that the site at http://that.labs.bt.com has broken. It has been running for some time, but now I get

Fatal error: Call to a member function on a non-object in /var/www/html/that.labs.bt.com/ezpublish/kernel/common/eztreemenuoperator.php on line 180
Fatal error: eZ publish did not finish its request

I think this may be because the username and password that the scripts were using to access the mysql database could have been revoked or changed. Therefore any data requests are coming back empty, when they shouldn't.

How can I set the correct database config in ezpublish?

How can I verify that ezpublish has the correct database config?

I think this was originally configured by an interactive install, and since the index page won't load, I'm not sure now where to set this right.

When I try to run the cron jobs I get this...

/usr/local/php-cli/bin/php -C runcronjobs.php
Error initializing script: database error: Access denied for user: 'root@localhost' (Using password: YES).

...as if the username and password stored in settings/site.ini is not being accessed. I have verified the username, password and database name which are stored in the site.ini file by interactive login to mysql.

If there's a better approach - for example to just install the latest version over the current one (3.5.1) then I'll consider that too. But I suspect this could make things worse still if the current one is not properly configured.

Cefn Hoile

Thursday 22 September 2005 7:55:49 am

OK, I couldn't work out how to do it manually, but went through the following procedure which worked OK in the end.

index.php will take you through a setup sequence if you change CheckValidity in settings/override/site.ini.append to true.

This will then recreate the original interactive setup session when you next visit index.php and this sesson will prompt you for mysql mail and admin account information.

To get the site to function again I had to choose the same templating settings (in my case the 'forum' template), and this process then ended up writing mysql username and password information into settings/siteaccess/forum and settings/siteaccess/forum_admin
in files called site.ini.append.php

I suppose this was where the original values were, and could potentially have been edited, but I couldn't find that at the time - assumed it would be in some sitewide config.

One key thing to remember is to choose not to add any capabilities when you configure it, and to ask it to preserve data without adding any.

eZ debug

Timing:	Jan 18 2025 16:07:23
Script start
Timing:	Jan 18 2025 16:07:23
Module start 'layout'
Timing:	Jan 18 2025 16:07:23
Module start 'content'
Timing:	Jan 18 2025 16:07:23
Module end 'content'
Timing:	Jan 18 2025 16:07:23
Script end

Main resources:

Total runtime	0.9516 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	589.6563	152.6406
Module start 'layout'	0.0048	0.0028	742.2969	39.4766
Module start 'content'	0.0076	0.9423	781.7734	430.6406
Module end 'content'	0.9499	0.0017	1,212.4141	8.1250
Script end	0.9516		1,220.5391

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.3708	16	0.0002
Check MTime	0.0014	0.1429	16	0.0001
Mysql Total
Database connection	0.0005	0.0551	1	0.0005
Mysqli_queries	0.9074	95.3549	52	0.0175
Looping result	0.0009	0.0909	50	0.0000
Template Total	0.9180	96.5	2	0.4590
Template load	0.0027	0.2883	2	0.0014
Template processing	0.9152	96.1753	2	0.4576
Template load and register function	0.0002	0.0165	1	0.0002
states
state_id_array	0.0020	0.2055	1	0.0020
state_identifier_array	0.0019	0.2041	2	0.0010
Override
Cache load	0.0024	0.2544	23	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1134	1	0.0011
Fetch class attribute name	0.0015	0.1585	2	0.0008
XML
Image XML parsing	0.0001	0.0100	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0006	2	0.0000
General
dbfile	0.0010	0.1063	10	0.0001
String conversion	0.0000	0.0009	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 5

Time used to render debug report: 0.0003 secs