ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2017-08-10T20:10:34Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3943Invalid SQL Syntax in XMPP-Domain => SSL2017-08-10T20:10:34ZLinusInvalid SQL Syntax in XMPP-Domain => SSL```You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '= 'my.domain' LIMIT 0,1' at line 1```
I get this when clicking the SSL-tab for an XMPP-Domai...```You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '= 'my.domain' LIMIT 0,1' at line 1```
I get this when clicking the SSL-tab for an XMPP-Domain. I dug a little through /usr/local/ispconfig/interface/web/mail/xmpp_domain_edit.php and found the following in line 405:
```php
$soa = $app->db->queryOneRecord("SELECT id AS zone, sys_userid, sys_groupid, sys_perm_user, sys_perm_group, sys_perm_other FROM dns_soa WHERE active = 'Y' AND = ?", $this->dataRecord['domain'].'.');
```
As you can see the AND part is missing a domain field, which seems to be "origin", so changing the line to
```php
$soa = $app->db->queryOneRecord("SELECT id AS zone, sys_userid, sys_groupid, sys_perm_user, sys_perm_group, sys_perm_other FROM dns_soa WHERE active = 'Y' AND origin = ?", $this->dataRecord['domain'].'.');
```
fixes the error. However I have no idea about XMPP and if the SSL-Tab there makes sense as it is or if I interpret the code the right way, so I'd be glad if someone more experienced with this could take a look.
3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3941Corrupt SSL Certificate breaks entire webserver2018-12-15T18:14:35ZMarianne M. SpillerCorrupt SSL Certificate breaks entire webserverHi,
the situation was: user added malformed certificate/ key in ISPC WebUI - he didn't include the "----- BEGIN CERTIFICATE -----" lines par example. Cron did its job, and then the webserver was not able to start again - it recognized...Hi,
the situation was: user added malformed certificate/ key in ISPC WebUI - he didn't include the "----- BEGIN CERTIFICATE -----" lines par example. Cron did its job, and then the webserver was not able to start again - it recognized the cert (NOT the config!) as broken - and the entire webserver with all its vhosts gets down.
Same behaviour when inserting a certificate which includes a passphrase; so it's possible to a user to (unintentionally) break all vhosts.
This should be fixed.
Regards,
Marianne3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3939DNS Import fail with TXT resource records2017-08-10T20:10:34ZCristian G. SegarraDNS Import fail with TXT resource recordsDNS Import fail to handle TXT resource records. This issue is related with #3792
If the record's data has a semicolon or some uppercase letters, the import fail to load the correct values.
For example, if the RR is a DomainKey rec...DNS Import fail to handle TXT resource records. This issue is related with #3792
If the record's data has a semicolon or some uppercase letters, the import fail to load the correct values.
For example, if the RR is a DomainKey record (Or DKIM), it has multiple values separated with semicolons and the case of the key must be keeped.
myselector._domainkey 3600 TXT "k=rsa; t=y; p=MHwwDQYJKoZIhvcNAQEBBQADawAwaAJhALsL5WZEX2crTmZN+WeuloQuRVzEsa5MZve4SC6j4pMtfBM/yqrFTuEZN2TLrc0AMFzwEGxoAA5XF4vhxzxvSLzw/wZNk/QmK6OLAyw8c0qw6Ke5R8dmVj3gI7T98cEfgQIDAQAB"
After importing the zone's file, the new registry is:
myselector._domainkey 3600 TXT "k=rsa"
This resource records must be left as they are, without truncate them on the semicolon and without change their case.
3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3936Scrolling Down issue at ISPconfig Interface2018-12-15T18:14:35ZTuhin BhuiyanScrolling Down issue at ISPconfig InterfaceWhenever navigating to any tab menu and doing wheel down/ or scroll down, it just automatically forces the screen view up again, Requires multiple time to scroll down to breaking that gravity :) .
Checked in: Firefox Developer Editio...Whenever navigating to any tab menu and doing wheel down/ or scroll down, it just automatically forces the screen view up again, Requires multiple time to scroll down to breaking that gravity :) .
Checked in: Firefox Developer Edition 64bit, Win 10.
ispconfig: 3.1b13.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3932ISPC 3.1 b1 Client web form shows * in IPv4 field IPv6 field.2017-08-10T20:10:34ZAndyPLISPC 3.1 b1 Client web form shows * in IPv4 field IPv6 field.In the case when the client creates a web hosting and server does not support IPv6 is hosting this does not create because it can not assign a vhost to an IPv6 address.
It would add an option in the server configuration, the server does...In the case when the client creates a web hosting and server does not support IPv6 is hosting this does not create because it can not assign a vhost to an IPv6 address.
It would add an option in the server configuration, the server does not have to support IPv63.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3931ISPC 3.1 b1 monitor_tools.inc.php bug2018-12-15T18:14:35ZAndyPLISPC 3.1 b1 monitor_tools.inc.php bugDebian Jessie PHP 7.0.6
Fri May 27 00:35:02 CEST 2016 PHP Fatal error: Uncaught Error: Call to undefined function swriteln() in /usr/local/ispconfig/server/lib/classes/monitor_tools.inc.php:197
Fri May 27 00:35:02 CEST 2016 Stack tr...Debian Jessie PHP 7.0.6
Fri May 27 00:35:02 CEST 2016 PHP Fatal error: Uncaught Error: Call to undefined function swriteln() in /usr/local/ispconfig/server/lib/classes/monitor_tools.inc.php:197
Fri May 27 00:35:02 CEST 2016 Stack trace:
Fri May 27 00:35:02 CEST 2016 #0 /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_os_version.inc.php(72): monitor_tools->get_distname()
Fri May 27 00:35:02 CEST 2016 #1 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(86): cronjob_monitor_os_version->onRunJob()
Fri May 27 00:35:02 CEST 2016 #2 /usr/local/ispconfig/server/cron.php(79): cronjob->run()
Fri May 27 00:35:02 CEST 2016 #3 {main}
Fri May 27 00:35:02 CEST 2016 thrown in /usr/local/ispconfig/server/lib/classes/monitor_tools.inc.php on line 197
3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3930ISPC 3.1 b1 letsencrypt cron split function2017-08-10T20:10:34ZAndyPLISPC 3.1 b1 letsencrypt cron split functionPlease change function from split() to explode() in 900-letsencrypt.inc.php
class cronjob_letsencrypt extends cronjob {
// job schedule
protected $_schedule = '0 3 * * *';
public function onRunJob() {
...Please change function from split() to explode() in 900-letsencrypt.inc.php
class cronjob_letsencrypt extends cronjob {
// job schedule
protected $_schedule = '0 3 * * *';
public function onRunJob() {
global $app, $conf;
$letsencrypt = array_shift( explode("\n", `which letsencrypt /root/.local/share/letsencrypt/bin/letsencrypt`) );
if(is_executable($letsencrypt)) {
exec($letsencrypt . ' -n renew');
$app->services->restartServiceDelayed('httpd', 'reload');
}
parent::onRunJob();
}
}
3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3929ISPC 3.1 b1 letsencrypt bug2017-08-10T20:10:34ZAndyPLISPC 3.1 b1 letsencrypt bugPlease change configuration letsencrypt because when we create hosting with support letsencrypt get information.
urn:acme:error:unauthorized :: The client lacks sufficient authorization :: Invalid response from http://domain.ltd/.well...Please change configuration letsencrypt because when we create hosting with support letsencrypt get information.
urn:acme:error:unauthorized :: The client lacks sufficient authorization :: Invalid response from http://domain.ltd/.well-known/acme-challenge/Sk1C7t4Xvj9absx1uCmI7hfSIw1ebZHFjYhQ6pL6Wqc:
Letsencrypt works correctly if you create the first web hosting and later add support letsencrypt.3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3928ISPC 3.1 b1 Call to undefined function split() in /usr/local/ispconfig/server...2017-08-10T20:10:34ZAndyPLISPC 3.1 b1 Call to undefined function split() in /usr/local/ispconfig/server/plugins-available/nginx_plugin.inc.php:1315/usr/local/ispconfig/server/server.sh
PHP Fatal error: Uncaught Error: Call to undefined function split() in /usr/local/ispconfig/server/plugins-available/nginx_plugin.inc.php:1315
Stack trace:
#0 /usr/local/ispconfig/server/plug.../usr/local/ispconfig/server/server.sh
PHP Fatal error: Uncaught Error: Call to undefined function split() in /usr/local/ispconfig/server/plugins-available/nginx_plugin.inc.php:1315
Stack trace:
#0 /usr/local/ispconfig/server/plugins-available/nginx_plugin.inc.php(321): nginx_plugin->update('web_domain_inse...', Array)
#1 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): nginx_plugin->insert('web_domain_inse...', Array)
#2 /usr/local/ispconfig/server/mods-available/web_module.inc.php(134): plugins->raiseEvent('web_domain_inse...', Array)
#3 /usr/local/ispconfig/server/lib/classes/modules.inc.php(285): web_module->process('web_domain', 'i', Array)
#4 /usr/local/ispconfig/server/lib/classes/modules.inc.php(218): modules->raiseTableHook('web_domain', 'i', Array)
#5 /usr/local/ispconfig/server/server.php(179): modules->processDatalog()
#6 {main}
thrown in /usr/local/ispconfig/server/plugins-available/nginx_plugin.inc.php on line 1315
3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3926ISPC 3.1 b1 frontend bug -web directives2017-08-10T20:10:34ZAndyPLISPC 3.1 b1 frontend bug -web directives![isp-redirect-disp-bug](/uploads/dddaaebe7f05731f30016a904bdf3e05/isp-redirect-disp-bug.jpg)![isp-redirect-disp-bug](/uploads/dddaaebe7f05731f30016a904bdf3e05/isp-redirect-disp-bug.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3924ISPC 3.1 b1 delete client confirmation2018-12-15T18:14:35ZAndyPLISPC 3.1 b1 delete client confirmationPlease correct display confirm the deletion of the customer.
![isp-display-delclient](/uploads/006d32f622035fcc2c77e0eed5208c83/isp-display-delclient.jpg)Please correct display confirm the deletion of the customer.
![isp-display-delclient](/uploads/006d32f622035fcc2c77e0eed5208c83/isp-display-delclient.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3923ISPC 3.1 b1 display line (e.g. https://www.example.com:80802017-08-10T20:10:35ZAndyPLISPC 3.1 b1 display line (e.g. https://www.example.com:8080Change display this line: (e.g. https://www.example.com:8080
![isp-display-import](/uploads/f2899e8863b8e9d39676c61c3c24a43a/isp-display-import.jpg)Change display this line: (e.g. https://www.example.com:8080
![isp-display-import](/uploads/f2899e8863b8e9d39676c61c3c24a43a/isp-display-import.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3922ISPC 3.1 b1 Monitor bug2018-12-15T18:14:35ZAndyPLISPC 3.1 b1 Monitor bugPlease correct errors in displaying on the left side "Status systemu (Wszystkie"
![isp-display-monitor](/uploads/8e404212e1bb118edf0016c7d2f9e704/isp-display-monitor.jpg)Please correct errors in displaying on the left side "Status systemu (Wszystkie"
![isp-display-monitor](/uploads/8e404212e1bb118edf0016c7d2f9e704/isp-display-monitor.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3921ISPC 3.1 b1 Polish translation2018-12-15T18:14:35ZAndyPLISPC 3.1 b1 Polish translationPlease change translation from "Go to ..." to "Idź do ..."
![isp-translation1](/uploads/688c80980e423b58b50dc4939dfb531d/isp-translation1.jpg)Please change translation from "Go to ..." to "Idź do ..."
![isp-translation1](/uploads/688c80980e423b58b50dc4939dfb531d/isp-translation1.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3920ISPC 3.1 b1 quota mysql error display2017-08-10T20:10:35ZAndyPLISPC 3.1 b1 quota mysql error displayAs you can see wrong is displayed occupied space by the database
![isp-mysql](/uploads/8701c22a93c1ba1e2147f76ec6c99a8d/isp-mysql.jpg)As you can see wrong is displayed occupied space by the database
![isp-mysql](/uploads/8701c22a93c1ba1e2147f76ec6c99a8d/isp-mysql.jpg)3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3916Strict-Transport-Security is enforced on all websites2020-03-18T19:33:23ZEgbertStrict-Transport-Security is enforced on all websitesIn ISPConfig 3.1 (beta), when I enable SSL for a website it will automatically force the Strict-Transport-Security header, which is unwanted.
This website serves two types of content depending on whether the website is accessed throug...In ISPConfig 3.1 (beta), when I enable SSL for a website it will automatically force the Strict-Transport-Security header, which is unwanted.
This website serves two types of content depending on whether the website is accessed through http or https: http will result in a static web page provinding general information, https will provide a webapp that requires a login and handles sensitive data.
By specifiying the Strict-Transport-Security this effectively renders the HTTP-version unusable once the HTTPS site has been visited.
HSTS should not be enabled by default as it may cause unexpected results. It should be a option setting, with the ability to change the max-age parameter, the subdomain policy and the preload setting.
To resolve this issue, I had to add
Header always unset Strict-Transport-Security
to the Apache Directives in the website configuration, but that feels a bit in reverse to me.3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3914Bug during installation of ISPConfig 3.1 on a System with PHP7.0-FPM2017-08-10T20:10:35ZNathanaelBug during installation of ISPConfig 3.1 on a System with PHP7.0-FPMSystem: Ubuntu 16.04 with Nginx and PHP7
Output of the Installer:
Restarting services ...
Failed to reload php5-fpm.service: Unit php5-fpm.service not found.
Installation completed.
After the installation Nginx give the Erro...System: Ubuntu 16.04 with Nginx and PHP7
Output of the Installer:
Restarting services ...
Failed to reload php5-fpm.service: Unit php5-fpm.service not found.
Installation completed.
After the installation Nginx give the Error-Code 502 Bad Gateway if one tries to access the control panel.3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3913Changing FTP password sets expiration to 0000-00-00 prevents login2017-08-10T20:10:35ZKevin DethlefsChanging FTP password sets expiration to 0000-00-00 prevents loginI was attempting to update Wordpress via FTP (since ISPConfig 3.1 doesn't seem to have suPHP on Ubuntu 16.04 with PHP 7.0), and I had to reset the password. It continued to fail to log in.
Syslog continued to say failing to log in, ev...I was attempting to update Wordpress via FTP (since ISPConfig 3.1 doesn't seem to have suPHP on Ubuntu 16.04 with PHP 7.0), and I had to reset the password. It continued to fail to log in.
Syslog continued to say failing to log in, even though I copied the password.
After getting frustrated, I found the config files, found out it pulls directly from dbispconfig and then logged in to that database with phpmyadmin and found that the FTP expiration was not NULL but all 0's.
Setting to NULL in the database allowed login and functioned perfectly.
Changed the password again, it removed the NULL and set back to all 0's.
If date is there, it persists.3.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3912530 login authentication failed after ISPConfig update2017-08-10T20:10:35ZTill Brehm530 login authentication failed after ISPConfig updatehttps://www.howtoforge.com/community/threads/530-login-authentication-failed-after-ispconfig-update.73087/#post-343829https://www.howtoforge.com/community/threads/530-login-authentication-failed-after-ispconfig-update.73087/#post-3438293.1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3911Billing client list edit / cancel2018-12-15T18:14:35ZTristanBilling client list edit / cancelHi,
Sorry for my funny english, i'm french and i don't speak very well…
When i edit a client from the client list on the billing tab, if i click the cancel button, redirection page is the client list on the client tab (with no sett...Hi,
Sorry for my funny english, i'm french and i don't speak very well…
When i edit a client from the client list on the billing tab, if i click the cancel button, redirection page is the client list on the client tab (with no setting button).
Regards,3.1