Aug 5, 2024: iRedMail-1.7.1 has been released.

**veldsink** · 2011-02-03 16:03:41

veldsink
Member
Offline

Registered: 2010-04-09
Posts: 50

Topic: whitelist / blacklist internal server error

After upgrading iredadmin to version 1.4.0 I get an internal server error when opening the whitelist or blacklist under system.

I also get a lot of messages in the logwatch

Here are a few examples:

(!!)ERROR sql_storage: too many retries on storing final, info not saved: 963 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-DKwgv48KiL5D-0' for key 1 at (eval 98) line 166, <GEN14> line 60097.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-PKcGTtGKv6PG-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-ox3zi8NSzMFQ-0' for key 1 at (eval 98) line 166, <GEN14> line 9051.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qEkKIHdc47fV-0' for key 1 at (eval 98) line 166, <GEN14> line 58438.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-O8MGoXJPWMgK-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-Lb9thTCrPkWL-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-zS2ztH0NMVl5-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SY362HIHlYH1-0' for key 1 at (eval 98) line 166, <GEN14> line 4071.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-npIY5+KDmoY6-0' for key 1 at (eval 98) line 166, <GEN14> line 40790.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-JbpUrf7uUitB-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-J9K528lFyqdi-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-8+n4Z-O-rMyn-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qDXW+q-y6ENo-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SNyRxV-olHgu-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-8xrGm44kPQvx-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-kILAaqQqk8ax-0' for key 1 at (eval 98) line 166, <GEN14> line 764.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-MuQi9GiD+6+D-0' for key 1 at (eval 98) line 166, <GEN14> line 17012.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-4ZfURWTbpjdY-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-uR+jr1+-a2-P-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-DwFmq0pEaN1K-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-BLfQWcx2lWI8-0' for key 1 at (eval 98) line 166, <GEN14> line 9092.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-R2FixD1eEnyb-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-tNViAE8ZsjKM-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-xXOYEqMpP1ql-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-u8zbMNPT3NQU-0' for key 1 at (eval 98) line 166, <GEN14> line 3194.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-UTYCNnLg8QDN-0' for key 1 at (eval 98) line 166, <GEN14> line 5098.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qJ0q2vKl0J8y-0' for key 1 at (eval 98) line 166, <GEN14> line 99421.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-Hw+IfT1TzsxV-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-dElMoJhvWY1O-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-xWCpnX4EyVjF-0' for key 1 at (eval 98) line 166.: 5 Time(s)

----

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

**ZhangHuangbin** · 2011-02-03 17:15:28

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

Seems your server is busy. Try to increase max connections of mysql in /etc/my.cnf (search 'max_connections' in this file), restart mysql service, and it should fix this issue.

**veldsink** · 2011-02-03 18:19:28

veldsink
Member
Offline

Registered: 2010-04-09
Posts: 50

Re: whitelist / blacklist internal server error

max_connections is not set in this file. is there a default for this variable?

Is this also the reason for the internal server error?

I also found out that I'm unable to open de catch-all option with a domain. I get the message permission denied.

**ZhangHuangbin** · 2011-02-03 21:30:37

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

You can add below settings in section [mysqld]:

set-variable = max_connections=1024

**jackwjy** · 2011-02-08 08:59:46

jackwjy
Member
Offline

Registered: 2010-04-28
Posts: 19

Re: whitelist / blacklist internal server error

I have same error message after set-variable = max_connections=1024

**Unmatched Entries**
(!!)ERROR sql_storage: too many retries on storing final, info not saved: 125 Time(s)
(!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-wHSOCS5bMaxe-0' for key 1 at (eval 102) line 166, <GEN15> line 16070.: 5 Time(s)
(!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SmHamhrlQMkO-0' for key 1 at (eval 102) line 166, <GEN15> line 62077.: 5 Time(s)
(!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-wh-0YfMjFicK-0' for key 1 at (eval 102) line 166, <GEN15> line 88877.: 5 Time(s)
(!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-ySphir7txVU2-0' for key 1 at (eval 102) line 166, <GEN15> line 235068.: 5 Time(s)

**ZhangHuangbin** · 2011-02-08 09:12:59

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

Try to increase max connections to 2048 or even larger.

**jackwjy** · 2011-02-08 21:01:20

jackwjy
Member
Offline

Registered: 2010-04-28
Posts: 19

Re: whitelist / blacklist internal server error

ZhangHuangbin wrote:

Try to increase max connections to 2048 or even larger.

I'd increase max connections, but it's seems white-list & blacklist doesn't working now.
anywhere to troubleshoot it ?

**ZhangHuangbin** · 2011-02-08 22:27:15

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

jackwjy wrote:

I'd increase max connections, but it's seems white-list & blacklist doesn't working now.

What do you mean it doesn't work? Any related apache log?

**jackwjy** · 2011-02-10 23:57:55

jackwjy
Member
Offline

Registered: 2010-04-28
Posts: 19

Re: whitelist / blacklist internal server error

sample: I add @message.cmbchina.com to sender white-list,

but mail from @message.cmbchina.com still appear in Quarantined list

**veldsink** · 2011-02-14 16:56:08

veldsink
Member
Offline

Registered: 2010-04-09
Posts: 50

Re: whitelist / blacklist internal server error

I still can't open the whitelist or blacklist.

I also still get the "unmatched entries"errors.

**ZhangHuangbin** · 2011-02-14 18:24:12

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

veldsink wrote:

I also still get the "unmatched entries"errors.

Where did you get this error message? Any other related log?

**veldsink** · 2011-02-14 19:33:54

veldsink
Member
Offline

Registered: 2010-04-09
Posts: 50

Re: whitelist / blacklist internal server error

I have this message in the logwatch.

**ZhangHuangbin** · 2011-02-14 19:39:47

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

Did you try to increase mysql max_connections setting?
If it still happens, you have to disable it in Amavisd (@storage_sql_dsn).

**veldsink** · 2011-02-16 16:38:21

veldsink
Member
Offline

Registered: 2010-04-09
Posts: 50

Re: whitelist / blacklist internal server error

I had increased the mysql max_connections setting to 2048.

Now I have disabled it in Amavisd

**ZhangHuangbin** · 2011-02-18 00:27:31

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,134

Re: whitelist / blacklist internal server error

veldsink wrote:

(!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qEkKIHdc47fV-0' for key 1 at (eval 98) line 166, <GEN14> line 58438.: 5 Time(s)

Solved:
http://www.iredmail.org/forum/topic1677 … issue.html

Aug 5, 2024: iRedMail-1.7.1 has been released.

whitelist / blacklist internal server error

Posts: 15

1 Topic by veldsink 2011-02-03 16:03:41

Topic: whitelist / blacklist internal server error

2 Reply by ZhangHuangbin 2011-02-03 17:15:28

Re: whitelist / blacklist internal server error

3 Reply by veldsink 2011-02-03 18:19:28 (edited by veldsink 2011-02-03 18:20:15)

Re: whitelist / blacklist internal server error

4 Reply by ZhangHuangbin 2011-02-03 21:30:37

Re: whitelist / blacklist internal server error

5 Reply by jackwjy 2011-02-08 08:59:46

Re: whitelist / blacklist internal server error

6 Reply by ZhangHuangbin 2011-02-08 09:12:59

Re: whitelist / blacklist internal server error

7 Reply by jackwjy 2011-02-08 21:01:20

Re: whitelist / blacklist internal server error

8 Reply by ZhangHuangbin 2011-02-08 22:27:15

Re: whitelist / blacklist internal server error

9 Reply by jackwjy 2011-02-10 23:57:55

Re: whitelist / blacklist internal server error

10 Reply by veldsink 2011-02-14 16:56:08

Re: whitelist / blacklist internal server error

11 Reply by ZhangHuangbin 2011-02-14 18:24:12

Re: whitelist / blacklist internal server error

12 Reply by veldsink 2011-02-14 19:33:54

Re: whitelist / blacklist internal server error

13 Reply by ZhangHuangbin 2011-02-14 19:39:47

Re: whitelist / blacklist internal server error

14 Reply by veldsink 2011-02-16 16:38:21

Re: whitelist / blacklist internal server error

15 Reply by ZhangHuangbin 2011-02-18 00:27:31

Re: whitelist / blacklist internal server error

Posts: 15