1 Topic by selea (edited by selea 2018-05-26 03:33:41)

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Topic: Unable to create list in mlmmjadmin

==== Required information ====
- iRedMail version: 0.9.8
- Linux/BSD distribution name and version: Ubuntu 14.04
- Store mail accounts in which backend: mySQL
- Web server: Apache
====

I recently upgrade to the latest version on iRedmail, and the new core component mlmmjadmin was also installed in the process. Due to the fact that I use Ubuntu 14.04 I had some problems.

Anyway, when I try to create a mailinglist, I am greeted with the following:

╰─➤  python maillist_admin.py create announce@lists.linux.pizza      
Traceback (most recent call last):
  File "maillist_admin.py", line 14, in <module>
    from libs.utils import is_email
  File "/opt/mlmmjadmin-1.3/tools/../libs/utils.py", line 11, in <module>
    import settings
  File "/opt/mlmmjadmin-1.3/tools/../settings.py", line 44
    api_auth_tokens = [2d78697fhjrjsrjsrjr86e1]
                                                      ^
SyntaxError: invalid syntax

Clues? smile

----

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

2 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: Unable to create list in mlmmjadmin

selea wrote:

==== Required information ====
- iRedMail version: 0.9.8
- Linux/BSD distribution name and version: Ubuntu 14.04
- Store mail accounts in which backend: mySQL
- Web server: Apache
====

I recently upgrade to the latest version on iRedmail, and the new core component mlmmjadmin was also installed in the process. Due to the fact that I use Ubuntu 14.04 I had some problems.

Anyway, when I try to create a mailinglist, I am greeted with the following:

╰─➤  python maillist_admin.py create announce@lists.linux.pizza      
Traceback (most recent call last):
  File "maillist_admin.py", line 14, in <module>
    from libs.utils import is_email
  File "/opt/mlmmjadmin-1.3/tools/../libs/utils.py", line 11, in <module>
    import settings
  File "/opt/mlmmjadmin-1.3/tools/../settings.py", line 44
    api_auth_tokens = [2d78697fhjrjsrjsrjr86e1]
                                                      ^
SyntaxError: invalid syntax

Clues? smile

I am stupid, I forgot the quotes!

But I got greeted with another message:

 disable_archive=no
Traceback (most recent call last):
  File "maillist_admin.py", line 135, in <module>
    _json = r.json()
  File "/usr/lib/python2.7/dist-packages/requests/models.py", line 741, in json
    return json.loads(self.text, **kwargs)
  File "/usr/lib/python2.7/json/__init__.py", line 338, in loads
    return _default_decoder.decode(s)
  File "/usr/lib/python2.7/json/decoder.py", line 366, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/usr/lib/python2.7/json/decoder.py", line 384, in raw_decode
    raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Unable to create list in mlmmjadmin

Any related error in /var/log/mlmmjadmin/mlmmjadmin.log, or /var/log/syslog?
If nothing, try this:

- Stop mlmmjadmin service
- Run it on console manually:

cd /opt/mlmmjadmin/
python mlmmjadmin.py

- Login to iRedAdmin-Pro and trigger same issue. The console must have some error message related to the error, please paste it here.

4 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: Unable to create list in mlmmjadmin

ZhangHuangbin wrote:

Any related error in /var/log/mlmmjadmin/mlmmjadmin.log, or /var/log/syslog?
If nothing, try this:

- Stop mlmmjadmin service
- Run it on console manually:

cd /opt/mlmmjadmin/
python mlmmjadmin.py

- Login to iRedAdmin-Pro and trigger same issue. The console must have some error message related to the error, please paste it here.

Thans for your answer
There is 0 information in the syslog actually.

When I tried to stop the service, and ran i manually as you suggested I do get a message "Error: ALREADY_EXIST"
When I tried to delete the mailing list, I am greeted with this: "1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)

When I then use the exact same credentials that is located in /opt/mlmmjadmin/settings.py, I can login directly to the database. The same problem persist even if I use a new mySQL user with full privileges to access the vmail database.


Unfortunately, I do not have iRedAdmin-Pro yet, but I hope that I can buy in the coming years.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Unable to create list in mlmmjadmin

selea wrote:

When I tried to delete the mailing list, I am greeted with this: "1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)

Try to set the sql server address to '127.0.0.1' instead of 'localhost' in /opt/mlmmjadmin/settings.py.

selea wrote:

Unfortunately, I do not have iRedAdmin-Pro yet, but I hope that I can buy in the coming years.

mlmmj & mlmmjadmin work fine without iRedAdmin-Pro.

6 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: Unable to create list in mlmmjadmin

Try to set the sql server address to '127.0.0.1' instead of 'localhost' in /opt/mlmmjadmin/settings.py.

It already was defined by default


I am out of ideas smile Maybe it will work better when I upgrade the server to 16.04

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Unable to create list in mlmmjadmin

ok, let's treat it as a new issue, what's the error message now?
Could you try steps listed here?
https://forum.iredmail.org/post63172.html#p63172

Try to trigger the issue again, and mlmmjadmin will log some error message on console. I need the log on console when you start mlmmjadmin manually.

8 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: Unable to create list in mlmmjadmin

Please see attached image.
The user has full access to the database. And I can login with the same credentials define in settings.py.

PunBB bbcode test

9 Reply by selea

  • selea
  • selea
  • Member
  • Offline
  • Registered: 2017-06-02
  • Posts: 111

Re: Unable to create list in mlmmjadmin

@ZhangHuangbin

I noted in another thread that you fixed a bug related to mlmmjadmin? Does this issue have something to do with it?

10 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Unable to create list in mlmmjadmin

hi @selea,

You can try to upgrade to the latest mlmmjadmin-1.4:
https://github.com/iredmail/mlmmjadmin/ … UPGRADE.md