ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2018-12-15T18:15:14Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2129Add perl option to web sites (apache2 mod_perl2)2018-12-15T18:15:14ZMarius BurkardAdd perl option to web sites (apache2 mod_perl2)Add perl option (mod_perl2) in ispconfig web site config on apache-enabled servers.Add perl option (mod_perl2) in ispconfig web site config on apache-enabled servers.3.0.5Marius BurkardMarius Burkardhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2128$conf['theme'] value in interface/lib/config.inc.php is overwritten (reset to...2017-11-10T15:24:10ZFalko Timmef.timme@timmehosting.de$conf['theme'] value in interface/lib/config.inc.php is overwritten (reset to 'default') on updatehttp://www.howtoforge.com/forums/showthread.php?t=58276http://www.howtoforge.com/forums/showthread.php?t=582763.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2127Web folder protections is not removed before a site is deleted2017-11-10T15:24:10ZTill BrehmWeb folder protections is not removed before a site is deletedWeb folder protections is not removed before a site is deleted.Web folder protections is not removed before a site is deleted.3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2126Inform user about quota2018-12-15T18:15:17ZFalko Timmef.timme@timmehosting.deInform user about quotahttp://www.howtoforge.com/forums/showthread.php?t=58253http://www.howtoforge.com/forums/showthread.php?t=582533.0.5.3https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2125Report Cron errors and allow retry2020-10-24T18:22:43ZJanekReport Cron errors and allow retryThe jobs in queue are just executed one by one without any error checking - Regardless of any errors which may have been occurred while executing a job its removed from queue list and somewhat marked as (successfully) done.
This can be ...The jobs in queue are just executed one by one without any error checking - Regardless of any errors which may have been occurred while executing a job its removed from queue list and somewhat marked as (successfully) done.
This can be a big issue if any error occur. This could be because of wrong configuration and other permanent errors, but also for temporary errors like insufficient memory (In my case I disabled exec/shell_exec function in CLI php.ini).
Best way would be to have jobs executed in some kind of transaction (e.g via a sandbox) to allow reverting them. I know this would be a huge task and nothing which could be fixed in a day.
But it would be great to be at least able to see that an error occurred directly in the ISPConfig panel.
For example if an error occurred during execution of a task, the job could be kept in the queue and marked red with the possibility to see an excerpt from the cron log and a "Retry" button.
This problem makes using ISPConfig a lot more complicated because every time I make an important change in the web panel I have to check the cron log carefully and if I see any problem I don't have the possibility to easily retry the job but have to e.g remove the created site and create it again...https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2124MySQL error under Support > Send Message2017-11-10T15:24:10ZFalko Timmef.timme@timmehosting.deMySQL error under Support > Send MessageDB::query(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid ...DB::query(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) -> mysqli_query Column 'sys_userid' in where clause is ambiguous#0 db->query(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:111] #1 db->queryAllRecords(SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND ((sys_userid = 2 AND sys_perm_user like '%r%') OR (sys_groupid IN (2) AND sys_perm_group like '%r%') OR sys_perm_other like '%r%') ORDER BY sys_user.username) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:257] #2 tform->getDatasourceData(Array ([datatype] => INTEGER,[formtype] => SELECT,[default] => ,[datasource] => Array ([type] => SQL,[querystring] => SELECT sys_user.userid, CONCAT(sys_user.username,' :: ',client.company_name,' :: ',client.contact_name) as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND {AUTHSQL} ORDER BY sys_user.username,[keyfield] => userid,[valuefield] => contactname),[validators] => Array ([0] => Array ([type] => ISINT,[errmsg] => recipient_id_is_not_integer)),[value] => Array ([1] => Administrator)), Array ()) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:507] #3 tform->getHTML(Array (), message, NEW) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:516] #4 tform_actions->onShowNew() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:471] #5 tform_actions->onShow() called at [/usr/local/ispconfig/interface/web/help/support_message_edit.php:50] #6 page_action->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #7 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/help/support_message_edit.php:69] Column 'sys_userid' in where clause is ambiguous3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2123Postfix default MySQL configuration is not correct (wrong SQL host and relay_...2017-11-10T15:24:10ZJean WeisbuchPostfix default MySQL configuration is not correct (wrong SQL host and relay_domains lacks proxy:)These two issues are installer related as these configurations are created/modified by it.
----
ISPConfig creates /etc/postfix/mysql-virtual_*.cf files with :
hosts = 127.0.0.1
And the MySQL "dbispconfig" user hostname is "lo...These two issues are installer related as these configurations are created/modified by it.
----
ISPConfig creates /etc/postfix/mysql-virtual_*.cf files with :
hosts = 127.0.0.1
And the MySQL "dbispconfig" user hostname is "localhost" by default, which does not allow connexions from TCP/IP but only Socket, so you will have an error informing you that Postfix cannot login to the database with an error such as this one :
Aug 13 12:47:05 hostname postfix/proxymap[17382]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES)
In order to correct that issue :
perl -i -pe 's/hosts = 127.0.0.1$/hosts = localhost\n/' /etc/postfix/mysql-virtual_*.cf
/etc/init.d/postfix reload
----
The other issue is that the relay_domains mysql wrapper requires to be loaded using proxy: but its not done by ISPConfig install, so you will end up with this kind of errors in your syslog :
Aug 13 13:03:36 hostname postfix/trivial-rewrite[24143]: warning: connect to mysql server unix:/var/run/mysqld/mysqld.sock: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 13 13:03:36 hostname postfix/trivial-rewrite[24143]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
In order to correct that issue :
perl -i -pe 's#^relay_domains = mysql:#relay_domains = proxy:mysql:#' /etc/postfix/main.cf
/etc/init.d/postfix reloadhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2122won't add forward e-mail address containing one letter after @2017-11-10T15:24:10ZMike Hansenwon't add forward e-mail address containing one letter after @When making an mailbox and adding an address to forward mail to, it won't accept an e-mail address with only one letter after @, like name@c.dkWhen making an mailbox and adding an address to forward mail to, it won't accept an e-mail address with only one letter after @, like name@c.dk3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2121"login as user" chooses wrong user2017-11-10T15:24:10ZMarc Schütz"login as user" chooses wrong userIn the clients list, there is a button to login as a client (only for the admin). When you click that button, it asks for confirmation whether you want to login as a _different_ user than the one you clicked on, e.g. a reseller. If you c...In the clients list, there is a button to login as a client (only for the admin). When you click that button, it asks for confirmation whether you want to login as a _different_ user than the one you clicked on, e.g. a reseller. If you confirm, you will indeed be logged in as the wrong user. If you decline, it takes you back to the user list, which now contains all users (not just clients). If you click on the button in _this_ list, it actually selects the right user.
(Probably related to a list index being passed to the backend instead of the username.)3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2120Apache HTTP Ports Change 80 to 8989, no change in file vhost.conf.master2017-11-10T15:24:10ZNilton OSApache HTTP Ports Change 80 to 8989, no change in file vhost.conf.masterApache2 on a port other than 80
Config /usr/local/ispconfig/server/conf/vhost.conf.master
No change port http:
<VirtualHost {tmpl_var name='ip_address'}:{tmpl_var name='port'}>
Fix port 80, no change
System -> Interface IP A...Apache2 on a port other than 80
Config /usr/local/ispconfig/server/conf/vhost.conf.master
No change port http:
<VirtualHost {tmpl_var name='ip_address'}:{tmpl_var name='port'}>
Fix port 80, no change
System -> Interface IP Addresses -> HTTP Ports
Change 80 to 8989, no change in file /usr/local/ispconfig/server/conf/vhost.conf.master
OK change: apache_ispconfig.conf.master
No change: vhost.conf.masterhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2119Apache log files are in directory owned by web user2017-06-25T10:54:05ZMarc SchützApache log files are in directory owned by web userThe apache log files are placed in a directory in /var/log/ispconfig/httpd whose owner/group is set to web*:client*. Although the logfiles themselves are owned by root:root (well, except error.log, which belongs to the web user, too), th...The apache log files are placed in a directory in /var/log/ispconfig/httpd whose owner/group is set to web*:client*. Although the logfiles themselves are owned by root:root (well, except error.log, which belongs to the web user, too), they can still be deleted and replaced by the user. This might be undesirable from an auditing point of view.
This also opens up the system to various kinds of symlink attacks, as the log files are written to by vlogger (run as root). vlogger _does_ check for symlinks, but its reaction to finding one is simply to die, which makes Apache restart it. This could potentially lead to a high load. More importantly, the check is done in a non-atomic manner, making it circumventable with some effort.
AFAICS, the directory ownership as well as the ownership of error.log can simply be changed to root:root, without breaking any important functionality, thereby evading the above-mentioned problems easily.3.0.5Till BrehmTill Brehmhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2117Fedora/Centos (Maybe others) Dovecot configuration incorrect.2017-11-10T15:24:10ZDylan MyersFedora/Centos (Maybe others) Dovecot configuration incorrect.For any install using the fedora_dovecot-sql.conf.master file:
If you use something other than the full email address for the "login" it does not work correctly. The reason for this is the following portion of the user_query:
WHERE e...For any install using the fedora_dovecot-sql.conf.master file:
If you use something other than the full email address for the "login" it does not work correctly. The reason for this is the following portion of the user_query:
WHERE email = '%u' AND disable%Ls = 'n'
Which should in actuality be:
WHERE login = '%u' AND disable%Ls = 'n'
Or, for more versatility (and say... Gmail style where you can use the username OR the full email address), this is what I'm currently using in my /etc/dovecot.conf:
password_query = SELECT password FROM mail_user WHERE (login = '%u' OR email = '%u') AND disable%Ls = 'n'
# user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', floor(quota/1024)) AS quota, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (email = '%u' OR login ='%u') AND disable%Ls = 'n'
Which is probably how all of the XXXX_dovecot-sql.conf.master files should be setup since this makes the most sense.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2116Gameservermodule2020-10-24T18:22:43ZTorbenGameservermoduleCan you try to implement a Gameservermodule?Can you try to implement a Gameservermodule?https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2115sieve vacation does not take domain aliasses into account2017-11-10T15:24:10ZJannosieve vacation does not take domain aliasses into account- ISPConfig 3.0.3.4 on Ubuntu 10.04 LTS with postfix/mysql/sieve/dovecot
- Vacation filter for a users mailbox is created by ISPConfig in the .sieve file of the users mailbox.
- The 'addresses' configuration in the sieve-configuratio...- ISPConfig 3.0.3.4 on Ubuntu 10.04 LTS with postfix/mysql/sieve/dovecot
- Vacation filter for a users mailbox is created by ISPConfig in the .sieve file of the users mailbox.
- The 'addresses' configuration in the sieve-configuration takes into account the mailbox aliases of the user
- However the domain-aliases are not taken into account. An email to user@domain sends a vacation reply, an email to user@aliasdomain doesn't send a reply but the log says "discarding vacation response for message implicitly delivered to <user@doman>
- Fix would be to include the aliasdomains in the 'addresses' configuration in the .sieve file3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2114SSL for the apps.vhost2017-11-10T15:24:10ZpititisSSL for the apps.vhostHello,
will be nice if the apps vhost support the ssl cert from the interface.
Thank youHello,
will be nice if the apps vhost support the ssl cert from the interface.
Thank youhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2113client_id from remoting.inc.php functions is ignored2017-11-10T15:24:10ZCristiclient_id from remoting.inc.php functions is ignoredexample :
...
$client_id = 2;
...
$client->dns_ptr_update($session_id, $client_id, $id, $dns_record);
...
After update :
*************************** 1. row ***************************
sys_userid: 0
sys_groupid: 0
...example :
...
$client_id = 2;
...
$client->dns_ptr_update($session_id, $client_id, $id, $dns_record);
...
After update :
*************************** 1. row ***************************
sys_userid: 0
sys_groupid: 0
sys_perm_user: riud
sys_perm_group: riud
client_id is ignored.3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2112modules.inc.php / function processDatalog()2017-11-10T15:24:10ZCristimodules.inc.php / function processDatalog()you need to add option to limit sql queries (custom or fixed) to process data from dbispconfig/sys_datalog.
Problem :
i had over 1400000 records in sys_datalog, updated from remote scripts and server.php stop to process changes.
...you need to add option to limit sql queries (custom or fixed) to process data from dbispconfig/sys_datalog.
Problem :
i had over 1400000 records in sys_datalog, updated from remote scripts and server.php stop to process changes.
Log output :
Found 1153948 changes, starting update process.
PHP Fatal error: Out of memory (allocated 2018246656) (tried to allocate 7 bytes) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 147.
Solution:
a. limit sql query to process only defined number (custom or fixed) in modules.inc.php / function processDatalog()
b. if number of changes is greater than defined number (custom or fixed) process data with sql limit in modules.inc.php / function processDatalog()3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2111problem after deleting server in database2017-11-10T15:24:12ZOliver Vogelproblem after deleting server in databasei deleted a server INSIDE ISPConfig but i forgot to destroy the virtual server itself. so server.sh at this server is called every minute. the server now "looks" for his data inside the master-db but did nit found any. this means, the se...i deleted a server INSIDE ISPConfig but i forgot to destroy the virtual server itself. so server.sh at this server is called every minute. the server now "looks" for his data inside the master-db but did nit found any. this means, the server startet replication at datalog_id = 0 and reportet with loglevel = debug. after the whole datalog is done, the server startet once again from the beginning, because ot did not found any record of the server inside the database and this means once again start = 0
to fix it, do the following inside the server.php
(pseudo-code)
get the settings from the server -table with serverid = <<myid>>
if there is no record inside the server - table with "my-id" stop working3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2110potential bug in monito_tools.inc.php2017-11-10T15:24:12ZJürgen Hörmannpotential bug in monito_tools.inc.phpPlease take a look at the screenshot:
http://imageshack.us/photo/my-images/837/zwischenablage01f.jpg/
Seems the $res variable is never defined.Please take a look at the screenshot:
http://imageshack.us/photo/my-images/837/zwischenablage01f.jpg/
Seems the $res variable is never defined.3.0.5https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/2109cron log file reading defect2017-11-10T15:24:12ZJürgen Hörmanncron log file reading defectHi. There is something broken in the cron logfile reading:
my cron.log is full of php errors:
PHP Warning: Illegal string offset 'output' in /usr/local/ispconfig/server/mods-available/monitor_core_module.inc.php on line 707
I loo...Hi. There is something broken in the cron logfile reading:
my cron.log is full of php errors:
PHP Warning: Illegal string offset 'output' in /usr/local/ispconfig/server/mods-available/monitor_core_module.inc.php on line 707
I looked at the code and it seemes that the field
$res['data']['output'] is never filled up.
The variable $res is filled by the function monitorISPCCronLog() in monitor_tools.inc.php
But this function loads the logfile contents directly into $res['data'] as one string.
So I guess the line 707 in monitor_core_module.inc.php should be:
$res['data'] = htmlentities($res['data']);3.0.5