ISPConfig 3 issueshttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues2017-11-10T15:26:12Zhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/335Created subdomain does not get an entry in DNS2017-11-10T15:26:12ZNed HadCreated subdomain does not get an entry in DNSA crated subdomain under sites does not get a DNS entry when created, so it does not work....A crated subdomain under sites does not get a DNS entry when created, so it does not work....https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/334own error documents won't work with ssl2017-11-10T15:26:12ZOliver Vogelown error documents won't work with sslwe have to add the errordocument - directive also to the ssl section of the vhost-master-templatewe have to add the errordocument - directive also to the ssl section of the vhost-master-template3.0.0.9 RC2Oliver VogelOliver Vogelhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/331Password for mysql user/database cannot be changed from frontend2017-11-10T15:26:12ZNed HadPassword for mysql user/database cannot be changed from frontendIt does not matter if you try to change it as client or admin it won;t be changed.It does not matter if you try to change it as client or admin it won;t be changed.3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/323jailkit users cannot login2017-06-25T10:54:13ZNed Hadjailkit users cannot loginIf I create a jailkit user I cannot login to the system with that user, after typing my password the server logs me out immediately. The logs:
immortal:/etc/webalizer# tail /var/log/auth.log
Jan 12 12:01:01 immortal sshd[22404]: Ac...If I create a jailkit user I cannot login to the system with that user, after typing my password the server logs me out immediately. The logs:
immortal:/etc/webalizer# tail /var/log/auth.log
Jan 12 12:01:01 immortal sshd[22404]: Accepted password for nedim-1 from IP port 65278 ssh2
Jan 12 12:01:01 immortal sshd[22506]: (pam_unix) session opened for user nedim-1 by (uid=0)
Jan 12 12:01:01 immortal jk_chrootsh[22511]: path /var/clients/client2/web2 is not owned by user 0
Jan 12 12:01:01 immortal jk_chrootsh[22511]: path /var/clients/client2/web2 is not owned by group 0
Jan 12 12:01:01 immortal jk_chrootsh[22511]: abort, /var/clients/client2/web2 is not a safe chroot jail.
Jan 12 12:01:01 immortal sshd[22506]: (pam_unix) session closed for user nedim-1https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/322webalizer for domains not working2017-06-20T22:34:24ZNed Hadwebalizer for domains not workingWebalizer cron entry is there, running, but on domain level webalizer is not working. Config files in /etc/webalizer for domains is not created and the stats director in domain web directory is missing.Webalizer cron entry is there, running, but on domain level webalizer is not working. Config files in /etc/webalizer for domains is not created and the stats director in domain web directory is missing.https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/318Mail traffic is not being generated2017-11-10T15:26:12ZNed HadMail traffic is not being generatedMy Mail traffic is not being generated, there is cron entry for cron_daily.sh (30 00 * * * /usr/local/ispconfig/server/cron_daily.sh > /dev/null 2>> /var/log/ispconfig/cron.log). When I run sh cron_daily.sh the database gets updated and ...My Mail traffic is not being generated, there is cron entry for cron_daily.sh (30 00 * * * /usr/local/ispconfig/server/cron_daily.sh > /dev/null 2>> /var/log/ispconfig/cron.log). When I run sh cron_daily.sh the database gets updated and the mailbox traffic is generated....https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/317custom configurations are being ingnored2017-06-20T22:34:24ZNed Hadcustom configurations are being ingnoredI copied vhost.conf.master file to conf-custom/ directory and made some custom changes to it, but domains do not get generated with my custom changes.I copied vhost.conf.master file to conf-custom/ directory and made some custom changes to it, but domains do not get generated with my custom changes.3.0.1 FinalOliver VogelOliver Vogelhttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/312Adding mailbox fails. No Such File2017-11-10T15:26:12ZChris RoemmichAdding mailbox fails. No Such FileAdding a new mailbox fails. maildirmake errors in log file.
Example:
Add mail domain foo.com
Add mailbox bar
ISPconfig first creates: /var/vmail/foo.com
but then creates: /var/vmail/bar
/var/vmail/foo.com then disappears, hav...Adding a new mailbox fails. maildirmake errors in log file.
Example:
Add mail domain foo.com
Add mailbox bar
ISPconfig first creates: /var/vmail/foo.com
but then creates: /var/vmail/bar
/var/vmail/foo.com then disappears, haven't investigated the cause of this. (cron clean up maybe?)
My fix is below, it seems to be working fine for me, please shoot some bullets through it if there are any.
replace the function user_insert in mail_plugin_inc.php with:
function user_insert($event_name,$data) {
global $app, $conf;
// get the config
$app->uses("getconf");
$mail_config = $app->getconf->get_server_config($conf["server_id"], 'mail');
$maildomain_path = $data['new']['maildir'];
$tmp_basepath = $data['new']['maildir'];
$tmp_basepath_parts = explode('/',$tmp_basepath);
unset($tmp_basepath_parts[count($tmp_basepath_parts)-1]);
$base_path = implode('/',$tmp_basepath_parts);
// Create the mail domain directory, if it does not exist
if(!empty($base_path) && !is_dir($base_path)) {
exec("su -c 'mkdir -p ".escapeshellcmd($base_path)."' ".$mail_config['mailuser_name']);
$app->log('Created Directory: '.$base_path,LOGLEVEL_DEBUG);
}
// Create the maildir, if it doesn not exist, set permissions, set quota.
if(!empty($maildomain_path) && !is_dir($maildomain_path)) {
exec("su -c 'maildirmake ".escapeshellcmd($maildomain_path)."' ".$mail_config['mailuser_name']);
exec('chown -R '.$mail_config['mailuser_name'].':'.$mail_config['mailuser_group'].' '.escapeshellcmd($data['new']['maildir']));
$app->log("Set ownership on ".escapeshellcmd($data['new']['maildir']),LOGLEVEL_DEBUG);
exec("su -c 'maildirmake -q ".$data['new']['quota']."S ".escapeshellcmd($maildomain_path)."' ".$mail_config['mailuser_name']); // Avoid maildirmake quota bug, see debian bug #214911
$app->log('Created Maildir: '."su -c 'maildirmake -q ".$data['new']['quota']."S ".escapeshellcmd($maildomain_path)."' ".$mail_config['mailuser_name'],LOGLEVEL_DEBUG);
}
}3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/311Bugs remain in the monitor as error after they have been solved.2017-11-10T15:26:12ZTill BrehmBugs remain in the monitor as error after they have been solved.http://www.howtoforge.com/forums/showthread.php?t=30043http://www.howtoforge.com/forums/showthread.php?t=30043https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/310Mail traffice stats not being generated.2017-11-10T15:26:15ZMichael GhensMail traffice stats not being generated.cron_daily.php cannot find .ispconfig_mailsize_save
Possible fix:
diff -u cron_daily.php cron_daily.php.orig
--- cron_daily.php 2009-01-09 09:38:02.000000000 -0800
+++ cron_daily.php.orig 2009-01-09 09:39:38.000000000 -0800...cron_daily.php cannot find .ispconfig_mailsize_save
Possible fix:
diff -u cron_daily.php cron_daily.php.orig
--- cron_daily.php 2009-01-09 09:38:02.000000000 -0800
+++ cron_daily.php.orig 2009-01-09 09:39:38.000000000 -0800
@@ -48,13 +48,13 @@
$sql = "SELECT mailuser_id,maildir FROM mail_user WHERE server_id = ".$conf["server_id"];
$records = $app->db->queryAllRecords($sql);
foreach($records as $rec) {
- if(@is_file($rec["maildir"].'/.ispconfig_mailsize')) {
+ if(@is_file($rec["maildir"].'.ispconfig_mailsize')) {
// rename file
- rename($rec["maildir"].'/.ispconfig_mailsize',$rec["maildir"].'/.ispconfig_mailsize_save');
+ rename($rec["maildir"].'.ispconfig_mailsize',$rec["maildir"].'.ispconfig_mailsize_save');
// Read the file
- $lines = file($rec["maildir"].'/.ispconfig_mailsize_save');
+ $lines = file($rec["maildir"].'.ispconfig_mailsize_save');
$mail_traffic = 0;
foreach($lines as $line) {
$mail_traffic += intval($line);
@@ -62,7 +62,7 @@
unset($lines);
// Delete backup file
- if(@is_file($rec["maildir"].'/.ispconfig_mailsize_save')) unlink
+ if(@is_file($rec["maildir"].'.ispconfig_mailsize_save')) unlink(
// Save the traffic stats in the sql database
$tstamp = date("Y-m");3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/309Webalizer stats not created.2017-11-10T15:26:15ZMichael GhensWebalizer stats not created.Webalizer cannot find access logs because vlogger in Debian Etch (vlogger 1.3-3) default template is mdY, not Ymd
Possible fix:
@@ -62,7 +62,7 @@
unset($lines);
// Delete backup file
- ...Webalizer cannot find access logs because vlogger in Debian Etch (vlogger 1.3-3) default template is mdY, not Ymd
Possible fix:
@@ -62,7 +62,7 @@
unset($lines);
// Delete backup file
- if(@is_file($rec["maildir"].'/.ispconfig_mailsize_save')) unlink
+ if(@is_file($rec["maildir"].'.ispconfig_mailsize_save')) unlink(
// Save the traffic stats in the sql database
$tstamp = date("Y-m");
@@ -110,7 +110,7 @@
$sql = "SELECT domain_id, domain, document_root FROM web_domain WHERE server_id
$records = $app->db->queryAllRecords($sql);
foreach($records as $rec) {
- $yesterday = date("mdY",time() - 86400);
+ $yesterday = date("Ymd",time() - 86400);
$logfile = escapeshellcmd($rec["document_root"].'/log/'.$yesterday.'-acc
if(@is_file($logfile)) {
// Compress yesterdays logfile3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/308vlogger stores in american date format2017-11-10T15:26:15Zskeldofvlogger stores in american date formatRelating to this thread: http://howtoforge.com/forums/showthread.php?t=30132
vlogger defaults to writing logs in the american date format Month,Day,Year. This is messy after a year roll over. Suggest changing to the ISO date format Ye...Relating to this thread: http://howtoforge.com/forums/showthread.php?t=30132
vlogger defaults to writing logs in the american date format Month,Day,Year. This is messy after a year roll over. Suggest changing to the ISO date format Year,Month,Day.
--- install/tpl/apache_ispconfig.conf.master (revision 850)
+++ install/tpl/apache_ispconfig.conf.master (working copy)
@@ -5,6 +5,6 @@
################################################
LogFormat "%v %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined_ispconfig
-CustomLog "| /usr/sbin/vlogger -s access.log /var/log/ispconfig/httpd" combined_ispconfig
+CustomLog "| /usr/sbin/vlogger -s access.log -t \"%Y%m%d-access.log\" /var/log/ispconfig/httpd" combined_ispconfig3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/307ispconfig 3 client fix (?)2017-11-10T15:26:15ZTill Brehmispconfig 3 client fix (?)When someone login as client (reseller) and create his own clients, when he create a new site, the dropdown box to select client for this site is empty. Also the label "Client" does not appear. The changes I've made to fix this are:
T...When someone login as client (reseller) and create his own clients, when he create a new site, the dropdown box to select client for this site is empty. Also the label "Client" does not appear. The changes I've made to fix this are:
The diff for the file web_domain_edit.php:
Start of diff.
99,100c99,103
< $client = $app->db->queryOneRecord("SELECT client_id, limit_web_domain, default_webserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
< ---
>
> // at change
> // $client = $app->db->queryOneRecord("SELECT client_id, limit_web_domain, default_webserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
> $client = $app->db->queryOneRecord("SELECT client.client_id, limit_web_domain, default_webserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
>
107c110,114
< $sql = "SELECT groupid, name FROM sys_group, client WHERE sys_group.client_id = client.parent_client_id AND client.parent_client_id = ".$client['client_id'];
---
>
> // at change > // $sql = "SELECT groupid, name FROM sys_group, client WHERE sys_group.client_id = client.parent_client_id AND client.parent_client_id = ".$client['client_id'];
> $sql = "SELECT groupid, name FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ".$client['client_id'];
>
109a117,123
>
> // at change
> $selected = '';
> $clientid = $_SESSION['s']['user']['sys_groupid'];
> $clientusername = $_SESSION['s']['user']['username'];
> $client_select .= "<option value='$clientid' $selected>$clientusername</option>\r\n";
>
112a127
>
342c357
< ?>
\ No newline at end of file
---
> ?>
End of diff.
And for the "Client" label to appear, must enter a new line to language file like this:
$wb["client_group_id_txt"] = 'Client';
In the previous email I sent you I forgot to mention a change I've made that shows the username in the header, at left of top navigation:
diff for topnav.tpl.htm:
0a1
> <div style="float: left; padding-left: 20px; "><tmpl_var name='headusername'></div>
and diff for nav.php:
40c40
< ---
>
52a53,55
>
> $app->tpl->setVar('headusername','User: '.$_SESSION["s"]["user"]["username"]);
>3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/302Change mailbox name2017-10-12T12:27:53ZDavid HamannChange mailbox nameThere seems to be an error in the mv command of the vmail directory when changing the name of a mailbox:
Steps to reproduce:
1) Create a mailbox mbox1@domain.tld
a maildir direcotry /var/vmail/domain.tld/mbox1 is created - so far ...There seems to be an error in the mv command of the vmail directory when changing the name of a mailbox:
Steps to reproduce:
1) Create a mailbox mbox1@domain.tld
a maildir direcotry /var/vmail/domain.tld/mbox1 is created - so far so good
2) Update mailbox to mbox2@domain.tld
the directory mbox1 is not renamed to mbox2 but is moved into directory mbox2 i.e. the directory structure is:
/var/mail/domain.tld/mbox2/mbox1/
if the command in line 119 is changed to
exec('mv -f '.escapeshellcmd($data['old']['maildir']).'/* '.escapeshellcmd($data['new']['maildir'])); //note the aditional /
the move is executed correctly - BUT the old dir is not deleted (because the mv command does not move the "invisible" .ispconfig_mailsize rmdir() fails)
Maybe it would be a better solution to move the whole directory, instead of the content
i.e.
mv -f /var/mail/domain.tld/mbox1 /var/mail/domain.tld/mbox2
instead of
mkdir -p /var/mail/domain.tld/mbox2
mv -f /var/mail/domain.tld/mbox1/* /var/mail/domain.tld/mbox2
rmdir(/var/mail/domain.tld/mbox1)
Cheers,
David3.0.0.9 RC2Fabio FantoniFabio Fantonihttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/301"Broken FTP clients" is not enabled in pure-ftpd on install/config2017-11-10T15:26:15ZJohn Spinuzzi"Broken FTP clients" is not enabled in pure-ftpd on install/configSome FTP clients like 'Windows Explorer' automatically logon anonymously.
Since anonymous logon in pure-ftpd is disabled by default, pure-ftpd drops the connection and leaves you to thinking that something is wrong with the FTP daemon.
...Some FTP clients like 'Windows Explorer' automatically logon anonymously.
Since anonymous logon in pure-ftpd is disabled by default, pure-ftpd drops the connection and leaves you to thinking that something is wrong with the FTP daemon.
The solution to this is to have the installer enable the -b flag.
This can be accomplished by running the following commands:
echo yes > /etc/pure-ftpd/conf/BrokenClientsCompatibility
/etc/init.d/pure-ftpd-mysql restart3.0.0.9 RC2Fabio FantoniFabio Fantonihttps://git.ispconfig.org/ispconfig/ispconfig3/-/issues/300error when tried to create 2 DBs sequentially2017-11-10T15:26:15ZEugene Sanerror when tried to create 2 DBs sequentiallyerror when tried to create 2 DBs sequentially.
After retry it works. See second part below...
Debug below:
------------
02.01.2009-21:07 - DEBUG - Found 3 changes, starting update process.
02.01.2009-21:07 - DEBUG - Processed datalo...error when tried to create 2 DBs sequentially.
After retry it works. See second part below...
Debug below:
------------
02.01.2009-21:07 - DEBUG - Found 3 changes, starting update process.
02.01.2009-21:07 - DEBUG - Processed datalog_id 124
02.01.2009-21:07 - DEBUG - Call function 'db_insert' in plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
02.01.2009-21:07 - ERROR - Going to connect using: [localhost[root] [xxxx].
02.01.2009-21:07 - DEBUG - Created MySQL database: xxxx_ru_forum
02.01.2009-21:07 - DEBUG - Processed datalog_id 125
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
02.01.2009-21:07 - DEBUG - Call function 'db_insert' in plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
02.01.2009-21:07 - ERROR - Going to connect using: [[] [].
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php on line 81
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php on line 83
02.01.2009-21:07 - ERROR - Unable to connect to the database
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
02.01.2009-21:07 - DEBUG - Processed datalog_id 126
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
finished.
root@srvsan:/usr/local/ispconfig/server# root@srvsan:/usr/local/ispconfig/server# ./server.sh
02.01.2009-21:08 - DEBUG - No Updated records found, starting only the core.
finished.
Second attempt after rewinding server::updated
-------------------------------------------------------------------
02.01.2009-21:09 - DEBUG - Found 1 changes, starting update process.
02.01.2009-21:09 - DEBUG - Call function 'db_insert' in plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
02.01.2009-21:09 - ERROR - Going to connect using: [localhost[root] [xxx].
02.01.2009-21:09 - DEBUG - Created MySQL database: xxxx_ru_chat
02.01.2009-21:09 - DEBUG - Processed datalog_id 126
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
finished.3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/299creating db_user with external access creates ONLY external without local2017-11-10T15:26:15ZEugene Sancreating db_user with external access creates ONLY external without localcreating db_user with external access creates ONLY external without local.
Adding user with external access should add 2 users, one for "localhost" and one for "any"creating db_user with external access creates ONLY external without local.
Adding user with external access should add 2 users, one for "localhost" and one for "any"3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/298mysql access error upon finishng db_user addition2017-11-10T15:26:15ZEugene Sanmysql access error upon finishng db_user additionmysql access error upon finishng db_user addition.
Debug output is below, according to mysql user is created and error happens after db_insert exits.
All permissions are ok in mysql_clientdb_plugin.inc.php
Note, that there is type in ...mysql access error upon finishng db_user addition.
Debug output is below, according to mysql user is created and error happens after db_insert exits.
All permissions are ok in mysql_clientdb_plugin.inc.php
Note, that there is type in line 98: "Unable to connect to the database" should be "Unable to create database".
Ignore line #5 in debug output, it's because of re-running same task.
1) 02.01.2009-17:30 - DEBUG - Found 1 changes, starting update process.
2) mailq: Mail queue is empty
3) 02.01.2009-17:30 - DEBUG - Call function 'db_insert' in plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
4) 02.01.2009-17:30 - ERROR - Going to connect using: [localhost[root] [reset100].
5) 02.01.2009-17:30 - ERROR - Unable to connect to the databaseCan't create database 'client1_user_db'; database exists
6) 02.01.2009-17:30 - DEBUG - Processed datalog_id 106
Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
Warning: mysql_real_escape_string(): A link to the server could not be established in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 171
finished.3.0.0.9 RC2https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/297Possibly login problems with safari. Can anyone with safari installed please ...2017-11-10T15:26:15ZTill BrehmPossibly login problems with safari. Can anyone with safari installed please confrm this?http://www.howtoforge.com/forums/showthread.php?t=29891http://www.howtoforge.com/forums/showthread.php?t=29891https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/296ispconfig_update_from_svn - broken2017-11-10T15:26:15ZDazispconfig_update_from_svn - brokenRunning /usr/local/bin/ispconfig_update_from_svn results in this error:
Fatal error: Cannot use string offset as an array in /tmp/trunk/install/update.php on line 146
This happens after being prompted for the root MySQL password.Running /usr/local/bin/ispconfig_update_from_svn results in this error:
Fatal error: Cannot use string offset as an array in /tmp/trunk/install/update.php on line 146
This happens after being prompted for the root MySQL password.