Forums / Developer / How do cron jobs know which site access settings to use

How do cron jobs know which site access settings to use

Author Message

Eirik Alfstad Johansen

Thursday 22 January 2004 1:16:47 am

Hi,

I'm wondering how the eZP cron job scripts know which site access settings to use (first and foremost concerning which database to use). I've noticed the "-s,--siteaccess" availble when running runcronjobs.php, and I've used it successfully, but my custom made cron job doesn't seem to take the specific siteaccess into consideration. At least that's my theory since it's unable to connect to the database.

Should it put something specifc into the cronjob script in order to make it fetch the settings from the specified siteaccess?

BTW, here's the code

[code]
<?php
$db =& eZDB::instance();
echo mysql_error() . "\n\n";
?>
[/code]

And here's the result it generates when run from runcronjobs.

[result]
Running extension/affiliate/cronjobs/createreports.php
Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)
[/result]

Thanks in advance !

Sincerely,

Eirik Johansen

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Eirik Alfstad Johansen

Wednesday 08 December 2004 6:28:16 am

Actually, I'm still struggling with this problem, nearly a year later. Does anyone know what I could be doing wrong?

Thanks in advance !

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Eirik Alfstad Johansen

Sunday 09 January 2005 5:15:57 am

Bump.

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Eirik Alfstad Johansen

Wednesday 12 January 2005 11:45:13 am

I will keep naging until I get an answer! :)

No, but seriously, I would greatly appreciate some help on this issue as it's the only thing holding me back from launching a client site.

Eazy-pleaze?

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Björn Dieding@xrow.de

Wednesday 12 January 2005 2:12:04 pm

Usually there is no futher action required to choose the siteaccess from the code site. You just have to use the class eZScript like it has been done before with other crons scripts

the -s option is the way to go

you may also consider running your cron as a cronjobscript part over "php runcronjobs.php -ssiteaccesssname cronjobpart"

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Eirik Alfstad Johansen

Wednesday 19 January 2005 11:44:38 am

Thanks for the tip.

However, I've narrowed it down to what seems to be a problem with my cli version of PHP (on _both_ my servers, actually) making it unable to connect to mysql for some reason. I have yet to figure out the reason, though, but at least I'm not scanning ezp code anymore. :)

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

eZ debug

Timing: Jan 19 2025 03:38:44
Script start
Timing: Jan 19 2025 03:38:44
Module start 'content'
Timing: Jan 19 2025 03:38:45
Module end 'content'
Timing: Jan 19 2025 03:38:45
Script end

Main resources:

Total runtime0.8403 sec
Peak memory usage4,096.0000 KB
Database Queries203

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0091 589.1953180.8125
Module start 'content' 0.00910.7030 770.0078585.0391
Module end 'content' 0.71210.1281 1,355.0469341.3516
Script end 0.8402  1,696.3984 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00440.5242210.0002
Check MTime0.00160.1936210.0001
Mysql Total
Database connection0.00210.249810.0021
Mysqli_queries0.752389.53052030.0037
Looping result0.00200.23602010.0000
Template Total0.810296.420.4051
Template load0.00240.291520.0012
Template processing0.807796.124520.4039
Template load and register function0.00010.014310.0001
states
state_id_array0.00190.231810.0019
state_identifier_array0.00110.130120.0005
Override
Cache load0.00200.2422430.0000
Sytem overhead
Fetch class attribute can translate value0.00170.203930.0006
Fetch class attribute name0.00120.145680.0002
XML
Image XML parsing0.00120.148230.0004
class_abstraction
Instantiating content class attribute0.00000.0026120.0000
General
dbfile0.00210.2444330.0001
String conversion0.00000.002930.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
6content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
6content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 24
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs