Script works from cmd but not from Scheduled Tasks?

[savyj]

I'm having a quite frustrating problem than me and another engineer have pretty much exhausted our efforts towards.

Specs:
Windows 2000 Server - Two Week Old Install
PHP 4.3.8 - Grabbed CLI version as well

If I run the script from a command line (cmd) as follows, it connects and logs a successful connection to the OLE DB.

e:\program files\php\php-cli.exe testslx.php

But if I do the same thing in a scheduled task it always shows a failure in the log. This makes no sense! The scheduled task is running as Administrator (for tests).

Has anyone ever run into such behavior?

Here's the script:

<?php
error_reporting(0);
$recipients = '[e-mail],[e-mail]';
$logfile = 'e:\\program files\\php\\testslx.log';

$dbc = new COM("ADODB.Connection");
$dbc->Open('Provider=SLXOLEDB.1;Password=password;Persist Security Info=True;User ID=xxxx;Initial Catalog=SALESLOGIX_SERVER;Data Source=XTNDSYNC1;Extended Properties="PORT=1706;LOG=ON"');
if ($dbc->State) {
	success();
} else {
	failure();
}

function success() {
	logentry("SUCCESS: Connected to XTNDSYNC1 SalesLogix service.");
}

function failure() {
	global $recipients;
	$res = mail($recipients, "TESTING - PLEASE IGNORE -- XTNDSYNC1 Error: Could not connect", "Could not connect to XTNDSYNC1 SalesLogix Server.\r\nPlease verify system and service health.\r\n\r\nThis message was generated by the testslx monitor script.");
	$pid = `c:\\Util\\tlist.exe -p SLXServer.exe`;
//	`C:\\Util\\Kill.exe -f $pid`;
//	sleep(3);
//	`net start "SalesLogix Server"`;
	logentry("ERROR: Could not connect to XTNDSYNC1 SalesLogix service.  Mail result code was $res.");
}

function logentry($message) {
	$date = date("[d/M/Y:G:i:s O]");
	$logentry = "$date $message\r\n";
	global $logfile;

if (!$handle = fopen($logfile, 'a')) {
     	echo "Cannot open file ($logfile)";
     	exit;
}

// Write logentry to our opened file.
if (fwrite($handle, $logentry) === FALSE) {
   		echo "Cannot write to file ($logfile)";
   		exit;
}

fclose($handle);           
}

$dbc->Close();
$dbc = null;
?>

[LordShryku]

I've never had much luck just scheduling the command. I've always made a batch file to process it. Try making a .bat file like so, and scheduling that instead.

@ E:
@ CD \program files\php\
@ PHP-CLI E:\program files\php\testslx.php
@ CD \
@ CLS

[savyj]

Originally posted by LordShryku
I've never had much luck just scheduling the command. I've always made a batch file to process it. Try making a .bat file like so, and scheduling that instead.

@ E:
@ CD \program files\php\
@ PHP-CLI E:\program files\php\testslx.php
@ CD \
@ CLS

[/B]

We tried the batch file method yesterday, it didn't fix the problem. Here's the problem and it doesn't make sense. The script connects via a COM object (SalesLogix OLE DB Provider) to a SalesLogix service/db. After I attempt the connection, I grab the state. If the state is 1 then it's a success, otherwise it's a failure. If I run this from command line it's always accurate, in that it shows up when the service is allowing customers to connect and down when the service doesn't. If I run this from the Scheduled Task, it ALWAYS fails to connect! So basically, based on how it's run, it's affecting the function! That doesn't seem right to me or my fellow engineers.

Furthermore, it ran perfectly for three days.

Finally, we've had two reboots now and it runs fine for a time after the reboot and then displays this behavior. ARGGGGHH! 🙂