A Nice Mysql Server Check

football123213

Oct 27 2005, 10:53 AM

I made this and its not very hard at all just fill in the info and it willl see if your mysql is up or down

CODE

<html>
<head> <title> Mysql Connection Test </title> </head>
<body>
<h2>

<?php
// On this you need to put your host most of the times localhost username and password.
$conncect = mysql_connect ( "host", "Username", "password" )
or die (" Sorry your server can't connect to your mysql server <BR> Check to see you have put in the Username and password and if this is the 1st time you have got this <BR> And it has worked before That means you need to contact your hoster and tell them my MySql server is down");
echo ("Good job your server has connected to your mysql server");
?>

</h2>
</body> <html>

Tell me what you think

Comment/Reply (w/o sign-up)

OpaQue

Oct 28 2005, 08:30 AM

The above script is not recommended as it has to connect to database to find out the error. Therefore, I would recommend the following script, which checks the server statistics and uptime.

And also all other ports and reports the ones which fail. So it can check httpd, mysql, POP (mail), SSH and other ports.

CODE

<?php

$data .= "
<style>
td,body
{
font-family: Arial, Helvetica, sans-serif;
font-size: 8pt;
color: #444444;
}
</style>
<br>
<center>
<div style=\"border-bottom:1px #999999 solid;width:480;\"><b>
<font size='1' color='#3896CC'>Service Status</font></b>
</div>
</center>
<br>";

//configure script
$timeout = "1";

//set service checks
$port[1] = "80"; $service[1] = "Apache"; $ip[1] ="";
$port[2] = "21"; $service[2] = "FTP"; $ip[2] ="";
$port[3] = "3306"; $service[3] = "MYSQL"; $ip[3] ="";
$port[4] = "25"; $service[4] = "Email(POP3)"; $ip[4] ="";
$port[5] = "143"; $service[5] = "Email(IMAP)"; $ip[5] ="";
$port[6] = "2095"; $service[6] = "Webmail"; $ip[6] ="";
$port[7] = "2082"; $service[7] = "Cpanel"; $ip[7] ="";
$port[8] = "80"; $service[8] = "Internet Connection"; $ip[8] ="google.com";
$port[9] = "2086"; $service[9] = "WHM"; $ip[9] ="";

//
// NO NEED TO EDIT BEYOND HERE
// UNLESS YOU WISH TO CHANGE STYLE OF RESULTS
//

//count arrays
$ports = count($port);
$ports = $ports + 1;
$count = 1;

//beggin table for status
$data .= "<table width='480' border='1' cellspacing='0' cellpadding='3' style='border-collapse:collapse' bordercolor='#333333' align='center'>";

while($count < $ports){

if($ip[$count]==""){
$ip[$count] = "localhost";
}

$fp = @fsockopen("$ip[$count]", $port[$count], $errno, $errstr, $timeout);
if (!$fp) {
$data .= "<tr><td>$service[$count]</td><td bgcolor='#FFC6C6'>Offline </td></tr>";
} else {
$data .= "<tr><td>$service[$count]</td><td bgcolor='#D9FFB3'>Online</td></tr>";
}
$count++;

}

//close table
$data .= "</table>";

echo $data;
$data1 .= "
<br>
<center>
<div style=\"border-bottom:1px #999999 solid;width:480;\"><b>
<font size='1' color='#3896CC'>Server Information</font></b>
</div>
</center><BR>";

$data1 .= "<table width='480' border='1' cellspacing='0' cellpadding='3' style='border-collapse:collapse'

bordercolor='#333333' align='center'>";

//GET SERVER LOADS
$loadresult = @exec('uptime');
preg_match("/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/",$loadresult,$avgs);

//GET SERVER UPTIME
$uptime = explode(' up ', $loadresult);
$uptime = explode(',', $uptime[1]);
$uptime = $uptime[0].', '.$uptime[1];

$data1 .= "<tr><td>Server Load Averages </td><td>$avgs[1], $avgs[2], $avgs[3]</td>\n";
$data1 .= "<tr><td>Server Uptime </td><td>$uptime </td></tr>";
$data1 .= "</table>";
echo $data1;

?>

If you want to check a remote server using the above script, you will have to replace

CODE

$ip[$count] = "localhost";

CODE

$ip[$count] = "IP-OF-REMOTE-HOST";

Comment/Reply (w/o sign-up)

sandbox

Oct 28 2005, 09:12 AM

cool script! What does this line in an example output mean? :

Server Load Averages 4.37, 3.06, 2.68

Comment/Reply (w/o sign-up)

football123213

Oct 28 2005, 11:49 PM

U talking about My Script or his

Because rember its not like a hard core php script is just nice and ez