Forums / General / php runcronjobs.php errors

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.

eZ debug

Timing: Jan 18 2025 11:23:33
Script start
Timing: Jan 18 2025 11:23:33
Module start 'content'
Timing: Jan 18 2025 11:23:34
Module end 'content'
Timing: Jan 18 2025 11:23:34
Script end

Main resources:

Total runtime0.7669 sec
Peak memory usage4,096.0000 KB
Database Queries210

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 587.7031180.8438
Module start 'content' 0.00680.6181 768.5469677.6953
Module end 'content' 0.62490.1419 1,446.2422341.0703
Script end 0.7668  1,787.3125 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00440.5796210.0002
Check MTime0.00170.2218210.0001
Mysql Total
Database connection0.00110.141910.0011
Mysqli_queries0.683389.10402100.0033
Looping result0.00230.29402080.0000
Template Total0.741496.720.3707
Template load0.00210.277920.0011
Template processing0.739296.394220.3696
Template load and register function0.00020.022210.0002
states
state_id_array0.00100.127510.0010
state_identifier_array0.00090.115920.0004
Override
Cache load0.00190.2437340.0001
Sytem overhead
Fetch class attribute can translate value0.00170.216150.0003
Fetch class attribute name0.00100.1264100.0001
XML
Image XML parsing0.00190.248850.0004
class_abstraction
Instantiating content class attribute0.00000.0022110.0000
General
dbfile0.00330.4242410.0001
String conversion0.00000.000830.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
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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/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