View | Details | Raw Unified | Return to bug 130266
Collapse All | Expand All

(-)syscp/Makefile (-3 / +5 lines)
Lines 7-16 Link Here
7
7
8
PORTNAME=	syscp
8
PORTNAME=	syscp
9
PORTVERSION=	1.4.2
9
PORTVERSION=	1.4.2
10
PORTREVISION=	1
10
CATEGORIES=	sysutils www
11
CATEGORIES=	sysutils www
11
MASTER_SITES=	http://nuernburg.files.syscp.org/releases/tgz/ \
12
MASTER_SITES=	http://canada.files.syscp.org/releases/tgz/ \
12
		http://canada.files.syscp.org/releases/tgz/ \
13
		http://frankfurt.files.syscp.org/releases/tgz/ \
13
		http://france.files.syscp.org/releases/tgz/
14
		http://france.files.syscp.org/releases/tgz/ \
15
		http://nuernburg.files.syscp.org/releases/tgz/
14
DISTNAME=	${PORTNAME}-${PORTVERSION}
16
DISTNAME=	${PORTNAME}-${PORTVERSION}
15
17
16
PATCH_DIST_STRIP=	-p0
18
PATCH_DIST_STRIP=	-p0
(-)syscp/files/patch-syscp-fbsd (+617 lines)
Line 0 Link Here
1
diff -Naur syscp.orig/admin_configfiles.php syscp/admin_configfiles.php
2
--- syscp.orig/admin_configfiles.php	2008-11-29 05:18:53.000000000 -0700
3
+++ syscp/admin_configfiles.php	2008-12-12 12:21:46.000000000 -0700
4
@@ -86,6 +86,7 @@
5
 			'<SQL_UNPRIVILEGED_PASSWORD>' => 'MYSQL_PASSWORD',
6
 			'<SQL_DB>' => $sql['db'],
7
 			'<SQL_HOST>' => $sql['host'],
8
+			'<ADMIN_EMAIL>' => $settings['panel']['adminmail'],
9
 			'<SERVERNAME>' => $settings['system']['hostname'],
10
 			'<SERVERIP>' => $settings['system']['ipaddress'],
11
 			'<NAMESERVERS>' => $settings['system']['nameservers'],
12
diff -Naur syscp.orig/install/install.php syscp/install/install.php
13
--- syscp.orig/install/install.php	2008-11-30 06:12:36.000000000 -0700
14
+++ syscp/install/install.php	2008-12-12 12:21:46.000000000 -0700
15
@@ -374,7 +374,7 @@
16
 }
17
 else
18
 {
19
-	$mysql_host = '127.0.0.1';
20
+	$mysql_host = 'localhost';
21
 }
22
 
23
 if(!empty($_POST['mysql_database']))
24
@@ -716,10 +716,10 @@
25
 
26
 	if($webserver == "apache2")
27
 	{
28
-		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/etc/apache2/sites-enabled/' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_vhost'");
29
-		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/etc/apache2/sites-enabled/' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_diroptions'");
30
-		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/etc/apache2/syscp-htpasswd/' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_htpasswddir'");
31
-		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/etc/init.d/apache2 reload' WHERE `settinggroup` = 'system' AND `varname` = 'apachereload_command'");
32
+		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/usr/local/etc/apache22/syscp/vhosts.conf' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_vhost'");
33
+		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/usr/local/etc/apache22/syscp/diroptions.conf' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_diroptions'");
34
+		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/usr/local/etc/apache22/syscp/htpasswd/' WHERE `settinggroup` = 'system' AND `varname` = 'apacheconf_htpasswddir'");
35
+		$db->query("UPDATE `" . TABLE_PANEL_SETTINGS . "` SET `value` = '/usr/local/etc/rc.d/apache22 reload' WHERE `settinggroup` = 'system' AND `varname` = 'apachereload_command'");
36
 	}
37
 	elseif($webserver == "lighttpd")
