Forums / Install & configuration / Database initialization fails

Database initialization fails

Author Message

David Gordon

Wednesday 08 September 2004 5:52:28 am

I have asked here before but the reply hasn't helped. I'll try once more before going on to something easier like Typo3 and selling my "Learning eZ publish 3" book...

I have (again) reinstalled eZ publish 3.4.1 on my *nix server where I have mySQL 3.2.58, Apache 1.3.29 and PHP 4.0.6. I have created a database and user for that database using phpMyAdmin.

Now I start the eZ publish "Setup" from /ezpublish-3.4.1/index.php. I proceed to the step "Database initialization" where I enter the username and password for the mySQL database. When I click "next" the page returns with a warning: "The database would not accept the connection, please review your settings and try again."

I have previously set up and run eZ publish on my local machine (running Mac OS X). Why can't I get eZ publish to run on my live server?

In order to try and help myself (as this seems to be a pretty sparse "community") I have attempted a fully manual install and have even summoned up some help from one of the eZ publish book authors. A fully manual install, based on the settings from my working local server, will not run. All I get is a blank browser page and an error that no data can be loaded.

I'm kinda surprised I can't solve this and that there doesn't seem to be much help here. EIther I am doing something so basic and stupid that nobody can believe it and tell me or there is some other problem with eZp 3.4.1.

Thanks for any useful help you can offer...

Björn Dieding@xrow.de

Wednesday 08 September 2004 9:41:02 am

PHP 4.0.6 !!! When did this version come out? 4 years ago?

Man you are definitly outdated.

Check the eZ requirements I think you need somethign above 4.3.2

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

David Parrish

Wednesday 08 September 2004 10:41:50 am

David:

Our similarities are uncanny. I have had the exact same experience - right down to runnin ezPublish successfull on my local machine - running OSX.

My only difference in I'm running php 4.1.1 (which incidently is unstable with ezPublish aparently).

I've done the manaul install as well with no joy.

It seems to me that the issue must be with the php Version and the code used by ezPub to connect to the database. I've run Mambo in the environment successfully.

I suppose that I could update the PHP install on the remote system (I have root access), but that seems painful and risky, as my server is runing Ensim WebAppliance and hosting a bunch of other sites, and there is no redundancy.

I think I might have to go back to Mambo...

Bruce Morrison

Wednesday 08 September 2004 3:18:19 pm

As Björn says php 4.0.6 is quite old.

In the past we used php4.1.2 (it was part of the distribution on servers we were using) and this worked with ezp3.2-3 and below (if register_globals was on)

After ezP3.2-3 it was necessary to use a php version above 4.3.X.

Your only option is to upgrade the php version I'm afraid.

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

David Gordon

Saturday 11 September 2004 9:37:27 am

I've updated my PHP to 4.3. I now beleive I was running 4.1 rather than 4.0.6.

I haven't received any memory warnings when running the Setup again. Howv=ever on inputting my database details I get the following error

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 512 bytes)
in /usr/local/home/httpd/docs/ezpublish-3.4.1/kernel/common/eztemplatedesignresource.php
on line 848

Fatal error: eZ publish did not finish it's request

The execution of eZ publish was abruptly ended, the debug output is present below.

I don't have any debug output.

Further suggestions?

BTW I must say thet if 4.3 is a <b>requirment</b> I'd expect the Setup to say "go fix your PHP" rather than let me continue to bash my head agaist a brick wall ;)

Daniel Beyer

Sunday 12 September 2004 3:00:30 pm

>>I haven't received any memory warnings when running the Setup again

Just give your php a bit more memory than 8 MB. Double it and eZ publish will run fine!
->change your php.ini from memory_limit = 8M to memory_limit = 16M

>>I don't have any debug output.

You need to switch it on in eZ publish.
->change DebugOutput=disbaled to DebugOutput=enabled in section [DebugSettings] in file settings/site.ini
or better:
Create an override site.ini.append in /settings/override/ and add this:
[DebugSettings]
DebugOutput=enabled

And if you want to know which templates are included in your layout add this, too:
[TemplateSettings]
Debug=enabled

Greetings

Daniel Beyer
_________________________________
YMC AG
Kreuzlingen, Switzerland
web: www.ymc.ch
____________________________________

Sascha Klein

Monday 13 September 2004 12:59:31 am

Hello!

It's very easy, I had the same Problem.
Find the my.cnf configuration File from MySQL and change the

max_allowed_packet variable to 16M

No it works!!

Sascha Klein
[powergrafx::mmn] germany
web solutions for the mobile generation!

David Gordon

Monday 13 September 2004 1:47:42 am

Okay, seem to be sorted now...

I've had to up the PHP memory to 24M

Thanks to all who answered and helped.