1 Topic by liom_chins

  • liom_chins
  • Member
  • Offline
  • Registered: 2020-03-27
  • Posts: 2

Topic: iredmail出现大量循环错误，WebUI无法登陆

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.1
- Deployed with iRedMail Easy or the downloadable installer? 由0.98 upgrade 1.1
- Linux/BSD distribution name and version: Ubuntu 18.044 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
之前一直正常，从0.98升级至1.1也正常。

昨天中午开始WebUI登录显示
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

syslog记录错误
mx roundcube: <nfam3om3> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away in /opt/www/roundcubemail-1.3.6/program/lib/Roundcube/rcube_db.php on line 175 (GET /mail/)
mx roundcube: <nfam3om3> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away (GET /mail/)
另有大量循环错误
mx postfix/cleanup[2948]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@xxx.com"
mx postfix/cleanup[2948]: warning: 628465C0C8D: sender_bcc_maps map lookup problem -- message not accepted, try again later
mx postfix/pickup[2469]: warning: maildrop/C67E45C356A: error writing 628465C0C8D: queue file write error

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iredmail出现大量循环错误，WebUI无法登陆

liom_chins wrote:

mx roundcube: <nfam3om3> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away (GET /mail/)

mysql 服务没运行。

3 Reply by liom_chins

  • liom_chins
  • Member
  • Offline
  • Registered: 2020-03-27
  • Posts: 2

Re: iredmail出现大量循环错误，WebUI无法登陆

ZhangHuangbin wrote:
liom_chins wrote:

mx roundcube: <nfam3om3> DB Error: SQLSTATE[HY000] [2006] MySQL server has gone away (GET /mail/)

mysql 服务没运行。

MySQL启动运行中
mysql/error.log
2020-03-27T01:43:59.262287Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1) starting as process 1076 ...
2020-03-27T01:43:59.367325Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-03-27T01:43:59.367360Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-27T01:43:59.367372Z 0 [Note] InnoDB: Uses event mutexes
2020-03-27T01:43:59.367382Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-27T01:43:59.367393Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-27T01:43:59.367403Z 0 [Note] InnoDB: Using Linux native AIO
2020-03-27T01:43:59.368077Z 0 [Note] InnoDB: Number of pools: 1
2020-03-27T01:43:59.368828Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-03-27T01:43:59.371695Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-27T01:43:59.529227Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-27T01:43:59.766046Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-03-27T01:43:59.899801Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-27T01:44:00.311831Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-27T01:44:00.366905Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-27T01:44:00.734257Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-27T01:44:00.736064Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-27T01:44:00.736085Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-27T01:44:00.736913Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-27T01:44:00.788027Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 6036940105
2020-03-27T01:44:00.788291Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-03-27T01:44:00.878233Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200327  9:44:00
2020-03-27T01:44:00.886666Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-27T01:44:01.092405Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-03-27T01:44:01.092434Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-03-27T01:44:01.094057Z 0 [Warning] CA certificate ca.pem is self signed.
2020-03-27T01:44:01.094138Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-03-27T01:44:01.094623Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-27T01:44:01.094645Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-03-27T01:44:01.094689Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-27T01:44:01.192078Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-27T01:44:01.194086Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-03-27T01:44:06.609451Z 2 [Note] Access denied for user 'stats'@'localhost' (using password: YES)
2020-03-27T01:44:06.611606Z 3 [Note] Access denied for user 'admin'@'localhost' (using password: YES)

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iredmail出现大量循环错误，WebUI无法登陆

现在的错误信息是什么？