38
 	{
39
diff -Naur syscp.orig/install/syscp.sql syscp/install/syscp.sql
40
--- syscp.orig/install/syscp.sql	2008-12-12 09:41:14.000000000 -0700
41
+++ syscp/install/syscp.sql	2008-12-12 12:28:09.000000000 -0700
42
@@ -534,16 +534,16 @@
43
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (7, 'customer', 'mysqlprefix', 'sql');
44
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (8, 'system', 'lastaccountnumber', '0');
45
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (9, 'system', 'lastguid', '9999');
46
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (10, 'system', 'documentroot_prefix', '/var/kunden/webs/');
47
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (11, 'system', 'logfiles_directory', '/var/kunden/logs/');
48
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (10, 'system', 'documentroot_prefix', '/usr/local/customers/webs/');
49
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (11, 'system', 'logfiles_directory', '/usr/local/customers/logs/');
50
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (12, 'system', 'ipaddress', 'SERVERIP');
51
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (14, 'system', 'apachereload_command', '/etc/init.d/apache reload');
52
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (14, 'system', 'apachereload_command', '/usr/local/etc/rc.d/apache22 reload');
53
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (15, 'system', 'last_traffic_run', '000000');
54
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (16, 'system', 'vmail_uid', '2000');
55
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (17, 'system', 'vmail_gid', '2000');
56
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (18, 'system', 'vmail_homedir', '/var/kunden/mail/');
57
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (19, 'system', 'bindconf_directory', '/etc/bind/');
58
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (20, 'system', 'bindreload_command', '/etc/init.d/bind9 reload');
59
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (16, 'system', 'vmail_uid', '125');
60
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (17, 'system', 'vmail_gid', '125');
61
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (18, 'system', 'vmail_homedir', '/usr/local/customers/mail/');
62
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (19, 'system', 'bindconf_directory', '/var/named/etc/namedb/');
63
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (20, 'system', 'bindreload_command', '/usr/sbin/rndc reload');
64
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (22, 'panel', 'version', '1.4.2');
65
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (23, 'system', 'hostname', 'SERVERNAME');
66
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (24, 'login', 'maxloginattempts', '3');
67
@@ -556,10 +556,10 @@
68
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (32, 'system', 'lastcronrun', '');
69
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (33, 'panel', 'paging', '20');
70
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (34, 'system', 'defaultip', '1');
71
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (35, 'system', 'phpappendopenbasedir', '/tmp/');
72
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (35, 'system', 'phpappendopenbasedir', '/var/tmp/:/usr/local/www/syscp');
73
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (36, 'panel', 'natsorting', '1');
74
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (37, 'system', 'deactivateddocroot', '');
75
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (38, 'system', 'mailpwcleartext', '1');
76
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (38, 'system', 'mailpwcleartext', '0');
77
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (39, 'system', 'last_tasks_run', '000000');
78
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (40, 'customer', 'ftpatdomain', '0');
79
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (41, 'system', 'nameservers', '');
80
@@ -567,9 +567,9 @@
81
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (43, 'system', 'mod_log_sql', '0');
82
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (44, 'system', 'mod_fcgid', '0');
83
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (45, 'panel', 'sendalternativemail', '0');
84
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (46, 'system', 'apacheconf_vhost', '/etc/apache/vhosts.conf');
85
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (47, 'system', 'apacheconf_diroptions', '/etc/apache/diroptions.conf');
86
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (48, 'system', 'apacheconf_htpasswddir', '/etc/apache/htpasswd/');
87
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (46, 'system', 'apacheconf_vhost', '/usr/local/etc/apache22/syscp/vhosts.conf');
88
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (47, 'system', 'apacheconf_diroptions', '/usr/local/etc/apache22/syscp/diroptions.conf');
89
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (48, 'system', 'apacheconf_htpasswddir', '/usr/local/etc/apache22/syscp/htpasswd/');
90
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (49, 'system', 'webalizer_quiet', '2');
91
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (50, 'ticket', 'noreply_email', 'NO-REPLY@SERVERNAME');
92
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (51, 'ticket', 'worktime_all', '1');
93
@@ -582,8 +582,8 @@
94
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (58, 'ticket', 'enabled', '1');
95
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (59, 'ticket', 'concurrently_open', '5');
96
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (60, 'ticket', 'noreply_name', 'SysCP Support');
97
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (61, 'system', 'mod_fcgid_configdir', '/var/www/php-fcgi-scripts');
98
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (62, 'system', 'mod_fcgid_tmpdir', '/var/kunden/tmp');
99
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (61, 'system', 'mod_fcgid_configdir', '/usr/local/www/php-fcgi-scripts');
100
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (62, 'system', 'mod_fcgid_tmpdir', '/usr/local/customers/tmp');
101
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (63, 'ticket', 'reset_cycle', '2');
102
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (64, 'panel', 'no_robots', '1');
103
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (65, 'logger', 'enabled', '1');
104
@@ -591,7 +591,7 @@
105
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (67, 'logger', 'logfile', '');
106
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (68, 'logger', 'logtypes', 'syslog,mysql');
107
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (69, 'logger', 'severity', '1');
108
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (70, 'system','ssl_cert_file','/etc/apache2/apache2.pem');
109
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (70, 'system','ssl_cert_file','/usr/local/etc/apache22/apache2.pem');
110
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (71, 'system','use_ssl','1');
111
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (72, 'system','openssl_cnf','[ req ]\r\ndefault_bits = 1024\r\ndistinguished_name = req_distinguished_name\r\nattributes = req_attributes\r\nprompt = no\r\noutput_password =\r\ninput_password =\r\n[ req_distinguished_name ]\r\nC = DE\r\nST = syscp\r\nL = syscp    \r\nO = Testcertificate\r\nOU = syscp        \r\nCN = @@domain_name@@\r\nemailAddress = @@email@@    \r\n[ req_attributes ]\r\nchallengePassword =\r\n');
112
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (73, 'system', 'default_vhostconf', '');
113
@@ -601,22 +601,22 @@
114
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (77, 'dkim', 'use_dkim', '0');
115
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (78, 'system', 'webalizer_enabled', '1');
116
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (79, 'system', 'awstats_enabled', '0');
117
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (80, 'system', 'awstats_domain_file', '/etc/awstats/');
118
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (81, 'system', 'awstats_model_file', '/etc/awstats/awstats.model.conf.syscp');
119
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (82, 'dkim', 'dkim_prefix', '/etc/postfix/dkim/');
120
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (80, 'system', 'awstats_domain_file', '/usr/local/www/awstats/');
121
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (81, 'system', 'awstats_model_file', '/usr/local/www/awstats/cgi-bin/awstats.model.conf.syscp');
122
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (82, 'dkim', 'dkim_prefix', '/usr/local/etc/postfix/dkim/');
123
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (83, 'dkim', 'dkim_domains', 'domains');
124
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (84, 'dkim', 'dkim_dkimkeys', 'dkim-keys.conf');
125
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (85, 'dkim', 'dkimrestart_command', '/etc/init.d/dkim-filter restart');
126
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (85, 'dkim', 'dkimrestart_command', '/usr/local/etc/rc.d/dkim-filter restart');
127
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (86, 'panel', 'unix_names', '1');
128
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (87, 'panel', 'allow_preset', '1');
129
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (88, 'system', 'awstats_path', '/usr/share/awstats/VERSION/webroot/cgi-bin/');
130
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (89, 'system', 'awstats_updateall_command', '/usr/bin/awstats_updateall.pl');
131
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (88, 'system', 'awstats_path', '/usr/local/www/awstats/cgi-bin/');
132
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (89, 'system', 'awstats_updateall_command', '/usr/local/www/awstats/tools/awstats_updateall.pl');
133
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (90, 'billing', 'invoicenumber_count', '0');
134
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (91, 'panel', 'allow_preset_admin', '0');
135
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (92, 'billing', 'activate_billing', '0');
136
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (93, 'billing', 'highlight_inactive', '0');
137
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (94, 'system', 'httpuser', 'www-data');
138
-INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (95, 'system', 'httpgroup', 'www-data');
139
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (94, 'system', 'httpuser', 'www');
140
+INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (95, 'system', 'httpgroup', 'www');
141
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (96, 'system', 'webserver', 'apache2');
142
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (97, 'autoresponder', 'autoresponder_active', '0');
143
 INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (98, 'autoresponder', 'last_autoresponder_run', '0');
144
diff -Naur syscp.orig/lib/configfiles/freebsd.inc.php syscp/lib/configfiles/freebsd.inc.php
145
--- syscp.orig/lib/configfiles/freebsd.inc.php	1969-12-31 17:00:00.000000000 -0700
146
+++ syscp/lib/configfiles/freebsd.inc.php	2008-12-12 12:21:46.000000000 -0700
147
@@ -0,0 +1,126 @@
148
+<?php
149
+return Array(
150
+	'freebsd_release' => Array(
151
+		'label' => 'FreeBSD (RELEASE)',
152
+		'services' => Array(
153
+			'http' => Array(
154
+				'label' => $lng['admin']['configfiles']['http'],
155
+				'daemons' => Array(
156
+					'apache' => Array(
157
+						'label' => 'Apache',
158
+						'commands' => Array(
159
+							'mkdir -p ' . $settings['system']['apacheconf_htpasswddir'],
160
+							'touch ' . $settings['system']['apacheconf_vhost'],
161
+							'touch ' . $settings['system']['apacheconf_diroptions'],
162
+							'mkdir -p ' . $settings['system']['documentroot_prefix'],
163
+							'mkdir -p ' . $settings['system']['logfiles_directory'],
164
+							'echo "Include etc/apache22/syscp/vhosts.conf" >> /usr/local/etc/apache22/httpd.conf',
165
+						),
166
+						'restart' => Array(
167
+							'/usr/local/etc/rc.d/apache22 graceful'
168
+						)
169
+					)
170
+				)
171
+			),
172
+			'dns' => Array(
173
+				'label' => $lng['admin']['configfiles']['dns'],
174
+				'daemons' => Array(
175
+					'bind' => Array(
176
+						'label' => 'Bind9',
177
+						'commands' => Array(
178
+							'echo \'include "syscp_bind.conf";\' >> '.$settings['system']['bindconf_directory'].'named.conf',
179
+							'touch ' . $settings['system']['bindconf_directory'] . 'syscp_bind.conf'
180
+						),
181
+						'restart' => Array(
182
+							'/usr/sbin/rndc reload'
183
+						)
184
+					),
185
+				)
186
+			),
187
+			'mail' => Array(
188
+				'label' => $lng['admin']['configfiles']['mail'],
189
+				'daemons' => Array(
190
+					'dovecot' => Array(
191
+						'label' => 'Dovecot',
192
+						'commands' => Array(
193
+							'mkdir -p /etc/ssl/dovecot',
194
+							'cd /etc/ssl/dovecot',
195
+							'openssl req -new -x509 -nodes -out cert.pem -keyout key.pem -days 365',
196
+							'chmod 0600 *.pem'
197
+						),
198
+						'files' => Array(
199
+							'etc_dovecot.conf' => '/usr/local/etc/dovecot.conf',
200
+							'etc_dovecot-sql.conf' => '/usr/local/etc/dovecot-sql.conf'
201
+						),
202
+						'restart' => Array(
203
+							'/usr/local/etc/rc.d/dovecot restart'
204
+						)
205
+					),
206
+				)
207
+			),
208
+			'smtp' => Array(
209
+				'label' => $lng['admin']['configfiles']['smtp'],
210
+				'daemons' => Array(
211
+					'postfix' => Array(
212
+						'label' => 'Postfix',
213
+						'files' => Array(
214
+							'etc_postfix_main.cf' => '/usr/local/etc/postfix/main.cf',
215
+							'etc_postfix_master.cf' => '/usr/local/etc/postfix/master.cf',
216
+							'etc_postfix_mysql-virtual_alias_maps.cf' => '/usr/local/etc/postfix/mysql-virtual_alias_maps.cf',
217
+							'etc_postfix_mysql-virtual_mailbox_domains.cf' => '/usr/local/etc/postfix/mysql-virtual_mailbox_domains.cf',
218
+							'etc_postfix_mysql-virtual_mailbox_maps.cf' => '/usr/local/etc/postfix/mysql-virtual_mailbox_maps.cf'
219
+						),
220
+						'commands' => Array(
221
+							'mkdir -p ' . $settings['system']['vmail_homedir'],
222
+							'chown -R postfix:postfix ' . $settings['system']['vmail_homedir'],
223
+							'mkdir -p /etc/ssl/postfix',
224
+							'cd /etc/ssl/postfix',
225
+							'openssl req -new -x509 -nodes -out smtpd.pem -keyout smtpd.pem -days 3650',
226
+							'chmod 750 /etc/ssl/postfix',
227
+							'chmod 640 /etc/ssl/postfix/smtpd.pem',
228
+							'chgrp -R postfix /etc/ssl/postfix',
229
+							'chmod 640 /usr/local/etc/postfix/mysql-virtual_*',
230
+							'chgrp postfix /usr/local/etc/postfix/mysql-virtual_*'
231
+						),
232
+						'restart' => Array(
233
+							'/usr/local/etc/rc.d/postfix reload'
234
+						)
235
+					),
236
+				)
237
+			),
238
+			'ftp' => Array(
239
+				'label' => $lng['admin']['configfiles']['ftp'],
240
+				'daemons' => Array(
241
+					'proftpd' => Array(
242
+						'label' => 'ProFTPd',
243
+						'commands' => Array(
244
+							'mkdir -p /etc/ssl/proftpd',
245
+							'cd /etc/ssl/proftpd',
246
+							'openssl req -new -x509 -days 365 -nodes -out cert.pem -keyout key.pem',
247
+							'chmod 640 *.pem'
248
+						),
249
+						'files' => Array(
250
+							'etc_proftpd.conf' => '/usr/local/etc/proftpd.conf'
251
+						),
252
+						'restart' => Array(
253
+							'/usr/local/etc/rc.d/proftpd restart'
254
+						)
255
+					),
256
+				)
257
+			),
258
+			'etc' => Array(
259
+				'label' => $lng['admin']['configfiles']['etc'],
260
+				'daemons' => Array(
261
+					'cron' => Array(
262
+						'label' => 'Crond (cronscript)',
263
+						'files' => Array(
264
+							'cron_syscp' => 'crontab -e (As root)'
265
+						)
266
+					)
267
+				)
268
+			)
269
+		)
270
+	)
271
+);
272
+
273
+?>
274
diff -Naur syscp.orig/lib/configfiles_index.inc.php syscp/lib/configfiles_index.inc.php
275
--- syscp.orig/lib/configfiles_index.inc.php	2008-11-30 06:12:36.000000000 -0700
276
+++ syscp/lib/configfiles_index.inc.php	2008-12-12 12:21:46.000000000 -0700
277
@@ -43,6 +43,6 @@
278
 
279
 $cfgPath = 'lib/configfiles/';
280
 $configfiles = Array();
281
-$configfiles = array_merge(include $cfgPath . 'etch.inc.php', include $cfgPath . 'hardy.inc.php', include $cfgPath . 'gentoo.inc.php', include $cfgPath . 'suse10.inc.php');
282
+$configfiles = array_merge(include $cfgPath . 'freebsd.inc.php', include $cfgPath . 'etch.inc.php', include $cfgPath . 'hardy.inc.php', include $cfgPath . 'gentoo.inc.php', include $cfgPath . 'suse10.inc.php');
283
 
284
-?>
285
\ No newline at end of file
286
+?>
287
diff -Naur syscp.orig/lib/functions.php syscp/lib/functions.php
288
--- syscp.orig/lib/functions.php	2008-12-12 09:29:41.000000000 -0700
289
+++ syscp/lib/functions.php	2008-12-12 12:21:46.000000000 -0700
290
@@ -1229,7 +1229,7 @@
291
 		'cp',
292
 		'du',
293
 		'chmod',
294
-		'chattr',
295
+		'chflags',
296
 		$settings['system']['apachereload_command'],
297
 		$settings['system']['bindreload_command'],
298
 		$settings['dkim']['dkimrestart_command'],
299
diff -Naur syscp.orig/scripts/cron_tasks.inc.dns.10.bind.php syscp/scripts/cron_tasks.inc.dns.10.bind.php
300
--- syscp.orig/scripts/cron_tasks.inc.dns.10.bind.php	2008-10-24 07:47:49.000000000 -0600
301
+++ syscp/scripts/cron_tasks.inc.dns.10.bind.php	2008-12-12 12:21:46.000000000 -0700
302
@@ -111,7 +111,7 @@
303
 			$bindconf_file.= '# Domain ID: ' . $domain['id'] . ' - CustomerID: ' . $domain['customerid'] . ' - CustomerLogin: ' . $domain['loginname'] . "\n";
304
 			$bindconf_file.= 'zone "' . $domain['domain'] . '" in {' . "\n";
305
 			$bindconf_file.= '	type master;' . "\n";
306
-			$bindconf_file.= '	file "' . makeCorrectFile($this->settings['system']['bindconf_directory'] . '/' . $domain['zonefile']) . '";' . "\n";
307
+			$bindconf_file.= '	file "' . $domain['zonefile'] . '";' . "\n";
308
 			$bindconf_file.= '	allow-query { any; };' . "\n";
309
 
310
 			if(count($this->nameservers) > 0)
311
@@ -332,4 +332,4 @@
312
 	}
