1 Topic by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Topic: Error when update user

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail 1.6.1 
- Downloadable installer
- Debian 11.5
- LDAP backend
- Web server Nginx
- Manage mail accounts with iRedAdmin-Pro
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

We migrate iremail from CentOS 7 to Debian 11.5 (following docs.iredmail.org/migrate.to.new.iredmail.server.html). We upgrade iredadmin to last version (5.3). It's all working good, except when we try do edit some attributes from user (General tab) it gives the error:

Error: TYPE_OR_VALUE_EXISTS({'desc': 'Type or value exists', 'info': 'modify/add: member: value #0 already exists'})

What this can do? Nghinx log and openldap.log show nothing.

UPDATE:

When I restart the service "iredadmin" it works for a short time!

Thanks.

----

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

dsti's Website

2 Reply by ZhangHuangbin

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

Re: Error when update user

dsti wrote:

when we try do edit some attributes from user (General tab) it gives the error:

Which attribute / profile did you edit to trigger the error?

3 Reply by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

Sep 22 18:22:18 email slapd[489766]: conn=1001 fd=15 ACCEPT from IP=127.0.0.1:54756 (IP=0.0.0.0:389)
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=0 BIND dn="cn=vmailadmin,dc=**DELETED**" method=128
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=0 BIND dn="cn=vmailadmin,dc=**DELETED**" mech=SIMPLE ssf=0
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=0 RESULT tag=97 err=0 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=1 SRCH base="domainName=dominio.ufrj.br,o=domains,dc=**DELETED**" scope=0 deref=0 filter="(objectClass=*)"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=1 SRCH attr=accountSetting
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=2 SRCH base="mail=fcaseiro@dominio.ufrj.br,ou=Users,domainName=dominio.ufrj.br,o=domains,dc=**DELETED**" scope=0 deref=0 filter="(&(objectClass=mailUser)(mail=fcaseiro@dominio.ufrj.br))"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=2 SRCH attr=mail cn uid accountStatus mailQuota employeeNumber title senderRelayHost shadowAddress mailForwardingAddress memberOfGroup enabledService disabledService domainGlobalAdmin shadowLastChange sn givenName uid mobile telephoneNumber preferredLanguage memberOfGroup userRecipientBccAddress userSenderBccAddress mailForwardingAddress mtaTransport storageBaseDirectory mailMessageStore homeDirectory accountSetting allowNets street postalCode postalAddress
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=2 SEARCH RESULT tag=101 err=0 nentries=1 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=3 SRCH base="ou=Users,domainName=dominio.ufrj.br,o=domains,dc=**DELETED**" scope=2 deref=0 filter="(objectClass=mailUser)"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=3 SRCH attr=mailQuota
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=3 SEARCH RESULT tag=101 err=0 nentries=389 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=4 SRCH base="mail=fcaseiro@dominio.ufrj.br,ou=Users,domainName=dominio.ufrj.br,o=domains,dc=**DELETED**" scope=0 deref=0 filter="(mail=fcaseiro@dominio.ufrj.br)"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=4 SRCH attr=mailQuota
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=4 SEARCH RESULT tag=101 err=0 nentries=1 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=5 SRCH base="o=domains,dc=**DELETED**" scope=2 deref=0 filter="(&(objectClass=mailList)(|(mail=lista@dominio.ufrj.br)(shadowAddress=lista@dominio.ufrj.br)))"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=5 SRCH attr=mail shadowAddress
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=5 SEARCH RESULT tag=101 err=0 nentries=1 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=6 SRCH base="o=domains,dc=**DELETED**" scope=2 deref=0 filter="(&(&(objectClass=mailList)(enabledService=mlmmj))(|(mail=lista@dominio.ufrj.br)(shadowAddress=lista@dominio.ufrj.br)))"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=6 SRCH attr=mail shadowAddress
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=6 SEARCH RESULT tag=101 err=0 nentries=1 text=
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=7 MOD dn="mail=lista@dominio.ufrj.br,ou=Groups,domainName=dominio.ufrj.br,o=domains,dc=**DELETED**"
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=7 MOD attr=member
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=7 RESULT tag=103 err=20 text=modify/add: member: value #0 already exists
Sep 22 18:22:18 email slapd[489766]: conn=1001 op=8 UNBIND
Sep 22 18:22:18 email slapd[489766]: conn=1001 fd=15 closed

dsti's Website

4 Reply by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

I have posted the log above. The problem appears to be the mailing list integration.

dsti's Website

5 Reply by ZhangHuangbin

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

Re: Error when update user

Does restarting mlmmjadmin service fix the issue?

6 Reply by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

ZhangHuangbin wrote:

Does restarting mlmmjadmin service fix the issue?

No. sad

dsti's Website

7 Reply by ZhangHuangbin

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

Re: Error when update user

- How can i reproduce this issue? Please give me a step-by-step instruction.
- Did you update any LDAP data during migration?

8 Reply by yavuzmaslak

  • yavuzmaslak
  • Member
  • Offline
  • Registered: 2020-06-10
  • Posts: 8

Re: Error when update user

ZhangHuangbin wrote:

- How can i reproduce this issue? Please give me a step-by-step instruction.
- Did you update any LDAP data during migration?

Is there any solution about that ?

9 Reply by dsti (edited by dsti 2023-01-26 21:18:48)

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

ZhangHuangbin wrote:

- How can i reproduce this issue? Please give me a step-by-step instruction.
- Did you update any LDAP data during migration?

Hi, the error still occurs. It occurs on page that edit account profile "Profile of user: xyz". I don't did any update during data migration.

dsti's Website

10 Reply by ZhangHuangbin

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

Re: Error when update user

No any related log in files listed below?

- /var/log/maillog
- /var/log/mlmmjadmin/mlmmjadmin.log
- /var/log/nginx/*.log

11 Reply by dsti (edited by dsti 2023-01-30 22:45:58)

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

In /var/log/mlmmjadmin/mlmmjadmin.log I got:

an 30 11:37:21 email mlmmjadmin: [127.0.0.1] GET /api/subscriber/EMAIL/subscribed?query_all_lists=no&email_only=no 200 137 "-"
Jan 30 11:40:39 email mlmmjadmin: [127.0.0.1] GET /api/subscriber/EMAIL/subscribed?query_all_lists=no&email_only=yes 200 101 "-"
Jan 30 11:40:40 email mlmmjadmin: [127.0.0.1] GET /api/subscriber/EMAIL/subscribed?query_all_lists=no&email_only=no 200 137 "-"

dsti's Website

12 Reply by ZhangHuangbin

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

Re: Error when update user

Did you ever modify LDAP data without iRedAdmin-Pro?

13 Reply by dsti (edited by dsti 2023-02-16 00:59:33)

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

Yes. I yet modified parameters with ldapmodify. I tested here, if I demark all lists the error not occurs. When I set some list again, not occurs. But in sequence, if I try to edit some field again this error occurs.

dsti's Website

14 Reply by ZhangHuangbin

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

Re: Error when update user

dsti wrote:

Yes. I yet modified parameters with ldapmodify.

What did you modify?

15 Reply by dsti (edited by dsti 2023-02-23 03:50:21)

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

ZhangHuangbin wrote:
dsti wrote:

Yes. I yet modified parameters with ldapmodify.

What did you modify?

Often I use to modify ldap quota of a user, I made a file like:

---
dn: mail=xxx@xxx.br,ou=Users,domainName=xxx.br,o=domains,dc=vmail,dc=etc
changetype: modify
replace: mailQuota
mailQuota: 1073741824

dn: mail=yyy@yyy.br,ou=Users,domainName=yyy.br,o=domains,dc=vmail,dc=etc
changetype: modify
replace: mailQuota
mailQuota: 1073741824
---

Then I ran ldapmodify

dsti's Website

16 Reply by ZhangHuangbin

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

Re: Error when update user

dsti wrote:

Error: TYPE_OR_VALUE_EXISTS({'desc': 'Type or value exists', 'info': 'modify/add: member: value #0 already exists'})

Updating mailQuota with ldapmodify should be fine and not cause above error.
I wonder whether you updated any other attributes too?

17 Reply by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

ZhangHuangbin wrote:
dsti wrote:

Error: TYPE_OR_VALUE_EXISTS({'desc': 'Type or value exists', 'info': 'modify/add: member: value #0 already exists'})

Updating mailQuota with ldapmodify should be fine and not cause above error.
I wonder whether you updated any other attributes too?

No.

dsti's Website

18 Reply by ZhangHuangbin

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

Re: Error when update user

Cannot figure it out with posted log or info. Direct ssh access with full root privilege is required for further debug. smile

19 Reply by dsti

  • dsti
  • Member
  • Offline
  • From: Brasil
  • Registered: 2022-09-20
  • Posts: 11

Re: Error when update user

ZhangHuangbin wrote:

Cannot figure it out with posted log or info. Direct ssh access with full root privilege is required for further debug. smile

how do we accomplish this?

dsti's Website

20 Reply by ZhangHuangbin

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

Re: Error when update user

I need direct ssh access with root privilege, also an admin account used to reproduce the issue.

Note: if it's a bug of iRedAdmin-Pro, it will be free, but if it's caused by incorrect / improper LDAP data added/modified manually (without iRedAdmin-Pro), we will charge one support ticket ($149). Is it ok for you? Contact us: https://www.iredmail.org/contact.html