Report when a server comes online

siege

Hi,

I am looking to find a php script which broadcasts my servers current ip address
- not the static ip that i assigned in my router, but the ip address that my ISP has assigned me for the day/week.

After it has detirmined my ip address I would like the script to send that info out to another of my servers at a different IP then store it in a MySQL db. is this possbile? I dont have the slightest idea how to do this.

PS I dont want to use dynamicDNS or any of the others at the moment.

wilku

You need to know when your ip has changed
You need to know how to obtain your new ip
You need a way to send this information to the other server.

Ad. 1. You can run php script as cron job (or similar in windows) to check ip address now with the previous one, which should be stored in some file or local database. If the address changes go to point 3.

Ad. 2. I have checked this in my configuration (web server behind a router with dhcp) and , when I run pages with lynx at my server, the ip provided by ISP is stored in $_SERVER['REMOTE_ADDR'] - you can get it there. I think it won't work with php command line, because it's an apache header, so you have to acces this script via apache from the client located at your server).

Ad 3. You can connect directly to your other server's database and store the new IP.

siege

OK. I understood all of your points and would like to try to accomplish that step by step if you dont mind. So far this is what i have. It echo's the address of the server perfectly.

<?php
    $ip = $_SERVER['REMOTE_ADDR'];
	echo $ip;
?>

Now I know a conditional to check to see if $ip is equal to the address stored in my mysql db, but i dont know how to do that in php yet.

wilku

Check [man]mysql[/man] or [man]mysqli[/man] or [man]pdo[/man] to see how to operate on databases in php.
If you want to connect to your remote server make sure you pass the name of the server as the first argument of mysql_connect (otherwise it will connect to localhost). The other thing is that the user you're connecting with must have permissions to connect to your other server (this must be set in the other server's mysql configuration for your_user_name@ip_of_your_first_server or your_user_name@*).

siege

this is what i have so far. Im trying to at least capture the server its currently on, and store the info in a db before i try to send it over to another server. I notice one problem..... the ip address is always the ip addy of the machine im using to access the page and not the actual server's addy.... will this change when i start to use cron?

<?php

include("db.php");

$ip = $_SERVER['REMOTE_ADDR'];
$fullhost = gethostbyaddr($ip);
$host = preg_replace("/^[^.]+./", "*.", $fullhost);

//echo $ip;
//echo "<br />";



$sql="delete from currentStats";
mysql_query($sql);
$svr="Insert into currentStats (ip) Values ('$host');";
mysql_query($svr);
$query = "select * from currentStats ;";
$result=mysql_query($query);
while($articlerow=mysql_fetch_assoc($result))
{
echo "<a href=\"http://".$articlerow['ip']."\" target=\"_blank\">new ip addy</a>";

}                 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
		<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
		<title>server</title>
		</head>
		<body>

	</body>

</html>