You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Malio/app/Command/SyncRadius.php

225 lines
7.5 KiB
PHP

<?php
namespace App\Command;
use App\Models\User;
use App\Models\Node;
use App\Models\RadiusRadPostauth;
use App\Models\RadiusRadAcct;
use App\Models\RadiusNas;
use App\Services\Config;
use App\Services\Mail;
use App\Models\TrafficLog;
use App\Utils\Tools;
use App\Utils\Radius;
use App\Utils\Da;
use Exception;
class SyncRadius
{
public static function synclogin()
{
if (Config::get('enable_radius') == 'false') {
return;
}
$tempuserbox = array();
$users = User::all();
foreach ($users as $user) {
$email = $user->email;
$email = Radius::GetUserName($email);
$tempuserbox[$email] = $user->id;
}
/*$tempnodebox=array();
$nodes = Node::all();
foreach($nodes as $node){
if(strpos($node->name,"Shadowsocks")!=FALSE)
{
$ip=gethostbyname($node->server);
$tempnodebox[$ip]=$node->id;
}
}*/
$logs = RadiusRadPostauth::where('authdate', '<', date('Y-m-d H:i:s'))->where('authdate', '>', date('Y-m-d H:i:s', time() - 60))->get();
foreach ($logs as $log) {
if (isset($tempuserbox[$log->username])) {
$traffic = new TrafficLog();
$traffic->user_id = $tempuserbox[$log->username];
$traffic->u = 0;
$traffic->d = 10000;
$traffic->node_id = 1;
$traffic->rate = 1;
$traffic->traffic = Tools::flowAutoShow(10000);
$traffic->log_time = time();
$traffic->save();
$user = User::find($tempuserbox[$log->username]);
$user->t = time();
$user->u += 0;
$user->d += 10000;
$user->save();
}
}
/*$stmt = $db->query("SELECT * FROM `radacct` WHERE `acctstoptime`<'".date("Y-m-d H:i:s")."' AND `acctstoptime`>'".date("Y-m-d H:i:s",time()-60)."'");
$result = $stmt->fetchAll();
foreach($result as $row)
{
$traffic = new TrafficLog();
$traffic->user_id = $tempuserbox[$row["username"]];
$traffic->u = $row["acctinputoctets"];
$traffic->d = $row["acctoutputoctets"];
$traffic->node_id = 150;
$traffic->rate = 1;
$traffic->traffic = Tools::flowAutoShow(($row["acctinputoctets"]+$row["acctoutputoctets"])/1024/1024);
$traffic->log_time = time();
$traffic->save();
$user->t = time();
$user->u = $user->u + $row["acctinputoctets"];
$user->d = $user->d + $row["acctoutputoctets"];
$user->save();
} */
}
public static function syncvpn()
{
if (Config::get('radius_db_host') == '') {
return;
}
$tempuserbox = array();
$users = User::all();
foreach ($users as $user) {
$email = $user->email;
$email = Radius::GetUserName($email);
$tempuserbox[$email] = $user->id;
}
/*$tempnodebox=array();
$nodes = Node::all();
foreach($nodes as $node){
if(strpos($node->name,"Shadowsocks")!=FALSE)
{
$ip=gethostbyname($node->server);
$tempnodebox[$ip]=$node->id;
}
}*/
/*$stmt = $db->query("SELECT * FROM `radpostauth` WHERE `authdate`<'".date("Y-m-d H:i:s")."' AND`authdate`>'".date("Y-m-d H:i:s",time()-60)."'");
$result = $stmt->fetchAll();
foreach($result as $row)
{
//if($row["pass"]!="")
{
$traffic = new TrafficLog();
$traffic->user_id = $tempuserbox[$row["username"]];
$traffic->u = 0;
$traffic->d = 10000;
$traffic->node_id = 149;
$traffic->rate = 1;
$traffic->traffic = Tools::flowAutoShow(10000);
$traffic->log_time = time();
$traffic->save();
$user->t = time();
$user->u = $user->u + 0;
$user->d = $user->d + 10000;
$user->save();
}
}
*/
$logs = RadiusRadAcct::where('acctstoptime', '<', date('Y-m-d H:i:s'))->where('acctstoptime', '>', date('Y-m-d H:i:s', time() - 60))->get();
foreach ($logs as $log) {
$traffic = new TrafficLog();
$traffic->user_id = $tempuserbox[$log->username];
$traffic->u = $log->acctinputoctets;
$traffic->d = $log->acctoutputoctets;
$traffic->node_id = 2;
$traffic->rate = 1;
$traffic->traffic = Tools::flowAutoShow($log->acctinputoctets + $log->acctoutputoctets);
$traffic->log_time = time();
$traffic->save();
$user = User::find($tempuserbox[$log->username]);
$user->t = time();
$user->u += $log->acctinputoctets;
$user->d += $log->acctoutputoctets;
$user->save();
}
}
public static function syncusers()
{
$users = User::all();
foreach ($users as $user) {
Radius::Add($user, $user->passwd);
echo 'Send sync mail to user: ' . $user->id;
$subject = Config::get('appName') . '-密码更新通知';
$to = $user->email;
$text = '您好,为了保证密码系统的统一,刚刚系统已经将您 vpn 等连接方式的用户名已经重置为:' . Radius::GetUserName($user->email) . ',密码自动重置为您 ss 的密码:' . $user->passwd . ' 了,以后您修改 ss 密码就会自动修改 vpn 等连接方式的密码了,感谢您的支持。 ';
try {
Mail::send($to, $subject, 'password/vpn.tpl', [
'user' => $user, 'text' => $text
], [
]);
} catch (Exception $e) {
echo $e->getMessage();
}
}
}
public static function syncnas()
{
if (Config::get('radius_db_host') != '') {
$md5txt = '';
$nases = RadiusNas::all();
foreach ($nases as $nas) {
//if($row["pass"]!="")
{
$md5txt = $md5txt . $nas->id . $nas->nasname . $nas->shortname . $nas->secret . $nas->description;
}
}
$md5 = MD5($md5txt);
$oldmd5 = file_get_contents(BASE_PATH . '/storage/nas.md5');
if ($oldmd5 != $md5) {
//Restart radius
$myfile = fopen(BASE_PATH . '/storage/nas.md5', 'wb+') or die('Unable to open file!');
echo('Restarting...');
system('/bin/bash /sbin/service radiusd restart', $retval);
echo($retval);
$txt = $md5;
fwrite($myfile, $txt);
fclose($myfile);
}
}
$Nodes = Node::where('sort', 0)->where('node_ip', '<>', '')->where('node_ip', '<>', 'NULL')->get();
foreach ($Nodes as $Node) {
if (file_exists('/usr/local/psionic/portsentry/portsentry.ignore')) {
$content = file_get_contents('/usr/local/psionic/portsentry/portsentry.ignore');
if (strpos($content, $Node->node_ip) === false) {
file_put_contents('/usr/local/psionic/portsentry/portsentry.ignore', "\n" . $Node->node_ip . '/32', FILE_APPEND);
}
}
}
}
}