Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 17 replies
  • Subscribers 1 subscriber
  • Views 8493 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.100-16] can't click on 'SMTP Spool' -- does nothing

luckman212
We have a ASG220 that was recently upgraded to 9.100-16 and after that started having problems delivering mail to one specific SMTP server (seems like a TLS issue). We had mail getting stuck in the outbound spool and I was checking it, there were 40-50 messages in there over the last few days.  I finally whitelisted the server in the Advanced settings and I think that fixed the problem.

Now however, when I click on Mail Manager and then SMTP Spool, nothing happens, the screen never 'updates'. The other tabs are fine (SMTP Quarantine, SMTP Log, POP3 Quarantine) just Spool doesn't work.

I checked CPU usage, memory and disk space etc -- all are fine. Nothing In /var/log/system.log etc. I rebooted the box twice already but that didn't fix the issue either.

Any ideas??


This thread was automatically locked due to age.
Parents
  • 0

    Yes, that does reinitialize the databases.  Before you do that, there are two other things to try.

    Re-index SMTP only (from Andreas in 2008):

    psql -Upostgres -c"reindex database smtp;" smtp
    psql -Upostgres -c"vacuum;" smtp



    Reinitialize SMTP only (from Billybob in 2012):

    /var/mdw/scripts/smtp stop
    dropdb -U postgres smtp
    createdb -U postgres smtp
    /var/mdw/scripts/smtp start

    EDIT 2016-07-12: changed line 3 to createdb

    Please let us know if those still work.  In the postgresql command, you might need to use postgresql92 instead.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • 0 in reply to BAlfson
    I tried the re-index command and it resulted in a bunch of output...

    [FONT="Courier New"]gw1:/root # psql -Upostgres -c"reindex database smtp;" smtp
    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 "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_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 "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_largeobject" 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 "pg_catalog.pg_opclass" was reindexed
    NOTICE:  table "pg_catalog.pg_depend" was reindexed
    NOTICE:  table "pg_catalog.pg_foreign_server" was reindexed
    NOTICE:  table "information_schema.sql_features" was reindexed
    NOTICE:  table "public.greylist_retry_hosts" was reindexed
    NOTICE:  table "public.import" was reindexed
    NOTICE:  table "public.l" was reindexed
    NOTICE:  table "public.m" was reindexed
    NOTICE:  table "public.greylist_msg_hashes" was reindexed
    NOTICE:  table "public.q" was reindexed
    REINDEX
    gw1:/root #[/FONT]

    Sad news is, that it did not fix the problem.
    I'm scared to run the 2nd set of commands -- dropping the smtp table completely seems kind of dangerous. Don't want to be the guinea pig on that one. Is there any other way to debug this strange issue??
Reply
  • 0 in reply to BAlfson
    I tried the re-index command and it resulted in a bunch of output...

    [FONT="Courier New"]gw1:/root # psql -Upostgres -c"reindex database smtp;" smtp
    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 "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_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 "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_largeobject" 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 "pg_catalog.pg_opclass" was reindexed
    NOTICE:  table "pg_catalog.pg_depend" was reindexed
    NOTICE:  table "pg_catalog.pg_foreign_server" was reindexed
    NOTICE:  table "information_schema.sql_features" was reindexed
    NOTICE:  table "public.greylist_retry_hosts" was reindexed
    NOTICE:  table "public.import" was reindexed
    NOTICE:  table "public.l" was reindexed
    NOTICE:  table "public.m" was reindexed
    NOTICE:  table "public.greylist_msg_hashes" was reindexed
    NOTICE:  table "public.q" was reindexed
    REINDEX
    gw1:/root #[/FONT]

    Sad news is, that it did not fix the problem.
    I'm scared to run the 2nd set of commands -- dropping the smtp table completely seems kind of dangerous. Don't want to be the guinea pig on that one. Is there any other way to debug this strange issue??
Children
No Data
Unfiltered HTML