[wplug] crontab problems

[Poyner, Brandon]

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