1 Topic by Jochie

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Topic: Mailinglist error - Permission denied [MySQL]

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.0
- Deployed with iRedMail Easy or the downloadable installer?  Downloadable installer
- Linux/BSD distribution name and version: Ubuntu 20
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? yes.
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Similar to the LDAP issue, i have the same problem. Permission denied, but under MySQL.
See attached file.

How to resolve this? Thanks in advance.

Post's attachments

2021-04-19 23_04_28-Window.jpg 109.38 kb, file has never been downloaded. 

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

----

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,082

Re: Mailinglist error - Permission denied [MySQL]

So sorry about this trouble, i didn't make the patch for SQL edition yesterday.
Here it is:

diff --git a/libs/sqllib/ml.py b/libs/sqllib/ml.py
index b2a64048..b56c108e 100644
--- a/libs/sqllib/ml.py
+++ b/libs/sqllib/ml.py
@@ -620,7 +620,7 @@ def update(mail, profile_type, form, conn=None):
 
     elif profile_type == 'owners':
         # Do not allow mailing list owner / moderator to update owner/moderators.
-        if session.get('is_global_admin') or session.get('is_normal_admin'):
+        if not (session.get('is_global_admin') or session.get('is_normal_admin')):
             return (False, "PERMISSION_DENIED")
 
         kvs = {}

3 Reply by Jochie

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Re: Mailinglist error - Permission denied [MySQL]

Sorry Zhang, i must be doing something wrong :

root@mail.doma.in:~# diff --git
diff: unrecognized option '--git'
diff: Try 'diff --help' for more information.
root@mail.doma.in:~#

4 Reply by ZhangHuangbin

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

Re: Mailinglist error - Permission denied [MySQL]

Better contact us to get a patched version: https://www.iredmail.org/contact.html
i didn't find your forum email address in our license database.

5 Reply by Jochie

  • Jochie
  • Jochie
  • Member
  • Offline
  • Registered: 2010-09-23
  • Posts: 100

Re: Mailinglist error - Permission denied [MySQL]

Hi Zhang,

I've updated my email addresss and sent out an email to support as well.
Thanks in advance.

Cheers,

J