1 (edited by yourtownonline 2021-12-24 07:49:00)

Topic: iredapd 2.3 broken on mysql 8

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I have an older iredmail installation that uses iRedApd-2.3. Due to some issues, I needed to switch to mysql from 5.4 (we have a site database server all use). I was able to make everything fly, but now I see that when iredapd conencts to mysql, it bombs out with Error 255 and logs the following message:

ERROR Unexpected error: 255. Fallback to default action: DUNNO

From the command line of this host, I am able to connect and log in with the exact name/password that is listed in settings.py. I think the problem is some kind of library incompatibility with mysql 8 because the server doesn't even report the login attempt and under strace really all I see is the initial tcp connect, the server sends the mysql greeting string (binary garbage with the string "native_password" at the end), and then the iredapd just barfs and closes the connection.
startup of iredapd looks normal - no errors or anything noted:

2021-12-23 10:01:00 INFO Starting iRedAPD (version: 2.3, backend: mysql), listening on 127.0.0.1:7777.
2021-12-23 10:01:00 INFO Log rotate type: time, interval: W6, backup copies: 12.
2021-12-23 10:01:00 INFO Loading plugin (priority: 100): reject_null_sender
2021-12-23 10:01:00 INFO Loading plugin (priority: 99): wblist_rdns
2021-12-23 10:01:00 INFO Loading plugin (priority: 60): throttle
2021-12-23 10:01:00 INFO Loading plugin (priority: 50): sql_alias_access_policy
2021-12-23 10:01:00 INFO Loading plugin (priority: 40): amavisd_wblist


I am kinda thinking this is relatively easy - some flag or option to set in the python connector, but I am not smart enough with python to figure this out. I have toyed around with different versions (I am on old iredmail and upgrade is not possible at this time) and am just not seeing an easy solution.
Thank you.

----

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

2

Re: iredapd 2.3 broken on mysql 8

why cant you upgrade iredapd?

3

Re: iredapd 2.3 broken on mysql 8

Cthulhu wrote:

why cant you upgrade iredapd?

Well, it doesn't work. Most recent versions require python3. The older versions (py2) have other stacktraces. Various. It needs to just be fixed in place if possible, I cannot and will not update this server there's too many other attendant problems that make 'upgrade' impossible without a heavy migration.