Fortianalyzer not showing logs in Fortiview

sguru · ‎01-11-2017

Hi All,

Good day...!

We have 2 fortigates which are configured to send all the logs to the FortiAnalyzer. The point is that we dont see any logs in "fortiview and log view", but the device is receiving logs. Its stuck like loading the information

Recently we upgraded Fortianalyzer-1000D from version 5.0 to 5.2.5. After upgrading, logs are not showing in Fortiview even rebuild the SQL database.

Already I tried to format the FA and install the firmware 5.2.5 directly, followed the standard way to rebuild the SQL database on multiple times but no luck. Then I restore the backup logs existing firewall logs. There is no much logs in storage even I given enough time to rebuild like a week.

If anyone knows the solution to resolve this issue? expecting your reply

Fortianalyzer 1000D Info:

--------------------

Current version : v5.2.5-build3175 160119 (GA)

Error message in fortiview: "No entry found"

Error message in log view: "No record found"

Log browse: I can see all the logs which is receiving from firewall

sqllogd services utilizing 100% cpu, all other services normal ( exec top)

Log volume in 7 days: 219.64 MB/day

FortiGate 300D Info:

Current Version: v5.2.5,build701 (GA)

Log setting configured to send the log to Fortianalyzer and local HDD

Thanks

Sivaguru D

awasfi_FTNT · ‎01-15-2017

Hello,

There are some known issues on FortiAnalyzer v5.2.5 related to FortiView which have been fixed on v5.2.6 and later.

I think the best if to upgrade to latest v5.2 version v5.2.10.

Regards

sguru · ‎01-22-2017

Hi,

Thanks for your inputs, I have updated latest version 5.2.10, which is not help me to resolve this issue. Still problem is continuing.

I can't able to see the logs in fortiview => summary view , Log view. If am change the settings in Tools->Real time logs-> am able to see the logs in Log view. This is applicable for all options under Log view.

Already I formatted the FA completely and then restore the images 5.2.5 directly, deleted the sql DB and recreate it, now upgraded to 5.2.10, still my issues not resolved.

I had restore the backup logs of existing 310B firewall also, Is this cause this kind of issue?

Is there any other setting need to be enabled..?

If anyone have idea, please share with me.

Regards, Sguru

awasfi_FTNT · ‎01-23-2017

Hi,

So you are saying real time logs can be seen but historical logs.

>> When you go to log view >> log browse you should see logs files. Can you display the content logs? Select one file and click on display...

>> Did you try different browsers?

>> Did you rebuild the database after restoring the logs or before?

>> Can you enable Administrative Domain and check the ADOM version that the FortiGate belongs to under "System Settings All ADOMs". For example if the root ADOM which the FortiGate added to is on v5.0 then you should create a new v5.2 ADOM and add the FortiGate to it then rebuild the database.

>> Is it possible to capture the output of:

get system status

execute top <<-- use "q" to stop it

get system performance

diagnose dvm device list

diag sql show db-size

diag sql status rebuild-db diag sql status sqlplugind

diag debug crashlog read

Regards,

sguru · ‎01-23-2017

Hi,

Yes, am able to see the logs in log view >> log browse you should see logs files

I tried different browsers but no luck

I tried to rebuild the DB after restoring the logs. (fortiview not showing the logs, then initiate the rebuild db)

Today I upgraded latest 5.2.10 and now initiated the rebuild DB

The below logs are captured during the DB rebuilding activity is going on.

=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2017.01.23 13:07:16 =~=~=~=~=~=~=~=~=~=~=~= login as: admin Using keyboard-interactive authentication. Password: FAZ1000D # get system statusPlatform Type : FAZ1000D Platform Full Name : FortiAnalyzer-1000D Version : v5.2.10-build0786 170112 (GA) Serial Number : FL-1KD3A14123455 BIOS version : 00010003 System Part-Number : P13276-01 Hostname : FAZ1000D Max Number of Admin Domains : 2000 Admin Domain Configuration : Disabled FIPS Mode : Disabled Branch Point : 0786 Release Version Information : GA Current Time : Mon Jan 23 13:07:37 GST 2017 Daylight Time Saving : Yes Time Zone : (GMT+4:00) Abu Dhabi, Muscat. x86-64 Applications : Yes Disk Usage : Free 5371.31GB, Total 5499.82GB File System : Ext4

