Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h3>Preliminary</h3> <ul> <li><p>Check that in the crontab the values of <code>SHELL</code> and <code>PATH</code> are set up correctly, e.g.:</p> <pre><code>SHELL=/bin/bash PATH=/bin:/usr/local/bin:/bin:/usr/bin:/sbin:/usr/local/sbin:/usr/sbin </code></pre> <ul> <li>Ensure that the intended shell (e.g. bash) is really used.</li> <li>Ensure that all needed binaries are accessible via the denoted <code>PATH</code>. </li> </ul></li> <li>Check that you don't have an unescaped <code>%</code> in the crontab. See <code>man 5 crontab</code> for details.</li> <li><p>Maybe you set also the environment variable <code>MAILTO</code> to an approbate value, e.g.:</p> <pre><code>MAILTO="webmaster@example.com" </code></pre></li> </ul> <h3>Ensure your crontab is working</h3> <p>Another little trick to ensure that your <em>crontab</em> is parsed correct, is to add a <em>marker</em> entry at the <strong>end</strong>.</p> <p>I'm using myself this marker entry</p> <blockquote> <p>@daily logger -p local0.notice -t CRON '$Id: demo 7029 2012-11-27 09:27:39Z dirk $'</p> </blockquote> <p>If the marker entry is missing in the syslog, you know that the <em>crontab</em> has become corrupted. This may be triggered by some weird syntax error you haven't seen.</p> <h3>How to debug a cron job</h3> <p>If a cron job it not working please investigate first the job output.</p> <p>Change your crontab to:</p> <pre><code>0 1 * * * /bin/bash -x /var/www/example.com/processors/run.sh &gt;&gt;/tmp/cronTrace 2&gt;&amp;1 </code></pre> <p>Please investigate the generated script output together with the trace output (<code>bash -x</code>).</p> <h3>Additional note</h3> <p><strike><code>chmod +x $SCRIPT</code></strike><br/> <code>$PHP $SCRIPT</code></p> <p>The <code>chmod</code> step is not necessary and should be avoided. In the next line you invoke the script by explicitly use the interpreter command. </p>
    singulars
    1. This table or related slice is empty.
    1. POSequence of PHP Scripts in Bash script executed by Cron not running
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USH.-Dirk Schmitt
    1. USH.-Dirk Schmitt
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSequence of PHP Scripts in Bash script executed by Cron not running
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you elaborate on adding a marker to the crontab and how to check whether the values for `SHELL` and `PATH` are setup correctly in the crontab.
      singulars
      1. PO
      1. USpaperclip
    2. COAfter letting it run with logging to a file as suggested it created an empty log file. No output at all.
      singulars
      1. PO
      1. USpaperclip
    3. CO@paperclip This is only be possible, if the script file is empty. If the script file has at least one (none-comment) line, it is traced with the `-x` option.
      singulars
      1. PO
      1. USH.-Dirk Schmitt
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload