./ipdb/README 100664 0 0 1744 7070455637 11115 0 ustar root root ///////////////////////////////////////////////////////
This is a tutorial I wrote on using PHP w/SNMP support
Coder: Chauncey Thorn
Email: cthorn@wt.net
URL : http://PCCS-Linux.COM
///////////////////////////////////////////////////////
phpget_ips IP/MAC address gathering tool
Copyright (C) 2000 Chauncey Thorn
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
./ipdb/getip.php3 100664 0 0 13224 7070454731 12147 0 ustar root root
BayNetwork BackBone Node Query Tool
Query A BackBone Node";
print "";
print "";
print "";
endif;
/* Get Basic Router Info */
if($action == "qry_router"):
/* Using snmpget to get system variables */
$_desc = snmpget("$mhost", "public", "system.sysDescr.0");
$_uptime = snmpget($mhost, public, "system.sysUpTime.0");
$_contact = snmpget("$mhost", "public", "system.sysContact.0");
$_hostname = snmpget("$mhost", "public", "system.sysName.0");
$_location = snmpget("$mhost", "public", "system.sysLocation.0");
/* Using snmpwalk to create an array for the number of interaces on the router */
$_mib = snmpwalk("$mhost","public","interfaces.ifTable.ifEntry.ifIndex");
for($i=0; $i < count($_mib); $i++) {
$interface[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifDescr.$_mib[$i]");
$interface_type[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifType.$_mib[$i]");
$hwaddr_interface[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifPhysAddress.$_mib[$i]");
$inOctets[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifInOctets.$_mib[$i]");
$outOctets[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifOutOctets.$_mib[$i]");
}
print"
| Description: $_desc |
| Uptime: $_uptime |
| Contact: $_contact |
| Hostname: $_hostname |
| Location: $_location |
"; // End if print statement
print"
| Interfaces |
Type |
MacAddress |
InOctets |
OutOctets |
|
"; // End if print statement
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " |
";
print "
";
print "Hosts the this device answers to:";
$hosts = gethostbynamel("$mhost");
for($i =0; $i < count($hosts); $i++)
echo $hosts[$i] . "
";
print "Grab
the IP addresses";
endif;
/*
NOW this is where PHP/SNMP can help the Network Administrator
*/
if($action == "get_ips"):
function get_ips($mhost,$community) {
global $ipoctet,$db_server,$db_user,$db_passwd,$db_name;
$mib_str = "at.atTable.atEntry.atPhysAddress";
/* get Data using snmpwalkoid*/
$_mibvars = snmpwalkoid("$mhost","$community","$mib_str");
/*
Output example ;
at.atTable.atEntry.atPhysAddress.1.1.136.xxx.xxx.1 = Hex: 00 00 X2 X6 XD XD
at.atTable.atEntry.atPhysAddress.1.1.136.xxx.xxx.47 = Hex: 00 C0 4X 8X 9X DX
*/
for (reset($_mibvars); $i = key($_mibvars); next($_mibvars)) {
/* Process Results */
$ip = eregi_replace("$mib_str.[^s].[^s^s].$ipoctet","$ipoctet","$i");
$mac = ereg_replace("Hex:","","$_mibvars[$i]");
/* Insert data into database */
/* You will need to change these variables to connect to your database */
$conn = mysql_connect("$db_server","$db_user","$db_passwd");
mysql_select_db("$db_name");
$mac = chop($mac);
$query = "REPLACE INTO ip_mac (ipaddr,mac_addr) VALUES ('$ip','$mac')";
$macaddr_res = mysql_query($query);
if(!empty($macaddr_res)) {
echo "";
}else{
echo mysql_error() . "
\n";
}
}
}
get_ips($mhost,$community);
endif;
?>
./ipdb/getip.phps 100664 0 0 13224 7070455720 12246 0 ustar root root
BayNetwork BackBone Node Query Tool
Query A BackBone Node";
print "";
print "";
print "";
endif;
/* Get Basic Router Info */
if($action == "qry_router"):
/* Using snmpget to get system variables */
$_desc = snmpget("$mhost", "public", "system.sysDescr.0");
$_uptime = snmpget($mhost, public, "system.sysUpTime.0");
$_contact = snmpget("$mhost", "public", "system.sysContact.0");
$_hostname = snmpget("$mhost", "public", "system.sysName.0");
$_location = snmpget("$mhost", "public", "system.sysLocation.0");
/* Using snmpwalk to create an array for the number of interaces on the router */
$_mib = snmpwalk("$mhost","public","interfaces.ifTable.ifEntry.ifIndex");
for($i=0; $i < count($_mib); $i++) {
$interface[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifDescr.$_mib[$i]");
$interface_type[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifType.$_mib[$i]");
$hwaddr_interface[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifPhysAddress.$_mib[$i]");
$inOctets[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifInOctets.$_mib[$i]");
$outOctets[] = snmpget("$mhost","public","interfaces.ifTable.ifEntry.ifOutOctets.$_mib[$i]");
}
print"
| Description: $_desc |
| Uptime: $_uptime |
| Contact: $_contact |
| Hostname: $_hostname |
| Location: $_location |
"; // End if print statement
print"
| Interfaces |
Type |
MacAddress |
InOctets |
OutOctets |
|
"; // End if print statement
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " | ";
for($i=0; $i ";
}
print " |
";
print "
";
print "Hosts the this device answers to:";
$hosts = gethostbynamel("$mhost");
for($i =0; $i < count($hosts); $i++)
echo $hosts[$i] . "
";
print "Grab
the IP addresses";
endif;
/*
NOW this is where PHP/SNMP can help the Network Administrator
*/
if($action == "get_ips"):
function get_ips($mhost,$community) {
global $ipoctet,$db_server,$db_user,$db_passwd,$db_name;
$mib_str = "at.atTable.atEntry.atPhysAddress";
/* get Data using snmpwalkoid*/
$_mibvars = snmpwalkoid("$mhost","$community","$mib_str");
/*
Output example ;
at.atTable.atEntry.atPhysAddress.1.1.136.xxx.xxx.1 = Hex: 00 00 X2 X6 XD XD
at.atTable.atEntry.atPhysAddress.1.1.136.xxx.xxx.47 = Hex: 00 C0 4X 8X 9X DX
*/
for (reset($_mibvars); $i = key($_mibvars); next($_mibvars)) {
/* Process Results */
$ip = eregi_replace("$mib_str.[^s].[^s^s].$ipoctet","$ipoctet","$i");
$mac = ereg_replace("Hex:","","$_mibvars[$i]");
/* Insert data into database */
/* You will need to change these variables to connect to your database */
$conn = mysql_connect("$db_server","$db_user","$db_passwd");
mysql_select_db("$db_name");
$mac = chop($mac);
$query = "REPLACE INTO ip_mac (ipaddr,mac_addr) VALUES ('$ip','$mac')";
$macaddr_res = mysql_query($query);
if(!empty($macaddr_res)) {
echo "";
}else{
echo mysql_error() . "
\n";
}
}
}
get_ips($mhost,$community);
endif;
?>
./ipdb/ipdb.php3 100664 0 0 10106 7070451125 11743 0 ustar root root
IP DB
";
$result = mysql($db_name,$query);
return $result;
}
?>
> New Search
Search for '' in '' returned hits
0) { ?>
?ip_mac=&found=&start=><<<Previous
?ip_mac=&found=&start=>>>>Next
| PHP/SNMP Ip/MAC Address Gathering and Query Tool |
|
|
./ipdb/ipdb.sql 100664 0 0 212 7070453407 11632 0 ustar root root DROP TABLE IF EXISTS ip_mac;
CREATE TABLE ip_mac (
ipaddr char(15) NOT NULL,
mac_addr char(20) NOT NULL,
UNIQUE(ipaddr,mac_addr)
);