fsockopen in a loop

_XLV_Az

I have a script that performs an fsockopen command in a while loop. Basically it checks several ports on one server.

The problem is that if it fails to open a port because it is down or non-existant then it completely fails when it moves the next port. I guess this is because the previous fsockopen call is still trying to connect to the port or something similar.

Does anyone know of any way to kill an fsockopen command if it fails. I can't use die() or the equivalent as I need to perform some database updates if the fsockopen call fails.

Code is as follows

 while ($sql_server_ports_result = mysql_fetch_array($sql_server_ports_query))
			{
				$fp = @fsockopen ($sql_server_result["server_address"], $sql_server_ports_result["Port_Number"], $errno, $errstr, 20);
				// if we can't get to the port then it is down
				if (!$fp) 
				{
					print $sql_server_ports_result["port_name"]." [".$sql_server_ports_result["Port_Number"]."] <img src=\"graphics/red.gif\" align=\"middle\">";
					// create the log entry
					$sql_create_log_query = mysql_query("INSERT INTO az_logs SET server_ports_ID = ".$sql_server_ports_result["Port_Number"].", creation_date=NOW(), servers_ID = ".$sql_server_result["ID"].", status='down'",$db) or die("Error creating log: " .mysql_error());

			// if the server responds and is up
			} else {
				print $sql_server_ports_result["port_name"]." [".$sql_server_ports_result["Port_Number"]."] <img src=\"graphics/green.gif\" align=\"middle\">";
				fclose ($fp);
			} // end of if that checks if server is up
			print " &nbsp ";
		} // end of while loop that goes through the server ports

ajmoore

Does the script output the correct information when the connection fails for a port? You've got fsockopen set to timeout at 20 seconds, you may want to check out the socket_set_timeout() function...

_XLV_Az

No the output is not produced. Instead I get the message

Error

The requested item could not be loaded by the proxy.

Document contains no data

Proxy server at portia on port 8080

I've tried using socket_close() and socket_shutdown() to cancel the fsockopen call but to no avail. The error code works fine if there is only one socket. The problem appears to be when there are multiple sockets in the loop and the fsockopen is still trying to access the last socket when it gets to the next one in the loop.

I've tried setting the timeout to 1 but the code loops faster than that so the socket timeout isn't really an option.

Any ideas ?

_XLV_Az

I should also say that if the unavailable port is the last one in the loop then the code works fine. It only happens when it is not the last port, hence leading me to think that fsockopen is still attempting a call

shaneo

use iframe in a loop to open a seperate instance for each port
then run fsockopen script in each frame

_XLV_Az

that's not really a viable solution as it is inefficient coding to have the same code running at x simultaneous instances. Also it would be a nightmare to format on-screen.

It might work though so thanks for the idea but I need a solution that doesn't involve calling the page across several different frames

Cow

I agree, Iframe doesn't seem very efficient. I can't see why it would cause this problem?