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/

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 19 2025 04:38:38
Script start
Timing: Jan 19 2025 04:38:38
Module start 'layout'
Timing: Jan 19 2025 04:38:38
Module start 'content'
Timing: Jan 19 2025 04:38:39
Module end 'content'
Timing: Jan 19 2025 04:38:39
Script end

Main resources:

Total runtime1.0721 sec
Peak memory usage4,096.0000 KB
Database Queries66

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0075 589.4063152.6563
Module start 'layout' 0.00750.0036 742.062539.5078
Module start 'content' 0.01111.0594 781.5703579.9297
Module end 'content' 1.07050.0016 1,361.500016.1094
Script end 1.0721  1,377.6094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00330.3045160.0002
Check MTime0.00130.1204160.0001
Mysql Total
Database connection0.00130.120410.0013
Mysqli_queries0.969090.3811660.0147
Looping result0.00060.0593640.0000
Template Total0.998593.120.4993
Template load0.00220.203120.0011
Template processing0.996492.933520.4982
Template load and register function0.00010.009210.0001
states
state_id_array0.00080.071010.0008
state_identifier_array0.00070.062420.0003
Override
Cache load0.00170.1605430.0000
Sytem overhead
Fetch class attribute can translate value0.00100.091420.0005
Fetch class attribute name0.00150.143980.0002
XML
Image XML parsing0.00100.088920.0005
class_abstraction
Instantiating content class attribute0.00000.0019120.0000
General
dbfile0.00100.0901220.0000
String conversion0.00000.000940.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
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
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_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