Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 3 subscribers
  • Views 2827 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

[9.106-17] Strange characters in Services Reports

Mark_D_01
Hi All
After Upgrading to the new Firmware 9.106-17 I noticed strange characters in Services Reports.
When I look at Logging and Reporting/ Network Protection/ Firewall or IPS Reports, this also affects the daily exec report (But I only have seen blank lines so far).
A lot of the services are appearing in strange ascii characters and or missing.
Please see attached screen captures.

ps using Firefox 24.0 and tested on another system using Firefox X.X.

Regards

Mark


This thread was automatically locked due to age.
  • 0
    We haven't yet moved to 9.106-17 but due to compliance we don't use FF. However i'm curious, have you tried in IE/Chrome?
  • 0
    Hi, I just updated and it's OK so far (in FF24), but I'll try to check again after the reporting system has a chance to update.

    Barry
  • 0
    Hi Barry
    Only one of two Updated has shown this feature.
    I'm stopping this rollout until I get a resolution to why one of mine went this way.
    I have raised a support case and will see what happens.
    Mark
  • 0 in reply to Mark_D_01
    I have given up on the blank line, no one can tell me what it is?

    Ian
  • 0 in reply to RFCat_vk_01
    This problem is not new with this release. It has been around for quite a while. I posted about it in July. Here is the thread.
  • 0
    Guys, I'm not seeing this elsewhere.  Before doing /etc/init.d/postgresql rebuild which deletes some information, you might try
    psql -Ureporting -c"reindex database reporting;" reporting
    psql -Ureporting -c"vacuum;" reporting

    Any luck?

    Cheers - Bob
  • 0 in reply to BAlfson
    Hi Bob
    I tried psql -Ureporting -c"vacuum;" reporting, but it said only superuser can vacuum it.

    I will report later or tomorrow with results to see if this fixed it issue.
    ps when would I expect to see these clear?

    Thanks for a reply.

    Mark

    Same results today.
    Still looks like pic.
  • 0
    Hi, try running as root with sudo (or 'su' before running the command).

    Barry
  • 0
    Hi Barry
    Same as before.
    Below is copy of terminal log.

    Using username "root".
    Authenticating with public key "fmaster-root"
    Passphrase for key "fmaster-root":
    Last login: Mon Nov 11 16:34:44 2013 from 172.16.20.8


    Sophos UTM
    (C) Copyrights by Sophos Ltd and by others 2000-2013.
    For more copyright information look at /doc/astaro-license.txt
    or http://www.astaro.com/doc/astaro-license.txt

    NOTE: Any modifications done by root will void your support.
          Please use WebAdmin for any configuration changes.

    fmaster:/root # whoami
    root
    fmaster:/root # psql -Ureporting -c"reindex database reporting;" reporting
    NOTICE:  table "pg_catalog.pg_class" was reindexed
    NOTICE:  table "pg_catalog.pg_statistic" was reindexed
    NOTICE:  table "pg_catalog.pg_type" was reindexed
    NOTICE:  table "public.endpoint_users" was reindexed
    NOTICE:  table "pg_catalog.pg_authid" was reindexed
    NOTICE:  table "pg_catalog.pg_proc" was reindexed
    NOTICE:  table "pg_catalog.pg_user_mapping" was reindexed
    NOTICE:  table "pg_catalog.pg_attribute" was reindexed
    NOTICE:  table "pg_catalog.pg_constraint" was reindexed
    NOTICE:  table "pg_catalog.pg_inherits" was reindexed
    NOTICE:  table "pg_catalog.pg_index" was reindexed
    NOTICE:  table "pg_catalog.pg_operator" was reindexed
    NOTICE:  table "pg_catalog.pg_opfamily" was reindexed
    NOTICE:  table "pg_catalog.pg_am" was reindexed
    NOTICE:  table "pg_catalog.pg_amop" was reindexed
    NOTICE:  table "pg_catalog.pg_amproc" was reindexed
    NOTICE:  table "pg_catalog.pg_language" was reindexed
    NOTICE:  table "pg_catalog.pg_largeobject_metadata" was reindexed
    NOTICE:  table "pg_catalog.pg_aggregate" was reindexed
    NOTICE:  table "pg_catalog.pg_rewrite" was reindexed
    NOTICE:  table "pg_catalog.pg_largeobject" was reindexed
    NOTICE:  table "pg_catalog.pg_trigger" was reindexed
    NOTICE:  table "pg_catalog.pg_description" was reindexed
    NOTICE:  table "pg_catalog.pg_cast" was reindexed
    NOTICE:  table "pg_catalog.pg_enum" was reindexed
    NOTICE:  table "pg_catalog.pg_namespace" was reindexed
    NOTICE:  table "pg_catalog.pg_conversion" was reindexed
    NOTICE:  table "pg_catalog.pg_database" was reindexed
    NOTICE:  table "public.endpoint_lookup" was reindexed
    NOTICE:  table "pg_catalog.pg_db_role_setting" was reindexed
    NOTICE:  table "pg_catalog.pg_tablespace" was reindexed
    NOTICE:  table "pg_catalog.pg_pltemplate" was reindexed
    NOTICE:  table "pg_catalog.pg_auth_members" was reindexed
    NOTICE:  table "pg_catalog.pg_shdepend" was reindexed
    NOTICE:  table "pg_catalog.pg_shdescription" was reindexed
    NOTICE:  table "pg_catalog.pg_ts_config" was reindexed
    NOTICE:  table "pg_catalog.pg_ts_config_map" was reindexed
    NOTICE:  table "pg_catalog.pg_ts_dict" was reindexed
    NOTICE:  table "pg_catalog.pg_ts_parser" was reindexed
    NOTICE:  table "pg_catalog.pg_ts_template" was reindexed
    NOTICE:  table "pg_catalog.pg_extension" was reindexed
    NOTICE:  table "pg_catalog.pg_foreign_data_wrapper" was reindexed
    NOTICE:  table "pg_catalog.pg_foreign_table" was reindexed
    NOTICE:  table "pg_catalog.pg_default_acl" was reindexed
    NOTICE:  table "pg_catalog.pg_seclabel" was reindexed
    NOTICE:  table "pg_catalog.pg_shseclabel" was reindexed
    NOTICE:  table "pg_catalog.pg_collation" was reindexed
    NOTICE:  table "pg_catalog.pg_range" was reindexed
    NOTICE:  table "information_schema.sql_implementation_info" was reindexed
    NOTICE:  table "information_schema.sql_languages" was reindexed
    NOTICE:  table "information_schema.sql_packages" was reindexed
    NOTICE:  table "information_schema.sql_parts" was reindexed
    NOTICE:  table "information_schema.sql_sizing" was reindexed
    NOTICE:  table "information_schema.sql_sizing_profiles" was reindexed
    NOTICE:  table "pg_catalog.pg_attrdef" was reindexed
    NOTICE:  table "public.dpt_lookup" was reindexed
    NOTICE:  table "pg_catalog.pg_opclass" was reindexed
    NOTICE:  table "public.confd_sessions" was reindexed
    NOTICE:  table "public.confd_nodes" was reindexed
    NOTICE:  table "pg_catalog.pg_depend" was reindexed
    NOTICE:  table "public.accounting" was reindexed
    NOTICE:  table "pg_catalog.pg_foreign_server" was reindexed
    NOTICE:  table "information_schema.sql_features" was reindexed
    NOTICE:  table "public.confd_objects" was reindexed
    NOTICE:  table "public.vpn" was reindexed
    NOTICE:  table "public.ipscount" was reindexed
    NOTICE:  table "public.mailanon_addrs" was reindexed
    NOTICE:  table "public.websec_categories" was reindexed
    NOTICE:  table "public.websec_reqcat" was reindexed
    NOTICE:  table "public.websec_reqdpt" was reindexed
    NOTICE:  table "public.websecurity" was reindexed
    NOTICE:  table "public.mailsec" was reindexed
    NOTICE:  table "public.websec_searches" was reindexed
    NOTICE:  table "public.websec_visits" was reindexed
    NOTICE:  table "public.waf_events" was reindexed
    NOTICE:  table "public.appcontrol" was reindexed
    NOTICE:  table "public.auth" was reindexed
    NOTICE:  table "public.waf" was reindexed
    NOTICE:  table "public.websec_sessions" was reindexed
    NOTICE:  table "public.mailanon_domains" was reindexed
    NOTICE:  table "public.ips" was reindexed
    NOTICE:  table "public.pfilter" was reindexed
    NOTICE:  table "public.webanon_users" was reindexed
    REINDEX
    fmaster:/root # su psql -Ureporting -c"vacuum;" reporting
    su: invalid option -- 'U'
    Try `su --help' for more information.
    fmaster:/root # psql -Ureporting -c"vacuum;" reporting
    WARNING:  skipping "pg_authid" --- only superuser can vacuum it
    WARNING:  skipping "pg_database" --- only superuser can vacuum it
    WARNING:  skipping "pg_db_role_setting" --- only superuser can vacuum it
    WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
    WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
    WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
    WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
    WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
    WARNING:  skipping "pg_shseclabel" --- only superuser can vacuum it
    VACUUM
    fmaster:/root # su -l
    fmaster:/root # psql -Ureporting -c"vacuum;" reporting
    WARNING:  skipping "pg_authid" --- only superuser can vacuum it
    WARNING:  skipping "pg_database" --- only superuser can vacuum it
    WARNING:  skipping "pg_db_role_setting" --- only superuser can vacuum it
    WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
    WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
    WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
    WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
    WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
    WARNING:  skipping "pg_shseclabel" --- only superuser can vacuum it
    VACUUM
    fmaster:/root #

    Same result

    Mark