[wplug] crontab problems [SOLVED]

[Chris Romano]

It was a syntax error.

Org (non-working):
* 9-16 * * Mon-Fri /home/chris/script.sh

New (working):
* 9-16 * * mon-fri /home/chris/script.sh

It was the capital "M" and "F".

I just now realized that the caps was the difference between the man
example and my mine.  Should have known, I never use capital letters.

Thanks everyone for your help.

Chris

On Thu, 10 Feb 2005 12:17:28 -0500, Poyner, Brandon <bpoyner at ccac.edu> wrote:
> I would run crond with the -d option, possibly -d2 or higher, to see
> what's happening.  This will run crond in the foreground and give you
> debugging output.  It certainly sounds like crond is noticing your
> crontab changes.
> 
> Brandon Poyner
> Network Engineer III
> CCAC - College Office
> 412-237-3086
> 
> -----Original Message-----
> From: Chris Romano [mailto:romano.chris at gmail.com]
> Sent: Thursday, February 10, 2005 10:56 AM
> To: General user list
> Subject: Re: [wplug] crontab problems
> 
> Yep, its gone
> 
> Thanks,
> Chris
> 
> On Thu, 10 Feb 2005 10:48:37 -0500, Poyner, Brandon <bpoyner at ccac.edu>
> wrote:
> > I guess the follow up question is does cron.update disappear?  It
> should
> > be removed after crond notices the file and reloads the tabs.
> >
> > Brandon Poyner
> > Network Engineer III
> > CCAC - College Office
> > 412-237-3086
> >
> > -----Original Message-----
> > From: Chris Romano [mailto:romano.chris at gmail.com]
> > Sent: Thursday, February 10, 2005 10:33 AM
> > To: General user list
> > Subject: Re: [wplug] crontab problems
> >
> > Yes, it's there
> >
> > Thanks,
> > Chris
> >
> > On Thu, 10 Feb 2005 10:20:38 -0500, Poyner, Brandon <bpoyner at ccac.edu>
> > wrote:
> > > After you use 'crontab -e' do you see a file in
> > /var/spool/cron/crontabs
> > > named cron.update?  That is how crond from Dillon's Cron knows it
> has
> > to
> > > reload the various user crontabs.  See the man page for crond.
> > >
> > > Brandon Poyner
> > > Network Engineer III
> > > CCAC - College Office
> > > 412-237-3086
> > >
> > > -----Original Message-----
> > > From: Chris Romano [mailto:romano.chris at gmail.com]
> > > Sent: Thursday, February 10, 2005 10:07 AM
> > > To: General user list
> > > Subject: Re: [wplug] crontab problems
> > >
> > > On Wed, 9 Feb 2005 22:47:47 -0500, Tom Rhodes <trhodes at freebsd.org>
> > > wrote:
> > > > On Wed, 9 Feb 2005 15:45:51 -0500
> > > > Chris Romano <romano.chris at gmail.com> wrote:
> > > >
> > > > > On Wed, 9 Feb 2005 15:11:42 -0500, Tom Rhodes
> > <trhodes at freebsd.org>
> > > wrote:
> > > > > > On Wed, 9 Feb 2005 14:47:13 -0500
> > > > > > Chris Romano <romano.chris at gmail.com> wrote:
> > > > > >
> > > > > > > 1). See previous message
> > > > > > >
> > > > > > > 2). The script doesn't produce any output.
> > > > > > >
> > > > > > > 3). All cron files in /var/log/ are empty.
> > > > > >
> > > > > > Add -x to the top of your script and run it by hand.
> > > > > >
> > > > >
> > > > > Done.  Still no output.
> > > >
> > > > Probably because you're still sending it to /dev/null, I'm not
> > > > sure if the -x is supposed to override that or not.  Try removing
> > > > those parts from the script.  Remember, they'll send failures
> > > > to /dev/null also.
> > > >
> > >
> > > Remove what parts?
> > >
> > > Ok, I now have added this to root's crontab and still nothing.  I
> > > don't know if this helps or not but here you go:
> > >
> > > $ cat scripts
> > > #!/bin/bash -x
> > >
> > > touch /tmp/t
> > >
> > > ./yahoo_equ.php
> > > ./yahoo_inx.php
> > >
> > > $ cat yahoo_equ.php
> > >
> > > #!/usr/bin/php
> > > <?php
> > > include "conn.php";
> > >
> > > $file = fopen("/home/chris/findata/equ.list","r");
> > > $list = fread($file,2000);
> > > $open =
> > >
> >
> fopen("http://quote.yahoo.com/d/quotes.csv?s=$list&f=sl1d1t1ov&e=.csv",
> > > "r");
> > >
> > > $read = fread($open, 2000);
> > > fclose($open);
> > > fclose($file);
> > >
> > > $read = str_replace("\"", "", $read);
> > >
> > > $stocks = explode("\n",$read);
> > > $sym = explode(",",$_POST[tickersymbol]);
> > > $count = count($stocks);
> > >
> > > $db = mysql_connect($host,$user,$pass);
> > > mysql_select_db($dbase,$db);
> > >
> > > for ($x=0;$x<$count-2;$x++) {
> > >  $read = explode(",", $stocks[$x]);
> > >
> > >  $stamp = date(Ymd,strtotime("$read[2]"));
> > >  $stamp.= date(His,strtotime("$read[3]"));
> > >
> > >  $sql = "INSERT INTO equities
> (id,symbol,price,timestamp,open,volume)
> > > VALUES(NULL,'$read[0]','$read[1]','$stamp','$read[4]','$read[5]')";
> > >  mysql_query($sql);
> > >
> > > }
> > > mysql_close($db);
> > > ?>
> > >
> > > # crontab -l
> > > ...
> > > * 9-16 * * Mon-Fri /home/chris/script.sh >> /tmp/tlog.txt 2>&1
> > >
> > > Thanks,
> > > Chris
> > > _______________________________________________
> > > wplug mailing list
> > > wplug at wplug.org
> > > http://www.wplug.org/mailman/listinfo/wplug
> > >
> > >
> > _______________________________________________
> > wplug mailing list
> > wplug at wplug.org
> > http://www.wplug.org/mailman/listinfo/wplug
> >
> >
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
> 
>