ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2018-10-18T07:48:41Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5149100-monitor_database_size.inc.php reports always 0 used space2018-10-18T07:48:41ZRoberto Altravia100-monitor_database_size.inc.php reports always 0 used space## short description
On the ISPConfig main page, on database Quota, Used space is always 0kb
If I run /usr/local/ispconfig/server/cron.sh by hand, 100-monitor_database_size.inc.php says:
database c0testdb size does not exceed quota: 262...## short description
On the ISPConfig main page, on database Quota, Used space is always 0kb
If I run /usr/local/ispconfig/server/cron.sh by hand, 100-monitor_database_size.inc.php says:
database c0testdb size does not exceed quota: 26214400 (quota) > 0 (used)
But that's not true. I checked the library and internally it runs a mysql query:
SELECT SUM(data_length+index_length) FROM information_schema.TABLES WHERE table_schema='c0testdb';
that if I run manually on mysql it returns correctly about 40MB :
>
> +-------------------------------+
> | SUM(data_length+index_length) |
>
>
> +-------------------------------+| 41324160 |
> +-------------------------------+
>
After some debugging, the problem seems to be in the function getDatabaseSize in file db_mysql.inc.php. It returns always 0
## correct behaviour
The database quota size should be reported on the ISPConfig main page
100-monitor_database_size.inc.php should report correct values
## environment
Server OS: Ubuntu
Server OS version: 14.04.5 LTS Trusty
ISPConfig version: 3.1dev e2465bd7a2d324259c3c1dae00dfca8c2535edcc
apachectl -v
Server version: Apache/2.4.7 (Ubuntu)
Server built: Apr 18 2018 15:36:26
PHP 5.5.9-1ubuntu4.26 (cli) (built: Sep 17 2018 13:46:30)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
with XCache v3.1.0, Copyright (c) 2005-2013, by mOo
with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies
with XCache Optimizer v3.1.0, Copyright (c) 2005-2013, by mOo
with XCache Cacher v3.1.0, Copyright (c) 2005-2013, by mOo
with XCache Coverager v3.1.0, Copyright (c) 2005-2013, by mOo3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5146disabled reseller still may login2019-07-05T08:56:41ZTobias Wollowskidisabled reseller still may login## short description
A disables reseller is able to login into ispconfig
## correct behaviour
Login should be disabled
## environment
Server OS: debian
ISPConfig version: 3## short description
A disables reseller is able to login into ispconfig
## correct behaviour
Login should be disabled
## environment
Server OS: debian
ISPConfig version: 33.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5129Syntax errors in PHP 5.3.32019-06-26T14:06:59ZTill BrehmSyntax errors in PHP 5.3.3There are some syntax errors in PHP 5.3.3 due to lack of new PHP array access function syntax:
https://www.howtoforge.com/community/threads/cant-generate-dkim-and-access-server-config.80015/There are some syntax errors in PHP 5.3.3 due to lack of new PHP array access function syntax:
https://www.howtoforge.com/community/threads/cant-generate-dkim-and-access-server-config.80015/3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5128Bug in password strength meter2018-09-17T09:15:14ZTim SerowskiBug in password strength meterThere is a bug in the password strength meter password level identification method in
/interface/lib/classes/validate_password.inc.php
Line 74:
`} else if (length >= 7 && length <=10) {`
Variables start with $.
This could lead to a...There is a bug in the password strength meter password level identification method in
/interface/lib/classes/validate_password.inc.php
Line 74:
`} else if (length >= 7 && length <=10) {`
Variables start with $.
This could lead to a password incorrectly being classified as strength level 4 instead of level 3.3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5113PHP error in server config edit form when old PHP versions are used2019-06-26T14:09:13ZTill BrehmPHP error in server config edit form when old PHP versions are usedSee comments in #5063 for details.See comments in #5063 for details.3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5095The update_serial option in _delete functions of API does not work2018-08-20T20:22:58ZTill BrehmThe update_serial option in _delete functions of API does not workhttps://www.howtoforge.com/community/threads/having-some-trouble-with-acme-sh-and-isp-config-api.79616/
Reason: the $params array which is passed to the increase_serial function does not exist in the DNS record _delete() functions.https://www.howtoforge.com/community/threads/having-some-trouble-with-acme-sh-and-isp-config-api.79616/
Reason: the $params array which is passed to the increase_serial function does not exist in the DNS record _delete() functions.3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5070Firewall > Character not allowed in tcp port definition2019-07-03T10:58:32ZAndreas B.Firewall > Character not allowed in tcp port definition## short description
What is happening and what is wrong with that?
Firewall Open TCP ports limit to 255 chars
## correct behaviour
What should happen instead?
`error message : "Character not allowed in tcp port definition. Allowed cha...## short description
What is happening and what is wrong with that?
Firewall Open TCP ports limit to 255 chars
## correct behaviour
What should happen instead?
`error message : "Character not allowed in tcp port definition. Allowed characters are numbers, ":" and ","."`
## environment
Server OS: Debian
Server OS version: jessie 8.11
ISPConfig version: 3.1.12 (define('ISPC_APP_VERSION', '3.1.12');)
If it might be related to the problem
no more output.
## references
https://www.howtoforge.de/forum/threads/firewall-character-not-allowed-in-tcp-port-definition.11141/#post-55559
## screenshots
![2018-07-03_15_55_14-ISPConfig](/uploads/bb16d9b46431b5ec4f03a0cf0a226de2/2018-07-03_15_55_14-ISPConfig.png)
## log entries
no entries3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5033Renewal of letsencrypt does not restart/reload nginx2019-06-26T13:51:42ZRajko AlbrechtRenewal of letsencrypt does not restart/reload nginx## short description
When renew letsencrypt certificates from domains in nginx service the nginx service will not restart in debian9. So it may happen, that a non valid certificate is send by nginx to clients instead of the newly generat...## short description
When renew letsencrypt certificates from domains in nginx service the nginx service will not restart in debian9. So it may happen, that a non valid certificate is send by nginx to clients instead of the newly generated one.
## correct behaviour
After renew of letsencrypt nginx should be restarted. On a debian stretch with apache as webserver it works.
## environment
Server OS: Debian
Server OS version: Stretch
ISPConfig version: 3.1.11
```
nginx version: nginx/1.10.3
```
Not sure, but I think the problem is in `900-letsencrypt.inc.php` in line 71 - `systemctl force-reload nginx` does not work.
I had not tracked down what is realy send at this point but wouldn't be a `restart` better for nginx?
Bye
Rajko3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/4972domain in spamfilter_user settings not punicode encoded2019-03-05T15:34:38ZTill Brehmdomain in spamfilter_user settings not punicode encodedWhen a mail domain with spamfilter enabled is saved to the spamfilter_users table, then the punicode filter is not applied correctly.When a mail domain with spamfilter enabled is saved to the spamfilter_users table, then the punicode filter is not applied correctly.3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/4946e-mail stats cronjob funktioniert nicht ( https://www.howtoforge.de/forum/thr...2019-07-03T12:02:17ZAndreas Weike-mail stats cronjob funktioniert nicht ( https://www.howtoforge.de/forum/threads/e-mail-konto-datenverkehr-ist-0mb.8806/ )E-Mail traffic wird nicht generiert. Der Fehler ist in /usr/share/ispconfig/server/lib/classes/cron.d/100-mailbox_stats.inc.php.
Im Anhang meine bearbeitete Version zur Prüfung.
Die Zeilen 194 bis 197 und 248 bis 250 sind die Änderungen...E-Mail traffic wird nicht generiert. Der Fehler ist in /usr/share/ispconfig/server/lib/classes/cron.d/100-mailbox_stats.inc.php.
Im Anhang meine bearbeitete Version zur Prüfung.
Die Zeilen 194 bis 197 und 248 bis 250 sind die Änderungen.[100-mailbox_stats.inc.php](/uploads/0ced0a8578cfeff07f3d1914e21dd777/100-mailbox_stats.inc.php)3.1.14https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/4353Layout Issues2019-07-03T11:12:07ZSamuel SutherLayout IssuesThe new Layout is awesome. :Thanks a lot for this.
But here a Bug I've found... the dropdodwn-Field is much to small (on any view, not only on the "Server"-View) [here in Google Chrome on Linux]:
![Auswahl_090](/uploads/e88d229820532c590...The new Layout is awesome. :Thanks a lot for this.
But here a Bug I've found... the dropdodwn-Field is much to small (on any view, not only on the "Server"-View) [here in Google Chrome on Linux]:
![Auswahl_090](/uploads/e88d229820532c590fb01f9293db2b8d/Auswahl_090.jpg)
Here how to fix it:
![Auswahl_089](/uploads/8ab8ccfc11e5fb6f5ba0e9f02ae7b7b0/Auswahl_089.jpg)3.1.14