ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2019-09-04T09:10:28Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5355Implement a more secure way to use exec, system and shell_exec2019-09-04T09:10:28ZMarius BurkardImplement a more secure way to use exec, system and shell_execUse a similar approach as we have with database queries (placeholders and argument list that automatically gets quoted).Use a similar approach as we have with database queries (placeholders and argument list that automatically gets quoted).3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5382Remote API: monitor_jobqueue_count returning wrong count in multiserver setup2019-09-02T14:14:15ZRadim ŠulákRemote API: monitor_jobqueue_count returning wrong count in multiserver setup## short description
I have two servers: S1 (master) and S2 (slave).
When I make a change on S2, the number of pending tasks increases on S1 too. When the task is completed on S2, it still remains counted as incompleted on S1.
## corr...## short description
I have two servers: S1 (master) and S2 (slave).
When I make a change on S2, the number of pending tasks increases on S1 too. When the task is completed on S2, it still remains counted as incompleted on S1.
## correct behaviour
The function monitor_jobqueue_count() in /interface/lib/classes/remote.d/monitor.inc.php should use the "server_id" parameter in SQL query, so it counts tasks for selected server only.
## environment
Server OS: Debian
Server OS version: Buster (10)
ISPConfig version: 3.1dev
## proposed fix
Replace
```
$tmp = $app->db->queryOneRecord('SELECT count(datalog_id) as jobqueue_count FROM sys_datalog WHERE datalog_id > ?',$server['updated']);
```
with
```
$tmp = $app->db->queryOneRecord('SELECT count(datalog_id) as jobqueue_count FROM sys_datalog WHERE datalog_id > ? AND server_id = ?',$server['updated'],$server_id);
```3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5379Rspamd has inconsistent greylisting setting2021-04-16T15:24:58ZMarius BurkardRspamd has inconsistent greylisting settingWhen using rspamd the greylisting is set via spamfilter policies. Instead it should use the same setting that are used by amavis (mail user, mail fwd/alias, mail catchall).When using rspamd the greylisting is set via spamfilter policies. Instead it should use the same setting that are used by amavis (mail user, mail fwd/alias, mail catchall).3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5378Greylisting setting not respected under some circumstances2019-08-30T13:27:13ZMarius BurkardGreylisting setting not respected under some circumstancesIf a catchall is defined for a mail domain and the target has configured greylisting "yes", then it is not possible to disable greylisting for a specific mail account of that domain.
This does not affect rspamd.
The query for that is
`...If a catchall is defined for a mail domain and the target has configured greylisting "yes", then it is not possible to disable greylisting for a specific mail account of that domain.
This does not affect rspamd.
The query for that is
```sql
SELECT 'greylisting' FROM (SELECT greylisting, source AS email FROM mail_forwarding WHERE server_id = {server_id} UNION SELECT greylisting, email FROM mail_user WHERE server_id = {server_id}) addresses WHERE addresses.email='%s' AND addresses.greylisting='y' UNION SELECT 'greylisting' FROM `mail_forwarding` f CROSS JOIN `mail_user` u ON u.email = f.destination WHERE f.type = 'catchall' AND u.greylisting = 'y' AND u.server_id = {server_id} AND f.source = '@%s'
```
The "UNION SELECT" part is responsible for this behaviour.3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5373No file when dns zone delete.2019-08-29T12:15:09ZMarek AdamskiNo file when dns zone delete.## short description
in ispconfig i select domain to delete
## correct behaviour
root@server /usr/local/ispconfig/server/server.sh
sh: /usr/local/ispconfig/server/scripts/dnssec-delete.sh: file not found
## environment
Server OS: debi...## short description
in ispconfig i select domain to delete
## correct behaviour
root@server /usr/local/ispconfig/server/server.sh
sh: /usr/local/ispconfig/server/scripts/dnssec-delete.sh: file not found
## environment
Server OS: debian
Server OS version: stretch
ISPConfig version: 3.1.14p2
3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5369Internal ISPConfig cronjobs are not run in 3.1-dev version2019-08-16T13:21:55ZTill BrehmInternal ISPConfig cronjobs are not run in 3.1-dev versionInternal ISPConfig cronjobs are not run. This problem existed in git stable versions from July 30 until August 16. Released versions are not affected by this.
To fix the issue, update to ISPConfig 3.1.15 (when it got released) or to git...Internal ISPConfig cronjobs are not run. This problem existed in git stable versions from July 30 until August 16. Released versions are not affected by this.
To fix the issue, update to ISPConfig 3.1.15 (when it got released) or to git-stable.3.1.15Till BrehmTill Brehmhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5362UBUNTU 18.04 + PHP7.2-FPM / FRESH INSTALL : ERROR 5032019-08-06T18:06:39ZJulien GauthierUBUNTU 18.04 + PHP7.2-FPM / FRESH INSTALL : ERROR 503Hi,
After few fresh install Bionic & ISPConfig3 i get the same error with Php7.2-fpm = error 503.
log :
ee the debug log :
05.08.2019-23:28 - DEBUG - Enable SSL for: ***.*****.com
05.08.2019-23:28 - DEBUG - Writing the vhost file: /etc...Hi,
After few fresh install Bionic & ISPConfig3 i get the same error with Php7.2-fpm = error 503.
log :
ee the debug log :
05.08.2019-23:28 - DEBUG - Enable SSL for: ***.*****.com
05.08.2019-23:28 - DEBUG - Writing the vhost file: /etc/apache2/sites-available/***.*****.vhost
====> 05.08.2019-23:28 - DEBUG - Writing the PHP-FPM config file: /web3.conf <=====================
05.08.2019-23:28 - DEBUG - Calling function 'restartPHP_FPM' from module 'web_module'.
05.08.2019-23:28 - DEBUG - Restarting php-fpm: systemctl reload php7.2-fpm.service
05.08.2019-23:28 - DEBUG - Apache status is: running
05.08.2019-23:28 - DEBUG - Calling function 'restartHttpd' from module 'web_module'.
05.08.2019-23:28 - DEBUG - Restarting httpd: systemctl restart apache2.service
05.08.2019-23:28 - DEBUG - Apache restart return value is: 0
05.08.2019-23:28 - DEBUG - Apache online status after restart is: running
05.08.2019-23:28 - DEBUG - Processed datalog_id 37
05.08.2019-23:28 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
in the folder pool.d :
root@***:/etc/php/7.2/fpm/pool.d# ls
www. conf
root@***:/etc/php/7.2/fpm/pool.d#
in the folder /var/lib/ (socks)
root@***:/etc/php/7.2/fpm/pool.d# cd /var/lib/php7.2-fpm/
root@***:/var/lib/php7.2-fpm# ls
root@***:/var/lib/php7.2-fpm#
No way to find the web3.conf
No sock file in /var/lib/php7.2-fpm
install was create by follow the perfect server
https://www.howtoforge.com/tutorial/perfect-server-ubuntu-18.04-with-apache-php-myqsl-pureftpd-bind-postfix-doveot-and-ispconfig/
In the past (few day ago) no error or problem.
This days we get this error with absolutely 0 information about in debug mode.
Thanks for your help.
Xym3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5356Client can create global whitelists and blacklists for email2019-09-02T14:14:51ZMarius BurkardClient can create global whitelists and blacklists for emailA client can create global postfix whitelists and blacklists for every domain he likes to. This function should be limited to admin.A client can create global postfix whitelists and blacklists for every domain he likes to. This function should be limited to admin.3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5351Remote API function dns_templatezone_add issue2019-10-07T14:41:26ZTill BrehmRemote API function dns_templatezone_add issuehttps://www.howtoforge.com/community/threads/problem-on-dns-zone-creation-after-update-to-3-1-14p1.82392/https://www.howtoforge.com/community/threads/problem-on-dns-zone-creation-after-update-to-3-1-14p1.82392/3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5348Virtual server config panel showing without active VServer2019-09-02T13:45:00ZMark CraxfordVirtual server config panel showing without active VServer![Screenshot_20190720_120620](/uploads/462765d49c4f4dfd939b3ffdceadc872/Screenshot_20190720_120620.jpg)![Screenshot_20190720_120717](/uploads/47117b5711b474ea91b5ad9f17acc31e/Screenshot_20190720_120717.jpg)
Cluster setup (incomplete)
V...![Screenshot_20190720_120620](/uploads/462765d49c4f4dfd939b3ffdceadc872/Screenshot_20190720_120620.jpg)![Screenshot_20190720_120717](/uploads/47117b5711b474ea91b5ad9f17acc31e/Screenshot_20190720_120717.jpg)
Cluster setup (incomplete)
Virtual server button shows on dashboard and is accessible. No virtual server configured or package(s) installed. Will update when cluster is complete.
Debian 10 Buster.
Apache2 2.4.38
Php 7.3
Ispconfig sourced on the 19 July 2019 (Is there a version check in the gui?) http://www.ispconfig.org/downloads/ISPConfig-3-stable.tar.gz3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5343Buster/Dovecot stats-writer2020-05-19T11:01:15ZHelmoBuster/Dovecot stats-writerI noticed another issue on an upgraded test server...
```
postfix/pipe[9881]: 18F1A402DF: to=<drdev@example.com>, relay=dovecot, delay=0.05, delays=0/0.01/0/0.03, dsn=2.0.0, status=sent (delivered via dovecot service (lda(drdev@example.c...I noticed another issue on an upgraded test server...
```
postfix/pipe[9881]: 18F1A402DF: to=<drdev@example.com>, relay=dovecot, delay=0.05, delays=0/0.01/0/0.03, dsn=2.0.0, status=sent (delivered via dovecot service (lda(drdev@example.com,)Error: net_connect_unix(/var/run/dovecot/stats-writer) failed: Permission de))
```
By default the stats-writer socket is owned by root.dovecot ... while the delivery is running as the vmail user.
The solution from https://forum.iredmail.org/post67035.html#p67035 seems to work. It adds to dovecot.conf:
```
service stats {
unix_listener stats-reader {
user = vmail
group = vmail
mode = 0660
}
unix_listener stats-writer {
user = vmail
group = vmail
mode = 0660
}
}
```3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/4974Remoting API call sites_aps_update_package_list() error2019-09-02T14:28:22ZkobukiRemoting API call sites_aps_update_package_list() errorI'm trying to schedule the APS package update via cron, using the API, but I get a SOAP error every time:
```
$ php aps_update_packages.php
Login successful, session ID: d333694e14016e81d1d00290e6553713
Starting sites_aps_update_package...I'm trying to schedule the APS package update via cron, using the API, but I get a SOAP error every time:
```
$ php aps_update_packages.php
Login successful, session ID: d333694e14016e81d1d00290e6553713
Starting sites_aps_update_package_list()...
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring>require_once(): Failed opening required '../../../lib/config.>
SOAP Error: require_once(): Failed opening required '../../../lib/config.inc.php' (include_path='.:/usr/share/php')
```
When I comment out aps.inc.php line 47 (require_once), it seems to run as expected. I think it was left there inadvertently.
Also, all functions in this file are called using interface mode, is that intended or a mistake?3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5383Updated Czech translation for 3.1.14p22019-09-02T12:25:44ZTill BrehmUpdated Czech translation for 3.1.14p2Updated Czech translation. Thank you to Tomáš for submitting it![cz.lng](/uploads/87a67846bbb669c747c3d6e1dfd5782a/cz.lng)Updated Czech translation. Thank you to Tomáš for submitting it![cz.lng](/uploads/87a67846bbb669c747c3d6e1dfd5782a/cz.lng)3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5375Add WebDAV functions to remoting API2020-06-22T19:28:35ZTill BrehmAdd WebDAV functions to remoting APIAdd WebDAV functions to remoting APIAdd WebDAV functions to remoting API3.1.15https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5358Give the focus to "username" edit box on login page2019-08-03T08:54:57ZPatrick ZajdaGive the focus to "username" edit box on login pageWhen the ISPConfig login page is displayed, the focus is not given.
Would it be possible to give the focus to "Username" edit box?
It could help for accessibility for example and to be able to type the username directly when the page is ...When the ISPConfig login page is displayed, the focus is not given.
Would it be possible to give the focus to "Username" edit box?
It could help for accessibility for example and to be able to type the username directly when the page is opened.3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5353Support CRYPT-SHA512 for passwords2020-01-31T13:49:22ZMarius BurkardSupport CRYPT-SHA512 for passwordsAdd support for CRYPT-SHA512 and SHA256 passwords to ISPConfig and make it the default password algorithm if available in PHP.Add support for CRYPT-SHA512 and SHA256 passwords to ISPConfig and make it the default password algorithm if available in PHP.3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5342Remove MySQL engine directive from SQL files2019-08-03T08:55:43ZTill BrehmRemove MySQL engine directive from SQL filesRemove MySQL engine directive from SQL files so that the default engine is used. This will default to InnoDB instead of MyISAM on newer systems.Remove MySQL engine directive from SQL files so that the default engine is used. This will default to InnoDB instead of MyISAM on newer systems.3.1.15Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3807Support for Rspamd2019-10-29T21:05:00ZJan KopeckySupport for RspamdPlease consider support for Rspamd. It should be more accurate than spamassassin and it should be 13 times faster than spamassassin.
https://rspamd.com
https://rspamd.com/misc/2016/03/03/rspamd-performance.htmlPlease consider support for Rspamd. It should be more accurate than spamassassin and it should be 13 times faster than spamassassin.
https://rspamd.com
https://rspamd.com/misc/2016/03/03/rspamd-performance.html3.1.15Marius BurkardMarius Burkard