Mantis - ISSUES

0001303: Slovak language translation update

Updated transtation of slovak version

0001302: Aps-Installer wont Validate or Upload ANY Aps Zip files

Hi Guys,

Have been trying for ages to get the APS-Installer working but every time I try to upload a zip package I get "File Too Big",

So then I upload via FTP to my server into the /usr/share/syscp/temp dir which has 0777 privileges,
The file uploads perfectly but when I go to "Scan for new packages" it brings up error:

Errors for {Package name here}
This is not a valid APS zipfile!

e.g.

Errors for phpBB-3.0.7-6.app.zip
This is not a valid APS zipfile!

I have tried many APS, including Wordpress etc but I always without fail get this error, I have tried configuring the server's APS options too but this had no effect,

I'm running:
Ubuntu Server x64 10.04
Apache2.2
PHP5
MySQL

I have also tried to configure the php.ini via the instructions here:
http://wiki.syscp.org/docs/aps-handbook [^]
For 64-bit but cannot find the disabled_functions section in the php.ini file

If anyone could shed some light on this it would be much appreciated!
Cheers
Myles

0001301: Japanese Language File

feel free to include with further syscp version

0001300: lib/init.php: cannot login

I think
AND `s`.`useragent`="' . $db->escape($http_user_agent) . '"
is a little bit paranoid, somehow I can't login with new my IE 8 and some new Updates...

0001299: PHP Bug 51192: validateDomain with filter_var()

Hyphens in Domains were not accepted as proper Domains www.ex-ample.de reutrn false

possible fix?
function validateDomain($domainname)
{
// we add http:// because this makes a domain valid for the filter;
// but if a user gives "http://" [^] it's not a valid domain
// (because for syscp, a domain mustn't have "http://" [^] in it

$domainname_tmp = 'http://' [^] . $domainname;

if (version_compare(PHP_VERSION, '5.3.3') === 1) {

if(filter_var($domainname_tmp, FILTER_VALIDATE_URL) !== false)
{
return $domainname;
}
else
{
return false;
}

}
else
{
return $domainname;
}
}

0001298: postfix main.cf: virtual_mailbox_limit is missing

When copying the supposed contents from

Configuration -> Debian 5.0 (Lenny) -> Mailserver (SMTP) -> Postfix -> /etc/postfix/main.cf

there is missing an important line:

virtual_mailbox_limit = 0

If this line is not inserted in main.cf the following error occures and is shown in /var/log/mail.log on start/restart of postfix:

Jul 15 00:05:13 server postfix/virtual[3865]: fatal: main.cf configuration error: virtual_mailbox_limit is smaller than message_size_limit

The effect is, that postfix is not started.

If you create an email account through SysCP Panel you cannot login through IMAP with this account because the appropriate folder (for example /var/customers/mail/web1/user@domain.com) is not created because of the not started postfix.

This bug can be very easily fixed by adding the above line into the supposed configuration template.

After inserting the line and restarting postfix the folder is created because of the now sent welcome message and everything is fine.

0001297: MySql Root User Name

SysCP Installation
Testing if PHP MySQL-extension is installed... OK
Testing if PHP filter-extension is installed... OK
Testing if PHP bcmath-extension is installed... OK
Testing if open_basedir is enabled... OK
Testing if MySQL-root-username and password are correct...Establishing connection failed, exiting
mysql error number: 1045
mysql error desc: Access denied for user 'test'@'localhost' (using password: YES)
Time/date: 07/07/2010 03:07 PM
Script: /install/install.php
Referer: http://www.5squad.com/install/install.php [^]

0001296: Invalid Redirect directive for HTTPS in Apache config

If you enable HTTPS redirection for some domain, SysCP cron job puts something like this in the vhost file:
Redirect / https://bigcampaign.org [^]
This is wrong. If I go to "http://bigcampaign.org/salam", [^] I get redirected to "https://bigcampaign.orgsalam". [^] Correct directive would be:
Redirect / https://bigcampaign.org/ [^]
Note the ending slash.

0001295: Messaging system fails at Persian (and presumably some other languages)

In admin panel write some Persian text in "Write a Message" (for example "سلام") and send it. It send something like this: سلام،
It is probably caused by inappropriate charset. Maybe using UTF-8 as the charset fix such problems.

0001294: SysCP doesn't add global and per-domain custom vhost config to Lighttpd vhosts

SysCP doesn't add global and per-domain custom vhost config to Lighttpd vhosts. It totally ignores specialsettings and default_vhostconf in cron_tasks.inc.http.20.lighttpd.php. This is a simple patch to fix it:

--- cron_tasks.inc.http.20.lighttpd.php.orig 2010-06-25 16:38:33.000000000 +0430
+++ cron_tasks.inc.http.20.lighttpd.php 2010-06-25 07:15:47.000000000 +0430
@@ -236,6 +236,14 @@
$vhost_content.= $this->create_htaccess($domain);
$vhost_content.= $this->create_pathOptions($domain);
$vhost_content.= $this->getLogFiles($domain);
+ if($domain['specialsettings'] != '')
+ {
+ $vhost_content.= $domain['specialsettings'] . "\n";
+ }
+ if($this->settings['system']['default_vhostconf'] != '')
+ {
+ $vhost_content.= $this->settings['system']['default_vhostconf'] . "\n";
+ }
$vhost_content.= '}' . "\n";
return $vhost_content;
}

