1 Topic by fabien.hespul

  • fabien.hespul
  • Member
  • Offline
  • Registered: 2013-11-07
  • Posts: 10

Topic: Can't use cluebringer integration with 2.1 LDAP

==== Required information ====
- iRedMail version: 0;8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Linux/BSD distribution name and version:  Debian 7
- Related log if you're reporting an issue: (1054, "Unknown column 'type' in 'field list'")
====

Hi,
I have upgrade to iRedMail 0.8.6 and iRedAdmin-Pro-LDAP 2.1 from 0.8.5 and 2.0 (This is the initial iRedMail/iRedAdmin-pro install)
I followed these procedures without any trouble :
- http://iredmail.org/wiki/index.php?titl … .8.5-0.8.6
- http://iredmail.org/wiki/index.php?titl … AP/2.0-2.1

In iRedAdmin, when i try to add entries to whitlist (System->Whitelist), i get the following error :
(1054, "Unknown column 'type' in 'field list'")
Furthermore i don't see all whitelist entries i've added in cluebringer web-gui.

When i got to System>Limits, the Greylisting checkbox is unchecked whereas the function is working on this system.

Did i miss something ?

----

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: 30,768

Re: Can't use cluebringer integration with 2.1 LDAP

Sorry about this, it's my fault that i didn't mention SQL structure of Cluebringer database in upgrade tutorial.
Please give me some minutes.

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,768

Re: Can't use cluebringer integration with 2.1 LDAP

Check below section in upgrade tutorial please:
http://www.iredmail.org/wiki/index.php? … r_database

4 Reply by fabien.hespul

  • fabien.hespul
  • Member
  • Offline
  • Registered: 2013-11-07
  • Posts: 10

Re: Can't use cluebringer integration with 2.1 LDAP

Thanks for your reactivity.

I've followed instructions. But i've change "USE vmail" to "USE cluebringer"
And when I do "SOURCE /root/extra.sql". I got some errors : http://pastebin.com/hzMXq2nw

iRedAdmin-Pro seems to work better now.
But i don't see all IPs I have added manually in cluebringer web-gui
And when i go to System > Limits Throttling and Greylisting seems to be disabled whereas they are working on this system

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,768

Re: Can't use cluebringer integration with 2.1 LDAP

fabien.hespul wrote:

But i've change "USE vmail" to "USE cluebringer"

Oops, my mistake, again. Fixed moment ago.

fabien.hespul wrote:

I got some errors : http://pastebin.com/hzMXq2nw

It's safe to ignore them.

fabien.hespul wrote:

But i don't see all IPs I have added manually in cluebringer web-gui
And when i go to System > Limits Throttling and Greylisting seems to be disabled whereas they are working on this system

If you have custom Cluebringer rules/policies, iRedAdmin-Pro may not work with them. It's better to backup your own rules then delete them and use the ones created by iRedAdmin-Pro.

I'd like to explain with some more details about this: Policyd-1.8 has SQL tables for whitelist/blacklist/greylisting, so it's easy to use them. But Cluebringer doesn't have them, developers make it more flexible and avoid these SQL tables directly. So you have to create your own policy in table "cluebringer.policies" first, then define what it will be used for. That's why Policyd cannot provide an official upgrade tutorial for Policyd to Cluebringer, because no one will use the same policies as yours. This is how Policyd/Cluebringer works.

To manage Cluebringer, we have to create some hard-coded policies for whitelist/blacklist/greylisting (and more), so that iRedAdmin-Pro can manage them. That's how iRedAdmin-Pro works with Cluebringer.

Hope it helps.