mailcow / mailcow-dockerized

mailcow: dockerized - 🐮 + 🐋 = 💕
https://mailcow.email
GNU General Public License v3.0
8.75k stars 1.17k forks source link

Mailbox List doesn't load anymore #4630

Closed JlNiko closed 1 year ago

JlNiko commented 2 years ago

Contribution guidelines

I've found a bug and checked that ...

Description

Hello, someone open the issue #2710 in the past but no answer was found except to reinstall it.

I can't load the list of mailboxes any more since the upgrade of may as main administrator. As domain administrator if there is not too much mailboxes in the domaoin i can list them.

Logs

mailcowdockerized-dockerapi-mailcow-1  |  * Running on all addresses (0.0.0.0)
mailcowdockerized-dockerapi-mailcow-1  |    WARNING: This is a development server. Do not use it in a production deployment.
mailcowdockerized-dockerapi-mailcow-1  |  * Running on https://127.0.0.1:443
mailcowdockerized-dockerapi-mailcow-1  |  * Running on https://172.22.1.2:443 (Press CTRL+C to quit)
mailcowdockerized-dockerapi-mailcow-1  | 172.22.1.7 - - [11/Jun/2022 00:14:16] "GET /containers/json HTTP/1.1" 200 -
mailcowdockerized-dockerapi-mailcow-1  | api call: container_post__exec__system__mysql_upgrade, container_id: 26d3e97b34dcfb723797c0fa27871821132ddeb253e4d70ffd0f457217366b7d
mailcowdockerized-dockerapi-mailcow-1  | 172.22.1.7 - - [11/Jun/2022 00:14:18] "POST /containers/26d3e97b34dcfb723797c0fa27871821132ddeb253e4d70ffd0f457217366b7d/exec HTTP/1.1" 200 -
mailcowdockerized-dockerapi-mailcow-1  | 172.22.1.7 - - [13/Jun/2022 13:05:26] "GET /containers/json HTTP/1.1" 200 -
mailcowdockerized-dockerapi-mailcow-1  | api call: container_post__exec__mailq__list, container_id: 0914e1995ad5af32c2fcdd1549e012a895de8354efc7c808565bf6b214f7a6be
mailcowdockerized-dockerapi-mailcow-1  | 172.22.1.7 - - [13/Jun/2022 13:05:26] "POST /containers/0914e1995ad5af32c2fcdd1549e012a895de8354efc7c808565bf6b214f7a6be/exec HTTP/1.1" 200 -
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:52 2022 -> Database test passed.
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:52 2022 -> daily.cld updated (version: 26571, sigs: 1985856, f-level: 90, builder: raynman)
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:53 2022 -> main.cvd database is up-to-date (version: 62, sigs: 6647427, f-level: 90, builder: sigmgr)
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:53 2022 -> bytecode.cvd database is up-to-date (version: 333, sigs: 92, f-level: 63, builder: awillia2)
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:53 2022 -> Clamd successfully notified about the update.
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:44:54 2022 -> Reading databases from /var/lib/clamav
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:45:08 2022 -> Database correctly reloaded (8744921 signatures)
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:45:08 2022 -> Database reload completed.
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 11:45:08 2022 -> Activating the newly loaded database...
mailcowdockerized-clamd-mailcow-1      | Mon Jun 13 12:25:07 2022 -> SelfCheck: Database status OK.
mailcowdockerized-netfilter-mailcow-1  | 185.36.81.192 matched rule id 3 (warning: unknown[185.36.81.192]: SASL LOGIN authentication failed: UGFzc3dvcmQ6)
mailcowdockerized-netfilter-mailcow-1  | 9 more attempts in the next 600 seconds until 185.36.81.192/32 is banned
mailcowdockerized-netfilter-mailcow-1  | 185.36.81.192 matched rule id 3 (warning: unknown[185.36.81.192]: SASL LOGIN authentication failed: UGFzc3dvcmQ6)
mailcowdockerized-netfilter-mailcow-1  | 9 more attempts in the next 600 seconds until 185.36.81.192/32 is banned
mailcowdockerized-netfilter-mailcow-1  | 141.98.11.26 matched rule id 3 (warning: unknown[141.98.11.26]: SASL LOGIN authentication failed: UGFzc3dvcmQ6)
mailcowdockerized-netfilter-mailcow-1  | 9 more attempts in the next 600 seconds until 141.98.11.26/32 is banned
mailcowdockerized-netfilter-mailcow-1  | 141.98.10.198 matched rule id 3 (warning: unknown[141.98.10.198]: SASL LOGIN authentication failed: UGFzc3dvcmQ6)
mailcowdockerized-netfilter-mailcow-1  | 9 more attempts in the next 600 seconds until 141.98.10.198/32 is banned
mailcowdockerized-netfilter-mailcow-1  | 185.36.81.192 matched rule id 3 (warning: unknown[185.36.81.192]: SASL LOGIN authentication failed: UGFzc3dvcmQ6)
mailcowdockerized-netfilter-mailcow-1  | 9 more attempts in the next 600 seconds until 185.36.81.192/32 is banned
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:15:04 7b0dbd30d185 dovecot: managesieve-login: Disconnected: Connection closed (no auth attempts in 0 secs): user=<>, rip=172.22.1.8, lip=172.22.1.250
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:15:21 7b0dbd30d185 dovecot: imap(bbbb@llll.eu)<166468><kLSchVHhSW25KD0M>: Disconnected: Inactivity - no input for 1800 secs in=943 out=2806 deleted=0 expunged=0 trashed=0 hdr_count=0 hdr_bytes=0 body_count=0 body_bytes=0
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:15:33 7b0dbd30d185 dovecot: imap(bbbbb@XXXXXXXXX.net)<166517><0Mtph1HhLG25KD0M>: Disconnected: Inactivity - no input for 1800 secs in=551 out=1747 deleted=0 expunged=0 trashed=0 hdr_count=0 hdr_bytes=0 body_count=0 body_bytes=0
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:15:35 7b0dbd30d185 dovecot: imap(admin@XXXXXXXXX.net)<166515><LMtph1HhJG25KD0M>: Disconnected: Inactivity - no input for 1800 secs in=548 out=1729 deleted=0 expunged=0 trashed=0 hdr_count=0 hdr_bytes=0 body_count=0 body_bytes=0
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:15:36 7b0dbd30d185 dovecot: imap-login: Disconnected: Aborted login by logging out (no auth attempts in 0 secs): user=<>, rip=172.22.1.8, lip=172.22.1.250, TLS, TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:16:06 7b0dbd30d185 dovecot: lmtp(169535): Connect from 172.22.1.8
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:16:06 7b0dbd30d185 dovecot: lmtp(169535): Disconnect from 172.22.1.8: Logged out (state=MAIL FROM)
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:16:06 7b0dbd30d185 dovecot: imap-login: Disconnected: Aborted login by logging out (no auth attempts in 0 secs): user=<>, rip=172.22.1.8, lip=172.22.1.250, TLS, TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:16:06 7b0dbd30d185 dovecot: imap-login: Disconnected: Aborted login by logging out (no auth attempts in 0 secs): user=<>, rip=172.22.1.8, lip=172.22.1.250
mailcowdockerized-dovecot-mailcow-1    | Jun 13 13:16:06 7b0dbd30d185 dovecot: managesieve-login: Disconnected: Connection closed (no auth attempts in 0 secs): user=<>, rip=172.22.1.8, lip=172.22.1.250
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:07:48.074 * 100 changes in 300 seconds. Saving...
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:07:48.075 * Background saving started by pid 754
mailcowdockerized-redis-mailcow-1      | 754:C 13 Jun 2022 13:07:48.129 * DB saved on disk
mailcowdockerized-redis-mailcow-1      | 754:C 13 Jun 2022 13:07:48.129 * RDB: 0 MB of memory used by copy-on-write
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:07:48.175 * Background saving terminated with success
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:12:49.032 * 100 changes in 300 seconds. Saving...
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:12:49.033 * Background saving started by pid 755
mailcowdockerized-redis-mailcow-1      | 755:C 13 Jun 2022 13:12:49.085 * DB saved on disk
mailcowdockerized-redis-mailcow-1      | 755:C 13 Jun 2022 13:12:49.086 * RDB: 0 MB of memory used by copy-on-write
mailcowdockerized-redis-mailcow-1      | 1:M 13 Jun 2022 13:12:49.133 * Background saving terminated with success
mailcowdockerized-nginx-mailcow-1      | 172.22.1.13 - - [13/Jun/2022:13:15:52 +0200] "HEAD /settings.php HTTP/1.1" 304 0 "-" "rspamd-3.2"
mailcowdockerized-nginx-mailcow-1      | 185.40.61.12 - - [13/Jun/2022:13:16:09 +0200] "GET /mailbox HTTP/2.0" 200 231113 "https://mx.XXXXXXXXX.net/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
mailcowdockerized-nginx-mailcow-1      | 185.40.61.12 - - [13/Jun/2022:13:16:13 +0200] "GET /api/v1/get/presets/sieve HTTP/2.0" 200 881 "https://mx.XXXXXXXXX.net/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
mailcowdockerized-nginx-mailcow-1      | 185.40.61.12 - - [13/Jun/2022:13:16:14 +0200] "GET /api/v1/get/passwordpolicy/html HTTP/2.0" 200 86 "https://mx.XXXXXXXXX.net/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
mailcowdockerized-nginx-mailcow-1      | 185.40.61.12 - - [13/Jun/2022:13:16:14 +0200] "GET /api/v1/get/domain/smsnt.net HTTP/2.0" 200 360 "https://mx.XXXXXXXXX.net/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
mailcowdockerized-nginx-mailcow-1      | 185.40.61.12 - - [13/Jun/2022:13:16:14 +0200] "GET /api/v1/get/mailbox/reduced HTTP/2.0" 200 7468 "https://mx.XXXXXXXXX.net/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:15:15.167+02:00  common.go:125 ▶ NOTICE [Job "sogo_sessions" (71ca0e7dd817)] Finished in "161.582519ms", failed: false, skipped: false, error: none
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:15:15.19+02:00  common.go:125 ▶ NOTICE [Job "sogo_ealarms" (745edd59491a)] Finished in "185.104492ms", failed: false, skipped: false, error: none
mailcowdockerized-nginx-mailcow-1      | 172.22.1.8 - - [13/Jun/2022:13:16:20 +0200] "GET / HTTP/1.1" 200 15 "-" "check_http/v (nagios-plugins 2.3.3)"
mailcowdockerized-nginx-mailcow-1      | 172.22.1.13 - - [13/Jun/2022:13:16:23 +0200] "HEAD /settings.php HTTP/1.1" 304 0 "-" "rspamd-3.2"
mailcowdockerized-nginx-mailcow-1      | fd4d:6169:6c63:6f77::11 - - [13/Jun/2022:13:16:31 +0200] "HEAD /forwardinghosts.php HTTP/1.1" 200 0 "-" "rspamd-3.2"
mailcowdockerized-nginx-mailcow-1      | 172.22.1.13 - - [13/Jun/2022:13:16:31 +0200] "GET /forwardinghosts.php HTTP/1.1" 200 42 "-" "rspamd-3.2"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.003+02:00  common.go:125 ▶ NOTICE [Job "dovecot_trim_logs" (bfd449f1547d)] Started - /bin/bash -c "[[ ${MASTER} == y ]] && /usr/local/bin/gosu vmail /usr/local/bin/trim_logs.sh || exit 0"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.004+02:00  common.go:125 ▶ NOTICE [Job "sogo_ealarms" (7f24c6db9df2)] Started - /bin/bash -c "[[ ${MASTER} == y ]] && /usr/local/bin/gosu sogo /usr/sbin/sogo-ealarms-notify -p /etc/sogo/sieve.creds || exit 0"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.005+02:00  common.go:125 ▶ NOTICE [Job "sogo_sessions" (8394f9714548)] Started - /bin/bash -c "[[ ${MASTER} == y ]] && /usr/local/bin/gosu sogo /usr/sbin/sogo-tool expire-sessions ${SOGO_EXPIRE_SESSION} || exit 0"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.005+02:00  common.go:125 ▶ NOTICE [Job "dovecot_imapsync_runner" (e583698f0ef4)] Started - /bin/bash -c "[[ ${MASTER} == y ]] && /usr/local/bin/gosu nobody /usr/local/bin/imapsync_runner.pl || exit 0"
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.109+02:00  common.go:125 ▶ NOTICE [Job "dovecot_trim_logs" (bfd449f1547d)] Finished in "106.245342ms", failed: false, skipped: false, error: none
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.152+02:00  common.go:125 ▶ NOTICE [Job "dovecot_imapsync_runner" (e583698f0ef4)] Finished in "146.708079ms", failed: false, skipped: false, error: none
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.179+02:00  common.go:125 ▶ NOTICE [Job "sogo_ealarms" (7f24c6db9df2)] Finished in "174.853553ms", failed: false, skipped: false, error: none
mailcowdockerized-ofelia-mailcow-1     | 2022-06-13T13:16:15.18+02:00  common.go:125 ▶ NOTICE [Job "sogo_sessions" (8394f9714548)] Finished in "175.401254ms", failed: false, skipped: false, error: none
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:07:56 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.003 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:08:55 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:09:18 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:10:34 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:06 CEST 2022 Dovecot health level: 100% (12/12), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:08 CEST 2022 SOGo health level: 100% (3/3), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:11 CEST 2022 Fail2ban health level: 100% (1/1), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:17 CEST 2022 Clamd health level: 100% (15/15), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:20 CEST 2022 Nginx health level: 100% (5/5), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:25 CEST 2022 Mail queue health level: 100% (20/20), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:26 CEST 2022 MySQL/MariaDB health level: 100% (5/5), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:28 CEST 2022 Olefy health level: 100% (5/5), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:29 CEST 2022 Ratelimit health level: 100% (1/1), health trend: 0
mailcowdockerized-watchdog-mailcow-1   | Mon Jun 13 13:16:33 CEST 2022 Postfix health level: 100% (8/8), health trend: 0
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:11:04 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:12:02 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:13:18 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 12
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:14:18 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.006 - - 0 - 13
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:14:52 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 13
mailcowdockerized-sogo-mailcow-1       | Jun 13 13:16:08 11de7e2211a9 sogod [65]: mailcowdockerized-watchdog-mailcow-1.mailcowdockerized_mailcow-network "GET /SOGo.index/ HTTP/1.1" 200 2586/0 0.002 - - 0 - 13
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.955 INFO  (qtp1399701152-55) [   x:dovecot-fts] o.a.s.u.p.LogUpdateProcessorFactory [dovecot-fts]  webapp=/solr path=/update params={}{add=[239/6e566303795f5d625b340400c5b2faa8/shi_eu@XXXXXXXXX.net (1735492927168184320)]} 0 10
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.958 INFO  (qtp1399701152-20) [   x:dovecot-fts] o.a.s.u.DirectUpdateHandler2 start commit{_version_=1735492927181815808,optimize=false,openSearcher=true,waitSearcher=true,expungeDeletes=false,softCommit=true,prepareCommit=false}
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.965 INFO  (qtp1399701152-20) [   x:dovecot-fts] o.a.s.s.SolrIndexSearcher Opening [Searcher@4dceb991[dovecot-fts] main]
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.966 INFO  (qtp1399701152-20) [   x:dovecot-fts] o.a.s.u.DirectUpdateHandler2 end_commit_flush
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.967 INFO  (searcherExecutor-10-thread-1-processing-x:dovecot-fts) [   x:dovecot-fts] o.a.s.c.SolrCore [dovecot-fts] Registered new searcher Searcher@4dceb991[dovecot-fts] main{ExitableDirectoryReader(UninvertingDirectoryReader(Uninverting(_d1(7.7.3):C345/12:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, mergeMaxNumSegments=2147483647, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=merge, mergeFactor=10, os.version=5.10.0-13-amd64, timestamp=1653930401065}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]:delGen=2) Uninverting(_io(7.7.3):C116:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, mergeMaxNumSegments=2147483647, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=merge, mergeFactor=10, os.version=5.10.0-14-amd64, timestamp=1654996733878}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_ip(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655016671763}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_iq(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655029981921}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_ir(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655032669155}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_is(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655033486375}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_it(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655033748914}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_iu(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655080988870}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_iv(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655082258284}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}]) Uninverting(_iw(7.7.3):C1:[diagnostics={os=Linux, java.vendor=Oracle Corporation, java.version=11.0.14.1, java.vm.version=11.0.14.1+1, lucene.version=7.7.3, os.arch=amd64, java.runtime.version=11.0.14.1+1, source=flush, os.version=5.10.0-14-amd64, timestamp=1655095030963}]:[attributes={Lucene50StoredFieldsFormat.mode=BEST_SPEED}])))}
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:10.968 INFO  (qtp1399701152-20) [   x:dovecot-fts] o.a.s.u.p.LogUpdateProcessorFactory [dovecot-fts]  webapp=/solr path=/update params={}{commit=} 0 11
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:25.955 INFO  (commitScheduler-13-thread-1) [   ] o.a.s.u.DirectUpdateHandler2 start commit{,optimize=false,openSearcher=false,waitSearcher=true,expungeDeletes=false,softCommit=false,prepareCommit=false}
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:25.955 INFO  (commitScheduler-13-thread-1) [   ] o.a.s.u.SolrIndexWriter Calling setCommitData with IW:org.apache.solr.update.SolrIndexWriter@12a77d5d commitCommandVersion:0
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:25.991 INFO  (commitScheduler-13-thread-1) [   ] o.a.s.s.SolrIndexSearcher Opening [Searcher@5b059c19[dovecot-fts] realtime]
mailcowdockerized-solr-mailcow-1       | 2022-06-13 04:37:25.991 INFO  (commitScheduler-13-thread-1) [   ] o.a.s.u.DirectUpdateHandler2 end_commit_flush
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:12:06 #43(controller) <e41c7a>; csession; rspamd_redis_connected: skip obtaining bayes tokens for BAYES_SPAM of classifier bayes: not enough learns 3; 5 required
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:12:06 #43(controller) <e41c7a>; csession; rspamd_protocol_http_reply: regexp statistics: 0 pcre regexps scanned, 0 regexps matched, 3238 regexps total, 2432 regexps cached, 0B scanned using pcre, 102B scanned total
mailcowdockerized-memcached-mailcow-1  | Signal handled: Terminated.
mailcowdockerized-memcached-mailcow-1  | Signal handled: Terminated.
mailcowdockerized-memcached-mailcow-1  | Signal handled: Terminated.
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:12:44 #43(controller) <f39bd0>; csession; rspamd_redis_connected: skip obtaining bayes tokens for BAYES_SPAM of classifier bayes: not enough learns 3; 5 required
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:12:44 #43(controller) <f39bd0>; csession; rspamd_protocol_http_reply: regexp statistics: 0 pcre regexps scanned, 0 regexps matched, 3238 regexps total, 2432 regexps cached, 0B scanned using pcre, 102B scanned total
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:13:48 #43(controller) <d4fc42>; csession; rspamd_redis_connected: skip obtaining bayes tokens for BAYES_SPAM of classifier bayes: not enough learns 3; 5 required
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:13:48 #43(controller) <d4fc42>; csession; rspamd_protocol_http_reply: regexp statistics: 0 pcre regexps scanned, 0 regexps matched, 3238 regexps total, 2432 regexps cached, 0B scanned using pcre, 102B scanned total
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:14:54 #43(controller) <285e52>; csession; rspamd_redis_connected: skip obtaining bayes tokens for BAYES_SPAM of classifier bayes: not enough learns 3; 5 required
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:14:54 #43(controller) <285e52>; csession; rspamd_protocol_http_reply: regexp statistics: 0 pcre regexps scanned, 0 regexps matched, 3238 regexps total, 2432 regexps cached, 0B scanned using pcre, 102B scanned total
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:15:49 #43(controller) <496f12>; csession; rspamd_redis_connected: skip obtaining bayes tokens for BAYES_SPAM of classifier bayes: not enough learns 3; 5 required
mailcowdockerized-rspamd-mailcow-1     | 2022-06-13 13:15:49 #43(controller) <496f12>; csession; rspamd_protocol_http_reply: regexp statistics: 0 pcre regexps scanned, 0 regexps matched, 3238 regexps total, 2432 regexps cached, 0B scanned using pcre, 102B scanned total
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy tmp dir: /tmp
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy python path: /usr/bin/python3
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy olvba path: /usr/bin/olevba
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy log level: 20
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy min file length: 500
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy delete tmp file: 1
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> olefy delete tmp file when failed: 1
mailcowdockerized-olefy-mailcow-1      | /app/olefy.py:203: DeprecationWarning: There is no current event loop
mailcowdockerized-olefy-mailcow-1      |   loop = asyncio.get_event_loop()
mailcowdockerized-olefy-mailcow-1      | olefy INFO <module> serving on ('0.0.0.0', 10055)
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mailcowdockerized-unbound-mailcow-1    | Setup success. Certificates created. Enable in unbound.conf file to use
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: 10.5.16 started; log sequence number 53743506; transaction id 215101
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] Server socket created on IP: '::'.
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 1 [Note] Event Scheduler: scheduler thread started with id 1
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] mysqld: ready for connections.
mailcowdockerized-mysql-mailcow-1      | Version: '10.5.16-MariaDB-1:10.5.16+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
mailcowdockerized-mysql-mailcow-1      | 2022-06-11  0:14:15 0 [Note] InnoDB: Buffer pool(s) load completed at 220611  0:14:15
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:48:44 0914e1995ad5 postfix/postscreen[12804]: warning: dnsblog reply timeout 10s for dnsbl.sorbs.net
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/postscreen[12804]: CONNECT from [212.192.241.71]:60166 to [172.22.1.253]:25
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 whitelist_forwardinghosts: Look up 212.192.241.71 on whitelist, result 200 DUNNO
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/postscreen[12804]: PREGREET 11 after 0.03 from [212.192.241.71]:60166: EHLO User\r\n
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/dnsblog[12812]: addr 212.192.241.71 listed by domain zen.spamhaus.org as 127.0.0.4
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/dnsblog[12818]: addr 212.192.241.71 listed by domain b.barracudacentral.org as 127.0.0.2
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/dnsblog[12816]: addr 212.192.241.71 listed by domain hostkarma.junkemailfilter.com as 127.0.1.1
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:08 0914e1995ad5 postfix/dnsblog[12816]: addr 212.192.241.71 listed by domain hostkarma.junkemailfilter.com as 127.0.0.2
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:09 0914e1995ad5 postfix/postscreen[12804]: DNSBL rank 16 for [212.192.241.71]:60166
mailcowdockerized-postfix-mailcow-1    | Jun 13 12:49:09 0914e1995ad5 postfix/postscreen[12804]: DISCONNECT [212.192.241.71]:60166
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Confirmed AAAA record with IP 2a01:04f9:003a:1e58:0000:0000:0000:0002, but HTTP validation failed
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Found AAAA record for mx.XXXXXXXXX.net: 2a01:4f9:3a:1e58::2 - skipping A record check
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Confirmed AAAA record with IP 2a01:04f9:003a:1e58:0000:0000:0000:0002, but HTTP validation failed
mailcowdockerized-unbound-mailcow-1    | [1654899255] unbound[1:0] notice: init module 0: validator
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Found AAAA record for mail.XXXXXXXXX.net: 2a01:4f9:3a:1e58::2 - skipping A record check
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Confirmed AAAA record with IP 2a01:04f9:003a:1e58:0000:0000:0000:0002, but HTTP validation failed
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Found AAAA record for wm.XXXXXXXXX.net: 2a01:4f9:3a:1e58::2 - skipping A record check
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Confirmed AAAA record with IP 2a01:04f9:003a:1e58:0000:0000:0000:0002, but HTTP validation failed
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Cannot validate any hostnames, skipping Let's Encrypt for 1 hour.
mailcowdockerized-acme-mailcow-1       | Mon Jun 13 12:20:28 CEST 2022 - Use SKIP_LETS_ENCRYPT=y in mailcow.conf to skip it permanently.
mailcowdockerized-acme-mailcow-1       | OK
mailcowdockerized-unbound-mailcow-1    | [1654899255] unbound[1:0] notice: init module 1: iterator
mailcowdockerized-unbound-mailcow-1    | [1654899255] unbound[1:0] info: start of service (unbound 1.15.0).
mailcowdockerized-unbound-mailcow-1    | [1654899257] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-unbound-mailcow-1    | [1654941164] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-unbound-mailcow-1    | [1654981291] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-unbound-mailcow-1    | [1655024182] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-unbound-mailcow-1    | [1655064317] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-unbound-mailcow-1    | [1655103639] unbound[1:0] info: generate keytag query _ta-4f66. NULL IN
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:15:32 +0200 "GET /forwardinghosts.php" 200
mailcowdockerized-php-fpm-mailcow-1    | 172.22.1.4 -  13/Jun/2022:13:15:52 +0200 "HEAD /settings.php" 304
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:16:09 +0200 "GET /mailbox.php" 200
mailcowdockerized-php-fpm-mailcow-1    | 172.22.1.4 -  13/Jun/2022:13:16:13 +0200 "GET /json_api.php" 200
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:16:14 +0200 "GET /json_api.php" 200
mailcowdockerized-php-fpm-mailcow-1    | 172.22.1.4 -  13/Jun/2022:13:16:14 +0200 "GET /json_api.php" 200
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:16:14 +0200 "GET /json_api.php" 200
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:16:23 +0200 "HEAD /settings.php" 304
mailcowdockerized-php-fpm-mailcow-1    | 172.22.1.4 -  13/Jun/2022:13:16:31 +0200 "HEAD /forwardinghosts.php" 200
mailcowdockerized-php-fpm-mailcow-1    | fd4d:6169:6c63:6f77::4 -  13/Jun/2022:13:16:31 +0200 "GET /forwardinghosts.php" 200

Steps to reproduce

Go to mailbox settings then mailboxes list

System information

Question Answer
My operating system Debian 11
Is Apparmor, SELinux or similar active? I_DO_REPLY_HERE
Virtualization technology (KVM, VMware, Xen, etc - LXC and OpenVZ are not supported No
Server/VM specifications (Memory, CPU Cores) 12 cores and 64Gb RAM
Docker version (docker version) 20.10.17, build 100c701
docker-compose version (docker-compose version) docker-compose version 1.29.2, build 5becea4c

docker-py version: 5.0.0 CPython version: 3.7.10 OpenSSL version: OpenSSL 1.1.0l 10 Sep 2019 | | mailcow version (git describe --tags `git rev-list --tags --max-count=1`) |2022-06 63f7181 | | Reverse proxy (custom solution) | No |

mritzmann commented 2 years ago

Are errors displayed in the Developer Tools (for e.g. Chrome or Firefox)?

JlNiko commented 2 years ago

In the dev tools thé réponse IS 200 and all thé mailboxes are listed. But athe end there IS an error with Reading passwd_update signal-2022-06-16-14-04-52-911

JlNiko commented 2 years ago

Hello, I found the error. a 'null' record was created in the user table. I tried to manage to show the mailbox list in removing the line 425 to 451 of the mailbox.js file. Now i have to find a way to remove the null record for allowing us to see the mailboxes as a good a way. Does anyone can I help me for removing the record? May be the record, is a result of a not well deleted user. Thank you

JlNiko commented 2 years ago

Hello, Does anyone can give the way to connect to Mysql for removing the "null" user? Thank you

MAGICCC commented 2 years ago

You can use following to connect to mysql

source mailcow.conf
docker-compose exec mysql-mailcow mysql -u${DBUSER} -p${DBPASS} ${DBNAME}

and then you can use mysql commands

JlNiko commented 2 years ago

Hello, Thank you for your answer. i checked but no empty entry in the database mailbox. maybe I have to chek over why i got an empty entry in the table . image

milkmaker commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.