1 Topic by dejavux

  • dejavux
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 25

Topic: Error when running ./wblist_admin.py --blacklist --list

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): latest
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: Ubuntu 22.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache2
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

When attempting to execute the following command I get an error.

/opt/iredapd/tools$ ./wblist_admin.py --blacklist --list

* Establishing SQL connection.
* List all inbound blacklist for account: @.
'Engine' object has no attribute 'execute'

----

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

2 Reply by dejavux

  • dejavux
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 25

Re: Error when running ./wblist_admin.py --blacklist --list

/opt/iredapd/tools$ ./wblist_admin.py --blacklist --list

* Establishing SQL connection.
* List all inbound blacklist for account: @.
'Engine' object has no attribute 'execute'

I have found the issue.  I have recently upgraded the system from 18.04 -> 20.04 -> 22.04 and during this time, while there were only a couple of issues related to the iRedMail installation.  Mostly deprecated items in the config files or out of date python module (web.py). 

What I discovered with the error above is it appears that I had the 2.x version of the python SQLAlchemy module installed.  wblist_admin.py was throwing the error above because it would appear iRedAPD is not compatible with the newer version. I removed the 2.x version and installed the 1.4.49 version of SQLAlchemy and this resolved the issue.

3 Reply by ZhangHuangbin

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

Re: Error when running ./wblist_admin.py --blacklist --list

This is a known issue reported by another user: https://github.com/iredmail/iRedAPD/issues/15
Will fix it shortly. Feel free to reply to that issue as a reminder if i didn't get it done. sad

4 Reply by dittman

  • dittman
  • Member
  • Offline
  • Registered: 2015-08-15
  • Posts: 74

Re: Error when running ./wblist_admin.py --blacklist --list

I'm running into this issue on Rocky Linux 10 running iRedMail 1.7.4.  Are there still plans to fix it?

5 Reply by ZhangHuangbin

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

Re: Error when running ./wblist_admin.py --blacklist --list

dittman wrote:

I'm running into this issue on Rocky Linux 10 running iRedMail 1.7.4.  Are there still plans to fix it?

Did you upgrade iRedAPD to latest 5.9.3?
FYI https://docs.iredmail.org/upgrade.iredapd.html

6 Reply by dittman

  • dittman
  • Member
  • Offline
  • Registered: 2015-08-15
  • Posts: 74

Re: Error when running ./wblist_admin.py --blacklist --list

ZhangHuangbin wrote:
dittman wrote:

I'm running into this issue on Rocky Linux 10 running iRedMail 1.7.4.  Are there still plans to fix it?

Did you upgrade iRedAPD to latest 5.9.3?
FYI https://docs.iredmail.org/upgrade.iredapd.html

No, this was a fresh install of 1.7.4 which still has 5.9.1.  I'll update.

Is it recommended to monitor the github pages and upgrade as things are released or wait until an update announcement?  It looks like there's a new iredadmin package out, too.

7 Reply by ZhangHuangbin

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

Re: Error when running ./wblist_admin.py --blacklist --list

Wait for new iRedMail release then upgrade.

8 Reply by dittman

  • dittman
  • Member
  • Offline
  • Registered: 2015-08-15
  • Posts: 74

Re: Error when running ./wblist_admin.py --blacklist --list

ZhangHuangbin wrote:

Wait for new iRedMail release then upgrade.

Thank you.  I'll wait, then.