Running Scripts

nalleyp23

This may be an off the wall question but I have several scripts that I have written in PHP and Update information in my database.

I was wondering what is the best way to have these executed at say 2 a.m. every morning?

Can you use cron to call the script?

I know this is a rather newbie question but I appreciate it.

Thanks,

dalecosp

If you have the CLI build of PHP installed, then cron can do it.

daleco@localhost [/var/home/dalecosp] 21:43
#whereis php
php:  /usr/local/bin/php

daleco@localhost [/var/home/dalecosp] 21:44
#crontab -l
30       16    19    8      *     /usr/local/bin/php - q /var/home/dalecosp/reminder.php

If you don't, but have lynx, that might be a possibility:

daleco@localhost [/var/home/dalecosp] 21:45
#crontab -l
30       16    13    8      *     /usr/local/bin/lynx  [url]http://mysite.com/myscript.php[/url]

HTH,

nalleyp23

Can you tell me why I get this?

Your Terminal type is unknown!

Enter a terminal type: [vt100]
TERMINAL TYPE IS SET TO vt100
(😎0[1;24r[m[?7h[?1h=[H[J[21B[0;7mGetting http://www.vrtxcom.com/Ciprus/scripts/disconnects.php[m[0;7mLooking up www.vrtxcom.com[m[K[0;7mMaking HTTP connection to www.vrtxcom.com[m[0;7mSending HTTP request.[m[K[0;7mHTTP request sent; waiting for response.[m[36D[0;7m/1.1 200 OK[m[K[0;7mwww.vrtxcom.com cookie: PHPSE=1999e08eeb74c49d7976 Allow? (Y/N/Always/neVer)[m

[24;1H[?1l>

dalecosp

Not with the information you are providing. I could guess that your cat walked across the keyboard while you were posting, but I'm doubting the reality of that ... 😉

Should I assume you tried the lynx solution and got this message in your [e]-mailbox?

And, 'shotgunning' is the act of placing the same question/post in multiple forums on the same site...

nalleyp23

Yes.. I setup the script in crontab w/ lynx. It does execute the script fine but I get this response..

Sorry about the shotgunning thing..

dalecosp

I don't generally run scripts via lynx, so I didn't think about redirecting any output when run via cron.

Cron's tty wasn't set to a compatible terminal type ... You got a copy of what it saw ...

probably that command should be ...

/usr/local/bin/lynx [url]http://mysite.com/myscript.php[/url] >/dev/null 2>&1

... and then you won't get any output at all ...

nalleyp23

That worked great! Thank you so much for your help..