FAZ1000D # exec top[H[J[mtop_bin - 13:07:51 up 1:49, 0 users, load average: 1.52, 1.67, 1.71[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 21.4%[mus,[m[m 4.7%[msy,[m[m 0.0%[mni,[m[m 73.6%[mid,[m[m 0.3%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617080k [mused,[m[m 10799264k [mfree,[m[m 32092k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632180k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 97 0.3 110:12.81 sqllogd [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.44 kworker/0:1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m [m 17 root 0 -20 0 0 0 S 0 0.0 0:00.00 khelper [m[6;1H[K[H[mtop_bin - 13:07:54 up 1:49, 0 users, load average: 1.56, 1.67, 1.71[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 22.1%[mus,[m[m 4.7%[msy,[m[m 0.0%[mni,[m[m 73.2%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617708k [mused,[m[m 10798636k [mfree,[m[m 32104k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632192k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:15.82 sqllogd [m [m 636 root -13 0 360m 285m 19m S 0 1.8 0:02.92 fortilogd.main [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.44 kworker/0:1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m[6;1H[K[H[mtop_bin - 13:07:57 up 1:49, 0 users, load average: 1.51, 1.66, 1.71[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 20.1%[mus,[m[m 4.9%[msy,[m[m 0.0%[mni,[m[m 75.0%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617708k [mused,[m[m 10798636k [mfree,[m[m 32104k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632200k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:18.82 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.45 kworker/0:1 [m [m 496 root 20 0 163m 11m 4544 S 0 0.1 0:03.10 dmserver [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m

