1 (edited by murali 2021-01-02 20:59:43)

Topic: frequent internal server error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer?downloadable installer
- Linux/BSD distribution name and version: Debian 10
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginix
- Manage mail accounts with iRedAdmin-Pro?iRedAdmin-Pro 4.7
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

We have installed  iRedAdmin-Pro-SQL-4.7 and now frequently we are facing the issue of  internal server error while accessing admin panel and at the same  mail server stops working. We have to manually restart dovecot service then it starts working. We dont know why and when it stops working. Posting below the dovecot log.
Jan  2 14:53:36 mail dovecot: dict(27520): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27520): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27521): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27522): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27522): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27522): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27523): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27523): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27523): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry
Jan  2 14:53:36 mail dovecot: dict(27525): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry

We have created some email ids with custom path and some ids with default path. Please help me to resolve the issue.

Regards
Murali

2

Re: frequent internal server error

Attached the error maillog

Post's attachments

error_maillog 49.34 kb, 1 downloads since 2021-01-04 

You don't have the permssions to download the attachments of this post.

3

Re: frequent internal server error

attached dovecot log at the time of error

Post's attachments

dovecot_error_log 7.25 kb, 1 downloads since 2021-01-04 

You don't have the permssions to download the attachments of this post.

4

Re: frequent internal server error

murali wrote:

Jan  2 14:53:36 mail dovecot: dict(27525): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry

It's quite clear here. You need to increase the "max_connections" setting in MySQL config file in /etc/mysql/my.cnf, under "[mysqld]" section.

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

5

Re: frequent internal server error

ZhangHuangbin wrote:
murali wrote:

Jan  2 14:53:36 mail dovecot: dict(27525): Error: mysql(127.0.0.1): Connect failed to database (vmail): Too many connections - waiting for 625 seconds before retry

It's quite clear here. You need to increase the "max_connections" setting in MySQL config file in /etc/mysql/my.cnf, under "[mysqld]" section.



There is no section by name mysqld in  /etc/mysql/my.cnf . Shall add the max_connection any where in the file?

Thanks & Regards
Murali.S

6

Re: frequent internal server error

On Debian 10, it should be /etc/mysql/mariadb.cnf, which is also linked to /etc/mysql/my.cnf.

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee