반응형
SMALL
get system sql
diagnose sql status
diagnose sql show db-size
diagnose log device
diagnose sql process list
diagnose dvm device list
diagose fortilogd msgrate-device
diagose fortilogd lograte
get system performance
get system status

 

execute log device logstore list

 

 

반응형
LIST
저작자표시 비영리 변경금지

'업무이야기 > Security' 카테고리의 다른 글

Palo Alto Firewall Appliance PA-VM - Useful Commands  (0) 2018.05.08
FortiGate FGSP  (0) 2018.05.08
fortigate File reached uncompressed size limit  (0) 2018.05.08
FortiGate 점검 CLI  (0) 2018.05.08
How-to: Automate FortiGate configuration backups  (0) 2018.05.08
반응형
SMALL

Technical Note: FortiAnalyzer SQL database delete and rebuildProducts

FortiAnalyzer v5.0
 
FortiAnalyzer v5.2
 

Description

Occasionally an upgrade does not correctly update the SQL database and reporting will cease to function properly due to missing/misnamed columns and/or indexes.
 
“exec sql-local rebuild-db” is the first option, but if that does not resolve the issue then deleting and rebuilding of the database is the next step.

Solution

 

Remove and re-create the SQL db:
 
1) Change operation mode to collector
 
config system global
set log-mode collector
end
 
2) Disable SQL and remove the current database
 
config system sql
set status disable
end
 
execute sql-local remove-db
 
3) Re-enable SQL
 
config system sql
set status local
end
 
4) Change operation mode back to analyser
 
config system global
set log-mode analyzer
end
 
5) Rebuild database
 
exec sql-local rebuild-db
 
 
 
Notes:
 
(1) The rebuild-db command causes the unit to reboot and the rebuild starts when the unit comes back up.
 
(2) Use the command 'diag sql status rebuild-db' to show the status of the rebuild.
 
(3) The time required to rebuild the database depends on the amount of logs stored on the unit.
 
(4) Although this procedure does not remove any log files it is recommended to backup log files beforehand as a precaution.

 

반응형
LIST
저작자표시 비영리 변경금지

'업무이야기 > Security' 카테고리의 다른 글

Fortigate Custom Application Control  (0) 2018.05.08
Fortigate SSLVPN Host Check  (0) 2018.05.08
Fortigate IP Macbindging  (0) 2018.05.08
Fortinet Open Ports Diagram  (0) 2018.05.08
FortiSandbox diagram  (0) 2018.05.08
반응형
SMALL

get system sql
diagnose sql status
diagnose sql show db-size
diagnose log device
diagnose sql process list
diagnose dvm device list
diagose fortilogd msgrate-device
diagose fortilogd lograte
get system performance
get system status
execute log device logstore list

 

 

반응형
LIST
저작자표시 비영리 변경금지

'업무이야기 > Security' 카테고리의 다른 글

FortiGate diagnose CLI  (0) 2015.12.28
FortiGate FGSP  (0) 2015.12.28
fortigate File reached uncompressed size limit  (0) 2015.12.28
FortiGate 점점 CLI  (2) 2015.12.28
Fortigate Auto backup configuration  (0) 2015.12.28

+ Recent posts

티스토리툴바