[wplug] crontab problems
Chris Romano
romano.chris at gmail.com
Thu Feb 10 10:33:29 EST 2005
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
>
>
More information about the wplug
mailing list