Database initialization fails

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 Exponential 3" book...

I have (again) reinstalled Exponential 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 Exponential "Setup" from /Exponential-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 Exponential on my local machine (running Mac OS X). Why can't I get Exponential 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 Exponential 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...

Wednesday 08 September 2004 10:41:50 am

David:

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

My only difference in I'm running php 4.1.1 (which incidently is unstable with Exponential 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...

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/Exponential-3.4.1/kernel/common/eztemplatedesignresource.php
on line 848

Fatal error: Exponential did not finish it's request

The execution of Exponential 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 ;)

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!