1 Topic by antoniob (edited by antoniob 2013-09-23 10:58:57)

  • antoniob
  • antoniob
  • Member
  • Offline
  • From: Norway
  • Registered: 2013-09-23
  • Posts: 7

Topic: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

I install iRedMail-0.8.5 on OpenBSD-5.3 (i386) with MySQL backend.
I watch the logs scrolling as packages are installed and configured by the setup script.
The script chokes on MySQL:

"mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
ERROR 1235 (42000) at line 341 in file: '/root/iRedMail-0.8.5/samples/iredmail.mysql': This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'"

----

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

2 Reply by ZhangHuangbin

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

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

I don't have this error with OpenBSD 5.3. What's the MySQL version on your server? It's mysql-server-5.1.68 here.

If you're running OpenBSD on a virtual machine, is it possible for you to try it on a (OpenBSD) x86_64 server?

3 Reply by antoniob

  • antoniob
  • antoniob
  • Member
  • Offline
  • From: Norway
  • Registered: 2013-09-23
  • Posts: 7

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

yes same, the release packages of OBSD 5.3 so indeed mysql 5.1.68. On a dedicated server, running OBSD 5.3 i386. I will have a closer look later when I have some more time.

4 Reply by ZhangHuangbin

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

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

I always test with OpenBSD amd64, will try to reproduce this issue with OpenBSD 5.3 i386 later.

5 Reply by antoniob

  • antoniob
  • antoniob
  • Member
  • Offline
  • From: Norway
  • Registered: 2013-09-23
  • Posts: 7

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

Solved. No need to try to reproduce. That was my bad: the OpenBSD running on the dedicated server was not a fresh installation but a "refreshed" one: after an upgrade 5.2->5.3 all packages were removed and configs wiped to get back to a clean system. But I forgot to completely clean a mysql instance. Hence the error.
So, everything's fine smile

6 Reply by ZhangHuangbin

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

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

Glad to hear that. I tested OpenBSD 5.3 i386 last night, it works for me too.

7 Reply by antoniob

  • antoniob
  • antoniob
  • Member
  • Offline
  • From: Norway
  • Registered: 2013-09-23
  • Posts: 7

Re: OpenBSD 5.3 iRedmail 0.8.5 MySQL ERROR 1235 multiple triggers

Btw.  Thank you for the fast support provided here! :-)