Dec 29, 2023: iRedMail-1.6.8 has been released.

**yavuz.maslak** · 2015-09-21 21:21:55

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Topic: i can't enter throttle on iredadmin

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: ubuntu14.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):ldap
- Web server (Apache or Nginx):apache
- Manage mail accounts with iRedAdmin-Pro?2.3.1
- Related log if you're reporting an issue:
====
i began to use iredadmin-pro instead of iredadmin.
i can not reach throttle tab.
i followed http://www.iredmail.org/docs/install.ir … ebian.html during installation.
i edited settings.py

there is the config file like below
# SQL Database used to store policyd data, eg. whitelist, blacklist.
# You can find related information in policyd config files:
# - On RHEL/CentOS: /etc/policyd.conf
# - On Debian/Ubuntu: /etc/postfix-policyd.conf
# - On FreeBSD: /usr/local/etc/policyd.conf
# Related parameters:
# host -> MYSQLHOST
# port -> 3306 (Default)
# db -> MYSQLDBASE
# user -> MYSQLUSER
# passwd -> MYSQLPASS
policyd_db_host = '127.0.0.1'
policyd_db_port = 3306
policyd_db_name = 'cluebringer'
policyd_db_user = 'cluebringer'

first on ubuntu, there is no file /etc/postfix-policyd.conf , but there is cluebringer under /etc folder.
older settings.py ( i used iredadmin-freeversion) database name cluebringer
if i edit cluebringer as policy_db in settings.py. I get an error internal server error.

how can i fix that ?

Also i can i change time of system maillog as GMT+3 on the iredadmin?

----

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

**ZhangHuangbin** · 2015-09-21 21:27:39

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,770

Re: i can't enter throttle on iredadmin

You can use the SQL username/password defined in /etc/cluebringer/cluebringer.conf.

By the way, upcoming iRedMail release will drop Cluebringer (although iRedAdmin-Pro still supports it).

**yavuz.maslak** · 2015-09-21 21:40:27

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Re: i can't enter throttle on iredadmin

I already used it. But i get internal error on the browser.
Also i see on the apache error.log;
113] ProgrammingError: (1146, "Table 'cluebringer.throttle' doesn't exist")

there is no longer policyd database. ( in the installation page, it mentions policyd database )

**ZhangHuangbin** · 2015-09-21 22:40:36

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,770

Re: i can't enter throttle on iredadmin

yavuz.maslak wrote:

113] ProgrammingError: (1146, "Table 'cluebringer.throttle' doesn't exist")

*) Do you have SQL database `cluebringer`?
*) Do you have any SQL tables in database `cluebringer`?

**yavuz.maslak** · 2015-09-21 23:13:27

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Re: i can't enter throttle on iredadmin

Yes i have.
when i try to configure throttle value i got Error: 'Throttle' object has no attribute 'add_throttle'

tables in cluebringer;
root@mail:/var/lib/mysql/cluebringer# ls -l
total 19004
-rwxr--r-- 1 mysql mysql 12860 Jul 29 20:00 access_control.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 access_control.ibd
-rwxr--r-- 1 mysql mysql 16278 Jul 29 20:00 amavis_rules.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 amavis_rules.ibd
-rwxr--r-- 1 mysql mysql 8660 Jul 29 20:00 checkhelo_blacklist.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 checkhelo_blacklist.ibd
-rwxr--r-- 1 mysql mysql 13148 Jul 29 20:00 checkhelo.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 checkhelo.ibd
-rwxr--r-- 1 mysql mysql 8638 Jul 29 20:00 checkhelo_tracking.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 checkhelo_tracking.ibd
-rwxr--r-- 1 mysql mysql 12760 Jul 29 20:00 checkhelo_whitelist.frm
-rwxr--r-- 1 mysql mysql 131072 Jul 29 20:01 checkhelo_whitelist.ibd
-rwxr--r-- 1 mysql mysql 8830 Jul 29 20:00 checkspf.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 checkspf.ibd
-rwxr--r-- 1 mysql mysql 65 Jul 29 20:00 db.opt
-rwxr--r-- 1 mysql mysql 12758 Jul 29 20:00 greylisting_autoblacklist.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 greylisting_autoblacklist.ibd
-rwxr--r-- 1 mysql mysql 12796 Jul 29 20:00 greylisting_autowhitelist.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 greylisting_autowhitelist.ibd
-rwxr--r-- 1 mysql mysql 13534 Jul 29 20:00 greylisting.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 greylisting.ibd
-rwxr--r-- 1 mysql mysql 8788 Jul 29 20:00 greylisting_tracking.frm
-rwxr--r-- 1 mysql mysql 147456 Sep 19 03:01 greylisting_tracking.ibd
-rwxr--r-- 1 mysql mysql 12760 Jul 29 20:00 greylisting_whitelist.frm
-rwxr--r-- 1 mysql mysql 131072 Jul 29 20:01 greylisting_whitelist.ibd
-rwxr--r-- 1 mysql mysql 12802 Jul 29 20:00 policies.frm
-rwxr--r-- 1 mysql mysql 131072 Jul 29 20:01 policies.ibd
-rwxr--r-- 1 mysql mysql 12838 Jul 29 20:00 policy_group_members.frm
-rwxr--r-- 1 mysql mysql 163840 Jul 29 20:01 policy_group_members.ibd
-rwxr--r-- 1 mysql mysql 12756 Jul 29 20:00 policy_groups.frm
-rwxr--r-- 1 mysql mysql 131072 Jul 29 20:01 policy_groups.ibd
-rwxr--r-- 1 mysql mysql 8746 Jul 29 20:00 policy_members.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 policy_members.ibd
-rwxr--r-- 1 mysql mysql 12926 Jul 29 20:00 quotas.frm
-rwxr--r-- 1 mysql mysql 131072 Jul 29 20:01 quotas.ibd
-rwxr--r-- 1 mysql mysql 8744 Jul 29 20:00 quotas_limits.frm
-rwxr--r-- 1 mysql mysql 114688 Jul 29 20:01 quotas_limits.ibd
-rwxr--r-- 1 mysql mysql 8696 Jul 29 20:00 quotas_tracking.frm
-rwxr--r-- 1 mysql mysql 147456 Jul 29 20:01 quotas_tracking.ibd
-rwxr--r-- 1 mysql mysql 13364 Jul 29 20:00 session_tracking.frm
-rwxr--r-- 1 mysql mysql 16777216 Sep 21 18:07 session_tracking.ibd

