ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2023-10-21T15:52:28Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6518Remove default RBL entry for Spamhaus2023-10-21T15:52:28ZThomRemove default RBL entry for SpamhausWe should remove the default RBL Spamhaus (and maybe replace it with a alternative) to prevent non-working systems due to Spamhaus usage restrictions.We should remove the default RBL Spamhaus (and maybe replace it with a alternative) to prevent non-working systems due to Spamhaus usage restrictions.3.2.12ThomThomhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6512Hide empty dashlets2023-06-01T13:01:18ZHelmoHide empty dashletsAs a result of #6505 I noticed that the summation gives 'NAN' where there are no rows to show.
![image](/uploads/98e3564073793759834f7af5da675c63/image.png)
That made me think, why do we show e.g. the mailquota table at all on a server...As a result of #6505 I noticed that the summation gives 'NAN' where there are no rows to show.
![image](/uploads/98e3564073793759834f7af5da675c63/image.png)
That made me think, why do we show e.g. the mailquota table at all on a server that does no mail hosting.3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6510Improve verbosity when an error occurs during replication2023-06-01T13:01:46ZMichaelImprove verbosity when an error occurs during replicationFollow up to the discussion: https://forum.howtoforge.com/threads/uncaught-mysqli_sql_exception-data-truncated-for-column-warnvirusrecip-at-row-1.90116Follow up to the discussion: https://forum.howtoforge.com/threads/uncaught-mysqli_sql_exception-data-truncated-for-column-warnvirusrecip-at-row-1.901163.2.10https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6508Add menu.d directory support in all UI modules2023-05-24T09:59:21ZTill BrehmAdd menu.d directory support in all UI modulesAdd menu.d directory support in all UI modules for the menu on the left side.Add menu.d directory support in all UI modules for the menu on the left side.3.2.10Till BrehmTill Brehmhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6506Check minimum required MySQL or MariaDB version during installation and update2023-05-25T16:24:44ZTill BrehmCheck minimum required MySQL or MariaDB version during installation and updateCheck minimum required MySQL or MariaDB version during installation and updateCheck minimum required MySQL or MariaDB version during installation and update3.2.10Till BrehmTill Brehmhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6500Rename Shell user to SSH/SFTP User2023-05-05T06:40:43ZTill BrehmRename Shell user to SSH/SFTP UserRename Shell User in the menu of the web module to SSH/SFTP User as there is always some confusion about SFTP vs. FTP.Rename Shell User in the menu of the web module to SSH/SFTP User as there is always some confusion about SFTP vs. FTP.3.2.10Till BrehmTill Brehmhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6484Add support for Simplified Chinese language2023-04-14T14:53:28ZAlan MiaoAdd support for Simplified Chinese languageAs more and more users from Simplified Chinese-speaking regions join our community, it's important to make our application more accessible to them. To do this, we propose adding support for Simplified Chinese as a language option in our ...As more and more users from Simplified Chinese-speaking regions join our community, it's important to make our application more accessible to them. To do this, we propose adding support for Simplified Chinese as a language option in our application.3.2.10https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6483Improve client circle page2023-04-21T20:46:09ZblinkenboxImprove client circle pageFor us it is not very convenient to have only the client names to distinguish them on a "Client Circle" page. It would be much better to have something like "company_name (firstname name)". Also it would be better to have a line for each...For us it is not very convenient to have only the client names to distinguish them on a "Client Circle" page. It would be much better to have something like "company_name (firstname name)". Also it would be better to have a line for each client. Since we have some clients it would be nice to change the order to:
1. Circle Name
2. Description
3. Active
4. Clients/Resellers
I did this **first solution** by changing the template and sql-query and I can easily create a merge request for this.
![Screenshot_circles](/uploads/499c2b3c5722168d335e19f8a1638855/Screenshot_circles.png)
Maybe it would be even better to have a proper Table with columns. So the head fields are clickable for sorting and maybe have a search:
| member | company name | first name | name |
| ------ | ------ | ------ | ------ |
| [x]| company1 | firstname1 | name1 |
| [ ]| company2 | firstname2 | name2 |
For this **second solution** I need to study more ispconfig internals. As far as I can see the _normal_ tables in ispconfig have a database table as source. This is not the case here. If someone could point me to a similar table in ispconfig it would be easier for me to do the second solution.
My questions:
- Is it OK, to change the page at all?
- Shall I create a merge request for the first solution?
- Can anyone give me a hint for the second solution?
- Ideas for even better solutions?3.2.10https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6479Nginx as a reverse proxy2023-08-08T07:22:08ZAdamNginx as a reverse proxyI created a plugin that allows you to use nginx as a reverse proxy.
Merge request for this plugin: https://git.ispconfig.org/ispconfig/ispconfig3/-/merge_requests/1703
All you need to do is:
1. Change apache port to 6080 for http and 6...I created a plugin that allows you to use nginx as a reverse proxy.
Merge request for this plugin: https://git.ispconfig.org/ispconfig/ispconfig3/-/merge_requests/1703
All you need to do is:
1. Change apache port to 6080 for http and 6443 for https.
2. Install Nginx web server
3. Activate the Nginx Reverse Proxy plugin.
`ln -s /usr/local/ispconfig/server/plugins-available/nginx_reverseproxy_plugin.inc.php /usr/local/ispconfig/server/plugins-enabled/nginx_reverseproxy_plugin.inc.php`3.2.12AdamAdamhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6476API call to set DNSSEC algorithm and activate it.2023-05-03T12:38:53ZTomAPI call to set DNSSEC algorithm and activate it.Here a patch to add a function to activate DNSSec and adjust the algorithm.
```
--- interface/lib/classes/remote.d/dns.inc.php.orig 2023-03-09 14:03:11.406869756 +0100
+++ interface/lib/classes/remote.d/dns.inc.php 2023-03-10 12:41:29.3...Here a patch to add a function to activate DNSSec and adjust the algorithm.
```
--- interface/lib/classes/remote.d/dns.inc.php.orig 2023-03-09 14:03:11.406869756 +0100
+++ interface/lib/classes/remote.d/dns.inc.php 2023-03-10 12:41:29.308279150 +0100
@@ -845,6 +845,37 @@
}
}
+ /**
+ * Set DNSSec Algo and activate it if needed.
+ *
+ * @param int session id
+ * @param int client id
+ * @param string algorithm 'NSEC3RSASHA1', 'ECDSAP256SHA256' or 'NSEC3RSASHA1,ECDSAP256SHA256' string
+ * @param boolean update serial
+ *
+ * @author Tom Albers <kovoks@kovoks.nl> KovoKs B.V. 2023
+ */
+ public function dns_zone_set_dnssec($session_id, $client_id, $primary_id, $algo, $update_serial=false) {
+ global $app;
+ if(!$this->checkPerm($session_id, 'dns_zone_set_status')) {
+ throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
+ return false;
+ }
+
+ if(!in_array($algo, ['NSEC3RSASHA1', 'ECDSAP256SHA256', 'NSEC3RSASHA1,ECDSAP256SHA256'])) {
+ throw new SoapFault('permission_denied', 'You are not using a valid algorithm for this function.');
+ return false;
+ }
+
+ $params["dnssec_wanted"] = "Y";
+ $params["dnssec_algo"] = $algo;
+ $affected_rows = $this->updateQuery('../dns/form/dns_soa.tform.php', $client_id, $primary_id, $params);
+ if($update_serial) {
+ $this->increase_serial($session_id, $client_id, ["zone" => $primary_id]);
+ }
+ return $affected_rows;
+ }
+
private function increase_serial($session_id, $client_id, $params) {
global $app;
if(!isset($params['zone']) && isset($params['dns_rr_id'])) {
```3.2.10ThomThomhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6454Show DKIM key in unsplit format2023-05-25T18:18:58ZTill BrehmShow DKIM key in unsplit formatThe DKIM key is currently shown in split format. While some providers require this, most providers as of today probably support the unsplit format. Therefore we should change the format to unsplit format, add an option to configure it ow...The DKIM key is currently shown in split format. While some providers require this, most providers as of today probably support the unsplit format. Therefore we should change the format to unsplit format, add an option to configure it ow show both formats. Showing both formats might confuse users, so just presenting the unsplit format might be the best option.3.2.11https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6451Selecting a dnssec algorithm should imply wanting to sign the zone2023-03-09T10:04:18ZHelmoSelecting a dnssec algorithm should imply wanting to sign the zoneJust a convenience thingy ... no need to click on two checkboxes.
Just like when you click on 'Let's Encrypt SSL' we also check the 'SSL' checkbox.
![image](/uploads/8facb30e404333fdf64f0ec4dfe5f7af/image.png)Just a convenience thingy ... no need to click on two checkboxes.
Just like when you click on 'Let's Encrypt SSL' we also check the 'SSL' checkbox.
![image](/uploads/8facb30e404333fdf64f0ec4dfe5f7af/image.png)3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6450Show DNSSEC status in soa list2023-03-08T16:49:43ZHelmoShow DNSSEC status in soa listCan we add an icon in the soa list to show that a dns zone is DNSsec signed?
I propose https://fontawesome.com/v4/icon/key
![image](/uploads/039909a8696b94fa1a1179c421dbac63/image.png)Can we add an icon in the soa list to show that a dns zone is DNSsec signed?
I propose https://fontawesome.com/v4/icon/key
![image](/uploads/039909a8696b94fa1a1179c421dbac63/image.png)3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6449Show mail_domain status in list on mail_user_edit2023-03-08T16:49:35ZHelmoShow mail_domain status in list on mail_user_editYou can create mailboxes on an inactive mail_domain, but it's nice to be reminded of that status.
![image](/uploads/1e1ea8bba2d81580b2d7fe7a0a37b6cb/image.png)
What about adding `(inactive)` in the list?
I also looked at using a font-...You can create mailboxes on an inactive mail_domain, but it's nice to be reminded of that status.
![image](/uploads/1e1ea8bba2d81580b2d7fe7a0a37b6cb/image.png)
What about adding `(inactive)` in the list?
I also looked at using a font-awsone icon but that gets striped out by the chosen JS lib.3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6445Move mailbox cleanup cronjobs to be included in ISPConfig main cronjobs2023-05-26T07:29:12ZThomMove mailbox cleanup cronjobs to be included in ISPConfig main cronjobsWe don't want a third separate cronjob, so we need to clean it up and move it to the main cronjobs.We don't want a third separate cronjob, so we need to clean it up and move it to the main cronjobs.3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6435Updating a slave server should not ask for SQL root password2023-04-14T12:24:38ZHelmoUpdating a slave server should not ask for SQL root passwordWhen using the standard update script on a slave server it asks for `MySQL master server root password` when in most cases it will remain unused.
Only when you confirm the `Reconfigure Permissions in master database?` question do we do o...When using the standard update script on a slave server it asks for `MySQL master server root password` when in most cases it will remain unused.
Only when you confirm the `Reconfigure Permissions in master database?` question do we do operations that need more privileges then the normal `$conf['dbmaster_user']` account.
I propose to move the free_query inside the if block.3.2.10HelmoHelmohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6415Change default URL of phpmyadmin and webmail to apps vhost2022-11-21T14:04:44ZTill BrehmChange default URL of phpmyadmin and webmail to apps vhostChange the URL for phpmyadmin and webmail from:
```
/phpmyadmin
/webmail
```
to
```
https://[SERVERNAME]:8081/phpmyadmin
https://[SERVERNAME]:8081/webmail
```
so they work via apps vhost on Nginx and Apache.Change the URL for phpmyadmin and webmail from:
```
/phpmyadmin
/webmail
```
to
```
https://[SERVERNAME]:8081/phpmyadmin
https://[SERVERNAME]:8081/webmail
```
so they work via apps vhost on Nginx and Apache.3.2.9https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6399add mail_relay_domain API functions2023-01-29T20:56:20ZPyte Cadd mail_relay_domain API functionsAdd functions for mail_relay_domain to the remote apiAdd functions for mail_relay_domain to the remote api3.2.10https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6395Add wildcard path option to IDS whitelist.2022-10-18T07:25:58ZTill BrehmAdd wildcard path option to IDS whitelist.Add wildcard path option to IDS whitelist.Add wildcard path option to IDS whitelist.3.2.9https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6390Use predefined DH params file to speed-up installation2022-11-08T15:40:00ZTill BrehmUse predefined DH params file to speed-up installationhttps://forum.howtoforge.com/threads/dh-parameters-error-message-via-update-php.82690/#post-411166https://forum.howtoforge.com/threads/dh-parameters-error-message-via-update-php.82690/#post-4111663.2.9