Changeset 167 for www/system/generators

Timestamp:

Mar 24, 2009, 11:44:03 AM (16 years ago)

Author:

george

Message:

• Přidáno: Stránka pro rozeslání emailů s počátečními hesly.
• Upraveno: Konfigurační skripty pro nastavení síťových zařízení se systémem RouterOS doplněny o podporu zápisu konfigurace do více samostatných zařízení. Změna se týká konfigurace DHCP serveru a sledování net_watch.
• Opraveno: Některé nefunkční odkazy na hlavní stránce.
• Upraveno: Tabulka finance_operations nově převedena na tabulky FinanceOperation a FinanceClaimsLiabilities. Upraveny související stránky.

Location:

www/system/generators

Files:

• . (modified) (1 prop)
• dhcp_routerboard.php (modified) (1 diff)
• netwatch.php (modified) (1 diff)
• traffic_shaping_routerboard.php (modified) (2 diffs)

www/system/generators/dhcp_routerboard.php

@@ -1 +1 @@
 <?php
+
+$SessionDisable = true;
 include_once('../../global.php');
 
-// Generate DHCP server configuration
-/*
-$File = fopen('/etc/dhcpd.conf', 'w');
-fputs($File, "# DHCP Configuration file\n".
-"authoritative;\n".
-'option domain-name "zdechov.net";'."\n".
-"server-name centrala;\n".
-"ddns-update-style ad-hoc;\n".
-"default-lease-time 86400;\n".
-"max-lease-time 86400;\n".
-"ddns-hostname centrala;\n".
-"option domain-name-servers 192.168.0.1;\n".
-"#option subnet-mask 255.255.0.0;\n\n".
-"# nastaveni WINS serveru\n".
-"option netbios-name-servers 192.168.0.1;\n".
-"option netbios-dd-server 192.168.0.1;\n".
-"option netbios-node-type 8;\n".
-'option netbios-scope "";'."\n".
-"server-identifier 192.168.0.1;\n\n");
-*/
-$Commands = array();
-//$MaxSubnet = 1;
-$Commands[] = '/ip dhcp-server lease { remove [find]}';
-for($i = 0; $i <= 5; $i++)
+$UserName = 'admin-ssh';
+
+$DbResult = $Database->query('SELECT * FROM NetworkSubnet');
+while($Subnet = $DbResult->fetch_assoc())
 {
-/*
-  fputs($File, "subnet 192.168.".$i.".0 netmask 255.255.255.0 {\n".
-  "  range 192.168.".$i.".128 192.168.".$i.".254;\n".
-  "  option broadcast-address 192.168.".$i.".255;\n".
-  "  option routers 192.168.".$i.".1;\n");
-*/
-  $DbResult = $Database->select('hosts', '*', "IP LIKE '192.168.".$i."%' ORDER BY IP");
-  while($Row = $DbResult->fetch_array())
+  //print_r($Subnet);
+  $I = explode('.', $Subnet['AddressRange']);
+  $I = $I[2];
+  $Commands = array();
+  $Commands[] = '/ip dhcp-server lease { remove [find server=dhcp'.$I.']}';
+  $DbResult2 = $Database->query('SELECT * FROM hosts WHERE (IP LIKE "192.168.'.$I.'.%") AND (MAC != "00:00:00:00:00:00") ORDER BY IP');
+  while($Host = $DbResult2->fetch_assoc())
   {
-//    $Data = $Row['name'];
-//    if(strlen($Data) < 9) $Data .= "\t";
-//    fputs($File, "  host ".$Data."\t{ fixed-address ".$Row['IP'].";\thardware ethernet ".$Row['MAC']."; }\n");
-    $Commands[] = '/ip dhcp-server lease add mac-address='.$Row['MAC'].' address='.$Row['IP'].' server=dhcp'.$i.' comment='.$Row['name'];
+    $Commands[] = '/ip dhcp-server lease add mac-address='.$Host['MAC'].' address='.$Host['IP'].' server=dhcp'.$I.' comment='.$Host['name'];
   }
-  
-//  fputs($File, "}\n\n");
+  $Commands = implode(';', $Commands);
+  $Command = '/usr/bin/ssh -l '.$UserName.' -i id_dsa '.$Subnet['DHCP'].' "'.$Commands.'"';
+  echo($Command."\n");
+  $Output = '';
+  exec($Command, $Output);
+  print_r($Output);
+  echo("\n");
 }
-//fclose($File);
-$Commands = implode(';', $Commands);
-$Command = '/usr/bin/ssh -l admin-ssh -i /root/.ssh/id_dsa rt-hajda-0 "'.$Commands.'"';
-echo($Command);
-exec($Command, $Output);
-print_r($Output);
 
 ?>

www/system/generators/netwatch.php

@@ -1 +1 @@
 <?php
+
+$SessionDisable = true;
 include_once('../../global.php');
 
-$Commands = array();
-//$MaxSubnet = 1;
-$Commands[] = '/tool netwatch remove [/tool netwatch find]';
-//for($i = 0; $i <= 4; $i++)
-//{
-  $DbResult = $Database->select('hosts', '*', 'IP != "" ORDER BY IP');
-  while($Row = $DbResult->fetch_array())
+$UserName = 'admin-ssh';
+
+$DbResult3 = $Database->query('SELECT DISTINCT (`DHCP`) FROM `NetworkSubnet`');
+while($Router = $DbResult3->fetch_assoc())
+{
+  $Commands = array();
+  $Commands[] = '/tool netwatch remove [find]';
+  $DbResult = $Database->query('SELECT * FROM `NetworkSubnet` WHERE `DHCP`="'.$Router['DHCP'].'"');
+  while($Subnet = $DbResult->fetch_assoc())
   {
-    $Commands[] = '/tool netwatch add host='.$Row['IP'].' interval=1m comment='.$Row['name'];
+    //print_r($Subnet);
+    $I = explode('.', $Subnet['AddressRange']);
+    $I = $I[2];
+    $DbResult2 = $Database->query('SELECT * FROM hosts WHERE (IP LIKE "192.168.'.$I.'.%") AND (MAC != "00:00:00:00:00:00") ORDER BY IP');
+    while($Host = $DbResult2->fetch_assoc())
+    {
+      $Commands[] = '/tool netwatch add host='.$Host['IP'].' interval=1m comment='.$Host['name'];
+    }
   }
-//}
-$Commands = implode(';', $Commands);
-$Command = '/usr/bin/ssh -l admin-ssh -i /root/.ssh/id_dsa rt-hajda-0 "'.$Commands.'"';
-echo($Command);
-exec($Command, $Output);
-print_r($Output);
+  $Commands = implode(';', $Commands);
+  $Command = '/usr/bin/ssh -l '.$UserName.' -i id_dsa '.$Router['DHCP'].' "'.$Commands.'"';
+  echo($Command."\n");
+  $Output = '';
+  exec($Command, $Output);
+  print_r($Output);
+  echo("\n");
+}
 
 ?>

www/system/generators/traffic_shaping_routerboard.php

@@ -3 +3 @@
 $Enabled = 1;
 $ClassesEnabled = 1;
+$SessionDisable = true;
 include_once('../../global.php');
 $Finance = &$System->Modules['Finance'];
@@ -28 +29 @@
 
 $InetInterface = 'ether3';
-$Router = '192.168.0.11';
+$Router = '192.168.0.99';
 
 $Commands = array();