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> |