Forums / Install & configuration / Installation - Wizard doesn't try to connect to MySQL?

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

eZ debug

Timing: Jan 19 2025 07:19:17
Script start
Timing: Jan 19 2025 07:19:17
Module start 'content'
Timing: Jan 19 2025 07:19:18
Module end 'content'
Timing: Jan 19 2025 07:19:19
Script end

Main resources:

Total runtime1.4682 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0049 590.3359180.8047
Module start 'content' 0.00491.2277 771.1406560.8984
Module end 'content' 1.23260.2355 1,332.0391336.7500
Script end 1.4681  1,668.7891 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.2792210.0002
Check MTime0.00160.1096210.0001
Mysql Total
Database connection0.00060.043810.0006
Mysqli_queries1.379493.95011970.0070
Looping result0.00230.15421950.0000
Template Total1.437097.920.7185
Template load0.00220.148120.0011
Template processing1.434897.726020.7174
Template load and register function0.00020.015210.0002
states
state_id_array0.00160.110310.0016
state_identifier_array0.00250.173320.0013
Override
Cache load0.00190.1277550.0000
Sytem overhead
Fetch class attribute can translate value0.00140.098030.0005
Fetch class attribute name0.00110.074850.0002
XML
Image XML parsing0.00100.066530.0003
class_abstraction
Instantiating content class attribute0.00000.000850.0000
General
dbfile0.00700.4778260.0003
String conversion0.00000.000330.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
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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs