FAZ200D # diagnose debug enable FAZ200D # FAZ200D # diagnose debug application sqlplugind 8 FAZ200D # execute sql-report[1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select src, tbl_name, flags from ((select 1 as src, tbl_name, flags, (timestamp+86400) as adj_time from log_tablst where (flags & 1 = 0) and timestamp >= 1419448579 order by timestamp desc limit 1) union all (select 0 as src, tbl_name, flags, timestamp as adj_time from log_tablst order by timestamp desc limit 1)) t order by adj_time desc limit 1 [1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0005 seconds to process sql request. (from=0) [1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053379] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. r[1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select 0 as src, tbl_name, flags from vacuum_tablst order by timestamp desc limit 1 [1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0003 seconds to process sql request. (from=0) [1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053381] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. un root 10012 ADOM is disabled, use defalut ADOM root. layout_num:1 start [0] get layout-id:10012. start report_process, layout-id:10012, layout title:User Detailed Browsing Log. device list:All_FortiGates. reports num:1. device list[0].FG300B3913600568[root]. > running (S-10012_t10012-User Detailed Browsing Log-2014-12-31-1116) ... [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:1). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1363: subtype: 0 [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select ((case when itime_start >= 1419408000 and itime_end <= 1420012799 then 1 else 0 end) || '|' || tbl_name) as table_list from table_ref where (tbl_name like 'FGTADOM3-tlog-%') and (itime_end >= 1419408000 and itime_start <= 1420012799) order by itime_end desc [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0007 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. (b5ab9ba0) processing chart: Detailed Web Browsing Log... [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:1). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1363: subtype: 0 [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select ((case when itime_start >= 1419408000 and itime_end <= 1420012799 then 1 else 0 end) || '|' || tbl_name) as table_list from table_ref where (tbl_name like 'FGTADOM3-tlog-%') and (itime_end >= 1419408000 and itime_start <= 1420012799) order by itime_end desc [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0003 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '6' is accepted. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select * from (select dtime, catdesc, hostname, action, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from "FGT-tlog-test-050617" where itime >= 1419408000 and itime <= 1420012799 and (coalesce(nullifna("user"), ipstr(srcip)) IN ('10.0.100.73')) and hostname is not null and logid_to_int(logid) not in (4, 7, 14) and utmevent in ('webfilter', 'banned-word', 'web-content', 'command-block', 'script-filter') group by dtime, catdesc, hostname, action order by dtime desc) t limit 0 [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0011 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=0, ds_size=40, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:1). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1363: subtype: 0 [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select ((case when itime_start >= 1419408000 and itime_end <= 1420012799 then 1 else 0 end) || '|' || tbl_name) as table_list from table_ref where (tbl_name like 'FGTADOM3-wlog-%') and (itime_end >= 1419408000 and itime_start <= 1420012799) order by itime_end desc [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0003 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=0, ds_size=29, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select * from (select dtime, catdesc, hostname, action, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from "FGTADOM3-wlog-0" where itime >= 1419408000 and itime <= 1420012799 and (coalesce(nullifna("user"), ipstr(srcip)) IN ('10.0.100.73')) and hostname is not null and (eventtype is null or logver=52) group by dtime, catdesc, hostname, action order by dtime desc) t limit 0 [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0011 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=0, ds_size=40, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select "timestamp", "catdesc", "website", "status", "bandwidth" from (select from_dtime(dtime) as timestamp, catdesc, hostname as website, action as status, sum(bandwidth) as bandwidth from (((select dtime, catdesc, hostname, action, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from "FGT-tlog-test-050617" where itime >= 1419408000 and itime <= 1420012799 and (coalesce(nullifna("user"), ipstr(srcip)) IN ('10.0.100.73')) and hostname is not null and logid_to_int(logid) not in (4, 7, 14) and utmevent in ('webfilter', 'banned-word', 'web-content', 'command-block', 'script-filter') group by dtime, catdesc, hostname, action order by dtime desc)) union all ((select dtime, catdesc, hostname, action, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from "FGTADOM3-wlog-0" where itime >= 1419408000 and itime <= 1420012799 and (coalesce(nullifna("user"), ipstr(srcip)) IN ('10.0.100.73')) and hostname is not null and (eventtype is null or logver=52) group by dtime, catdesc, hostname, action order by dtime desc))) t group by dtime, catdesc, website, status order by dtime desc) t [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.1856 seconds to process sql request. (from=0) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053399] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. Detailed Web Browsing Log No data. (b5ab9ba0) Done, 0.192 sec used. report took: 1.006 secs > rendering (S-10012_t10012-User Detailed Browsing Log-2014-12-31-1116) (en) ... [1420053400] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. sql_rpt_render_dir : start 0302 HTML Report (dbgmsg off) ++ col 1 width 140.0000 whint 1 wratio 100.0000 ++ col 1 width 3.0600 whint 0 wratio 2.1857 ++ col 2 width 63.4373 whint 1 wratio 45.3124 ++ col 3 width 73.5027 whint 1 wratio 52.5019 (l) (d) /Storage/Reports/ADOMs/root/2014_12_31/S-10012_t10012-User Detailed Browsing Log-2014-12-31-1116 (r) Generate PDF report at /Storage/Reports/ADOMs/root/2014_12_31/S-10012_t10012-User Detailed Browsing Log-2014-12-31-1116 Debug: false Copy resources files .. Process template files .. body_footer.html body_header.html cover_footer.html cover_header.html cover_page.html toc.xsl Generate PDF report... wkhtmltopdf --dpi 76 -L 0 -R 0 -T 25 -B 15 -s Letter cover_page.html --header-html cover_header.html --footer-html cover_footer.html --exclude-from-outline --page-offset -1 --load-error-handling ignore toc --footer-html body_footer.html --footer-spacing 5 --xsl-style-sheet toc.xsl report_body.html --header-html body_header.html --header-spacing 2 --footer-html body_footer.html --footer-spacing 2 ./FortiAnalyzer_Report.pdf Fontconfig error: Cannot load default config file Loading pages (1/6) [> ] 0%[===> ] 5%[======> ] 10%[======> ] 11%[======> ] 11%[============> ] 21%[=============> ] 23%[=================================> ] 55%[=================================> ] 56%[===========================================> ] 72%[============================================> ] 74%[============================================================] 100%Counting pages (2/6) [===================> ] Object 1 of 3[============================================================] Object 3 of 3Loading TOC (3/6) [======> ] 10%[==============================> ] 50%[============================================================] 100%[======> ] 10% [==============================> ] 50%[============================================================] 100%Resolving links (4/6) [===================> ] Object 1 of 3[=======================================> ] Object 2 of 3[============================================================] Object 3 of 3Loading headers and footers (5/6) [> ] 1%[=> ] 2%[=> ] 3%[==> ] 4%[===> ] 5%[===> ] 6%[====> ] 7%[====> ] 8%[======> ] 10%[========> ] 14%[============> ] 20%[==============> ] 24%[==================> ] 30%[====================> ] 34%[========================> ] 40%[==========================> ] 44%[==============================> ] 50%[================================> ] 54%[====================================> ] 60%[======================================> ] 64%[==========================================> ] 70%[============================================> ] 74%[================================================> ] 80%[==================================================> ] 84%[======================================================> ] 90%[========================================================> ] 94%[============================================================] 100%Printing pages (6/6) [> ] Preparing[============> ] Page 1 of 5[========================> ] Page 2 of 5[====================================> ] Page 3 of 5[================================================> ] Page 4 of 5[============================================================] Page 5 of 5Done Generate HTML report... Cleanup .. rm -f ./body_footer.html rm -f ./body_header.html rm -f ./cover_footer.html rm -f ./cover_header.html rm -f ./cover_page.html rm -f ./toc.xsl rm -f ./report_body.html rm -f ./report_toc.html rm -f ./replace.sed done. Report [S-10012_t10012-User Detailed Browsing Log-2014-12-31-1116] finished at Wed (3) 2014-12-31 11:16:42. FAZ200D # [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select src, tbl_name, flags from ((select 1 as src, tbl_name, flags, (timestamp+86400) as adj_time from log_tablst where (flags & 1 = 0) and timestamp >= 1419448609 order by timestamp desc limit 1) union all (select 0 as src, tbl_name, flags, timestamp as adj_time from log_tablst order by timestamp desc limit 1)) t order by adj_time desc limit 1 [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0005 seconds to process sql request. (from=0) [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053409] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select 0 as src, tbl_name, flags from vacuum_tablst order by timestamp desc limit 1 [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0002 seconds to process sql request. (from=0) [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053411] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select src, tbl_name, flags from ((select 1 as src, tbl_name, flags, (timestamp+86400) as adj_time from log_tablst where (flags & 1 = 0) and timestamp >= 1419448639 order by timestamp desc limit 1) union all (select 0 as src, tbl_name, flags, timestamp as adj_time from log_tablst order by timestamp desc limit 1)) t order by adj_time desc limit 1 [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0005 seconds to process sql request. (from=0) [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053439] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully. [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1971: Client '5' is accepted. [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1301: Received request (from:0, type:0). [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1522: Execute SQL query: select 0 as src, tbl_name, flags from vacuum_tablst order by timestamp desc limit 1 [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1599: Used 0.0003 seconds to process sql request. (from=0) [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1649: Prepare to send the result to client. (retcode=1, ds_size=0, errmsg=(null)) [1420053441] DEBUG: sqlplugind(415):sqlreport_main.c:1655: Send response to client successfully.