ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2023-08-28T15:41:45Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6562Database jobs not finishing?2023-08-28T15:41:45ZDannyDatabase jobs not finishing?<!-- Before creating a bug report, please:
- Read the contribution guidelines: https://git.ispconfig.org/ispconfig/ispconfig3/-/blob/develop/CONTRIBUTING.md
- Do not ask support questions here. If you are unsure if your problem is a bug,...<!-- Before creating a bug report, please:
- Read the contribution guidelines: https://git.ispconfig.org/ispconfig/ispconfig3/-/blob/develop/CONTRIBUTING.md
- Do not ask support questions here. If you are unsure if your problem is a bug, post a thread on the forum: https://www.howtoforge.com/community/#ispconfig-3.23
- Make sure to remove any content from the description that you did not add. For example, if there are no related log entries, remove the whole "Related log entries" part.
-->
## Summary
deleting or creating a database on a other server doesn't seem to finish (it does, but red circle doesnt go away)
## Steps to reproduce
1. create a user or delete a user on a external db server
2. see jobs increment
3. running server.sh with debug doesn't show errors
4. yet the jobs doesn't seem to finish as the red circle isnt go away. doing other jobs than db things does finish and the number goes down.
## Correct behaviour
red circle to be gone.
## Environment
Ubuntu 20.04.6 LTS (Focal Fossa)) ISPConfig 3.2.11
## Screenshots
![image](/uploads/02e0f9df60c4dade6c10f07c8796046c/image.png)https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6447DKIM key can not be generated without saving email domain first2023-07-17T18:49:14ZTill BrehmDKIM key can not be generated without saving email domain firsthttps://forum.howtoforge.com/threads/cant-generate-dkim-private-key-in-domain-creation-page.90006/https://forum.howtoforge.com/threads/cant-generate-dkim-private-key-in-domain-creation-page.90006/https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6207private/cron.log and private/cron_error.log are not being created2021-08-04T10:29:28ZMichaelprivate/cron.log and private/cron_error.log are not being createdIf you activate logging for a cronjob, then the files cron.log and cron_error.log are not created.
However, the stdout and stderr redirects requires that these files exist.If you activate logging for a cronjob, then the files cron.log and cron_error.log are not created.
However, the stdout and stderr redirects requires that these files exist.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6196Mailformed configuration of /etc/postfix/main.cf2021-07-15T18:27:19ZBernd SchuhmacherMailformed configuration of /etc/postfix/main.cf## Summary
After upgrading to ISPConfig 3.2.5 it seems the main.cf of postfix is malformed. Two servers I upgraded had the same issue and were not able to send mails aufter the upgrade (mail queue showed an "unknown mail transport error"...## Summary
After upgrading to ISPConfig 3.2.5 it seems the main.cf of postfix is malformed. Two servers I upgraded had the same issue and were not able to send mails aufter the upgrade (mail queue showed an "unknown mail transport error").
Looking into _/etc/postfix/main_ showed a missing linebreak between
`smtp_bind_address = <IP>smtpd_reject_unlisted_sender = no`
After changing this to
`smtp_bind_address = <IP>`
`smtpd_reject_unlisted_sender = no`
it worked.
## Steps to reproduce
I can't reproduce the error as all my servers are upgraded at the moment. But here are the steps I did on two ISPConfig installations
1. started the update of ISPConfig
2. Reconfigured all service whith the update wizard
3. tried to send mails on the maschine
## Correct behaviour
The mails should have been sent.
## Environment
Server OS + version: Ubuntu 20.04
ISPConfig version: upgrade from 3.1.5 to 3.2.5
Software version of the related software: postfix 3.4.13-0ubuntu1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6192reload (not restart) rspamd when possible2021-06-25T17:30:17ZJesse Norellreload (not restart) rspamd when possibleWe should look at all places where the rspamd server plugin restarts rspamd, and use "reload" instead of "restart" wherever possible. When rspamd is restarted, any mail currently being scanned is delivered without scanning (I found this ...We should look at all places where the rspamd server plugin restarts rspamd, and use "reload" instead of "restart" wherever possible. When rspamd is restarted, any mail currently being scanned is delivered without scanning (I found this while investigating why an occasional "blatantly obvious spam" message gets through the filter - ispconfig had restarted rspamd while it was delivering).https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6165Rspamd redis server is empty upon install2021-05-27T12:09:02ZThomRspamd redis server is empty upon install<!-- Before creating a bug report, please:
- Read the contribution guidelines: https://git.ispconfig.org/ispconfig/ispconfig3/-/blob/develop/CONTRIBUTING.md
- Do not ask support questions here. If you are unsure if your problem is a bug,...<!-- Before creating a bug report, please:
- Read the contribution guidelines: https://git.ispconfig.org/ispconfig/ispconfig3/-/blob/develop/CONTRIBUTING.md
- Do not ask support questions here. If you are unsure if your problem is a bug, post a thread on the forum: https://www.howtoforge.com/community/#ispconfig-3.23
- Make sure to remove any content from the description that you did not add. For example, if there are no related log entries, remove the whole "Related log entries" part.
-->
## Summary
Upon initial install, the rspamd redis server is empty, it should be `127.0.0.1`
## Environment
ISPConfig version: 3.2.4https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5042www. always added to alias subdomain breaking Letsencrypt2021-05-21T12:30:16ZSuperwww. always added to alias subdomain breaking Letsencrypt## Description:
ISPConfig erroneously adds the www. prefix to alias domains regardless of the settings chosen causing LetsEncrypt to fail to issue the certificate. no matter what I do I simply cannot get it to try to issue the certificat...## Description:
ISPConfig erroneously adds the www. prefix to alias domains regardless of the settings chosen causing LetsEncrypt to fail to issue the certificate. no matter what I do I simply cannot get it to try to issue the certificate without the www. prefix. I have even checked IPSConfig's database entries in web_domain and is_subdomainwww is always set to 1, and setting it to 0 and retrying has no effect (if this is even the relevant entry). It should not be necessary to add an incorrect DNS entry just to get this to work.
This is a new domain, added in the past couple of days.
As a side note, this seems to have broken in a recent update as earlier aliases worked.
## Proposed fix:
ISPConfig should recognise the Auto-Subdomain option in the Web Aliasdomain options. Actually, I dread going anywhere near the domain settings and anything to do with LetsEncrypt as it invariably breaks something each time, or simply doesn't update (e.g. remove domains), or do what is expected. It is extremely fragile and could do with revising.
## Letsencrypt log:
FailedChallenges: Failed authorization procedure. www.mail.xxxxx.com (http-01): urn:acme:error:dns
## Environment:
ISPConfig 3.1.11 on Ubuntu 16.04.1, Apache 2.4.18, PHP 7.0.28
## References
https://www.howtoforge.com/community/threads/lets-encrypt-cert-without-www-prefix.77016/
https://git.ispconfig.org/ispconfig/ispconfig3/issues/4983 (possibly related)
Thank you!
![Untitled-1](/uploads/8b0cfb837c43f96b4575edebb72bfd1b/Untitled-1.jpg)
![Untitled-2](/uploads/282545366b0af855388eec521a633d59/Untitled-2.jpg)https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/6033Failed to make backup of database (for empty DB)2021-02-18T15:53:20ZPatrick SchlesingerFailed to make backup of database (for empty DB)## short description
If a database is empty, the error is triggered:
01/28/2021-11:39 - ERROR - Failed to make backup of database c4_****
This works:
```
mysqldump -u root -p c4_*** > dumpfile.sql
```
## dumpfile.sql
```
-- MySQL dump...## short description
If a database is empty, the error is triggered:
01/28/2021-11:39 - ERROR - Failed to make backup of database c4_****
This works:
```
mysqldump -u root -p c4_*** > dumpfile.sql
```
## dumpfile.sql
```
-- MySQL dump 10.18 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: c4_***
-- ------------------------------------------------------
-- Server version 10.3.27-MariaDB-0+deb10u1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-01-28 11:42:01
```
## environment
Server OS: (debian)
Server OS version: (10.7)
ISPConfig version: (3.2dev20201215)
Server-Typ: MariaDB
Server-Version: 10.3.27-MariaDB-0+deb10u1 - Debian 10
Datenbank-Client Version: libmysql - mysqlnd 5.0.12-dev
PHP-Erweiterung: mysqli curl mbstring
PHP-Version: 7.3.19-1~deb10u1
## log entries
```
01/28/2021-11:39 - ERROR - Failed to make backup of database c4_****
```https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5998Ispconfig 3.2.2 does not create database for the users2021-01-05T15:25:45ZAlexandre Pereira BühlerIspconfig 3.2.2 does not create database for the usersEnviroment: Debian 9 and Debian 10 with ISPConfig 3.2.2
I updated today to ispconfig 3.2.2.
When a user tries to create a database, it appears as created in the panel. But in practice it is not created in Mariadb.
In version 3.2.1 it was...Enviroment: Debian 9 and Debian 10 with ISPConfig 3.2.2
I updated today to ispconfig 3.2.2.
When a user tries to create a database, it appears as created in the panel. But in practice it is not created in Mariadb.
In version 3.2.1 it was working normal.
There is no error in the cron.log in the debug.
And we noticed that the task of creating the bank in the red ball does not appear next to the research field.
But the task is recorded in the sys_datalog logs.
I upgraded to 3.2.2 and now I'm starting to regret it.
My contrab this normal
* * * * * /usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done
* * * * * /usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; donehttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/4511Let's encrypt gets disabled if user has no permission to set/change it2020-10-27T16:22:55ZKoSLet's encrypt gets disabled if user has no permission to set/change itHow to reproduce it in version 3.1.2:
- as admin: activate let's encrypt ssl & ssl for a subdomain (vhost)
- as user WITHOUT let's encrypt privileges/limit: just VIEW the vhost and click trough the tabs
- immediately the interface shows ...How to reproduce it in version 3.1.2:
- as admin: activate let's encrypt ssl & ssl for a subdomain (vhost)
- as user WITHOUT let's encrypt privileges/limit: just VIEW the vhost and click trough the tabs
- immediately the interface shows one change pending in the notification bar, and a view into the ispconfig database shows that the "ssl_lets_encrypt" is set to no
This means that If an admin activates let's encrypt for a vhost, and a normal user checks afterwards the settings of the vhost, he will disable the let's encrypt and make the httpS unusable (or even the whole website as probably in most cases the httpS redirection is activated).
I "fixed" the issue by giving all the users the ssl and let's encrypt permission.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5842Logs not coming from "Server to Monitor"2020-10-22T23:18:45ZTony GLogs not coming from "Server to Monitor"v3.2 over Ubuntu, Monitor tab : Select a Server to Monitor. Now select any log under Server State. The log is always from the primary/localhost, not from the selected server.
I might be missing some other setting that allows a secondary...v3.2 over Ubuntu, Monitor tab : Select a Server to Monitor. Now select any log under Server State. The log is always from the primary/localhost, not from the selected server.
I might be missing some other setting that allows a secondary server to make its logs available to the primary.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5831Bug in creating db user and shell user2020-10-17T12:37:46ZJonathan SvendsenBug in creating db user and shell user## short description
What is happening and what is wrong with that?
## environment
Server OS: (Ubuntu 20.04.1 LTS)
ISPConfig version: (3.2)
I just installed ISPConfig 3.2 from scratch from this guide here:
https://www.howtoforge.com...## short description
What is happening and what is wrong with that?
## environment
Server OS: (Ubuntu 20.04.1 LTS)
ISPConfig version: (3.2)
I just installed ISPConfig 3.2 from scratch from this guide here:
https://www.howtoforge.com/tutorial/perfect-server-ubuntu-20.04-with-apache-php-myqsl-pureftpd-bind-postfix-doveot-and-ispconfig/
And I replaced the last part with the final release of 3.2
All works fine execpt when I try to create a shell user or database, ftp etc. it will be named default, instead of [CLIENTNAME]
And DB user is not added into the users in phpmyadmin
## screenshots
![ISPConfigShell](/uploads/56630fbd39364a74a334ae88e191631b/ISPConfigShell.png)
![localhost-phpMyAdmin-4-9-5deb2](/uploads/36f6024c948a9f223dda8cd34eb9d680/localhost-phpMyAdmin-4-9-5deb2.png)https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5788[Nightly] DB User without password2020-10-12T06:17:06ZPascal Herbert[Nightly] DB User without passwordusing the following config:
ISPconfig 3.2dev20200930
Ubuntu 20.04.1 LTS
MariaDB 10.3
i did the following
added a db user "isptestdb"
added a new db and assigned the user to it
i could not connect to the db, so i checked in phpmyadmin i...using the following config:
ISPconfig 3.2dev20200930
Ubuntu 20.04.1 LTS
MariaDB 10.3
i did the following
added a db user "isptestdb"
added a new db and assigned the user to it
i could not connect to the db, so i checked in phpmyadmin it has no password:
![image](/uploads/51615743da9eccd2e2788b142cd0cceb/image.png)
after that i did the same thing with debug log:
```
30.09.2020-08:12 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
30.09.2020-08:12 - DEBUG - Created MySQL database: isptestdb
30.09.2020-08:12 - DEBUG - Calling GRANT for isptestdb with access rw and hosts localhost
30.09.2020-08:12 - DEBUG - GRANT for user isptestdb at host localhost
30.09.2020-08:12 - DEBUG - CREATE USER 'isptestdb'@'localhost'
30.09.2020-08:12 - DEBUG - GRANT ALL PRIVILEGES ON `isptestdb`.* TO 'isptestdb'@'localhost' success? no
30.09.2020-08:12 - DEBUG - Processed datalog_id 1326
30.09.2020-08:12 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.09.2020-08:13 - DEBUG - You must install incron in order to use this plugin
30.09.2020-08:13 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.09.2020-08:13 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.09.2020-08:14 - DEBUG - You must install incron in order to use this plugin
30.09.2020-08:14 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.09.2020-08:14 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
```
after that i tried to set a new password, and the db user got a new password.
after that i added remote access and the entry for "hostname %" had no password.
![image](/uploads/27af389840abb34a4e5ebf891d72bad2/image.png)
settting a new password solved that problem.
i have seen #5748 which is similar but the problem still exists in latest nightly.
i also run a test with mariadb 10.4 and 10.5. the same problem happens.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5804Variables not parsing when sending messages via control panel2020-10-05T18:37:43ZSteliosVariables not parsing when sending messages via control panelHi,
I tried to email all clients via ISPconfig control panel and used the variable {contact_firstname}.
The email came fine but the variable didn't include the customer's first name; it just showed the variable as it is {contact_firstna...Hi,
I tried to email all clients via ISPconfig control panel and used the variable {contact_firstname}.
The email came fine but the variable didn't include the customer's first name; it just showed the variable as it is {contact_firstname}.
Also further to above the search doesn't work. It shows the option to email all clients.
If you try to add any client name on Recipient filed it always displays 'No matches found'.
root@web1:~# grep 'ISPC_APP_VERSION' /usr/local/ispconfig/server/lib/config.inc.php
define('ISPC_APP_VERSION', '3.1.15p3');
$conf['app_version'] = ISPC_APP_VERSION;
root@web1:~# apachectl -v
Server version: Apache/2.4.38 (Debian)
Server built: 2020-08-25T20:08:29
root@web1:~# php -v
PHP 7.3.22-1+0~20200909.67+debian10~1.gbpdd7b72 (cli) (built: Sep 9 2020 06:55:18) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.22, Copyright (c) 1998-2018 Zend Technologies
with the ionCube PHP Loader + ionCube24 v10.4.3, Copyright (c) 2002-2020, by ionCube Ltd.
with Zend OPcache v7.3.22-1+0~20200909.67+debian10~1.gbpdd7b72, Copyright (c) 1999-2018, by Zend Technologieshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5790Incorrect POP3/IMAP Daemon displayed2020-10-03T07:15:00ZTony GIncorrect POP3/IMAP Daemon displayed## short description
In the Server Config page, Mail tab, field POP3/IMAP Daemon, the default value is Courier even though Courier is not installed and Dovecot is.
## correct behaviour
I believe if there is no override set, a check sho...## short description
In the Server Config page, Mail tab, field POP3/IMAP Daemon, the default value is Courier even though Courier is not installed and Dovecot is.
## correct behaviour
I believe if there is no override set, a check should be done to determine/display which package is installed on the server being queried. This might just be bad data in the UI.
## environment
Server OS: Ubuntu
Server OS version: 20
ISPConfig version: 3.2beta2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3469mysql-virtual_outgoing_bcc.cf is zero size2020-09-30T11:27:21ZNickmysql-virtual_outgoing_bcc.cf is zero sizeafter one of ispconfig git updates have a error in postfix log - postfix can't read dbname from mysql-virtual_outgoing_bcc.cf file`after one of ispconfig git updates have a error in postfix log - postfix can't read dbname from mysql-virtual_outgoing_bcc.cf file`https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3493Multiserver config - DB server is not properly populated2020-09-30T11:27:14ZTihomir VlahovskiMultiserver config - DB server is not properly populatedHello,
We are using ISPC version 3.0.5.4p5, multiserver config (2 servers). One server for mail services (master) and second server for web/db (child node).
The problem is when you specify in System -> Server Services -> that master (is ...Hello,
We are using ISPC version 3.0.5.4p5, multiserver config (2 servers). One server for mail services (master) and second server for web/db (child node).
The problem is when you specify in System -> Server Services -> that master (is ONLY mail) and child is Web and DB, the dropdown menu while creating new DB, the server field is populated with the correct text but in dbispconfig/web_database/server_id is the ID of the master node.
To avoid this, you have to click on the dropdown menu and click the text. Then the correct value is populated and DB is created on the correct server and not on the master node which is no configured (in Server services) to serve as DB.
Regards,
-Tihohttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3293pool.d conf datei wird gelöscht bei Zusatz PHP Version2020-09-30T11:27:07ZPatrick Omlandpool.d conf datei wird gelöscht bei Zusatz PHP VersionHier zu finden, http://www.howtoforge.de/forum/entwicklerforum-15/bug-zustz-php-version-subdomain-8349/#post41658Hier zu finden, http://www.howtoforge.de/forum/entwicklerforum-15/bug-zustz-php-version-subdomain-8349/#post41658https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3634wrong email quota usage shown2020-09-30T11:27:03ZÖkrös Bélawrong email quota usage shownThe quota usage datas are in monitor_data mysql table and ordered by timestamp. This cause problems, and I can see the wrong/backup server's quota usage on dashboard or in the email quota menu. It worked well before I added a slave server.The quota usage datas are in monitor_data mysql table and ordered by timestamp. This cause problems, and I can see the wrong/backup server's quota usage on dashboard or in the email quota menu. It worked well before I added a slave server.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/3566cannot use save_path in options tab of site specific settings2020-09-30T11:26:56ZLukas Wenningcannot use save_path in options tab of site specific settingssession.save_path = "tcp://127.0.0.1:6379?weight=1&database=10"
session.cache_expire = 1209600
session.save_handler = redis
try adding those values to the options tab.
this resulted in me having two save_path values inside the /etc/php...session.save_path = "tcp://127.0.0.1:6379?weight=1&database=10"
session.cache_expire = 1209600
session.save_handler = redis
try adding those values to the options tab.
this resulted in me having two save_path values inside the /etc/php5/fpm/pool.d/web1.conf had to manually correct it by editing the file