| 2815 |
rexy |
1 |
<?php
|
|
|
2 |
# Welcome page (sysinfo)
|
|
|
3 |
# by Rexy
|
|
|
4 |
// request database
|
|
|
5 |
function request ($texte) {
|
|
|
6 |
$strResult = 0;
|
|
|
7 |
// Déclaration des paramètres de connexion
|
|
|
8 |
$host = "localhost";
|
|
|
9 |
$DB_USER = "radius";
|
|
|
10 |
$DB_RADIUS = "radius";
|
| 3132 |
rexy |
11 |
$radiuspwd = "";
|
| 2815 |
rexy |
12 |
// Connexion au serveur
|
|
|
13 |
$mysqli = new mysqli($host, $DB_USER, $radiuspwd, $DB_RADIUS);
|
|
|
14 |
if ($texte == 'user') {$query = "SELECT UserName FROM userinfo";}
|
|
|
15 |
else { $query = "SELECT GroupName FROM radusergroup GROUP BY GroupName";}
|
|
|
16 |
$result = $mysqli->query($query);
|
|
|
17 |
// Recuperation des resultats
|
|
|
18 |
$strResult = $result->num_rows;
|
|
|
19 |
// Deconnexion de la base de donnees
|
|
|
20 |
$mysqli->close();
|
|
|
21 |
return $strResult;
|
|
|
22 |
}
|
| 3031 |
rexy |
23 |
// router test
|
| 3129 |
rexy |
24 |
function routerTest($host,$nic) {
|
| 3235 |
rexy |
25 |
$out = exec("(sudo LANG=C LC_ALL=C arping -I$nic -c1 $host|grep response|cut -d' ' -f2)");
|
| 3129 |
rexy |
26 |
return ($out == "1") ? true : false;
|
| 3031 |
rexy |
27 |
}
|
|
|
28 |
|
| 2815 |
rexy |
29 |
// Internet test
|
|
|
30 |
function internetTest() {
|
|
|
31 |
$host = 'www.google.com';
|
|
|
32 |
$host2 = 'www.alcasar.net';
|
|
|
33 |
$port = 80;
|
|
|
34 |
|
|
|
35 |
$sock = @fsockopen($host, $port, $errno, $errstr, 2);
|
|
|
36 |
if ($sock) {
|
|
|
37 |
fclose($sock);
|
|
|
38 |
return true;
|
|
|
39 |
}
|
|
|
40 |
|
|
|
41 |
$sock = @fsockopen($host2, $port, $errno, $errstr, 2);
|
|
|
42 |
if ($sock) {
|
|
|
43 |
fclose($sock);
|
|
|
44 |
return true;
|
|
|
45 |
}
|
|
|
46 |
|
|
|
47 |
return false;
|
|
|
48 |
}
|
|
|
49 |
|
| 3127 |
rexy |
50 |
// searchString = search for a string in a file
|
|
|
51 |
function searchString($file, $search_regex){
|
| 2815 |
rexy |
52 |
$pointeur = fopen($file,"r");
|
|
|
53 |
$result = false;
|
|
|
54 |
if ($pointeur)
|
|
|
55 |
{
|
|
|
56 |
while (!feof($pointeur))
|
|
|
57 |
{
|
|
|
58 |
$ligne = fgets($pointeur);
|
|
|
59 |
if (preg_match($search_regex, $ligne, $r))
|
|
|
60 |
{
|
|
|
61 |
$result = true;
|
|
|
62 |
break;
|
|
|
63 |
}
|
|
|
64 |
}
|
|
|
65 |
}
|
|
|
66 |
fclose($pointeur);
|
|
|
67 |
return $result;
|
|
|
68 |
}
|
|
|
69 |
|
|
|
70 |
$Language = 'en';
|
|
|
71 |
if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
|
|
|
72 |
$Langue = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
|
|
73 |
$Language = strtolower(substr(chop($Langue[0]), 0, 2));
|
|
|
74 |
}
|
|
|
75 |
if ($Language === 'fr') {
|
| 2887 |
rexy |
76 |
$locale_time = "fr_FR";
|
| 2815 |
rexy |
77 |
$l_title = "Bienvenue dans l'ACC (ALCASAR Control Center)";
|
| 3033 |
rexy |
78 |
$l_internet_link = "Accès Internet";
|
| 3031 |
rexy |
79 |
$l_lan = "LAN";
|
|
|
80 |
$l_router = "Routeur";
|
|
|
81 |
$l_DNS = "DNS";
|
|
|
82 |
$l_enable = "Activé";
|
|
|
83 |
$l_disable = "Désactivé";
|
| 2815 |
rexy |
84 |
$l_version = "Version instalée";
|
|
|
85 |
$l_available = "Version disponible";
|
|
|
86 |
$l_users = "Nombre d'utilisateurs / connectés";
|
|
|
87 |
$l_groups = "Nombre de groupes";
|
| 2887 |
rexy |
88 |
$l_system_date = "Date du système";
|
| 2815 |
rexy |
89 |
}
|
| 2853 |
rexy |
90 |
else if ($Language === 'es') {
|
| 2887 |
rexy |
91 |
$locale_time = "es_ES";
|
| 2853 |
rexy |
92 |
$l_title = "Bienvenido al ACC (Centro de Control de ALCASAR)";
|
| 3033 |
rexy |
93 |
$l_internet_link = "Acceso a Internet";
|
| 2853 |
rexy |
94 |
$l_enable = "Activo";
|
| 3031 |
rexy |
95 |
$l_lan = "LAN";
|
|
|
96 |
$l_router = "Rúter";
|
|
|
97 |
$l_DNS = "DNS";
|
| 2853 |
rexy |
98 |
$l_disable = "Desactivado";
|
|
|
99 |
$l_version = "Versión instalada";
|
|
|
100 |
$l_available = "Versión disponible";
|
|
|
101 |
$l_users = "Número de usuarios / conectados";
|
|
|
102 |
$l_groups = "Número de grupos";
|
| 2887 |
rexy |
103 |
$l_system_date = "Fecha del sistema";
|
| 2853 |
rexy |
104 |
}
|
| 2815 |
rexy |
105 |
else {
|
| 2887 |
rexy |
106 |
$locale_time = "en_EN";
|
| 2815 |
rexy |
107 |
$l_title = "Welcome in ACC (ALCASAR Control Center)";
|
| 3033 |
rexy |
108 |
$l_internet_link = "Internet access";
|
| 3031 |
rexy |
109 |
$l_lan = "LAN";
|
|
|
110 |
$l_router = "Router";
|
|
|
111 |
$l_DNS = "DNS";
|
| 2823 |
rexy |
112 |
$l_enable = "Enabled";
|
|
|
113 |
$l_disable = "Disabled";
|
| 2815 |
rexy |
114 |
$l_version = "Installed version";
|
|
|
115 |
$l_available = "Available version";
|
| 2976 |
rexy |
116 |
$l_users = "Number of users / connected";
|
| 2815 |
rexy |
117 |
$l_groups = "Number of groups";
|
| 2924 |
rexy |
118 |
$l_system_date = "System date";
|
| 2815 |
rexy |
119 |
}
|
|
|
120 |
?>
|
|
|
121 |
<!DOCTYPE html>
|
|
|
122 |
<html>
|
| 2823 |
rexy |
123 |
<head>
|
|
|
124 |
<link rel="stylesheet" href="/css/acc.css">
|
|
|
125 |
</head>
|
|
|
126 |
<body>
|
|
|
127 |
<div class="panel">
|
|
|
128 |
<div class="panel-header"><?= $l_title ?></div>
|
|
|
129 |
<div class ="panel-row">
|
|
|
130 |
<div class="panel-cell">
|
| 2815 |
rexy |
131 |
<?
|
|
|
132 |
// Read CONF_FILE
|
|
|
133 |
define ('CONF_FILE', '/usr/local/etc/alcasar.conf');
|
| 3031 |
rexy |
134 |
$file_conf = fopen(CONF_FILE, 'r');
|
|
|
135 |
if (!$file_conf) {
|
|
|
136 |
exit('Error opening the file '.CONF_FILE);}
|
|
|
137 |
while (!feof($file_conf)) {
|
|
|
138 |
$buffer = fgets($file_conf, 4096);
|
|
|
139 |
if ((strpos($buffer, '=') !== false) && (substr($buffer, 0, 1) !== '#')) {
|
|
|
140 |
$tmp = explode('=', $buffer, 2);
|
|
|
141 |
$conf[trim($tmp[0])] = trim($tmp[1]);
|
|
|
142 |
}
|
| 2815 |
rexy |
143 |
}
|
| 3031 |
rexy |
144 |
fclose($file_conf);
|
| 2815 |
rexy |
145 |
// Get current version
|
|
|
146 |
$INSTALLEDVERSION = $conf['VERSION'];
|
| 2887 |
rexy |
147 |
setlocale (LC_TIME, $locale_time);
|
| 3252 |
rexy |
148 |
$date = new DateTime();
|
|
|
149 |
$date_formatter = new IntlDateFormatter(
|
|
|
150 |
$Langue[0],
|
|
|
151 |
IntlDateFormatter::FULL,
|
|
|
152 |
IntlDateFormatter::FULL,
|
|
|
153 |
date_default_timezone_get(),
|
|
|
154 |
IntlDateFormatter::GREGORIAN
|
|
|
155 |
);
|
| 2815 |
rexy |
156 |
$nb_users = request ('user');
|
|
|
157 |
$nb_groups = request ('group');
|
|
|
158 |
$nb_online_users = exec ("sudo /usr/sbin/chilli_query list | cut -d\" \" -f5 | grep \"1\" | wc -l");
|
| 3031 |
rexy |
159 |
|
|
|
160 |
// LAN Status (Is connected and has IP)
|
|
|
161 |
$tmp = file_get_contents("/sys/class/net/".$conf['EXTIF']."/operstate");
|
|
|
162 |
if(strcmp($tmp,"up")==1){
|
| 3033 |
rexy |
163 |
$lan_status = $l_lan." "." <img src='/images/state_ok.gif'> ";
|
| 3031 |
rexy |
164 |
} else{
|
| 3033 |
rexy |
165 |
$lan_status = $l_lan." "." <img src='/images/state_error.gif'> ";
|
| 3031 |
rexy |
166 |
}
|
|
|
167 |
|
| 3132 |
rexy |
168 |
// Router(s) status
|
| 3031 |
rexy |
169 |
$mask = strrchr($conf['PUBLIC_IP'],"/");
|
| 3132 |
rexy |
170 |
if(routerTest($conf['GW'],$conf['EXTIF']) && ($conf['GW'].$mask != $conf['PUBLIC_IP'])){ //test only if ALCASAR is not directly connected to Internet
|
| 3033 |
rexy |
171 |
$router_status = $l_router." "." <img src='/images/state_ok.gif'> ";
|
| 3031 |
rexy |
172 |
} else{
|
| 3033 |
rexy |
173 |
$router_status = $l_router." "." <img src='/images/state_error.gif'> ";
|
| 3031 |
rexy |
174 |
}
|
| 3132 |
rexy |
175 |
if($conf['MULTIWAN'] == 'on'){
|
|
|
176 |
exec("grep \"^WAN\" " . CONF_FILE . " | wc -l", $nb_gw);
|
|
|
177 |
for ($i = 1; $i <= $nb_gw[0]; $i++){
|
|
|
178 |
$gw="WAN".$i; $tmp=explode(',', $conf[$gw], 2);
|
|
|
179 |
$gw_ip=trim(str_replace('"', '', $tmp[0]));
|
|
|
180 |
$nro_router = $i + 1;
|
|
|
181 |
if(routerTest($gw_ip,$conf['EXTIF'])){
|
|
|
182 |
$router_status = $router_status." $l_router"."$nro_router"." <img src='/images/state_ok.gif'> ";
|
|
|
183 |
} else{
|
|
|
184 |
$router_status = $router_status." $l_router"."$nro_router"." <img src='/images/state_error.gif'> ";
|
|
|
185 |
}
|
|
|
186 |
}
|
|
|
187 |
}
|
| 3031 |
rexy |
188 |
// Internet status
|
| 3127 |
rexy |
189 |
if ((searchString("/var/www/html/index.php","/network_pb = false/")) && (internetTest())) {
|
| 3033 |
rexy |
190 |
$internet_status = $l_DNS." "." <img src='/images/state_ok.gif'> ";
|
| 2815 |
rexy |
191 |
$version = dns_get_record("version.alcasar.net",DNS_TXT);
|
| 2853 |
rexy |
192 |
if (!empty($version)) {
|
|
|
193 |
$AVAILABLEDVERSION = $version[0]['txt'];
|
|
|
194 |
} else {
|
|
|
195 |
$AVAILABLEDVERSION = "-";
|
|
|
196 |
}
|
| 2815 |
rexy |
197 |
} else {
|
| 3033 |
rexy |
198 |
$internet_status = $l_DNS." "." <img src='/images/state_error.gif'> ";
|
| 2815 |
rexy |
199 |
$AVAILABLEDVERSION = "-";
|
|
|
200 |
}
|
| 3031 |
rexy |
201 |
|
| 3033 |
rexy |
202 |
echo $l_internet_link." : ".$lan_status.$router_status.$internet_status."<br>\n";
|
|
|
203 |
echo $l_version." : ".$INSTALLEDVERSION."<br>\n";
|
|
|
204 |
echo $l_available." : ".$AVAILABLEDVERSION."<br>\n";
|
| 2815 |
rexy |
205 |
echo "</div><div class=\"panel-cell\">";
|
| 3033 |
rexy |
206 |
echo $l_users." : ".$nb_users." / ".$nb_online_users."<br>\n";
|
|
|
207 |
echo $l_groups." : ".$nb_groups."<br>\n";
|
| 3252 |
rexy |
208 |
echo $l_system_date." : ".$date_formatter->format($date)."<br>\n";
|
| 2815 |
rexy |
209 |
?>
|
|
|
210 |
</div>
|
|
|
211 |
</div>
|
| 2823 |
rexy |
212 |
</div>
|
|
|
213 |
<div class="panel">
|
|
|
214 |
<iframe class="panel-iframe" src="phpsysinfo/">
|
|
|
215 |
</iframe>
|
|
|
216 |
</div>
|
|
|
217 |
</body>
|
| 2815 |
rexy |
218 |
</html>
|