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

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