Forums / Install & configuration / Broken site - mysql authentication failed?

Broken site - mysql authentication failed?

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.

eZ debug

Timing: Jan 30 2025 22:27:05
Script start
Timing: Jan 30 2025 22:27:05
Module start 'content'
Timing: Jan 30 2025 22:27:05
Module end 'content'
Timing: Jan 30 2025 22:27:06
Script end

Main resources:

Total runtime0.3563 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0090 588.0703370.2813
Module start 'content' 0.00910.0172 958.35161,001.5000
Module end 'content' 0.02630.3300 1,959.85163,891.5391
Script end 0.3562  5,851.3906 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00501.4142200.0003
Check MTime0.00150.4124200.0001
Mysql Total
Database connection0.00080.230510.0008
Mysqli_queries0.246869.25731410.0018
Looping result0.00170.47281390.0000
Template Total0.329692.510.3296
Template load0.00080.230210.0008
Template processing0.328792.265210.3287
Override
Cache load0.00060.155810.0006
Sytem overhead
Fetch class attribute can translate value0.00250.713210.0025
XML
Image XML parsing0.00030.074110.0003
General
dbfile0.00982.7636200.0005
String conversion0.00000.001730.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