@@ -79,22 +79,22 @@ |
||
| 79 | 79 | return $res; |
| 80 | 80 | } |
| 81 | 81 | |
| 82 | - public static function getDbConnection(){ |
|
| 83 | - if(!file_exists(Fail2BanConf::FAIL2BAN_DB_PATH)){ |
|
| 84 | - return null; |
|
| 85 | - } |
|
| 86 | - try { |
|
| 87 | - $db = new SQLite3(Fail2BanConf::FAIL2BAN_DB_PATH); |
|
| 88 | - }catch (\Exception $e){ |
|
| 89 | - return null; |
|
| 90 | - } |
|
| 91 | - $db->busyTimeout(5000); |
|
| 92 | - $fail2ban = new Fail2BanConf(); |
|
| 93 | - if (false === $fail2ban->tableBanExists($db)) { |
|
| 94 | - return null; |
|
| 95 | - } |
|
| 82 | + public static function getDbConnection(){ |
|
| 83 | + if(!file_exists(Fail2BanConf::FAIL2BAN_DB_PATH)){ |
|
| 84 | + return null; |
|
| 85 | + } |
|
| 86 | + try { |
|
| 87 | + $db = new SQLite3(Fail2BanConf::FAIL2BAN_DB_PATH); |
|
| 88 | + }catch (\Exception $e){ |
|
| 89 | + return null; |
|
| 90 | + } |
|
| 91 | + $db->busyTimeout(5000); |
|
| 92 | + $fail2ban = new Fail2BanConf(); |
|
| 93 | + if (false === $fail2ban->tableBanExists($db)) { |
|
| 94 | + return null; |
|
| 95 | + } |
|
| 96 | 96 | |
| 97 | - return $db; |
|
| 97 | + return $db; |
|
| 98 | 98 | } |
| 99 | 99 | |
| 100 | 100 | /** |
@@ -28,18 +28,18 @@ discard block |
||
| 28 | 28 | */ |
| 29 | 29 | public static function fail2banUnbanAll(string $ip): PBXApiResult |
| 30 | 30 | { |
| 31 | - $ip = trim($ip); |
|
| 31 | + $ip = trim($ip); |
|
| 32 | 32 | $res = new PBXApiResult(); |
| 33 | 33 | $res->processor = __METHOD__; |
| 34 | 34 | $res->success = true; |
| 35 | - if ( ! Verify::isIpAddress($ip)) { |
|
| 35 | + if (!Verify::isIpAddress($ip)) { |
|
| 36 | 36 | $res->success = false; |
| 37 | - $res->messages[]="Not valid ip '{$ip}'."; |
|
| 37 | + $res->messages[] = "Not valid ip '{$ip}'."; |
|
| 38 | 38 | } |
| 39 | - $fail2ban = new Fail2BanConf(); |
|
| 39 | + $fail2ban = new Fail2BanConf(); |
|
| 40 | 40 | if ($fail2ban->fail2ban_enable) { |
| 41 | 41 | $fail2ban = Util::which('fail2ban-client'); |
| 42 | - $res->success = (Util::mwExec("{$fail2ban} unban {$ip}") === 0); |
|
| 42 | + $res->success = (Util::mwExec("{$fail2ban} unban {$ip}") === 0); |
|
| 43 | 43 | } else { |
| 44 | 44 | $res = self::fail2banUnbanDb($ip); |
| 45 | 45 | } |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | $res->processor = __METHOD__; |
| 61 | 61 | |
| 62 | 62 | $db = self::getDbConnection(); |
| 63 | - if(!$db){ |
|
| 63 | + if (!$db) { |
|
| 64 | 64 | // Таблица не существует. Бана нет. |
| 65 | 65 | $res->success = false; |
| 66 | 66 | $res->messages[] = 'DB '.Fail2BanConf::FAIL2BAN_DB_PATH.' not found'; |
@@ -79,13 +79,13 @@ discard block |
||
| 79 | 79 | return $res; |
| 80 | 80 | } |
| 81 | 81 | |
| 82 | - public static function getDbConnection(){ |
|
| 83 | - if(!file_exists(Fail2BanConf::FAIL2BAN_DB_PATH)){ |
|
| 82 | + public static function getDbConnection() { |
|
| 83 | + if (!file_exists(Fail2BanConf::FAIL2BAN_DB_PATH)) { |
|
| 84 | 84 | return null; |
| 85 | 85 | } |
| 86 | 86 | try { |
| 87 | - $db = new SQLite3(Fail2BanConf::FAIL2BAN_DB_PATH); |
|
| 88 | - }catch (\Exception $e){ |
|
| 87 | + $db = new SQLite3(Fail2BanConf::FAIL2BAN_DB_PATH); |
|
| 88 | + } catch (\Exception $e) { |
|
| 89 | 89 | return null; |
| 90 | 90 | } |
| 91 | 91 | $db->busyTimeout(5000); |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | $ban_time = '43800'; |
| 111 | 111 | } |
| 112 | 112 | // Добавленн фильтр по времени бана. возвращаем только адреса, которые еще НЕ разбанены. |
| 113 | - $q = 'SELECT' . ' DISTINCT jail,ip,MAX(timeofban) AS timeofban, MAX(timeofban+' . $ban_time . ') AS timeunban FROM bans where (timeofban+' . $ban_time . ')>' . time(); |
|
| 113 | + $q = 'SELECT'.' DISTINCT jail,ip,MAX(timeofban) AS timeofban, MAX(timeofban+'.$ban_time.') AS timeunban FROM bans where (timeofban+'.$ban_time.')>'.time(); |
|
| 114 | 114 | if ($ip !== null) { |
| 115 | 115 | $q .= " AND ip='{$ip}'"; |
| 116 | 116 | } |
@@ -133,13 +133,13 @@ discard block |
||
| 133 | 133 | |
| 134 | 134 | $jail_q = ($jail === '') ? '' : "AND jail = '{$jail}'"; |
| 135 | 135 | $path_db = Fail2BanConf::FAIL2BAN_DB_PATH; |
| 136 | - if(!file_exists($path_db)){ |
|
| 136 | + if (!file_exists($path_db)) { |
|
| 137 | 137 | // Таблица не существует. Бана нет. |
| 138 | 138 | $res->success = false; |
| 139 | 139 | $res->messages[] = "DB {$path_db} not found"; |
| 140 | 140 | return $res; |
| 141 | 141 | } |
| 142 | - $db = new SQLite3($path_db); |
|
| 142 | + $db = new SQLite3($path_db); |
|
| 143 | 143 | $db->busyTimeout(3000); |
| 144 | 144 | $fail2ban = new Fail2BanConf(); |
| 145 | 145 | if (false === $fail2ban->tableBanExists($db)) { |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | $res->success = true; |
| 148 | 148 | return $res; |
| 149 | 149 | } |
| 150 | - $q = 'DELETE' . " FROM bans WHERE ip = '{$ip}' {$jail_q}"; |
|
| 150 | + $q = 'DELETE'." FROM bans WHERE ip = '{$ip}' {$jail_q}"; |
|
| 151 | 151 | $db->query($q); |
| 152 | 152 | |
| 153 | 153 | $err = $db->lastErrorMsg(); |
@@ -79,13 +79,14 @@ |
||
| 79 | 79 | return $res; |
| 80 | 80 | } |
| 81 | 81 | |
| 82 | - public static function getDbConnection(){ |
|
| 82 | + public static function getDbConnection() |
|
| 83 | + { |
|
| 83 | 84 | if(!file_exists(Fail2BanConf::FAIL2BAN_DB_PATH)){ |
| 84 | 85 | return null; |
| 85 | 86 | } |
| 86 | 87 | try { |
| 87 | 88 | $db = new SQLite3(Fail2BanConf::FAIL2BAN_DB_PATH); |
| 88 | - }catch (\Exception $e){ |
|
| 89 | + } catch (\Exception $e){ |
|
| 89 | 90 | return null; |
| 90 | 91 | } |
| 91 | 92 | $db->busyTimeout(5000); |
@@ -136,7 +136,7 @@ |
||
| 136 | 136 | if(!file_exists($path_db)){ |
| 137 | 137 | // Таблица не существует. Бана нет. |
| 138 | 138 | $res->success = false; |
| 139 | - $res->messages[] = "DB {$path_db} not found"; |
|
| 139 | + $res->messages[] = "db {$path_db} not found"; |
|
| 140 | 140 | return $res; |
| 141 | 141 | } |
| 142 | 142 | $db = new SQLite3($path_db); |