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.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 07:11:15
Script start
Timing: Jan 19 2025 07:11:15
Module start 'layout'
Timing: Jan 19 2025 07:11:15
Module start 'content'
Timing: Jan 19 2025 07:11:16
Module end 'content'
Timing: Jan 19 2025 07:11:16
Script end

Main resources:

Total runtime1.3924 sec
Peak memory usage4,096.0000 KB
Database Queries79

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 590.5391152.6563
Module start 'layout' 0.00610.0036 743.195339.5078
Module start 'content' 0.00981.3812 782.7031655.7969
Module end 'content' 1.39100.0014 1,438.500020.1094
Script end 1.3924  1,458.6094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.2324160.0002
Check MTime0.00140.0979160.0001
Mysql Total
Database connection0.00070.048610.0007
Mysqli_queries1.308593.9697790.0166
Looping result0.00080.0555770.0000
Template Total1.363197.920.6816
Template load0.00170.121120.0008
Template processing1.361497.771720.6807
Template load and register function0.00020.011010.0002
states
state_id_array0.00110.080910.0011
state_identifier_array0.00110.081920.0006
Override
Cache load0.00160.1141810.0000
Sytem overhead
Fetch class attribute can translate value0.00080.059240.0002
Fetch class attribute name0.00200.1412110.0002
XML
Image XML parsing0.00410.295140.0010
class_abstraction
Instantiating content class attribute0.00000.0016120.0000
General
dbfile0.00370.2672220.0002
String conversion0.00000.000740.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_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