php runcronjobs.php errors

Author Message

Carlos Revillo

Monday 28 January 2008 5:53:48 am

Hi. I need a crunjobs for aproval workflows. It seems something is not right in php settings of the machine we're uploading our site.

We have shell access, but we have no root permissions on this server.

If we do wget http://www.domain.com/runcronjobs.php, the approved items appear in contentree, but we have troubles if we do

php runcronjobs.php  frequent -s es -dall 

we get

#################################### DEBUG ####################################
Content-type: text/html

Warning: (eZMySQLDB)
MySQL extension was not found, the DB handler will not be initialized.


Total script time: 0.0255 sec

btw, my settings/siteaccess/es/site.ini.append.php looks like

[DatabaseSettings]
DatabaseImplementation=ezmysql
Server=localhost
User=db_user
Password=db_password
Database=database
Charset=
Socket=/var/lib/mysql/mysql.sock

This looks the same for administration siteaccess. i've got only these two siteaccess enabled.

Site is working perfectly, so it seems i need to do something with php config for running this cronjobs works?
thank you.

Ɓukasz Serwatka

Tuesday 29 January 2008 11:36:50 pm

Hi Carlos.

It seems that your CLI PHP does not have mysql extension enabled. You can check available modules with

$ php -m

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Gaetano Giunta

Wednesday 30 January 2008 12:51:58 am

This looks like a very common misstep (I have seen it biting lots of coders).

Maybe we should better document this - OR add a check somewhere for correct php extensions being loaded in php cli - at end of install script might be a good idea...

Principal Consultant International Business
Member of the Community Project Board

Carlos Revillo

Wednesday 30 January 2008 1:49:39 am

that was the problem. php -m doesn't show anything about mysql. i've asked my hosting provider to enable it. Thanks!.

Kristof Coomans

Wednesday 30 January 2008 4:40:25 am

imho in this case the message in the debug output was quite clear, "Warning: (eZMySQLDB) MySQL extension was not found" :)

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Gaetano Giunta

Wednesday 30 January 2008 12:47:15 pm

The message is really very telling, but some developers have no idea that you can be using a different php.ini for cli that the one used for the sapi module, so they look at the error message and are bewildered...

Principal Consultant International Business
Member of the Community Project Board

Carlos Revillo

Wednesday 30 January 2008 1:33:03 pm

Exactly :). Also, when you pay a lot of money to a hosting provider, you think all the extensiones you have asked for are enabled...
thanks everybody for your help.

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 31 2025 01:20:16
Script start
Timing: Jan 31 2025 01:20:16
Module start 'layout'
Timing: Jan 31 2025 01:20:16
Module start 'content'
Timing: Jan 31 2025 01:20:17
Module end 'content'
Timing: Jan 31 2025 01:20:17
Script end

Main resources:

Total runtime1.0412 sec
Peak memory usage8,192.0000 KB
Database Queries73

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0041 588.1250151.2109
Module start 'layout' 0.00410.0031 739.3359220.6875
Module start 'content' 0.00721.0332 960.02344,580.0781
Module end 'content' 1.04040.0007 5,540.101615.8516
Script end 1.0412  5,555.9531 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00310.3018160.0002
Check MTime0.00110.1075160.0001
Mysql Total
Database connection0.00070.065610.0007
Mysqli_queries0.952091.4292730.0130
Looping result0.00060.0533710.0000
Template Total0.985894.720.4929
Template load0.00180.174220.0009
Template processing0.983994.497020.4920
Template load and register function0.00130.127510.0013
states
state_id_array0.00190.178910.0019
state_identifier_array0.00140.130220.0007
Override
Cache load0.00160.1493340.0000
Sytem overhead
Fetch class attribute can translate value0.00160.153740.0004
Fetch class attribute name0.00160.1558100.0002
XML
Image XML parsing0.00160.156840.0004
class_abstraction
Instantiating content class attribute0.00000.0018110.0000
General
dbfile0.00120.1109300.0000
String conversion0.00000.000640.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
7content/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
4content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
4content/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: 30
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs