Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 7 replies
  • Subscribers 3 subscribers
  • Views 9025 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

Unable to parse mail in spool?

Louis-M

Since my last update 9.04, any mail I have that is stuck in the mail spool won't parse. I get a popup saying "unable to parse" which makes it harder to diagnose why the mail is there eg connection refused, greylisted etc

Is anybody else having this issue?



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

    try this:

    login as loginuser then su to root:

    /etc/init.d/postgresql92 rebuild

    greets

    zaphod
    ___________________________________________

    Home: Zotac CI321 (8GB RAM / 120GB SSD)  with latest Sophos UTM
    Work: 2 SG430 Cluster / many other models like SG105/SG115/SG135/SG135w/...

  • 0 in reply to zaphod

    Hi Zaphod,

    what does that command actually do? Sounds like it rebuilds the database but what effect/side effects does it have?

  • 0 in reply to Louis-M

    it rebuilds the internal database used by the UTM.

    Maybe you lost some log information... dont know exactly.. need to ask a sophos staff member or a mod here for more infos..

    it helps to fix my problem similar to yours and all runs fine now..

    greets

    zaphod
    ___________________________________________

    Home: Zotac CI321 (8GB RAM / 120GB SSD)  with latest Sophos UTM
    Work: 2 SG430 Cluster / many other models like SG105/SG115/SG135/SG135w/...

Reply
  • 0 in reply to Louis-M

    it rebuilds the internal database used by the UTM.

    Maybe you lost some log information... dont know exactly.. need to ask a sophos staff member or a mod here for more infos..

    it helps to fix my problem similar to yours and all runs fine now..

    greets

    zaphod
    ___________________________________________

    Home: Zotac CI321 (8GB RAM / 120GB SSD)  with latest Sophos UTM
    Work: 2 SG430 Cluster / many other models like SG105/SG115/SG135/SG135w/...

Children
  • 0 in reply to zaphod

    Hi Zaphod,

    I went to do this and it warned that I would lose all log information etc which we couldn't afford to do.

    I then adjusted the time retention limit for the database logs (in the GUI from 3 to 4 days) and restarted the smtp service in the GUI and then it worked fine.

    Back to normal.

  • 0 in reply to Louis-M

    hi louis,


    seems you find another way to fix this faulty with gui :-)

    greets

    zaphod
    ___________________________________________

    Home: Zotac CI321 (8GB RAM / 120GB SSD)  with latest Sophos UTM
    Work: 2 SG430 Cluster / many other models like SG105/SG115/SG135/SG135w/...

  • 0 in reply to Louis-M

    Very creative, Louis!  You are the first one to suggest this approach to repairing an individual PostgreSQL database.  To my knowledge, even Sophos Support is unaware of this.  Thanks for sharing your result!

    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'm not sure that is indeed a fix but it sorted my issue. Maybe it was just a fluke or a one off.

Unfiltered HTML