[6;1H[K[H[mtop_bin - 13:08:00 up 1:49, 0 users, load average: 1.51, 1.66, 1.71[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 22.6%[mus,[m[m 4.3%[msy,[m[m 0.0%[mni,[m[m 73.1%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617708k [mused,[m[m 10798636k [mfree,[m[m 32116k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632220k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:21.83 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.46 kworker/0:1 [m [m 2893 root 20 0 165m 9088 2756 S 0 0.1 0:00.68 httpd [m [m[m 7072 root 20 0 9536 1104 736 R 0 0.0 0:00.01 top_bin [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m[6;1H[K[H[mtop_bin - 13:08:03 up 1:49, 0 users, load average: 1.47, 1.65, 1.70[m[K Tasks:[m[m 152 [mtotal,[m[m 2 [mrunning,[m[m 150 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 21.7%[mus,[m[m 4.2%[msy,[m[m 0.0%[mni,[m[m 74.1%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617732k [mused,[m[m 10798612k [mfree,[m[m 32124k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632232k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:24.84 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.47 kworker/0:1 [m [m 763 postgres 20 0 3344m 40m 33m S 0 0.3 0:00.14 postgres [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m[6;1H[K[H[mtop_bin - 13:08:06 up 1:49, 0 users, load average: 1.47, 1.65, 1.70[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 20.4%[mus,[m[m 5.5%[msy,[m[m 0.0%[mni,[m[m 74.1%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5618204k [mused,[m[m 10798140k [mfree,[m[m 32124k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632248k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:27.84 sqllogd [m [m 496 root 20 0 163m 11m 4544 S 0 0.1 0:03.11 dmserver [m [m 594 root 20 0 189m 6644 3916 S 0 0.0 0:00.20 fctlinkd [m

[m 10 root 20 0 0 0 0 S 0 0.0 0:16.47 kworker/0:1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m[6;1H[K[H[mtop_bin - 13:08:09 up 1:49, 0 users, load average: 1.51, 1.66, 1.71[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 21.2%[mus,[m[m 4.7%[msy,[m[m 0.0%[mni,[m[m 74.1%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5618204k [mused,[m[m 10798140k [mfree,[m[m 32136k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632260k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:30.85 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.48 kworker/0:1 [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m [m 17 root 0 -20 0 0 0 S 0 0.0 0:00.00 khelper [m[6;1H[K[H[mtop_bin - 13:08:12 up 1:50, 0 users, load average: 1.47, 1.65, 1.70[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 21.0%[mus,[m[m 5.1%[msy,[m[m 0.0%[mni,[m[m 73.9%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.1%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5617956k [mused,[m[m 10798388k [mfree,[m[m 32136k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632272k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:33.85 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.49 kworker/0:1 [m [m[m 7072 root 20 0 9536 1104 736 R 0 0.0 0:00.02 top_bin [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m[6;1H[K[H[mtop_bin - 13:08:15 up 1:50, 0 users, load average: 1.47, 1.65, 1.70[m[K Tasks:[m[m 152 [mtotal,[m[m 1 [mrunning,[m[m 151 [msleeping,[m[m 0 [mstopped,[m[m 0 [mzombie[m[K Cpu(s):[m[m 21.7%[mus,[m[m 4.2%[msy,[m[m 0.0%[mni,[m[m 74.1%[mid,[m[m 0.0%[mwa,[m[m 0.0%[mhi,[m[m 0.0%[msi,[m[m 0.0%[mst[m[K Mem: [m[m 16416344k [mtotal,[m[m 5618080k [mused,[m[m 10798264k [mfree,[m[m 32144k [mbuffers[m[K Swap:[m[m 2076536k [mtotal,[m[m 0k [mused,[m[m 2076536k [mfree,[m[m 4632296k [mcached[m[K [6;1H [7m PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND [m[K [m 641 root 20 0 247m 52m 7372 S 100 0.3 110:36.86 sqllogd [m [m 10 root 20 0 0 0 0 S 0 0.0 0:16.50 kworker/0:1 [m [m 1 root 20 0 154m 11m 6164 S 0 0.1 0:04.81 initXXXXXXXXXXX [m [m 2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd [m [m 3 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0 [m [m 4 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/0:0 [m [m 6 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/0 [m [m 7 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/1 [m [m 8 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/1:0 [m [m 9 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 [m [m 11 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/2 [m [m 12 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/2:0 [m [m 13 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2 [m [m 14 root RT 0 0 0 0 S 0 0.0 0:00.00 migration/3 [m [m 15 root 20 0 0 0 0 S 0 0.0 0:00.00 kworker/3:0 [m [m 16 root 20 0 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 [m [m 17 root 0 -20 0 0 0 S 0 0.0 0:00.00 khelper [m[6;1H[K[25;1H

FAZ1000D # get system perfao[K[Kormatn[K[KnceCPU: Used: 25.98% Used(Excluded NICE): 25.98% %used %user %nice %sys %idle %iowait %irq %softirq CPU0 1.60 1.54 0.00 0.07 98.40 0.00 0.00 0.00 CPU1 0.13 0.07 0.00 0.07 99.87 0.00 0.00 0.00 CPU2 2.07 1.94 0.00 0.13 97.93 0.00 0.00 0.00 CPU3 100.00 81.68 0.00 18.32 0.00 0.00 0.00 0.00 Memory: Total: 18,492,880 KB Used: 984,340 KB 5.3% Hard Disk: Total: 5,766,984,312 KB Used: 134,758,460 KB 2.3% IOStat: tps r_tps w_tps r_kB/s w_kB/s queue wait_ms svc_ms %util sampling_sec 6.9 3.9 2.9 642.0 84.8 0.0 2.8 1.9 1.3 6616.70 Flash Disk: Total: 253,871 KB Used: 63,865 KB 25.2% IOStat: tps r_tps w_tps r_kB/s w_kB/s queue wait_ms svc_ms %util sampling_sec 0.0 0.0 0.0 0.0 0.0 0.0 22.7 8.1 0.0 6616.74

FAZ1000D # dis[Kag dvmdevi[K[K[K[K device listThere are currently 4 devices/vdoms managed:

TYPE OID SN HA IP NAME ADOM IPS FIRMWARE faz enabled 134 FG300B3908605870 - 172.16.25.3 FG300B3908605870 root N/A 5.0 MR0 (1) |- STATUS: db: unknown; conf: unknown; cond: unknown; dm: none; conn: unknown |- vdom:[3]root flags:0 adom:root pkg:[never-installed] faz enabled 120 FG300B3908605955 - 172.16.25.3 root N/A 5.0 MR0 (1) |- STATUS: db: unknown; conf: unknown; cond: unknown; dm: none; conn: unknown |- vdom:[3]root flags:0 adom:root pkg:[never-installed] faz enabled 189 FGT3HD3916801477 - 172.16.25.3 XXXHA-PRIMARY root N/A 5.0 MR2 (701) |- STATUS: db: unknown; conf: unknown; cond: unknown; dm: none; conn: unknown |- vdom:[3]root flags:0 adom:root pkg:[never-installed] faz enabled 204 FGT3HD3916800928 - 172.16.25.3 XXXHA-SECONDARY root N/A 5.0 MR2 (701) |- STATUS: db: unknown; conf: unknown; cond: unknown; dm: none; conn: unknown |- vdom:[3]root flags:0 adom:root pkg:[never-installed]

---End device list---

FAZ1000D # diag sql show db-su[KizeSize: 10.69 MB

FAZ1000D # diag swl[K[Kql status rebuild-db Rebuilding log SQL database has been processed 0%

FAZ1000D # diag sql status rebuild-db[K[K[K[K[K[K[K[K[K[Ksqlplugind PID: 643, now: 1485162577, uptime: 6663 Thread registered: 2 Log insert speed: logs/5sec: 0.0, logs/60sec: 0.0 Overall: 0.0 (0) Log received: logs=0 bat=0 avg-bat-sz=0 ack=0 ack-drop=0 ack-err=0 bat-recv=0 misc-recv=0 writers=1 indexers=1 tri-force=0 logtab: new-dbtbl=0 orphan=0 zombie=0 master-tbl:new=0/free=0 child-tbl:new=0/free=0 logtab: master-tbl create_err=0, child-tbl create-err=0 tr-err=0, new-retry=0 commit-locate-err: adom=0 master-tbl=0(oldtm=0) child-tbl=0 trim: req=1 drop-tbl=0 total-sz=0(MB) chkdisk=222 diskfull=0 mdevtree=0 abort=0 toohuge=0 trim-alerts: trim=0 total=0, flush=0 total=0

sqldata: batch=0 insert=0 update=0 alert=0 al-log=0 al-flush=0 dup_batch=0 invalid_sql=0 tasklist-tri: add=0 renew=0 run=0 save=0 tasklist-reg: add=0 renew=0 run=0 save=0 index-task: add=0 renew=0 drop=0 done=0 task-stats: new=0 free=0

recv-conn: accept=1 close=0 close-conn: idle=20 threshold=0 all_threshold=0

FAZ1000D # diag debut[Kg crashlog read FAZ1000D # FAZ1000D # diag debug crashlog read FAZ1000D # endUnknown action 0

FAZ1000D # exit

Thanks

Regards, Sguru

awasfi_FTNT · ‎01-23-2017

Hi,

Wait till rebuild finish. Use following command to confirm:

# diag sql status rebuild-db

Then enable Administrative Domain and check the ADOM version that the FortiGate belongs to under "System Settings All ADOMs". If FortiGate running v5.2 and added to v5.0 ADOM then you need to create a new v5.2 ADOM and move v5.2 devices to it.

Regards,

sguru · ‎01-24-2017

Hi,

Still sql database rebuilding is not completed, am waiting more than one day.

Before we are not enable the ADOM while we add the existing and new firewall.

Please explain how enabling the ADOM will resolve this logging issue.

Regards, Sguru

awasfi_FTNT · ‎01-24-2017

Hi,

We need to check the firmware version of "root" ADOM which all devices added to it.

If the ADOM firmware version for example on v5.0 and the device running firmware v5.2 it will cause incompatibility issues as the database is different.

Even if still the issue not fixed, adding the devices to correct ADOM version will ensure database compatibility and avoid any issues in the future.

If I'm not wrong I can see the device is running v5.2 and "root" ADOM version is v5.0 per the output of "diag dvm device list"

Also you can use command "diag dvm adom list" to confirm the firmware of "root" ADOM.

Regards,

sguru · ‎01-24-2017

Hi,

Thanks for your valuable info, Please clarify below things

1. ADOM creation will affect the existing log stored in FA?

2. Can I add the old 310B logs to new ADOM ?

3. Is new ADOM will support all firewalls (OS version either 5.2 or 5.4)

4. Is it affect the customized setting in FortiAnalyzer?

Regards, Sguru

awasfi_FTNT · ‎01-24-2017

Hello,

1. ADOM creation will affect the existing log stored in FA?

No

2. Can I add the old 310B logs to new ADOM ?

Yes from CLI:

http://kb.fortinet.com/kb/microsites/search.do?cmd=displayKC&docType=kc&externalId=FD36255&sliceId=1... 0 21714326

3. Is new ADOM will support all firewalls (OS version either 5.2 or 5.4)

Yes, since FortiAnalyzer running v5.4, so what you need to do is creating separate ADOM for each firmware. Example v5.2ADOM for any device running v5.2.x firmware and v5.4 ADOM for any device running v5.4.x firmware.

4. Is it affect the customized setting in FortiAnalyzer?

May affect settings so I recommend to export custom reports/charts and copy any custom datasets that you have then you can add them later if lost.

Also backup the previously created reports if needed.

To export/import reports/charts right click then export/import

Regards

Fortianalyzer not showing logs in Fortiview

Nominate a Forum Post for Knowledge Article Creation