Forums / Install & configuration / localhost and Database initialization problem

localhost and Database initialization problem

Author Message

Doris Krüger

Wednesday 23 November 2005 2:56:28 am

Hello,

I have tried to install eZ systems but have a problem at step 'Database initialization'.
I fill in localhost, root, no password but it doesn't work (also if I fill in a password, it doesn't work). It says ' The database would not accept the connection, please review your settings and try again.'

Maybe its because I have already installed xampp? When I now try to open my 'http://localhost' I only get 'Welcome to eZ publish 3.7.2' and none of my data from localhost...

Do I now have two apache and mysql running??

Do I have to uninstall?

Would be great if you could help me!
Tahnk you very much!

Børge Warvik

Wednesday 23 November 2005 9:24:09 am

I had the same problem, and the way I fixed it was to run the mysql console and type:

update password for root@domain = old_password("yourpassword");

Important! Write in a singe line and end sentence with ";".

Hope this helps

Allan Dean

Monday 06 February 2006 8:16:51 pm

Using:

eZ Publish 3.7.3
Linux Redhat
Apache/2.0.52 (Fedora)
mysql ver 11.18
php 4.3.11

I am having trouble with the database initialization while running the installation wizard.

At the system check I ignored two error messages:

1. allow_url_fopen ini setting is disabled

2. AcceptPathInfo disabled or running in CGI mode
(the webmaster on the shared host said he enabled AcceptPathInfo in the Apache config file.)

I have had a couple false starts with the installation. The first time through it accepted my database initialization. The wizard seemed to be nearly complete then it screwed up at the end.

Starting again, the installation proceeded until I got to the Database initialization. I entered the host, username and password, but this time I got an error message: "The database would not accept the connection, please review your settings and try again."

I am able to login and access the database with phpMyAdmin and through a shell account, but using the wizard the database won't accept the connection.

I tried manually initializing the database following the instructions here:
http://ez.no/doc/ez_publish/technical_manual/3_6/installation/manual_installation/manual_configuration_of_ez_publish

A clean eZ publish database was created using the SQL scripts: "kernel_schema" and "cleandata". Still, the database won't connect through the wizard.

I tried the password change that was recommended using:

update password for root@domain = old_password("yourpassword");

for
server: localhost
user: george
pasword: banana

I wrote:
update password for george@localhost = old_password("banana");
but I get a syntax error that reads "syntax error near unexpected token "("

Any help is appreciated.

Thanks.

Allan Dean

Tuesday 07 February 2006 9:20:06 am

Update.

According to my host, the syntax should have been,

set password=PASSWORD('newpassword') where user=user@localhost;

But since I do not have root access to the server I would not be able to run it.

My host reset my password.

Still, I am not able to get the database to connect when I run the wizard.

Able to log into mysql from shell and phpMyAdmin.

Allan Dean

Wednesday 08 February 2006 7:15:45 am

Still not able to make connection to the database when using the wizard.

Any ideas?

Thomas Nunninger

Wednesday 08 February 2006 1:03:22 pm

Hi Allan,

you need PHP 4.4 for eZ publish 3.7. Use eZ publish 3.6 if you can't upgrade to PHP 4.4.

Have a nice day

Thomas

Allan Dean

Thursday 09 February 2006 10:17:57 am

Thomas,

Thank you....

I've installed the correct version for my system now (3.6.5)

Still have a problem with security dealing with .htaccess and getting 403 forbidden access errors. I have posted to a different thread about that problem.

http://ez.no/community/forum/install_configuration/403_forbidden_error_after_installation#msg91958

If you have any ideas, I'd appreciate it.

Thomas Nunninger

Thursday 09 February 2006 10:31:03 am

Hi Allan,

sorry, I'm not that apache freak. I can only guess and probably I'm going wrong totally. But have you set the right permissions and ownerships of the php files that the apache user is able to access them?

Sorry, I think I'm not that helpfull at the moment :(

Have a nice day

Thomas

Allan Dean

Thursday 09 February 2006 10:49:16 am

Thanks again Thomas.

During installation I was prompted to make chmod some folders in the settings subdirectory. That was done with no trouble.

All the php files in the root directory, including index.php all have 644 permission settings.

eZ debug

Timing: Jan 19 2025 04:24:57
Script start
Timing: Jan 19 2025 04:24:57
Module start 'content'
Timing: Jan 19 2025 04:24:58
Module end 'content'
Timing: Jan 19 2025 04:24:58
Script end

Main resources:

Total runtime1.0063 sec
Peak memory usage4,096.0000 KB
Database Queries216

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0148 590.3203180.8047
Module start 'content' 0.01480.8720 771.1250660.9063
Module end 'content' 0.88670.1195 1,432.0313340.4063
Script end 1.0062  1,772.4375 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00480.4725210.0002
Check MTime0.00160.1606210.0001
Mysql Total
Database connection0.00140.141810.0014
Mysqli_queries0.904089.83382160.0042
Looping result0.00230.22412140.0000
Template Total0.955494.920.4777
Template load0.00240.240220.0012
Template processing0.953094.700720.4765
Template load and register function0.00020.016010.0002
states
state_id_array0.00100.100610.0010
state_identifier_array0.00220.215620.0011
Override
Cache load0.00210.2111810.0000
Sytem overhead
Fetch class attribute can translate value0.00190.190550.0004
Fetch class attribute name0.00120.1156110.0001
XML
Image XML parsing0.00150.150050.0003
class_abstraction
Instantiating content class attribute0.00000.0019120.0000
General
dbfile0.00880.8702330.0003
String conversion0.00000.003430.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
9content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
16content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
7content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 37
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs