[wplug] crontab problems

[Poyner, Brandon]

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