Advisory: Sophos Endpoint "Your connection isn't private" after reboot. Policy settings can be returned to normal. See: KB-000045954 for the latest updates.

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

Mails in filesystem spool folder - not showing in Mail Manager

Hello,

I monitor the SMTP proxy spool folders with a simple script which counts the mails on the filesystem.

This works good but from time to time the spool folder has mails in it which get not counted by the Mail Manager only on filesystem basis.

What could be the problem for this? Any ideas?

Regards

UTMaddict



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

    Hi ,

    Thanks for reaching out to the Communiuty! 

    What is the firmware version on your UTM? Did you see any database errors in the system logs? 

    Can you share the output of the command: ps aux | grep postgres 

    Thanks, 

Reply
  • FormerMember
    0 FormerMember

    Hi ,

    Thanks for reaching out to the Communiuty! 

    What is the firmware version on your UTM? Did you see any database errors in the system logs? 

    Can you share the output of the command: ps aux | grep postgres 

    Thanks, 

Children
  • Hello H_Patel,

    We are using version 9.705-3.

    Can't see any database errors in the timeframe since the mail is in the spool folder...

    This is the output of ps aux:

    postgres  4471  0.0  0.0  15256  6244 ?        Ss   Mar08   1:17 /usr/local/bin/repctl
    postgres  6124  0.0  0.0 2215252 5212 ?        Ss   Apr22   0:00 postgres: pop3 pop3 127.0.0.1(58130) idle
    postgres  6266  0.0  0.0 2214972 3772 ?        Ss   Mar25   0:00 postgres: sandbox sandbox 127.0.0.1(59694) idle
    postgres  6339  0.0  0.0 2215160 7500 ?        Ss   May06   0:01 postgres: hotspot hotspot 127.0.0.1(44179) idle
    postgres  7104  0.0  0.1 2217012 23516 ?       Ss   Apr22   0:05 postgres: smtp smtp 127.0.0.1(54690) idle
    postgres 10541  0.0  0.0 2215140 6736 ?        Ss   May06   0:00 postgres: hotspot hotspot 127.0.0.1(44326) idle
    postgres 10812  0.0  0.0 2214836 4776 ?        Ss   09:19   0:00 postgres: repmgr repmgr 198.19.250.2(57795) idle
    postgres 12774  0.0  0.0 2215128 7012 ?        Ss   09:20   0:00 postgres: smtp smtp 127.0.0.1(42922) idle
    root     14657  0.0  0.0   5672   752 pts/0    S+   09:21   0:00 grep postgres
    postgres 16938  0.0  0.0 2214964 5628 ?        Ss   01:02   0:00 postgres: smtp smtp [local] idle
    postgres 16940  0.0  0.0 2214964 5636 ?        Ss   01:02   0:00 postgres: smtp smtp [local] idle
    postgres 16944  0.0  0.0 2217392 7268 ?        Ss   01:02   0:00 postgres: reporting reporting [local] idle
    postgres 16945  0.0  0.0 2214972 4836 ?        Ss   01:02   0:00 postgres: reporting reporting [local] idle
    postgres 16977 14.7  5.0 2217824 613524 ?      Ss   01:02  73:45 postgres: reporting reporting [local] idle
    postgres 16996  0.0  0.0 2215068 6340 ?        Ss   01:02   0:00 postgres: hotspot hotspot [local] idle
    postgres 17006  0.0  0.0 2215068 6344 ?        Ss   01:02   0:00 postgres: hotspot hotspot [local] idle
    postgres 17572  0.0  0.0 2215032 6764 ?        Ss   01:03   0:00 postgres: sandbox sandbox [local] idle
    postgres 17579  0.0  0.0 2214968 5660 ?        Ss   01:03   0:00 postgres: sandbox sandbox [local] idle
    postgres 18210  0.0  0.0   6912   428 ?        Ss   Mar17   0:00 /usr/bin/rsync --daemon --config /var/lib/postgresql/rsyncd.conf
    postgres 19774  0.0  0.5 2210544 62128 ?       S    Mar17   4:11 /usr/pgsql92-64/bin/postgres -D /var/storage/pgsql92/data
    postgres 20063  0.0 13.0 2211920 1590864 ?     Ss   Mar17  47:23 postgres: checkpointer process
    postgres 20064  0.0  0.1 2211572 14156 ?       Ss   Mar17   0:41 postgres: writer process
    postgres 20065  0.0  0.1 2211572 17076 ?       Ss   Mar17  35:45 postgres: wal writer process
    postgres 20066  0.0  0.0 2212712 1952 ?        Ss   Mar17   5:24 postgres: autovacuum launcher process
    postgres 20067  0.0  0.0  26928   600 ?        Ss   Mar17   0:24 postgres: archiver process   last was 000000010000044D0000009B
    postgres 20068  0.0  0.0  27368   936 ?        Ss   Mar17  26:33 postgres: stats collector process
    postgres 20131  0.0  0.1 2215276 23448 ?       Ss   Mar17   6:17 postgres: hotspot hotspot 127.0.0.1(48167) idle
    postgres 20154  0.0  0.1 2217488 23424 ?       Ss   01:07   0:01 postgres: reporting reporting [local] idle
    postgres 20230  0.0  0.1 2215060 15872 ?       Ss   Mar17   0:30 postgres: smtp smtp 127.0.0.1(48184) idle
    postgres 20344  0.0  0.4 2216312 59564 ?       Ss   Mar17   2:26 postgres: smtp smtp 127.0.0.1(48190) idle
    postgres 20693  0.0  0.0 2214964 3772 ?        Ss   Mar17   0:00 postgres: sandbox sandbox 198.19.250.1(37577) idle
    postgres 20695  0.0  0.2 2215268 31404 ?       Ss   Mar17   3:18 postgres: sandbox sandbox 198.19.250.1(37578) idle
    postgres 21328  0.1  0.0 2215128 7452 ?        Ss   00:15   0:40 postgres: smtp smtp 198.19.250.2(54573) idle
    postgres 22561  0.0  0.0 2215160 7032 ?        Ss   Apr23   0:01 postgres: hotspot hotspot 127.0.0.1(59913) idle
    postgres 23484  0.0  0.0 2214840 2304 ?        Ss   Mar17   0:00 postgres: sandbox sandbox 198.19.250.2(37031) idle
    postgres 23485  0.0  0.2 2215248 29468 ?       Ss   Mar17   3:24 postgres: sandbox sandbox 198.19.250.2(37032) idle
    postgres 23561  0.0  0.1 2215060 15456 ?       Ss   Mar17   0:30 postgres: smtp smtp 198.19.250.2(37035) idle
    postgres 23565  0.0  0.0 2215096 5456 ?        Ss   Mar17   0:00 postgres: smtp smtp 198.19.250.2(37037) idle
    postgres 24695  0.0  0.0 2212548 1872 ?        Ss   Mar17  35:36 postgres: wal sender process repmgr 198.19.250.2(37078) streaming 44D/9C76E000

    Regards

    UTM_addict