1 Topic by exiper

  • exiper
  • Member
  • Offline
  • Registered: 2014-05-03
  • Posts: 6

Topic: Table 'cluebringer.throttle' doesn't exist

- iRedMail version: iRedAdmin-Pro-MySQL-1.8.1
- Linux/BSD distribution name and version: Ubuntu 12.04.4

When creating new domain, the following error shows in browser:
=======
internal server error
=======

UWSGI logs shows:

admin.mail.kily.ru [pid: 3563|app: 0|req: 10/36] 188.35.138.36 () {56 vars in 1088 bytes} [Sat May  3 00:26:40 2014] POST /create/domain => generated 0 bytes in 360 msecs (HTTP/1.1 303) 3 headers in 213 bytes (2 switches on core 0)
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/web/application.py", line 242, in process
    return self.handle()
  File "/usr/lib/pymodules/python2.7/web/application.py", line 233, in handle
    return self._delegate(fn, self.fvars, args)
  File "/usr/lib/pymodules/python2.7/web/application.py", line 415, in _delegate
    return handle_class(cls)
  File "/usr/lib/pymodules/python2.7/web/application.py", line 390, in handle_class
    return tocall(*args)
  File "/var/www/iredadmin/controllers/decorators.py", line 11, in proxyfunc
    return func(self, *args, **kw)
  File "/var/www/iredadmin/controllers/mysql/domain.py", line 122, in GET
    result_throttle = throttleLib.getThrottling(sender='@' + self.domain, recipient='@' + self.domain)
  File "/var/www/iredadmin/libs/policyd/throttle.py", line 162, in getThrottling
    limit=1,
  File "/usr/lib/pymodules/python2.7/web/db.py", line 649, in select
    return self.query(qout, processed=True)
  File "/usr/lib/pymodules/python2.7/web/db.py", line 611, in query
    self._db_execute(db_cursor, sql_query)
  File "/usr/lib/pymodules/python2.7/web/db.py", line 562, in _db_execute
    out = cur.execute(sql_query.query(paramstyle), sql_query.values())
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'cluebringer.throttle' doesn't exist")

admin.mail.kily.ru [pid: 3564|app: 0|req: 27/37] 188.35.138.36 () {50 vars in 997 bytes} [Sat May  3 00:26:40 2014] GET /profile/domain/general/kilylabs.com?msg=CREATED => generated 21 bytes in 601 msecs (HTTP/1.1 500) 2 headers in 139 bytes (2 switches on core 0)

----

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

Re: Table 'cluebringer.throttle' doesn't exist

SQL table "cluebringer.throttle" doesn't exist. Could you please show us what SQL tables you have?

mysql> USE cluebringer;
mysql> SHOW TABLES;

3 Reply by exiper

  • exiper
  • Member
  • Offline
  • Registered: 2014-05-03
  • Posts: 6

Re: Table 'cluebringer.throttle' doesn't exist

mysql> show tables;
+----------------------------+
| Tables_in_cluebringer |
+----------------------------+
| access_control             |
| amavis_rules               |
| checkhelo                  |
| checkhelo_blacklist        |
| checkhelo_tracking         |
| checkhelo_whitelist        |
| checkspf                   |
| greylisting                |
| greylisting_autoblacklist  |
| greylisting_autowhitelist  |
| greylisting_tracking       |
| greylisting_whitelist      |
| policies                   |
| policy_group_members       |
| policy_groups              |
| policy_members             |
| quotas                     |
| quotas_limits              |
| quotas_tracking            |
| session_tracking           |
+----------------------------+

I'm actually made it work with older policyd (1.8), but it would be great if i could do it with cluebringer.

4 Reply by ZhangHuangbin

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

Re: Table 'cluebringer.throttle' doesn't exist

Ubuntu 12.04 ships Cluebringer, and iRedAdmin-Pro does work with both Policyd and Cluebringer.
Could you please show me Cluebringer related settings in iRedAdmin-Pro? If you use 'cluebringer' as database name, iRedAdmin-Pro will enable Cluebringer support automatically.

5 Reply by exiper

  • exiper
  • Member
  • Offline
  • Registered: 2014-05-03
  • Posts: 6

Re: Table 'cluebringer.throttle' doesn't exist

Heh, I'm actually use prefixed table name "prefix_cluebringer", but when I posted here, I cleaned it out :-) I'll try to rename the table to 'cluebringer' and post back. Thanks!

6 Reply by exiper

  • exiper
  • Member
  • Offline
  • Registered: 2014-05-03
  • Posts: 6

Re: Table 'cluebringer.throttle' doesn't exist

Ok, I've got it working, thanks! But I needed to change line

if settings.policyd_db_name in ['cluebringer']:

to

if settings.policyd_db_name in ['prefix_cluebringer']:

in file iredbase.py

I think it is better to move this option to settings.py file...

7 Reply by ZhangHuangbin

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

Re: Table 'cluebringer.throttle' doesn't exist

iRedMail created database name "cluebringer" during installation, and it's better to use the same database name instead of modifying iRedAdmin-Pro (you have to modify it again after upgrading iRedAdmin-Pro)