ZhangHuangbin wrote:

yavuz.maslak wrote:
113] ProgrammingError: (1146, "Table 'cluebringer.throttle' doesn't exist")
*) Do you have SQL database `cluebringer`?
*) Do you have any SQL tables in database `cluebringer`?

**ZhangHuangbin** · 2015-09-22 09:17:55

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,770

Re: i can't enter throttle on iredadmin

What's the value of parameter 'policyd_db_name =' in /opt/www/iredadmin/settings.py?

**yavuz.maslak** · 2015-09-22 13:08:02

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Re: i can't enter throttle on iredadmin

root@mail:~# cat /opt/www/iredadmin/settings.py |grep policyd_db_name
policyd_db_name = "cluebringer"

**ZhangHuangbin** · 2015-09-22 23:39:56

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,770

Re: i can't enter throttle on iredadmin

yavuz.maslak wrote:

when i try to configure throttle value i got Error: 'Throttle' object has no attribute 'add_throttle'

Is it possible to let me login to your server for further debug? You can contact me here: http://www.iredmail.org/contact.html

**yavuz.maslak** · 2015-09-23 01:39:47

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Re: i can't enter throttle on iredadmin

it has become very interesting a thing. it works now.
whereas i didn't anything. Yesterday after we bought the license, first i could not enter throttle tab, i was getting "internal error." on the browser.

But after a while about 1 hour, i was able to enter it without any error. But if i had tried enable the throttle and given any values of throttle parameters and 'save changes' i was getting below error "Error: 'Throttle' object has no attribute 'add_throttle'"

But after i saw your reply mail, i checked again, it works now whereas i did not anything about that.

is it possible that does the system add required attributes or fields in a crontab ?

ZhangHuangbin wrote:

yavuz.maslak wrote:
when i try to configure throttle value i got Error: 'Throttle' object has no attribute 'add_throttle'
Is it possible to let me login to your server for further debug? You can contact me here: http://www.iredmail.org/contact.html

**ZhangHuangbin** · 2015-09-23 08:25:29

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 30,770

Re: i can't enter throttle on iredadmin

Did you restart web server?

**yavuz.maslak** · 2015-09-23 13:55:59

yavuz.maslak
Member
Offline

Registered: 2014-07-30
Posts: 159

Re: i can't enter throttle on iredadmin

yes i did , but i had restarted apache after setting the configure settings.py too

ZhangHuangbin wrote:

Did you restart web server?

Dec 29, 2023: iRedMail-1.6.8 has been released.

i can't enter throttle on iredadmin

Posts: 11

1 Topic by yavuz.maslak 2015-09-21 21:21:55

Topic: i can't enter throttle on iredadmin

2 Reply by ZhangHuangbin 2015-09-21 21:27:39

Re: i can't enter throttle on iredadmin

3 Reply by yavuz.maslak 2015-09-21 21:40:27

Re: i can't enter throttle on iredadmin

4 Reply by ZhangHuangbin 2015-09-21 22:40:36

Re: i can't enter throttle on iredadmin

5 Reply by yavuz.maslak 2015-09-21 23:13:27

Re: i can't enter throttle on iredadmin

6 Reply by ZhangHuangbin 2015-09-22 09:17:55

Re: i can't enter throttle on iredadmin

7 Reply by yavuz.maslak 2015-09-22 13:08:02

Re: i can't enter throttle on iredadmin

8 Reply by ZhangHuangbin 2015-09-22 23:39:56

Re: i can't enter throttle on iredadmin

9 Reply by yavuz.maslak 2015-09-23 01:39:47

Re: i can't enter throttle on iredadmin

10 Reply by ZhangHuangbin 2015-09-23 08:25:29

Re: i can't enter throttle on iredadmin

11 Reply by yavuz.maslak 2015-09-23 13:55:59

Re: i can't enter throttle on iredadmin

Posts: 11