313
 }
314
 
315
-?>
316
\ No newline at end of file
317
+?>
318
diff -Naur syscp.orig/scripts/cron_tasks.inc.http.15.apache_fcgid.php syscp/scripts/cron_tasks.inc.http.15.apache_fcgid.php
319
--- syscp.orig/scripts/cron_tasks.inc.http.15.apache_fcgid.php	2008-11-30 06:12:36.000000000 -0700
320
+++ syscp/scripts/cron_tasks.inc.http.15.apache_fcgid.php	2008-12-12 12:21:46.000000000 -0700
321
@@ -148,7 +148,7 @@
322
 
323
 			if(file_exists($starter_filename))
324
 			{
325
-				safe_exec('chattr -i ' . escapeshellarg($starter_filename));
326
+				safe_exec('chflags noschg ' . escapeshellarg($starter_filename));
327
 			}
328
 
329
 			$starter_file_handler = fopen($starter_filename, 'w');
330
@@ -156,7 +156,7 @@
331
 			fclose($starter_file_handler);
332
 			safe_exec('chmod 750 ' . escapeshellarg($starter_filename));
333
 			safe_exec('chown ' . $domain['guid'] . ':' . $domain['guid'] . ' ' . escapeshellarg($starter_filename));
334
-			safe_exec('chattr +i ' . escapeshellarg($starter_filename));
335
+			safe_exec('chflags schg ' . escapeshellarg($starter_filename));
336
 
337
 			// define the php.ini
338
 
339
@@ -255,4 +255,4 @@
340
 	}
341
 }
342
 
343
-?>
344
\ No newline at end of file
345
+?>
346
diff -Naur syscp.orig/scripts/cron_tasks.php syscp/scripts/cron_tasks.php
347
--- syscp.orig/scripts/cron_tasks.php	2008-11-09 10:53:18.000000000 -0700
348
+++ syscp/scripts/cron_tasks.php	2008-12-12 12:21:46.000000000 -0700
349
@@ -124,8 +124,8 @@
350
 			}
351
 			else
352
 			{
353
-				$cronlog->logAction(CRON_ACTION, LOG_NOTICE, 'Running: cp -a ' . $pathtophpfiles . '/templates/misc/standardcustomer/* ' . escapeshellarg($settings['system']['documentroot_prefix'] . $row['data']['loginname'] . '/'));
354
-				safe_exec('cp -a ' . $pathtophpfiles . '/templates/misc/standardcustomer/* ' . escapeshellarg($settings['system']['documentroot_prefix'] . $row['data']['loginname'] . '/'));
355
+				$cronlog->logAction(CRON_ACTION, LOG_NOTICE, 'Running: cp -Rp ' . $pathtophpfiles . '/templates/misc/standardcustomer/* ' . escapeshellarg($settings['system']['documentroot_prefix'] . $row['data']['loginname'] . '/'));
356
+				safe_exec('cp -Rp ' . $pathtophpfiles . '/templates/misc/standardcustomer/* ' . escapeshellarg($settings['system']['documentroot_prefix'] . $row['data']['loginname'] . '/'));
357
 			}
358
 
359
 			$cronlog->logAction(CRON_ACTION, LOG_NOTICE, 'Running: chown -R ' . (int)$row['data']['uid'] . ':' . (int)$row['data']['gid'] . ' ' . escapeshellarg($settings['system']['documentroot_prefix'] . $row['data']['loginname']));
360
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/cron/cron_syscp syscp/templates/misc/configfiles/freebsd_release/cron/cron_syscp
361
--- syscp.orig/templates/misc/configfiles/freebsd_release/cron/cron_syscp	1969-12-31 17:00:00.000000000 -0700
362
+++ syscp/templates/misc/configfiles/freebsd_release/cron/cron_syscp	2008-12-12 12:21:46.000000000 -0700
363
@@ -0,0 +1,14 @@
364
+#
365
+# Set PATH, otherwise restart-scripts won't find start-stop-daemon
366
+#
367
+PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
368
+#
369
+# Regular cron jobs for the syscp package
370
+#
371
+*/5 * * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_tasks.php
372
+0 0 * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_traffic.php
373
+30 0 * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_ticketarchive.php
374
+0 1 * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_used_tickets_reset.php
375
+*/5 * * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_autoresponder.php
376
+*/5 * * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_apsinstaller.php
377
+*/30 * * * *	/usr/local/bin/php -q /usr/local/www/syscp/scripts/cron_apsupdater.php
378
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot-sql.conf syscp/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot-sql.conf
379
--- syscp.orig/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot-sql.conf	1969-12-31 17:00:00.000000000 -0700
380
+++ syscp/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot-sql.conf	2008-12-12 12:21:46.000000000 -0700
381
@@ -0,0 +1,7 @@
382
+driver = mysql
383
+connect = host=<SQL_HOST> dbname=<SQL_DB> user=<SQL_UNPRIVILEGED_USER> password=<SQL_UNPRIVILEGED_PASSWORD>
384
+default_pass_scheme = CRYPT
385
+password_query = SELECT username AS user, password_enc AS password \
386
+ FROM mail_users WHERE username = '%u'
387
+user_query = SELECT CONCAT(homedir,maildir) AS home, concat('maildir:',homedir,maildir) \
388
+ AS mail, uid, gid FROM mail_users where username = '%u'
389
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot.conf syscp/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot.conf
390
--- syscp.orig/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot.conf	1969-12-31 17:00:00.000000000 -0700
391
+++ syscp/templates/misc/configfiles/freebsd_release/dovecot/etc_dovecot.conf	2008-12-12 12:21:46.000000000 -0700
392
@@ -0,0 +1,51 @@
393
+protocols = imap imaps pop3 pop3s
394
+disable_plaintext_auth = no
395
+ssl_disable = no
396
+ssl_cert_file = /etc/ssl/dovecot/cert.pem
397
+ssl_key_file = /etc/ssl/dovecot/key.pem
398
+login_greeting = <SERVERNAME> Server Ready.
399
+mail_uid = <VIRTUAL_UID_MAPS>
400
+mail_gid = <VIRTUAL_GID_MAPS>
401
+mail_privileged_group = mail
402
+dotlock_use_excl = yes
403
+verbose_proctitle = yes
404
+first_valid_uid = <VIRTUAL_UID_MAPS>
405
+first_valid_gid = <VIRTUAL_GID_MAPS>
406
+maildir_copy_with_hardlinks = yes
407
+protocol imap {
408
+  mail_plugins = quota imap_quota
409
+  login_greeting_capability = yes
410
+  imap_client_workarounds = delay-newmail netscape-eoh tb-extra-mailbox-sep
411
+}
412
+protocol pop3 {
413
+  pop3_uidl_format = %08Xu%08Xv
414
+  mail_plugins = quota
415
+  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
416
+}
417
+protocol lda {
418
+  postmaster_address = postmaster@<ADMIN_EMAIL>
419
+  sendmail_path = /usr/sbin/sendmail
420
+}
421
+auth_username_format = %Lu
422
+auth default {
423
+  mechanisms = plain login
424
+  passdb sql {
425
+    args = /usr/local/etc/dovecot-sql.conf
426
+  }
427
+  userdb sql {
428
+    args = /usr/local/etc/dovecot-sql.conf
429
+  }
430
+  user = root
431
+  socket listen {
432
+    client {
433
+      path = /var/spool/postfix/private/auth
434
+      mode = 0660
435
+      user = postfix
436
+      group = postfix
437
+    }
438
+  }
439
+}
440
+dict {
441
+}
442
+plugin {
443
+}
444
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_main.cf syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_main.cf
445
--- syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_main.cf	1969-12-31 17:00:00.000000000 -0700
446
+++ syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_main.cf	2008-12-12 12:21:46.000000000 -0700
447
@@ -0,0 +1,68 @@
448
+smtpd_sender_restrictions = permit_sasl_authenticated, permit_mynetworks
449
+smtpd_recipient_restrictions =
450
+  permit_mynetworks,
451
+  permit_sasl_authenticated,
452
+  reject_non_fqdn_hostname,
453
+  reject_non_fqdn_sender,
454
+  reject_non_fqdn_recipient,
455
+  reject_unauth_destination,
456
+  reject_unauth_pipelining,
457
+  reject_invalid_hostname
458
+smtpd_sasl_auth_enable = yes
459
+smtpd_sasl_authenticated_header = yes
460
+smtpd_sasl_local_domain = $myhostname
461
+smtpd_sasl_security_options = noanonymous
462
+broken_sasl_auth_clients = yes
463
+smtpd_sasl_type = dovecot
464
+smtpd_sasl_path = private/auth    
465
+smtp_use_tls = yes
466
+smtpd_use_tls = yes
467
+smtp_tls_note_starttls_offer = yes
468
+smtpd_tls_key_file = /etc/ssl/postfix/smtpd.pem
469
+smtpd_tls_cert_file = /etc/ssl/postfix/smtpd.pem
470
+smtpd_tls_CAfile = /etc/ssl/postfix/smtpd.pem
471
+smtpd_tls_loglevel = 0
472
+smtpd_tls_received_header = yes
473
+smtpd_tls_session_cache_timeout = 3600s
474
+tls_random_source = dev:/dev/urandom
475
+virtual_alias_maps = proxy:mysql:/usr/local/etc/postfix/mysql-virtual_alias_maps.cf
476
+virtual_gid_maps = static:<VIRTUAL_GID_MAPS>
477
+virtual_mailbox_base = <VIRTUAL_MAILBOX_BASE>
478
+virtual_mailbox_domains = proxy:mysql:/usr/local/etc/postfix/mysql-virtual_mailbox_domains.cf
479
+virtual_mailbox_limit = 51200000
480
+virtual_mailbox_maps = proxy:mysql:/usr/local/etc/postfix/mysql-virtual_mailbox_maps.cf
481
+virtual_minimum_uid = <VIRTUAL_UID_MAPS>
482
+virtual_transport = virtual
483
+virtual_uid_maps = static:<VIRTUAL_UID_MAPS>
484
+virtual_create_maildirsize = yes
485
+virtual_mailbox_extended = yes
486
+proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps
487
+  $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains
488
+  $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps
489
+  $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks
490
+virtual_mailbox_limit_override = yes
491
+virtual_maildir_limit_message = Sorry, this user has overdrawn their diskspace quota. Please try again later.
492
+virtual_overquota_bounce = yes
493
+alias_maps = $alias_database
494
+queue_directory = /var/spool/postfix
495
+command_directory = /usr/local/sbin
496
+daemon_directory = /usr/local/libexec/postfix
497
+data_directory = /var/db/postfix
498
+mail_owner = postfix
499
+myhostname = <SERVERNAME>
500
+mydomain = <SERVERNAME>
501
+myorigin = $mydomain
502
+unknown_local_recipient_reject_code = 550
503
+mynetworks_style = host
504
+debug_peer_level = 2
505
+debugger_command =
506
+	 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
507
+	 ddd $daemon_directory/$process_name $process_id & sleep 5
508
+sendmail_path = /usr/local/sbin/sendmail
509
+newaliases_path = /usr/local/bin/newaliases
510
+mailq_path = /usr/local/bin/mailq
511
+setgid_group = maildrop
512
+html_directory = no
513
+manpage_directory = /usr/local/man
514
+sample_directory = /usr/local/etc/postfix
515
+readme_directory = no
516
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_master.cf syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_master.cf
517
--- syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_master.cf	1969-12-31 17:00:00.000000000 -0700
518
+++ syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_master.cf	2008-12-12 12:21:46.000000000 -0700
519
@@ -0,0 +1,6 @@
520
+# Uncomment or add the following lines in your master.cf file 
521
+# to use the SSL 465 port (recommended)
522
+smtps     inet  n       -       n       -       -       smtpd
523
+  -o smtpd_tls_wrappermode=yes
524
+  -o smtpd_sasl_auth_enable=yes
525
+  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
526
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_alias_maps.cf syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_alias_maps.cf
527
--- syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_alias_maps.cf	1969-12-31 17:00:00.000000000 -0700
528
+++ syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_alias_maps.cf	2008-12-12 12:21:46.000000000 -0700
529
@@ -0,0 +1,8 @@
530
+user = <SQL_UNPRIVILEGED_USER>
531
+password = <SQL_UNPRIVILEGED_PASSWORD>
532
+dbname = <SQL_DB>
533
+table = mail_virtual
534
+select_field = destination
535
+where_field = email
536
+additional_conditions = and destination <> '' and destination <> ' '
537
+hosts = <SQL_HOST>
538
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_domains.cf syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_domains.cf
539
--- syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_domains.cf	1969-12-31 17:00:00.000000000 -0700
540
+++ syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_domains.cf	2008-12-12 12:21:46.000000000 -0700
541
@@ -0,0 +1,8 @@
542
+user = <SQL_UNPRIVILEGED_USER>
543
+password = <SQL_UNPRIVILEGED_PASSWORD>
544
+dbname = <SQL_DB>
545
+table = panel_domains
546
+select_field = domain
547
+where_field = domain
548
+additional_conditions = and isemaildomain = '1'
549
+hosts = <SQL_HOST>
550
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_maps.cf syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_maps.cf
551
--- syscp.orig/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_maps.cf	1969-12-31 17:00:00.000000000 -0700
552
+++ syscp/templates/misc/configfiles/freebsd_release/postfix/etc_postfix_mysql-virtual_mailbox_maps.cf	2008-12-12 12:21:46.000000000 -0700
553
@@ -0,0 +1,7 @@
554
+user = <SQL_UNPRIVILEGED_USER>
555
+password = <SQL_UNPRIVILEGED_PASSWORD>
556
+dbname = <SQL_DB>
557
+table = mail_users
558
+select_field = maildir
559
+where_field = email
560
+hosts = <SQL_HOST>
561
diff -Naur syscp.orig/templates/misc/configfiles/freebsd_release/proftpd/etc_proftpd.conf syscp/templates/misc/configfiles/freebsd_release/proftpd/etc_proftpd.conf
562
--- syscp.orig/templates/misc/configfiles/freebsd_release/proftpd/etc_proftpd.conf	1969-12-31 17:00:00.000000000 -0700
563
+++ syscp/templates/misc/configfiles/freebsd_release/proftpd/etc_proftpd.conf	2008-12-12 12:21:46.000000000 -0700
564
@@ -0,0 +1,53 @@
565
+ServerName			"<SERVERNAME> FTP Server"
566
+ServerType			standalone
567
+DefaultServer			on
568
+Port				21
569
+UseIPv6				off
570
+Umask				022
571
+SyslogLevel                     emerg
572
+SystemLog                       /var/log/xferlog
573
+LogFormat                       auth    "%v [%P] %h %t \"%r\" %s"
574
+ExtendedLog                     /var/log/xferlog        AUTH auth
575
+DeferWelcome                    off
576
+MultilineRFC2228                on
577
+ShowSymlinks                    on
578
+TimeoutNoTransfer               600
579
+TimeoutStalled                  600
580
+TimeoutIdle                     1200
581
+DisplayLogin                    welcome.msg
582
+DisplayChdir                    .message
583
+ListOptions                     "-l"
584
+DenyFilter                      \*.*/
585
+MaxInstances			30
586
+CommandBufferSize	512
587
+User				nobody
588
+Group				nogroup
589
+AllowOverwrite		on
590
+DefaultRoot ~
591
+RequireValidShell off
592
+AuthOrder mod_sql.c
593
+SQLAuthTypes Crypt
594
+SQLAuthenticate users groups
595
+SQLConnectInfo <SQL_DB>@<SQL_HOST> <SQL_UNPRIVILEGED_USER> <SQL_UNPRIVILEGED_PASSWORD>
596
+SQLUserInfo ftp_users username password uid gid homedir shell
597
+SQLGroupInfo ftp_groups groupname gid members
598
+SQLUserWhereClause "login_enabled = 'y'"
599
+SQLLog PASS login
600
+SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users
601
+SQLLog RETR download
602
+SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users
603
+SQLLog STOR upload
604
+SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users
605
+<IfModule mod_delay.c>
606
+  DelayEngine off
607
+</IfModule>
608
+<IfModule mod_tls.c>
609
+   TLSEngine on
610
+   TLSLog /var/log/xferlog
611
+   TLSProtocol SSLv23
612
+   TLSRequired off
613
+   TLSRSACertificateFile /etc/ssl/proftpd/cert.pem
614
+   TLSRSACertificateKeyFile /etc/ssl/proftpd/key.pem
615
+   TLSVerifyClient off
616
+   TLSRenegotiate required off
617
+</IfModule>

Return to bug 130266