0001293: Language switcher does not work

The language switcher on the login mask does not work. If you select a language, you always get the standard language or the user's language.

To resolv this, change following lines in lib/init.php (from line 334...)

if(!isset($userinfo['def_language'])
|| !isset($languages[$userinfo['def_language']]))
{
// modified by indual
if(isset($_POST['language'])/* $_GET replaced with $_POST */
&& isset($languages[$_POST['language']]))/* $_GET replaced with $_POST, form is POST not GET! */
{
$language = $_POST['language'];/* $_GET replaced with $_POST */
}
else
{
$language = $settings['panel']['standardlanguage'];
}
}
else
{
// modified by indual
// $language = $userinfo['def_language'];
$language = $userinfo['language']; /* it is not def_language, it is language */
}

0001017: Proftpd - Quota should be added

I just got this solved via mod_qoutatab_sql by myself. I would really appreciate if this could be implemented.

Its only necessary to add 2 tables to syscp db and edit /etc/proftpd/proftpd.conf and /etc/proftpd/modules.conf as follows:

1.) Create Tables in Syscp DB:

[code]
CREATE TABLE IF NOT EXISTS `ftp_quotalimits` (
`name` varchar(30) default NULL,
`quota_type` enum('user','group','class','all') NOT NULL default 'user',
`per_session` enum('false','true') NOT NULL default 'false',
`limit_type` enum('soft','hard') NOT NULL default 'hard',
`bytes_in_avail` float NOT NULL,
`bytes_out_avail` float NOT NULL,
`bytes_xfer_avail` float NOT NULL,
`files_in_avail` int(10) unsigned NOT NULL,
`files_out_avail` int(10) unsigned NOT NULL,
`files_xfer_avail` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ftp_quotalimits` (`name`, `quota_type`, `per_session`, `limit_type`, `bytes_in_avail`, `bytes_out_avail`, `bytes_xfer_avail`, `files_in_avail`, `files_out_avail`, `files_xfer_avail`) VALUES
('syscp', 'user', 'false', 'hard', 0, 0, 0, 0, 0, 0);

CREATE TABLE IF NOT EXISTS `ftp_quotatallies` (
`name` varchar(30) NOT NULL,
`quota_type` enum('user','group','class','all') NOT NULL,
`bytes_in_used` float NOT NULL,
`bytes_out_used` float NOT NULL,
`bytes_xfer_used` float NOT NULL,
`files_in_used` int(10) unsigned NOT NULL,
`files_out_used` int(10) unsigned NOT NULL,
`files_xfer_used` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[/code]

2.) Add to /etc/proftpd/modules.conf:

[code]
LoadModule mod_quotatab.c
LoadModule mod_quotatab_sql.c
[/code]

3.) Add to /etc/proftpd/proftpd.conf:

[code]
QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb
QuotaLock /var/lock/ftpd.quotatab.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
SQLNamedQuery get-quota-limit SELECT "ftp_users.username AS name, ftp_quotalimits.quota_type, ftp_quotalimits.per_session, ftp_quotalimits.limit_type, panel_customers.diskspace*1024 AS bytes_in_avail, ftp_quotalimits.bytes_out_avail, ftp_quotalimits.bytes_xfer_avail, ftp_quotalimits.files_in_avail, ftp_quotalimits.files_out_avail, ftp_quotalimits.files_xfer_avail FROM ftp_users, ftp_quotalimits, panel_customers WHERE ftp_users.username = '%{0}' AND panel_customers.loginname = SUBSTRING_INDEX('%{0}', 'ftp', 1) AND quota_type ='%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,bytes_out_used, bytes_xfer_used, files_in_used, files_out_used,files_xfer_used FROM ftp_quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used= files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name= '%{6}' AND quota_type = '%{7}'" ftp_quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies
[/code]

Thats it.
You have now a hard quota limit (diskspace from table panel_customers) for every Syscp FTP Account.

The field "bytes_in_used" of table "ftp_quotatallies" should be updated by cron every night to also count content not uploaded by ftp.

https://mantis.syscp.org/view.php?id=693 [^]

0001292: Ubuntu 10.04 support+Nginx support+more

My feature requests are:
1)Make sure syscp works 100% correctly with Ubuntu 10.04, because your website says it only works with Ubuntu 8.04(http://www.syscp.org/features.html). [^]

2)You should support the Nginx web server(www.nginx.net) too. Currently you support Apache and Lighttpd, but you do not support Nginx.

3)You should make sure syscp works 100% correctly with Lighttpd 1.4.26.

4)You should make sure syscp works 100% correctly with PHP5 and MySQL 5.

0001288: safe_exec filter doesn't work

The safe_exec function doesn't block commands which are not in the whitelist.

E.g. 'ln' is not in the $allowed_commands array, but the following works:

safe_exec("ln -s aaa bbb");

0001291: Warning for multiple user accounts by nss_mysql_passwd

This problem was first reported via forum in 2005, look here for further infos: http://www.syscp-forum.org/index.php?topic=644.15 [^]
The reason is a uncorrect nss-mysql configuration.

0001290: Using one vhost file for each domain, sub-domains do not work with wildcard domain

# 20_syscp_normal_vhost_DOMAIN.TLD.conf

ServerName DOMAIN.TLD
ServerAlias *.DOMAIN.TLD

----------------------

# 20_syscp_normal_vhost_syscp.DOMAIN.TLD.conf

ServerName syscp.DOMAIN.TLD

0001273: APS-Installer

There are a few Problems with that Module

The PHP Webserver processing MUST have chmod writable-bit for /var/www/syscp/temp/ and /var/www/syscp/packages/ .

0001289: DKIM Support for Keys with 2048 bit

I create a patch, because I prefer to use a 2048 bit key.

the TXT record is to long with the 2048 bit key and bind cant load the zonefile with "ran out of space"

I modified the code to split the record so, that bind can load the record correct.

Also there was the DKIM ADSP Record missed.

It will be nice, to set for every domain if the ADSP Record is unknown, all or discardable (see http://www.sendmail.org/dkim/wizard) [^]

We should also be able to globally set the size of the key (1024/2048) and there are a lot of more options, see http://www.dnswatch.info/dkim/create-dns-record [^]

0001287: nable to modify MySQL-Access-Hosts

I had problems wo view my database with phpmyadmin. I find out that the created user has an empty HOST configured.

I searched within all the system settings and found the MySQL-Access-Hosts setting. When I tried to change nothing happened. I searched within the syscp database and did not find a value for mysql_access_host.

I added an entry to table panel_settings, settinggroup = system, varname=mysql_access_host and value = localhost.

This fixed the problem that the HOST for the user is configured empty.

0001272: Default Config for libnss incomplete (debian/lenny)

If you use the Configuration-Generator from sysCP for libnss it generates an incomplete nsswitch.conf. With the generated config the system is unable to use the /etc/hosts. E.g. localhost can't be resolved anymore.

0001286: smtpd configuration does not work on lenny

Something changed on Debian lenny, and the auxprop method needs to be changed for smtp logins to work.

I spelunked quite some time in the Postfix configuration and could not really make out what went wrong (except that saslauthd wasn't installed, but maybe that was an installation error on my side).
However, I found a far easier way to achieve effortless smtpd authentication: let the IMAP service do the dirty work, it's installed and configured anyway.

Here's how:
* Edit /etc/default/saslauthd
* Change MECHANISMS="pam" to MECHANISMS="rimap"
* Change MECH_OPTIONS="" to MECH_OPTIONS="127.0.0.1"

No plugins, no plugin configuration, no auxprop and SASL hassles.
(It may be necessary to edit the OPTIONS line, too. I'm not sure whether the version I have now is still the distribution's original or a changed one. For reference, it now reads OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd".)

0001186: subdomains and php configuration

It is not yet possible to set up php configration for subdomains seperatly.

This could be a usefull feature if a subdomain is used for example for a shop system like magento.

0001285: New Translation

i have started to translate syscp in Turkish, and here is the first step,

0001284: Kein Email-Verkehr bei Umlaute Domains

Bei Domains die Umlaute enthalten wird der Eintrag "username" in der Datenbank "mail_users" falsch angelegt. Dieser wird als "user@prügner.de" angelegt, richtig müsste es "user@xn--prgner-4ya.de" heißen.

Dann funktioniert zumindest die Anmeldung via Outlook, da dieser den Umlaut selbstständig umwandelt, Roundcube dagegen macht dies noch nicht. Die Anmeldung via Roundcube müsste dann mit dem IDN Code geschehen, sprich als Benutzername muss man dort "user@xn--prgner-4ya.de" eintragen um sich auch darüber anmelden zu können.

0001282: Homedirs von Dovecot identisch

Bei der Konfiguration von Managesieve http://wiki.dovecot.org/ManageSieve/ [^] fiel mir auf, dass syscp die Homedirs der Benutzer alle auf den gleichen Pfad setzt.
Folglich legt Dovecot die Dateien für Managesieve (u.a. .dovecot.sieve) dort für jeden Benutzer ab!
Wenn ich die Dovecot Dokumentation http://wiki.dovecot.org/VirtualUsers/Home [^] richtig verstehe, so ist dies keinesfalls das gewünschte Verhalten und u.U. sogar eine Sicherheitslücke.
Sofern Ihr dies auch so versteht, möchte ich vorschlagen das Homedirverzeichnis in der MySQL Datenbank benutzerbezogen zu speichern:
Homedir /var/vmail/customer/customer@host.com/
Maildir mails/
Somit wären Homeverzeichnis und Mailverzeichnis im Sinne von Dovecot voneinander getrennt. Würde dafür Euch auch einen Patch schreiben.