1

Topic: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Dear all,

iRedAdmin-Pro-MySQL-1.9.2 (a.k.a. iRedAdmin-Pro for MySQL and MariaDB backends) is now available for your upgrading and purchasing. This is a bugfix release.

Download the latest iRedAdmin-Pro

All customers can get download link of this new release with below steps if you have iRedAdmin-Pro-MySQL-1.4.0 or later releases installed:

  • Login to iRedAdmin-Pro as global admin

  • Click "License" on the top-right corner, it will show you basic license info and a "Download" button if new version is available for upgrading.

If you're running older release, please mail to support @ iredmail.org to get download link of the latest release.

Full changes since iRedAdmin-Pro-MySQL-1.9.1:
    * Improvements:
        - Log message after updated mail list members/moderators.
        - Able to use '*@domain.com' as moderator of mail alias account.
          Note: this requires iRedAPD-1.4.5.
        - New script tool: migrate_cluebringer_wblist_to_amavisd.py.
          Used to migrate Cluebringer white/blacklists to Amavisd database.

          Note: Don't forget to enable iRedAPD plugin `amavisd_wblist` in
          /opt/iredapd/settings.py.

    * Fixed issues:
        - Cannot delete mail alias account.
        - Cannot display all domains in user profile page.
        - Not wrap subject/sender/recipient in Sent/Received Mails page.
        - Cannot correctly delete all Sent/Received mails in SQL database.
        - Not correctly handle SQL column `policy.spam_subject_tag3` while
          updating spam policy. This column doesn't exist in Amavisd-new-2.6.x.
        - Cannot remove existing white/blacklists.
        - Upgrading script (tools/upgrade_iredadmin.sh) should restart uwsgi
          sesrvice instead of nginx if Nginx is running as web server.
        - Not save 'Always insert X-Spam-* headers' setting in 'Global Spam
          Policy' page.
        - Show improper links in self-service spam policy page.
        - 'INNER JOIN' in tools/cleanup_amavisd_db.py causes performance
          issue while removing old records in amavisd database.

    * Updated translations:
        + Spain (es_ES).
          Thanks informatica _at_ ttu.es.

----

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

2

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Hi,

Where can I find iRedAPD-1.4.5 ?

On https://bitbucket.org/zhb/iredapd/downloads I can only find v. 1.4.4

3

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

iRedAPD-1.4.5 is not yet released. but if you want to use '*@domain.com' as moderator of mailing list/alias, you can download plugin 'sql_alias_access_policy.py' from source code repository directly, then override file /opt/iredapd/plugins/sql_alias_access_policy.py on your server.
https://bitbucket.org/zhb/iredapd/src/d … at=default

WARNING: you must be running iRedAPD-1.4.4, otherwise plugin will not work.

4

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

After upgrade I get an error when I try to access https://ireadminhosting.com/aliases/domainhosted.com

internal server error

In logs (apache error for vhost)

 Traceback (most recent call last):
   File "/usr/lib/python2.7/dist-packages/web/application.py", line 239, in process
     return self.handle()
   File "/usr/lib/python2.7/dist-packages/web/application.py", line 230, in handle
     return self._delegate(fn, self.fvars, args)
   File "/usr/lib/python2.7/dist-packages/web/application.py", line 420, in _delegate
     return handle_class(cls)
   File "/usr/lib/python2.7/dist-packages/web/application.py", line 396, in handle_class
     return tocall(*args)
   File "/usr/share/apache2/iredadmin/controllers/decorators.py", line 22, in proxyfunc
     return func(self, *args, **kw)
   File "/usr/share/apache2/iredadmin/controllers/mysql/alias.py", line 39, in GET
     msg=web.input().get('msg', None),
   File "/usr/share/apache2/iredadmin/libs/iredbase.py", line 199, in render_template
     return jinja_env.get_template(template_name).render(context)
   File "/usr/lib/python2.7/dist-packages/jinja2/environment.py", line 791, in get_template
     return self._load_template(name, self.make_globals(globals))
   File "/usr/lib/python2.7/dist-packages/jinja2/environment.py", line 765, in _load_template
     template = self.loader.load(self, name, globals)
   File "/usr/lib/python2.7/dist-packages/jinja2/loaders.py", line 113, in load
     source, filename, uptodate = self.get_source(environment, name)
   File "/usr/lib/python2.7/dist-packages/jinja2/loaders.py", line 178, in get_source
     raise TemplateNotFound(template)
 TemplateNotFound: pgsql/alias/list.html

5

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

swaclawski wrote:

     raise TemplateNotFound(template)
TemplateNotFound: pgsql/alias/list.html

Do you have file /usr/share/apache2/iredadmin/templates/default/pgsql/alias/list.html?

6

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Oops, confirmed it's a bug in iRedAdmin-Pro-MySQL-1.9.2. Please open file controllers/mysql/alias.py, search 'pgsql' in this file (only one in this file), replace it by 'mysql'.
Then restart Apache service or uwsgi service (if you're running Nginx).

7

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Provided solution works.

8 (edited by Gavin 2015-02-04 21:12:25)

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

I have upgraded the latest version today. I am still having the same "internal server problem" in while accessing Edit Domain Profile, Adding User etc. I have checked the alias.py file and i could not find the "pgsql"string in it. I guess you have updated the latest version with this fix, but the problem is not fixed yet.

please reply.

Following is the error log from ssl_error_log:

[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164] Traceback (most recent call last):
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/usr/lib/python2.6/site-packages/web/application.py", line 239, in process
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     return self.handle()
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/usr/lib/python2.6/site-packages/web/application.py", line 230, in handle
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     return self._delegate(fn, self.fvars, args)
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/usr/lib/python2.6/site-packages/web/application.py", line 420, in _delegate
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     return handle_class(cls)
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/usr/lib/python2.6/site-packages/web/application.py", line 396, in handle_class
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     return tocall(*args)
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/var/www/iredadmin/controllers/decorators.py", line 22, in proxyfunc
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     return func(self, *args, **kw)
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]   File "/var/www/iredadmin/controllers/mysql/domain.py", line 169, in GET
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]     domain_settings=sqlutils.convert_sql_account_settings_to_dict(domain_profile['settings']),
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164] KeyError: 'settings'
[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164]
[Wed Feb 04 18:40:06 2015] [error] [client 116.193.163.164] File does not exist: /var/www/html/robots.txt
[Wed Feb 04 18:40:06 2015] [error] [client 116.193.163.164] File does not exist: /var/www/html/robots.txt

9

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Gavin wrote:

[Wed Feb 04 18:40:05 2015] [error] [client 116.193.163.164] KeyError: 'settings'

Your iRedMail is out of date, because you didn't update your SQL structure to have column `domain.settings`. Please follow our tutorials to upgrade your iRedMail server:
http://www.iredmail.org/docs/iredmail.releases.html

10

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Just found this thread. Thanks. Edit from pgsql -> mysql did the trick. Back in business.

11

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Hello,
I log into the iRedAdmin-Pro interface and see that there is an update.  When I click on the update, I get the following error:

Error while getting license info: syntax error: line 1, column 0

Can't see anything about the upgrade, but the interface seems to be working ok.  Any idea?

12

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Same here, can't get to ask for a download link ...

scott wrote:

Hello,
I log into the iRedAdmin-Pro interface and see that there is an update.  When I click on the update, I get the following error:

Error while getting license info: syntax error: line 1, column 0

Can't see anything about the upgrade, but the interface seems to be working ok.  Any idea?

13

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

same here:

Error while geting license info: syntax error: line 1, column 0

14

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Dear @scott, @b.cherrier, @ppinto,

It's fixed, please try again. Sorry about this trouble. And thanks for your feedback.

15

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

ZhangHuangbin wrote:

Dear @scott, @b.cherrier, @ppinto,

It's fixed, please try again. Sorry about this trouble. And thanks for your feedback.

Thank you, it's indeed fixed !
Have a great day !

16

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

Hello,

In the list of bugs fixed in the original post is "Cannot delete mail alias account." but we still seem to be experiencing this on IRedAdminPro 1.9.2.

Steps to reproduce:

1. Login as the global administrator.
2. Navigate to domain and choose the "Aliases" entry.
3. Tick the box next to the alias to delete, select "Delete" from the "Choose Action" dropdown and hit "Apply".
4. The message "Selected accounts were deleted." is shown but the alias is still there in the list.

There are no associated entries in the apache error log.

Versions are currently:
O/S: ubuntu precise
iredapd: 1.4.4
IRedAdmin-Pro-Mysql: 1.9.2 (upgraded from 1.8.2 via the upgrade_iredadmin.sh script)

How should we proceed to fix this?

17

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

i-next wrote:

In the list of bugs fixed in the original post is "Cannot delete mail alias account." but we still seem to be experiencing this on IRedAdminPro 1.9.2.

I sent an email with download link of patched version, could you please try it? Follow our tutorial to upgrade to this patched version:
http://www.iredmail.org/docs/migrate.or … admin.html

18

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

ZhangHuangbin wrote:

I sent an email with download link of patched version, could you please try it? Follow our tutorial to upgrade to this patched version:
http://www.iredmail.org/docs/migrate.or … admin.html

We have installed the patched version as per the instructions and it has indeed solved this problem. Thank you for your swift action.

19

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

I can't delete aliases too. Can you please email me the pach.
Thank you!

20

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

cejko wrote:

I can't delete aliases too. Can you please email me the pach.

Sent patched version moment ago, let me know if you didn't receive it.

21

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

ZhangHuangbin wrote:

Oops, confirmed it's a bug in iRedAdmin-Pro-MySQL-1.9.2. Please open file controllers/mysql/alias.py, search 'pgsql' in this file (only one in this file), replace it by 'mysql'.
Then restart Apache service or uwsgi service (if you're running Nginx).

I applied the change however now i can't delete alias. Can you also please email me patch.

22

Re: iRedAdmin-Pro-MySQL-1.9.2 has been released.

neoark wrote:
ZhangHuangbin wrote:

Oops, confirmed it's a bug in iRedAdmin-Pro-MySQL-1.9.2. Please open file controllers/mysql/alias.py, search 'pgsql' in this file (only one in this file), replace it by 'mysql'.
Then restart Apache service or uwsgi service (if you're running Nginx).

I applied the change however now i can't delete alias. Can you also please email me patch.

Thanks for patch everything seems working good.