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

Incoming mails, are frozen and waiting state in SMTP spool

Hi,

I have Sophos UTM 9.413-4, in the SMTP spool, the incoming mails are all in waiting state, looking into the messages i got the next message delivery log:

     Message Delivery Log:
     R=static_route_hostlist defer (-1): remote host address is the local host
     *** Frozen

The only way to release the spool is selecting the e-mails and using the retry option two or three times, then those go out, i have to do this frecuently during the day
is the only way that it works.

How can i correct this error?

thanks :)

(postdata: sorry for my english)

This thread was automatically locked due to age.

Parents

0 BAlfson over 7 years ago

Hi, Milton, and welcome to the UTM Community!

Sounds like the PostgreSQL database might be damaged. You might be able to force it to rebuild by going to the 'Configuration' tab of 'Mail Manager' and changing the number of days retention and then changing it back. Any luck with that?

Cheers - Bob

Sophos UTM Community Moderator
Sophos Certified Architect - UTM
Sophos Certified Engineer - XG
Gold Solution Partner since 2005

MediaSoft, Inc. USA
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 BAlfson over 7 years ago

Hi, Milton, and welcome to the UTM Community!

Sounds like the PostgreSQL database might be damaged. You might be able to force it to rebuild by going to the 'Configuration' tab of 'Mail Manager' and changing the number of days retention and then changing it back. Any luck with that?

Cheers - Bob

Sophos UTM Community Moderator
Sophos Certified Architect - UTM
Sophos Certified Engineer - XG
Gold Solution Partner since 2005

MediaSoft, Inc. USA
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 Milton Jimenez over 7 years ago in reply to BAlfson

Hi BAlfson,

Firstly, i appreciate your early answer, secondly, I followed your instructions, but the problem persists, also i flush the database log, with no effect, any hint are wellcome
Cancel
Vote Up 0 Vote Down

Cancel
0 BAlfson over 7 years ago in reply to Milton Jimenez

To re-initialize the reporting databases (deletes all data), do the following as root at the command line:

/etc/init.d/postgresql92 rebuild

Cheers - Bob

Sophos UTM Community Moderator
Sophos Certified Architect - UTM
Sophos Certified Engineer - XG
Gold Solution Partner since 2005

MediaSoft, Inc. USA
Cancel
Vote Up 0 Vote Down

Cancel