Important note about SSL VPN compatibility for 20.0 MR1 with EoL SFOS versions and UTM9 OS. Learn more in the release notes.
Hello, Since installing the latest version of SFOS Firmware 19.0.0 GA-Build317, I found that reports they are no longer functional since 2022-07-29 13:12:22 , how I should do to solve this problem , this is the first time I have encountered this kind of bug, I have a Sophos XG230,
Thanks in advance
bonjour , Mayur Patel, Vivek Jagad
here is some event (log), thank you
************************************************************************************************************************************************************
XG230_WP01_SFOS 19.0.1 MR-1-Build365# csc cuustom debug
MESSAGE Sep 01 13:23:08Z [csc:3581]: Restricted context is initialized succes sfully
ERROR Sep 01 13:23:08Z [csc:3581]: Unable to open file : /_conf/csc/bind_fi le_list No such file or directory
/_conf/csc/cscdbgopts.conf: No such file or directory
ERROR Sep 01 13:23:08Z [csc:3581]: read_conffile: Failed to read file '/_co nf/csc/cscdbgopts.conf'
ERROR Sep 01 13:23:08Z [csc:3581]: cscdbgopts_parse: Failed to read conffil e
ERROR Sep 01 13:23:08Z [csc:3581]: Parsing cscdbgopts failed !!!!
MESSAGE Sep 01 13:23:08Z [csc:3581]: Starting csc-0.0.0.15 with glibc: 2.27
ERROR Sep 01 13:23:08Z [csc:3581]: fopen(/etc/csc/csc.conf) failed: No such file or directory
CRITICAL Sep 01 13:23:08Z [csc:3581]: parse_conf_file: /etc/csc/csc.conf - No such file or directory
/etc/csc/csc.conf: ERROR syntax error
XG230_WP01_SFOS 19.0.1 MR-1-Build365# XG230_WP01_SFOS 19.0.1 MR-1-Build365# csc
cuustom debug
/bin/sh: XG230_WP01_SFOS: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# MESSAGE Sep 01 13:23:08Z [csc:3581]: Restricted context is initiali
zed succes sfully
/bin/sh: MESSAGE: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# ERROR Sep 01 13:23:08Z [csc:3581]: Unable to open file : /_conf/c
sc/bind_fi le_list No such file or directory
/bin/sh: ERROR: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# /_conf/csc/cscdbgopts.conf: No such file or directory
ERROR Sep 01 13:23:08Z [csc:3581]: Parsing cscdbgopts failed !!!!
MESSAGE Sep 01 13:23:08Z [csc:3581]: Starting csc-0.0.0.15 with glibc: 2.27
ERROR Sep 01 13:23:08Z [csc:3581]: fopen(/etc/csc/csc.conf) failed: No such file or directory
CRITICAL Sep 01 13:23:08Z [csc:3581]: parse_conf_file: /etc/csc/csc.conf - No such file or directory
/etc/csc/csc.conf: ERROR syntax error
/bin/sh: /_conf/csc/cscdbgopts.conf:: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# ERROR Sep 01 13:23:08Z [csc:3581]: read_conffile: Failed to read
file '/_co nf/csc/cscdbgopts.conf'
/bin/sh: ERROR: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# ERROR Sep 01 13:23:08Z [csc:3581]: cscdbgopts_parse: Failed to re
ad conffil e
/bin/sh: ERROR: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# ERROR Sep 01 13:23:08Z [csc:3581]: Parsing cscdbgopts failed !!!!
/bin/sh: ERROR: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# MESSAGE Sep 01 13:23:08Z [csc:3581]: Starting csc-0.0.0.15 with gli
bc: 2.27
/bin/sh: MESSAGE: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# ERROR Sep 01 13:23:08Z [csc:3581]: fopen(/etc/csc/csc.conf) faile
d: No such file or directory
/bin/sh: syntax error: unexpected "("
XG230_WP01_SFOS 19.0.1 MR-1-Build365# CRITICAL Sep 01 13:23:08Z [csc:3581]: parse_conf_file: /etc/csc/csc.
conf - No such file or directory
/bin/sh: CRITICAL: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# /etc/csc/csc.conf: ERROR syntax error
/bin/sh: /etc/csc/csc.conf:: not found
******************************************************************************
XG230_WP01_SFOS 19.0.1 MR-1-Build365# df -kh
Filesystem Size Used Available Use% Mounted on
none 202.7M 2.7M 185.3M 1% /
none 3.8G 16.0K 3.8G 0% /dev
none 3.8G 14.5M 3.8G 0% /tmp
none 3.8G 14.6M 3.8G 0% /dev/shm
/dev/boot 127.7M 39.3M 85.7M 31% /boot
/dev/mapper/mountconf
385.4M 74.6M 306.8M 20% /conf
/dev/content 10.3G 616.3M 9.7G 6% /content
/dev/var 87.1G 17.2G 69.9G 20% /var
XG230_WP01_SFOS 19.0.1 MR-1-Build365#
******************************************************************************
XG230_WP01_SFOS 19.0.1 MR-1-Build365# /log/reportdb/.log
/bin/sh: /log/reportdb/.log: not found
XG230_WP01_SFOS 19.0.1 MR-1-Build365# tail /log/reportmigration.log
2022-08-28 21:24:27.384 GMT : Report db recovery start.
2022-08-28 21:24:27.811 GMT : Report db recovery finish.
2022-08-28 22:21:46.581 GMT : Report db recovery start.
2022-08-28 22:21:47.064 GMT : Report db recovery finish.
2022-08-28 22:35:18.556 GMT : Report db recovery start.
2022-08-28 22:35:18.847 GMT : Report db recovery finish.
2022-08-31 19:25:01.194 GMT : Report db recovery start.
2022-08-31 19:25:01.471 GMT : Report db recovery finish.
2022-08-31 19:48:24.364 GMT : Report db recovery start.
2022-08-31 19:48:24.663 GMT : Report db recovery finish.
******************************************************************************
/log/migration.log
/bin/sh: /log/migration.log: Permission denied
******************************************************************************
/log/reportdb/.log
/bin/sh: /log/reportdb/.log: not found
**********************************************************************************************************************************************************************************************
XG230_WP01_SFOS 19.0.1 MR-1-Build365# tail -30 /log/reportdb.log
12827 2022-08-31 20:01:37.597 GMTLOG: could not receive data from client: Connection reset by peer
5458 2022-08-31 20:01:37.597 GMTLOG: unexpected EOF on client connection with an open transaction
5446 2022-08-31 20:01:37.598 GMTLOG: unexpected EOF on client connection with an open transaction
5444 2022-08-31 20:01:37.599 GMTLOG: unexpected EOF on client connection with an open transaction
10186 2022-08-31 22:32:29.956 GMTERROR: canceling statement due to user request
10186 2022-08-31 22:32:29.956 GMTSTATEMENT: INSERT INTO available_fwapplicationv7_1661974802 (time,applicati on,username,destipv6,hostipv6,ruleid,hits,upload,download,hostcountry,destcountry,risk,technology,category,ed uusergroup,srczonename,srczonetype,destzonename,destzonetype,appresolver,app_id,classification,is_cloud_appli cation,app_parent,in_interface,parent_cat_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23,$24,$25,$26)
10955 2022-08-31 23:00:59.688 GMTERROR: relation "tbl_device_eventv5_4hr_ts_202209" does not exist at charac ter 13
10955 2022-08-31 23:00:59.688 GMTQUERY: insert into tbl_device_eventv5_4hr_ts_202209 values('2022-09-01 00: 00:59.687063' ,'Blocked Web',0)
10955 2022-08-31 23:00:59.688 GMTCONTEXT: PL/pgSQL function denied_web_proc_012() line 35 at EXECUTE stateme nt
10955 2022-08-31 23:00:59.688 GMTSTATEMENT: Select denied_web_proc_012();
10957 2022-08-31 23:00:59.694 GMTERROR: relation "tbl_device_eventv5_4hr_ts_202209" does not exist at charac ter 13
10957 2022-08-31 23:00:59.694 GMTQUERY: insert into tbl_device_eventv5_4hr_ts_202209 values('2022-09-01 00:0 0:59.692852' ,'IPS Attack',0)
10957 2022-08-31 23:00:59.694 GMTCONTEXT: PL/pgSQL function ips_alerts_proc_010() line 48 at EXECUTE stateme nt
10957 2022-08-31 23:00:59.694 GMTSTATEMENT: Select ips_alerts_proc_010();
10960 2022-08-31 23:00:59.699 GMTERROR: relation "tbl_device_eventv5_4hr_ts_202209" does not exist at charac ter 13
10960 2022-08-31 23:00:59.699 GMTQUERY: insert into tbl_device_eventv5_4hr_ts_202209 values('2022-09-01 00:0 0:59.697972' ,'Virus',0)
10960 2022-08-31 23:00:59.699 GMTCONTEXT: PL/pgSQL function virus_proc_011() line 42 at EXECUTE statement
10960 2022-08-31 23:00:59.699 GMTSTATEMENT: Select virus_proc_011();
10958 2022-08-31 23:00:59.710 GMTERROR: relation "tbl_device_eventv5_4hr_ts_202209" already exists
10958 2022-08-31 23:00:59.710 GMTCONTEXT: SQL statement "CREATE TABLE tbl_device_eventv5_4hr_ts_202209(like tbl_device_eventv5_4hr) INHERITS (tbl_device_eventv5_4hr)"
PL/pgSQL function mail_spam_proc_009() line 25 at EXECUTE statement
10958 2022-08-31 23:00:59.710 GMTSTATEMENT: Select mail_spam_proc_009();
10961 2022-08-31 23:00:59.710 GMTERROR: relation "tbl_device_eventv5_4hr_ts_202209" already exists
10961 2022-08-31 23:00:59.710 GMTCONTEXT: SQL statement "CREATE TABLE tbl_device_eventv5_4hr_ts_202209(like tbl_device_eventv5_4hr) INHERITS (tbl_device_eventv5_4hr)"
PL/pgSQL function web_usage_proc_012() line 27 at EXECUTE statement
10961 2022-08-31 23:00:59.710 GMTSTATEMENT: Select web_usage_proc_012();
8682 2022-09-01 11:16:04.481 GMTERROR: canceling statement due to user request
8682 2022-09-01 11:16:04.481 GMTSTATEMENT: INSERT INTO available_fwapplicationv7_1661973604 (time,applicatio n,username,destipv6,hostipv6,ruleid,hits,upload,download,hostcountry,destcountry,risk,technology,category,edu usergroup,srczonename,srczonetype,destzonename,destzonetype,appresolver,app_id,classification,is_cloud_applic ation,app_parent,in_interface,parent_cat_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$ 17,$18,$19,$20,$21,$22,$23,$24,$25,$26)
1380 2022-09-01 11:16:08.167 GMTLOG: checkpoints are occurring too frequently (6 seconds apart)
1380 2022-09-01 11:16:08.167 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
******************************************************************************************************************************************************************************************************************************************