Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "xusdb.test.247media.com";
- $username = "sdbxaxis";
- $password = "xaxissdb";
- $dbname = "servers";
- $files = scandir('ansible/');
- foreach($files as $file) {
- if($file == "." || $file == ".."){
- } else {
- $jsondata = file_get_contents('ansible/'.$file);
- $data = json_decode($jsondata, true);
- $hostname = $data['ansible_facts']['ansible_hostname'];
- mysql_connect($servername,$username,$password) or die(mysql_error());
- mysql_select_db($dbname) or die(mysql_error());
- $query = mysql_query("SELECT * FROM hostname WHERE systemname LIKE '$hostname'") or die(mysql_error());
- while($row = mysql_fetch_array($query)) {
- $id = $row['id'];
- echo $row['systemname'];
- echo '<br />';
- $interfacez = $data['ansible_facts']['ansible_interfaces'];
- foreach($interfacez as $interf){
- if($interf == "lo"){
- }else{
- if($interf == "eth0"){
- $idevice = $data['ansible_facts']['ansible_eth0']['device'];
- $iaddress = $data['ansible_facts']['ansible_eth0']['ipv4']['address'];
- $imacaddress = $data['ansible_facts']['ansible_eth0']['macaddress'];
- $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
- $istatus = $data['ansible_facts']['ansible_eth0']['active'];
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
- VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully ".$idevice;
- echo '<br />';
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- }elseif($interf == "eth1"){
- $idevice = $data['ansible_facts']['ansible_eth1']['device'];
- $iaddress = $data['ansible_facts']['ansible_eth1']['ipv4']['address'];
- $imacaddress = $data['ansible_facts']['ansible_eth1']['macaddress'];
- $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
- $istatus = $data['ansible_facts']['ansible_eth1']['active'];
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
- VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully ".$idevice;
- echo '<br />';
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- } elseif($interf == "eth2"){
- $idevice = $data['ansible_facts']['ansible_eth2']['device'];
- $iaddress = $data['ansible_facts']['ansible_eth2']['ipv4']['address'];
- $imacaddress = $data['ansible_facts']['ansible_eth2']['macaddress'];
- $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
- $istatus = $data['ansible_facts']['ansible_eth2']['active'];
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
- VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully ".$idevice;
- echo '<br />';
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- }
- }
- }
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement