Installation - Wizard doesn't try to connect to MySQL?

Author Message

Darre Nickerson

Sunday 06 June 2004 9:38:13 am

I'm trying to install the recent 3.4 release, and having problems with the wizard. No matter what I try, I can't get the MySQL setup step to connect to the database successfully.

I have various previous versions of EZpublish running on this server without any problems. In case it was a permissions issue, I recursively chmodded the whole tree as 777 and still no joy. I also tried various username/password combos that are known to work from the mysql commandline, and eve tried explicitly setting the port to 3306.

The problem is, PHP doesn't even seem to attempt a connection to the database. It's not an authentication failure, or a grants failure (at least not as far as I can tell), because I would be able to see that in my logs. I've elevated MySQL logging, and there's definitely NO! connection attempt to the database. The wizard just reports "The database would not accept the connection, please review your settings and try again." But it clearly did not even try.

I've looked at apache logs - nothing obviously wrong there either.

I must be missing something painfully obvious here. Sorry!

Help!?

-Darren

Darre Nickerson

Sunday 06 June 2004 9:04:51 pm

**UPDATE**

I don't know why the following works, but after a day of messing around (I really wanted to see 3.4 in action!) I stumbled on something.

If I copy all the files into place, then edit config/site.ini and set:

ConnectRetries=3
Socket=/var/lib/mysql/mysql.sock

Then I can actually get through the setup wizard. Note that neither of these on their own fix the problem ... they must both be there.

The next problem was that I was getting consistent segmentation faults of apache children on either the last step (before Finished!!) or after the setup was done when I tried to load the user or admin sites. It seemed it was running out of both RAM and time. I changed the following in php.ini:

max_execution_time = 30
memory_limit = 15M

to

max_execution_time = 300
memory_limit = 30M

and that seems to have allowed things to complete installing, and get setup to run for the first time.

Now onto my next problem ... I installed the 'shop' sample, and when I register a user and try to purchase anything, that user does not have access to their shopping cart.

*ugh*

Next problem ... when viewing a product and selecting "Download this product sheet as PDF" I get:

Fatal error: Call to undefined function: ob_clean()
in /usr/var/www/vhosts/wwwtest.ifax.com/ezpublish-3.4.0/kernel/content/pdf.php
on line 245
Fatal error: eZ publish did not finish it's request

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

(only there's no debug below)

Perhaps people with my level of eZ 'fu' (ie: just enough to be dangerous) should wait for future releases?

-Darren

Kåre Køhler Høvik

Monday 07 June 2004 12:00:49 am

Hi

Which version of PHP/apache/mysql are you running ?

MySQL : Are you connecting to local host or remote host ?

ob_clean error : This function was adde in PHP4.2.0 . We do not recommend running eZ publish on < PHP4.3.2, due to session bugs and other problems.

--
Kåre Høvik

Kåre Høvik

Darre Nickerson

Monday 07 June 2004 6:28:50 am

> Which version of PHP/apache/mysql are you running ?

php-4.1.2
MySQL-4.0.14
apache-1.3.22

> MySQL : Are you connecting to local host or remote host ?

localhost

> ob_clean error : This function was adde in PHP4.2.0 . We do not recommend
> running eZ publish on < PHP4.3.2, due to session bugs and other problems.

Okay, thanks, I'll have to work on upgrading PHP, clearly.

What about the shopping cart?

-Darren

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 18 2025 22:13:27
Script start
Timing: Jan 18 2025 22:13:27
Module start 'layout'
Timing: Jan 18 2025 22:13:27
Module start 'content'
Timing: Jan 18 2025 22:13:27
Module end 'content'
Timing: Jan 18 2025 22:13:27
Script end

Main resources:

Total runtime0.5054 sec
Peak memory usage4,096.0000 KB
Database Queries60

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0053 589.2969152.6563
Module start 'layout' 0.00530.0021 741.953139.5078
Module start 'content' 0.00740.4967 781.4609555.7891
Module end 'content' 0.50410.0013 1,337.250012.1094
Script end 0.5054  1,349.3594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00290.5772160.0002
Check MTime0.00130.2479160.0001
Mysql Total
Database connection0.00080.162810.0008
Mysqli_queries0.450289.0835600.0075
Looping result0.00050.0926580.0000
Template Total0.480095.020.2400
Template load0.00180.364820.0009
Template processing0.478194.597920.2391
Template load and register function0.00020.034910.0002
states
state_id_array0.00090.173510.0009
state_identifier_array0.00070.132320.0003
Override
Cache load0.00150.3028550.0000
Sytem overhead
Fetch class attribute can translate value0.00040.088120.0002
Fetch class attribute name0.00080.159850.0002
XML
Image XML parsing0.00050.092420.0002
class_abstraction
Instantiating content class attribute0.00000.001850.0000
General
dbfile0.00250.4877150.0002
String conversion0.00000.001640.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
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/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
1content/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: 25
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs