Development

Navigation

← Previous Changeset
Next Changeset →

Changeset 285

Timestamp:

02/03/07 23:39:24 (2 years ago)

Author:

rats

Message:

- CONFIGS:

modified sql datafiles to VHCS 2.4.8 ω
fixed bug #14

- DOCS:

changed SQL-Update-2.4.7.1-to-2.4.8.sql

- ENGINE:

added traffic correction by Thomas Partsch

- GUI TOOLS:

changed webmail default settings

- SETUP:

fixed bug in fcgi configuration

Files:

trunk/CHANGELOG (modified) (1 diff)
trunk/configs/crontab/crontab.conf (modified) (2 diffs)
trunk/configs/database/Makefile (modified) (2 diffs)
trunk/configs/database/database.sql (modified) (15 diffs)
trunk/configs/database/htaccess.sql (deleted)
trunk/configs/fcgi/parts/php4.ini (modified) (1 diff)
trunk/configs/fcgi/parts/php5.ini (modified) (1 diff)
trunk/docs/Debian/INSTALL (modified) (2 diffs)
trunk/docs/README (modified) (1 diff)
trunk/docs/SQL-Update-2.4.7.1-to-2.4.8.sql (modified) (1 diff)
trunk/engine/setup/vhcs2-setup (modified) (3 diffs)
trunk/engine/traffic/vhcs2-srv-traff (modified) (3 diffs)
trunk/engine/traffic/vhcs2-vrl-traff (modified) (2 diffs)
trunk/engine/traffic/vhcs2-vrl-traff-correction (added)
trunk/engine/vhcs2_common_code.pl (modified) (3 diffs)
trunk/gui/tools/webmail/inc/config.php (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/CHANGELOG

r284	r285
12	12	\____________________________________________________________/
13	13
14		2007-02-01 Benedikt Heintel
	14	2007-02-03 Benedikt Heintel
	15	- CONFIGS:
	16	modified sql datafiles to VHCS 2.4.8 ω
	17	fixed bug #14
	18	- DOCS:
	19	changed SQL-Update-2.4.7.1-to-2.4.8.sql
	20	- ENGINE:
	21	added traffic correction by Thomas Partsch
	22	- GUI TOOLS:
	23	changed webmail default settings
	24	- SETUP:
	25	fixed bug in fcgi configuration
	26
	27	2007-02-02 Benedikt Heintel
15	28	- DOCS:
16	29	added feodora install doc

trunk/configs/crontab/crontab.conf

r284	r285
3	3
4	4	# Quota
5		0 23 * * * {QUOTA_ROOT_DIR}/vhcs2-dsk-quota &>{LOG_DIR}/vhcs2-qsk-quota.log
	5	0 23 * * * {QUOTA_ROOT_DIR}/vhcs2-dsk-quota &>{LOG_DIR}/vhcs2-qsk-quota.log
6	6
7	7	# Traffic
8		0,30 * * * * {TRAFF_ROOT_DIR}/vhcs2-srv-traff &>{LOG_DIR}/vhcs2-srv-traff.log
9		0,30 * * * * {TRAFF_ROOT_DIR}/vhcs2-vrl-traff &>{LOG_DIR}/vhcs2-vrl-traff.log
10		30 23 * * * {TOOLS_ROOT_DIR}/vhcs2-httpd-logs-mngr &>{LOG_DIR}/vhcs2-httpd-logs-mngr.log
	8	0,30 * * * * {TRAFF_ROOT_DIR}/vhcs2-srv-traff &>{LOG_DIR}/vhcs2-srv-traff.log
	9	0,30 * * * * {TRAFF_ROOT_DIR}/vhcs2-vrl-traff &>{LOG_DIR}/vhcs2-vrl-traff.log
	10	15,45 * * * * {TRAFF_ROOT_DIR}/vhcs2-vrl-traff-correction &>{LOG_DIR}/vhcs2-vrl-traff-correction.log
	11	30 23 * * * {TOOLS_ROOT_DIR}/vhcs2-httpd-logs-mngr &>{LOG_DIR}/vhcs2-httpd-logs-mngr.log
11	12
12	13	# Backup
13		0 1 * * * {BACKUP_ROOT_DIR}/vhcs2-backup-all yes &>{LOG_DIR}/vhcs2-backup-all-mngr.log
	14	0 1 * * * {BACKUP_ROOT_DIR}/vhcs2-backup-all yes &>{LOG_DIR}/vhcs2-backup-all-mngr.log
14	15
15	16	# AWStats
…	…
17	18
18	19	# Rootkit Hunter
19		0 0,12 * * * rkhunter --createlogfile --cronjob
	20	0 0,12 * * * rkhunter --createlogfile --cronjob
20	21
21	22	# [{DMN_NAME}] backup task START.

trunk/configs/database/Makefile

r154	r285
6	6	$(SYSTEM_MAKE_DIRS) $(SYSTEM_CONF)/database
7	7	cp ./database.sql $(SYSTEM_CONF)/database
8		~~cp ./htaccess.sql $(SYSTEM_CONF)/database~~
9	8	cp ./languages.sql $(SYSTEM_CONF)/database
10	9
…	…
12	11
13	12	rm -rf $(SYSTEM_CONF)/database
14
	13

trunk/configs/database/database.sql

r154	r285
3	3	use {DATABASE_NAME};
4	4
5		# VHCS(tm) - Virtual Hosting Control System
6		# (c) 2001-2006 moleSoftware
7		# http://vhcs.net \| http://www.molesoftware.com
8		# All rights reserved
9		#
10		# Datenbank: `vhcs_pro_dev`
11		# --------------------------------------------------------
12		#
13		# Tabellenstruktur f�elle `admin`
14		#
	5	--
	6	-- VHCS ω (OMEGA) - Virtual Hosting Control System \| Omega Version
	7	-- Copyright (c) 2001-2006 by moleSoftware GmbH
	8	-- Copyright (c) 2006-2007 by ispCP \| http://isp-control.net
	9	--
	10	-- --------------------------------------------------------
	11
	12	-- Tabellenstruktur für Tabelle `admin`
	13	--
15	14
16	15	CREATE TABLE `admin` (
…	…
34	33	`street2` varchar(200) default NULL,
35	34	`uniqkey` varchar(255) default NULL,
36		`uniqkey_time` ~~TIMESTAMP~~ NULL,
	35	`uniqkey_time` timestamp NULL default NULL,
37	36	UNIQUE KEY `admin_id` (`admin_id`),
38	37	UNIQUE KEY `admin_name` (`admin_name`)
39		) ENGINE=MyISAM AUTO_INCREMENT=1 ;
40
41		#
42		# Daten f�elle `admin`
43		#
44
45
46		# --------------------------------------------------------
	38	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	39
	40	-- --------------------------------------------------------
	41
	42	--
	43	-- Tabellenstruktur für Tabelle `auto_num`
	44	--
	45
	46	CREATE TABLE `auto_num` (
	47	`id` int(10) unsigned NOT NULL auto_increment,
	48	`msg` varchar(255) default NULL,
	49	UNIQUE KEY `id` (`id`)
	50	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	51
	52	-- --------------------------------------------------------
	53
	54	--
	55	-- Tabellenstruktur für Tabelle `config`
	56	--
	57
	58	CREATE TABLE `config` (
	59	`name` varchar(255) NOT NULL default '',
	60	`value` varchar(255) NOT NULL default '',
	61	PRIMARY KEY (`name`)
	62	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
	63
	64	--
	65	-- Daten für Tabelle `auto_num`
	66	--
	67
	68	INSERT INTO `config` ( `name` , `value` )
	69	VALUES (
	70	'PORT_FTP', '21;tcp;FTP;1;0'
	71	), (
	72	'PORT_SSH', '22;tcp;SSH;1;0'
	73	),(
	74	'PORT_TELNET', '23;tcp;TELNET;1;0'
	75	),(
	76	'PORT_SMTP', '25;tcp;SMPT;1;0'
	77	),(
	78	'PORT_DNS', '53;tcp;DNS;1;0'
	79	),(
	80	'PORT_HTTP', '80;tcp;HTTP;1;0'
	81	),(
	82	'PORT_HTTPS', '443;tcp;HTTPS;1;0'
	83	),(
	84	'PORT_POP3', '110;tcp;POP3;1;0'
	85	),(
	86	'PORT_POP3-SSL', '995;tcp;POP3-SSL;1;0'
	87	),(
	88	'PORT_IMAP', '143;tcp;IMAP;1;0'
	89	),(
	90	'PORT_IMAP-SSL', '993;tcp;IMAP-SSL;1;0'
	91	);
	92
	93	-- --------------------------------------------------------
	94
	95	--
	96	-- Tabellenstruktur für Tabelle `custom_menus`
	97	--
	98	CREATE TABLE `custom_menus` (
	99	`menu_id` int(10) unsigned NOT NULL auto_increment,
	100	`menu_level` varchar(10) default NULL,
	101	`menu_name` varchar(255) default NULL,
	102	`menu_link` varchar(200) default NULL,
	103	`menu_target` varchar(200) NOT NULL default '',
	104	PRIMARY KEY (`menu_id`)
	105	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	106
	107	-- --------------------------------------------------------
	108
	109	--
	110	-- Tabellenstruktur für Tabelle `domain`
	111	--
	112
	113	CREATE TABLE `domain` (
	114	`domain_id` int(10) unsigned NOT NULL auto_increment,
	115	`domain_name` varchar(200) default NULL,
	116	`domain_gid` int(10) unsigned NOT NULL default '0',
	117	`domain_uid` int(10) unsigned NOT NULL default '0',
	118	`domain_admin_id` int(10) unsigned NOT NULL default '0',
	119	`domain_created_id` int(10) unsigned NOT NULL default '0',
	120	`domain_created` int(10) unsigned NOT NULL default '0',
	121	`domain_last_modified` int(10) unsigned NOT NULL default '0',
	122	`domain_mailacc_limit` int(11) default NULL,
	123	`domain_ftpacc_limit` int(11) default NULL,
	124	`domain_traffic_limit` bigint(20) default NULL,
	125	`domain_sqld_limit` int(11) default NULL,
	126	`domain_sqlu_limit` int(11) default NULL,
	127	`domain_status` varchar(255) default NULL,
	128	`domain_alias_limit` int(11) default NULL,
	129	`domain_subd_limit` int(11) default NULL,
	130	`domain_ip_id` int(10) unsigned default NULL,
	131	`domain_disk_limit` bigint(20) unsigned default NULL,
	132	`domain_disk_usage` bigint(20) unsigned default NULL,
	133	`domain_php` varchar(15) default NULL,
	134	`domain_cgi` varchar(15) default NULL,
	135	UNIQUE KEY `domain_id` (`domain_id`),
	136	UNIQUE KEY `domain_name` (`domain_name`),
	137	KEY `i_domain_admin_id` (`domain_admin_id`)
	138	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	139
	140	-- --------------------------------------------------------
	141
	142	--
	143	-- Tabellenstruktur für Tabelle `domain_aliasses`
	144	--
	145
	146	CREATE TABLE `domain_aliasses` (
	147	`alias_id` int(10) unsigned NOT NULL auto_increment,
	148	`domain_id` int(10) unsigned default NULL,
	149	`alias_name` varchar(200) default NULL,
	150	`alias_status` varchar(255) default NULL,
	151	`alias_mount` varchar(200) default NULL,
	152	`alias_ip_id` int(10) unsigned default NULL,
	153	`url_forward` varchar(200) default NULL,
	154	PRIMARY KEY (`alias_id`)
	155	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	156
	157	-- --------------------------------------------------------
	158
	159	--
	160	-- Tabellenstruktur für Tabelle `domain_props`
	161	--
	162
	163	CREATE TABLE `domain_props` (
	164	`id` int(10) unsigned NOT NULL auto_increment,
	165	`dmn_id` int(10) unsigned default NULL,
	166	`dmn_type` varchar(255) default NULL,
	167	`suexec_support` varchar(255) default NULL,
	168	`suexec_id` int(10) unsigned default NULL,
	169	`ssl_support` varchar(255) default NULL,
	170	`ssl_id` int(10) unsigned default NULL,
	171	`pri_master_dns` varchar(255) default NULL,
	172	`pri_master_dns_ip` varchar(255) default NULL,
	173	`sec_master_dns` varchar(255) default NULL,
	174	`sec_master_dns_ip` varchar(255) default NULL,
	175	PRIMARY KEY (`id`)
	176	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	177
	178	-- --------------------------------------------------------
	179
	180	--
	181	-- Tabellenstruktur für Tabelle `domain_traffic`
	182	--
	183
	184	CREATE TABLE `domain_traffic` (
	185	`dtraff_id` int(10) unsigned NOT NULL auto_increment,
	186	`domain_id` int(10) unsigned default NULL,
	187	`dtraff_time` int(10) unsigned default NULL,
	188	`dtraff_web` int(10) unsigned default NULL,
	189	`dtraff_ftp` int(10) unsigned default NULL,
	190	`dtraff_mail` int(10) unsigned default NULL,
	191	`dtraff_pop` int(10) unsigned default NULL,
	192	`correction` tinyint(1) NOT NULL default '0',
	193	PRIMARY KEY (`dtraff_id`),
	194	KEY `i_correction` (`correction`),
	195	KEY `i_domain_id` (`domain_id`),
	196	KEY `i_dtraff_time` (`dtraff_time`)
	197	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	198
	199	-- --------------------------------------------------------
	200
	201	--
	202	-- Tabellenstruktur für Tabelle `email_tpls`
	203	--
	204
	205	CREATE TABLE `email_tpls` (
	206	`id` int(10) unsigned NOT NULL auto_increment,
	207	`owner_id` int(10) unsigned NOT NULL default '0',
	208	`name` varchar(200) default NULL,
	209	`subject` varchar(200) default NULL,
	210	`message` text,
	211	UNIQUE KEY `id` (`id`)
	212	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	213
	214	-- --------------------------------------------------------
	215
	216	--
	217	-- Tabellenstruktur für Tabelle `error_pages`
	218	--
	219
	220	CREATE TABLE `error_pages` (
	221	`ep_id` int(10) unsigned NOT NULL auto_increment,
	222	`user_id` int(10) unsigned NOT NULL default '0',
	223	`error_401` text NOT NULL,
	224	`error_403` text NOT NULL,
	225	`error_404` text NOT NULL,
	226	`error_500` text NOT NULL,
	227	PRIMARY KEY (`ep_id`)
	228	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	229
	230	-- --------------------------------------------------------
	231
	232	--
	233	-- Tabellenstruktur für Tabelle `ftp_group`
	234	--
	235
	236	CREATE TABLE `ftp_group` (
	237	`groupname` varchar(255) default NULL,
	238	`gid` int(10) unsigned NOT NULL default '0',
	239	`members` text,
	240	UNIQUE KEY `groupname` (`groupname`)
	241	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	242
	243	-- --------------------------------------------------------
	244
	245	--
	246	-- Tabellenstruktur für Tabelle `ftp_users`
	247	--
	248
	249	CREATE TABLE `ftp_users` (
	250	`userid` varchar(255) default NULL,
	251	`passwd` varchar(255) default NULL,
	252	`uid` int(10) unsigned NOT NULL default '0',
	253	`gid` int(10) unsigned NOT NULL default '0',
	254	`shell` varchar(255) default NULL,
	255	`homedir` varchar(255) default NULL,
	256	UNIQUE KEY `userid` (`userid`)
	257	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	258
	259	-- --------------------------------------------------------
	260
	261	--
	262	-- Tabellenstruktur für Tabelle `hosting_plans`
	263	--
	264
	265	CREATE TABLE `hosting_plans` (
	266	`id` int(10) unsigned NOT NULL auto_increment,
	267	`reseller_id` int(10) unsigned NOT NULL default '0',
	268	`name` varchar(255) default NULL,
	269	`props` text,
	270	`description` varchar(255) default NULL,
	271	`price` decimal(4,2) NOT NULL default '0.00',
	272	`setup_fee` decimal(4,2) NOT NULL default '0.00',
	273	`value` varchar(255) default NULL,
	274	`payment` varchar(255) default NULL,
	275	`status` int(10) unsigned NOT NULL default '0',
	276	UNIQUE KEY `id` (`id`)
	277	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	278
	279	-- --------------------------------------------------------
	280
	281	--
	282	-- Tabellenstruktur für Tabelle `htaccess`
	283	--
	284	-- Erzeugt am: 14. Juni 2006 um 23:42
	285	-- Aktualisiert am: 09. Januar 2007 um 17:37
	286	-- Letzter Check am: 09. Januar 2007 um 17:37
	287	--
	288
	289	CREATE TABLE `htaccess` (
	290	`id` int(10) unsigned NOT NULL auto_increment,
	291	`dmn_id` int(10) unsigned NOT NULL default '0',
	292	`user_id` tinyint(4) default NULL,
	293	`group_id` tinyint(4) default NULL,
	294	`auth_type` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	295	`auth_name` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	296	`path` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	297	`status` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
	298	UNIQUE KEY `id` (`id`)
	299	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	300
	301	-- --------------------------------------------------------
	302
	303	--
	304	-- Tabellenstruktur für Tabelle `htaccess_groups`
	305	--
	306	-- Erzeugt am: 05. März 2006 um 21:59
	307	-- Aktualisiert am: 01. Oktober 2006 um 13:59
	308	-- Letzter Check am: 15. September 2006 um 21:41
	309	--
	310
	311	CREATE TABLE `htaccess_groups` (
	312	`id` int(10) unsigned NOT NULL auto_increment,
	313	`dmn_id` int(10) unsigned NOT NULL default '0',
	314	`ugroup` varchar(255) default NULL,
	315	`members` text,
	316	`status` varchar(255) default NULL,
	317	UNIQUE KEY `id` (`id`)
	318	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	319
	320	-- --------------------------------------------------------
	321
	322	--
	323	-- Tabellenstruktur für Tabelle `htaccess_users`
	324	--
	325	-- Erzeugt am: 05. März 2006 um 21:59
	326	-- Aktualisiert am: 09. Januar 2007 um 17:37
	327	-- Letzter Check am: 09. Januar 2007 um 17:37
	328	--
	329
	330	CREATE TABLE `htaccess_users` (
	331	`id` int(10) unsigned NOT NULL auto_increment,
	332	`dmn_id` int(10) unsigned NOT NULL default '0',
	333	`uname` varchar(255) default NULL,
	334	`upass` varchar(255) default NULL,
	335	`status` varchar(255) default NULL,
	336	UNIQUE KEY `id` (`id`)
	337	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	338
	339	-- --------------------------------------------------------
	340	-- Tabellenstruktur für Tabelle `log`
	341	--
	342
	343	CREATE TABLE `log` (
	344	`log_id` int(10) unsigned NOT NULL auto_increment,
	345	`log_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
	346	`log_message` varchar(250) default NULL,
	347	PRIMARY KEY (`log_id`)
	348	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	349
	350	-- --------------------------------------------------------
	351
	352	--
	353	-- Tabellenstruktur für Tabelle `login`
	354	--
	355
	356	CREATE TABLE `login` (
	357	`session_id` varchar(200) default NULL,
	358	`ipaddr` varchar(15) default NULL,
	359	`lastaccess` int(10) unsigned default NULL,
	360	`login_count` tinyint(1) default NULL,
	361	`user_name` varchar(255) default NULL
	362	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	363
	364	-- --------------------------------------------------------
	365
	366	--
	367	-- Tabellenstruktur für Tabelle `mail_users`
	368	--
	369
	370	CREATE TABLE `mail_users` (
	371	`mail_id` int(10) unsigned NOT NULL auto_increment,
	372	`mail_acc` varchar(200) default NULL,
	373	`mail_pass` varchar(150) default NULL,
	374	`mail_forward` text,
	375	`domain_id` int(10) unsigned default NULL,
	376	`mail_type` varchar(20) default NULL,
	377	`sub_id` int(10) unsigned default NULL,
	378	`status` varchar(255) default NULL,
	379	`mail_auto_respond` text,
	380	`quota` int(10) default '10485760',
	381	`mail_addr` varchar(200) default NULL,
	382	PRIMARY KEY (`mail_id`)
	383	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	384
	385	-- --------------------------------------------------------
	386
	387	--
	388	-- Tabellenstruktur für Tabelle `orders`
	389	--
47	390
48	391	CREATE TABLE `orders` (
…	…
66	409	`status` varchar(255) default NULL,
67	410	PRIMARY KEY (`id`)
68		) TYPE=MyISAM;
69
70		#
71		# Daten f�elle `orders`
72		#
73
74
75		# --------------------------------------------------------
76
77		#
78		# Tabellenstruktur f�elle `orders_settings`
79		#
	411	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	412
	413	-- --------------------------------------------------------
	414
	415	--
	416	-- Tabellenstruktur für Tabelle `orders_settings`
	417	--
80	418
81	419	CREATE TABLE `orders_settings` (
…	…
85	423	`footer` text,
86	424	PRIMARY KEY (`id`)
87		) TYPE=MyISAM;
88
89		#
90		# Daten f�elle `orders_settings`
91		#
92
93
94		# --------------------------------------------------------
95
96		#
97		# Tabellenstruktur f�elle `custom_menus`
98		#
99
100		CREATE TABLE `custom_menus` (
101		`menu_id` int(10) unsigned NOT NULL auto_increment,
102		`menu_level` varchar(10) default NULL,
103		`menu_name` varchar(255) default NULL,
104		`menu_link` varchar(200) default NULL,
105		`menu_target` varchar(200) NOT NULL default '',
106		PRIMARY KEY (`menu_id`)
107		) TYPE=MyISAM AUTO_INCREMENT=1 ;
108
109		#
110		# Daten f�elle `custom_menus`
111		#
112
113
114		# --------------------------------------------------------
115
116		#
117		# Tabellenstruktur f�elle `domain`
118		#
119
120		CREATE TABLE `domain` (
121		`domain_id` int(10) unsigned NOT NULL auto_increment,
122		`domain_name` varchar(200) default NULL,
123		`domain_gid` int(10) unsigned NOT NULL default '0',
124		`domain_uid` int(10) unsigned NOT NULL default '0',
125		`domain_admin_id` int(10) unsigned NOT NULL default '0',
126		`domain_created_id` int(10) unsigned NOT NULL default '0',
127		`domain_created` int(10) unsigned NOT NULL default '0',
128		`domain_last_modified` int(10) unsigned NOT NULL default '0',
129		`domain_mailacc_limit` int(11) default NULL,
130		`domain_ftpacc_limit` int(11) default NULL,
131		`domain_traffic_limit` int(11) default NULL,
132		`domain_sqld_limit` int(11) default NULL,
133		`domain_sqlu_limit` int(11) default NULL,
134		`domain_status` varchar(255) default NULL,
135		`domain_alias_limit` int(11) default NULL,
136		`domain_subd_limit` int(11) default NULL,
137		`domain_ip_id` int(10) unsigned default NULL,
138		`domain_disk_limit` int(30) unsigned default NULL,
139		`domain_disk_usage` int(30) unsigned default NULL,
140		`domain_php` varchar(15) default NULL,
141		`domain_cgi` varchar(15) default NULL,
142		UNIQUE KEY `domain_id` (`domain_id`),
143		UNIQUE KEY `domain_name` (`domain_name`),
144		KEY `i_domain_domain_admin_id` (`domain_admin_id`)
145		) ENGINE=MyISAM AUTO_INCREMENT=1 ;
146
147		#
148		# Daten f�elle `domain`
149		#
150
151
152		# --------------------------------------------------------
153
154		#
155		# Tabellenstruktur f�elle `domain_aliasses`
156		#
157
158		CREATE TABLE `domain_aliasses` (
159		`alias_id` int(10) unsigned NOT NULL auto_increment,
160		`domain_id` int(10) unsigned default NULL,
161		`alias_name` varchar(200) default NULL,
162		`alias_status` varchar(255) default NULL,
163		`alias_mount` varchar(200) default NULL,
164		`alias_ip_id` int(10) unsigned default NULL,
165		`url_forward` varchar(200) default NULL,
166		PRIMARY KEY (`alias_id`)
167		) TYPE=MyISAM AUTO_INCREMENT=1 ;
168
169		#
170		# Daten f�elle `domain_aliasses`
171		#
172
173
174		# --------------------------------------------------------
175
176		#
177		# Tabellenstruktur f�elle `domain_props`
178		#
179
180		CREATE TABLE `domain_props` (
181		`id` int(10) unsigned NOT NULL auto_increment,
182		`dmn_id` int(10) unsigned default NULL,
183		`dmn_type` varchar(255) default NULL,
184		`suexec_support` varchar(255) default NULL,
185		`suexec_id` int(10) unsigned default NULL,
186		`ssl_support` varchar(255) default NULL,
187		`ssl_id` int(10) unsigned default NULL,
188		`pri_master_dns` varchar(255) default NULL,
189		`pri_master_dns_ip` varchar(255) default NULL,
190		`sec_master_dns` varchar(255) default NULL,
191		`sec_master_dns_ip` varchar(255) default NULL,
192		PRIMARY KEY (`id`),
193		UNIQUE KEY `id` (`id`)
194		) TYPE=MyISAM AUTO_INCREMENT=1 ;
195
196		#
197		# Daten f�elle `domain_props`
198		#
199
200
201		# --------------------------------------------------------
202
203		#
204		# Tabellenstruktur f�elle `domain_traffic`
205		#
206
207		CREATE TABLE `domain_traffic` (
208		`dtraff_id` int(10) unsigned NOT NULL auto_increment,
209		`domain_id` int(10) unsigned default NULL,
210		`dtraff_time` int(10) unsigned default NULL,
211		`dtraff_web` int(10) unsigned default NULL,
212		`dtraff_ftp` int(10) unsigned default NULL,
213		`dtraff_mail` int(10) unsigned default NULL,
214		`dtraff_pop` int(10) unsigned default NULL,
215		PRIMARY KEY (`dtraff_id`),
216		KEY `i_domain_traffic_domain_id` (`domain_id`),
217		KEY `dtraff_time` (`dtraff_time`)
218		) ENGINE=MyISAM AUTO_INCREMENT=1;
219
220		#
221		# Daten f�elle `domain_traffic`
222		#
223
224
225		# --------------------------------------------------------
226
227		#
228		# Tabellenstruktur f�elle `email_tpls`
229		#
230
231		CREATE TABLE `email_tpls` (
232		`id` int(10) unsigned NOT NULL auto_increment,
233		`owner_id` int(10) unsigned NOT NULL default '0',
234		`name` varchar(200) default NULL,
235		`subject` varchar(200) default NULL,
236		`message` text,
237		UNIQUE KEY `id` (`id`)
238		) TYPE=MyISAM AUTO_INCREMENT=1 ;
239
240		#
241		# Daten f�elle `email_tpls`
242		#
243
244
245		# --------------------------------------------------------
246
247		#
248		# Tabellenstruktur f�elle `error_pages`
249		#
250
251		CREATE TABLE `error_pages` (
252		`ep_id` int(10) unsigned NOT NULL auto_increment,
253		`user_id` int(10) unsigned NOT NULL default '0',
254		`error_401` text NOT NULL,
255		`error_403` text NOT NULL,
256		`error_404` text NOT NULL,
257		`error_500` text NOT NULL,
258		PRIMARY KEY (`ep_id`)
259		) TYPE=MyISAM AUTO_INCREMENT=3 ;
260
261		#
262		# Daten f�elle `error_pages`
263		#
264
265
266		# --------------------------------------------------------
267
268		#
269		# Tabellenstruktur f�elle `ftp_group`
270		#
271
272		CREATE TABLE `ftp_group` (
273		`groupname` varchar(255) default NULL,
274		`gid` int(10) unsigned NOT NULL default '0',
275		`members` text
276		) TYPE=MyISAM;
277
278		#
279		# Daten f�elle `ftp_group`
280		#
281
282
283		# --------------------------------------------------------
284
285		#
286		# Tabellenstruktur f�elle `hosting_plans`
287		#
288
289		CREATE TABLE `hosting_plans` (
290		`id` int(10) unsigned NOT NULL auto_increment,
291		`reseller_id` int(10) unsigned NOT NULL default '0',
292		`name` varchar(255) default NULL,
293		`description` varchar(255) default NULL,
294		`props` text,
295		`price` decimal(10,2) NOT NULL default '0.00',
296		`setup_fee` decimal(10,2) NOT NULL default '0.00',
297		`value` varchar(255) default NULL,
298		`payment` varchar(255) default NULL,
299		`status` int(10) unsigned NOT NULL default '0',
300		UNIQUE KEY `id` (`id`)
301		) TYPE=MyISAM;
302
303		#
304		# Daten f�elle `hosting_plans`
305		#
306
307
308		# --------------------------------------------------------
309
310		#
311		# Tabellenstruktur f�elle `log`
312		#
313
314		CREATE TABLE `log` (
315		`log_id` int(10) unsigned NOT NULL auto_increment,
316		`log_time` timestamp(14) NOT NULL,
317		`log_message` varchar(250) default NULL,
318		PRIMARY KEY (`log_id`)
319		) TYPE=MyISAM AUTO_INCREMENT=1 ;
320
321		#
322		# Daten f�elle `log`
323		#
324
325
326		# --------------------------------------------------------
327
328		#
329		# Tabellenstruktur f�elle `login`
330		#
331
332		CREATE TABLE `login` (
333		`session_id` varchar(200) default NULL,
334		`ipaddr` varchar(15) default NULL,
335		`lastaccess` int(10) unsigned default NULL,
336		`user_name` varchar(255) default NULL,
337		`login_count` tinyint(1) default NULL
338		) TYPE=MyISAM;
339
340		#
341		# Daten f�elle `login`
342		#
343
344
345		# --------------------------------------------------------
346
347		#
348		# Tabellenstruktur f�elle `mail_users`
349		#
350
351		CREATE TABLE `mail_users` (
352		`mail_id` int(10) unsigned NOT NULL auto_increment,
353		`mail_acc` varchar(200) default NULL,
354		`mail_pass` varchar(150) default NULL,
355		`mail_forward` text,
356		`domain_id` int(10) unsigned default NULL,
357		`mail_type` varchar(20) default NULL,
358		`sub_id` int(10) unsigned default NULL,
359		`status` varchar(255) default NULL,
360		`mail_auto_respond` text,
361		PRIMARY KEY (`mail_id`)
362		) TYPE=MyISAM AUTO_INCREMENT=1 ;
363
364		#
365		# Daten f�elle `mail_users`
366		#
367
368
369		# --------------------------------------------------------
370
371		#
372		# Tabellenstruktur f�elle `reseller_props`
373		#
	425	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	426
	427	-- --------------------------------------------------------
	428
	429	--
	430	-- Tabellenstruktur für Tabelle `quotalimits`
	431	--
	432
	433	CREATE TABLE `quotalimits` (
	434	`name` varchar(30) default NULL,
	435	`quota_type` enum('user','group','class','all') NOT NULL default 'user',
	436	`per_session` enum('false','true') NOT NULL default 'false',
	437	`limit_type` enum('soft','hard') NOT NULL default 'soft',
	438	`bytes_in_avail` float NOT NULL default '0',
	439	`bytes_out_avail` float NOT NULL default '0',
	440	`bytes_xfer_avail` float NOT NULL default '0',
	441	`files_in_avail` int(10) unsigned NOT NULL default '0',
	442	`files_out_avail` int(10) unsigned NOT NULL default '0',
	443	`files_xfer_avail` int(10) unsigned NOT NULL default '0'
	444	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	445
	446	-- --------------------------------------------------------
	447
	448	--
	449	-- Tabellenstruktur für Tabelle `quotatallies`
	450	--
	451
	452	CREATE TABLE `quotatallies` (
	453	`name` varchar(30) NOT NULL default '',
	454	`quota_type` enum('user','group','class','all') NOT NULL default 'user',
	455	`bytes_in_used` float NOT NULL default '0',
	456	`bytes_out_used` float NOT NULL default '0',
	457	`bytes_xfer_used` float NOT NULL default '0',
	458	`files_in_used` int(10) unsigned NOT NULL default '0',
	459	`files_out_used` int(10) unsigned NOT NULL default '0',
	460	`files_xfer_used` int(10) unsigned NOT NULL default '0'
	461	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	462
	463	-- --------------------------------------------------------
	464
	465
	466	-- Tabellenstruktur für Tabelle `reseller_props`
	467	--
374	468
375	469	CREATE TABLE `reseller_props` (
…	…
397	491	`reseller_ips` text,
398	492	UNIQUE KEY `id` (`id`)
399		) TYPE=MyISAM AUTO_INCREMENT=1 ;
400
401		#
402		# Daten f�elle `reseller_props`
403		#
404
405
406		# --------------------------------------------------------
407
408		#
409		# Tabellenstruktur f�elle `server_ips`
410		#
	493	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	494
	495
	496
	497	-- --------------------------------------------------------
	498
	499	--
	500	-- Tabellenstruktur für Tabelle `server_ips`
	501	--
411	502
412	503	CREATE TABLE `server_ips` (
…	…
416	507	`ip_alias` varchar(200) default NULL,
417	508	UNIQUE KEY `ip_id` (`ip_id`)
418		) TYPE=MyISAM AUTO_INCREMENT=8 ;
419
420		#
421		# Daten f�elle `server_ips`
422		#
423
424		# --------------------------------------------------------
425
426		#
427		# Tabellenstruktur f�elle `server_traffic`
428		#
	509	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	510
	511	-- --------------------------------------------------------
	512
	513	--
	514	-- Tabellenstruktur für Tabelle `server_traffic`
	515	--
429	516
430	517	CREATE TABLE `server_traffic` (
…	…
439	526	`bytes_web_in` int(10) unsigned default NULL,
440	527	`bytes_web_out` int(10) unsigned default NULL,
	528	`correction` tinyint(1) NOT NULL default '0',
441	529	PRIMARY KEY (`straff_id`),
442		KEY `traff_time` (`traff_time`)
443		) ENGINE=MyISAM AUTO_INCREMENT=1;
444
445		#
446		# Daten f�elle `server_traffic`
447		#
448
449
450		# --------------------------------------------------------
451
452		#
453		# Tabellenstruktur f�elle `sql_database`
454		#
	530	KEY `i_correction` (`correction`),
	531	KEY `i_traff_time` (`traff_time`)
	532	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	533
	534	-- --------------------------------------------------------
	535
	536	--
	537	-- Tabellenstruktur für Tabelle `sql_database`
	538	--
455	539
456	540	CREATE TABLE `sql_database` (
…	…
459	543	`sqld_name` varchar(64) binary default 'n/a',
460	544	UNIQUE KEY `sqld_id` (`sqld_id`)
461		) TYPE=MyISAM AUTO_INCREMENT=3 ;
462
463		#
464		# Daten f�elle `sql_database`
465		#
466
467
468		# --------------------------------------------------------
469
470		#
471		# Tabellenstruktur f�elle `sql_user`
472		#
	545	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	546
	547	-- --------------------------------------------------------
	548
	549	--
	550	-- Tabellenstruktur für Tabelle `sql_user`
	551	--
473	552
474	553	CREATE TABLE `sql_user` (
…	…
480	559	) TYPE=MyISAM AUTO_INCREMENT=2 ;
481	560
482		#
483		# Daten f�elle `sql_user`
484		#
485
486
487		# --------------------------------------------------------
488
489		#
490		# Tabellenstruktur f�elle `straff_settings`
491		#
	561	-- --------------------------------------------------------
	562
	563	--
	564	-- Tabellenstruktur für Tabelle `straff_settings`
	565	--
492	566
493	567	CREATE TABLE `straff_settings` (
…	…
495	569	`straff_warn` int(10) unsigned default NULL,
496	570	`straff_email` int(10) unsigned default NULL
497		) ~~TYPE=MyISAM~~;
498
499		#
500		~~# Daten f�~~elle `straff_settings`
501		#
	571	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	572
	573	--
	574	-- Daten für Tabelle `straff_settings`
	575	--
502	576
503	577	INSERT INTO `straff_settings` VALUES (0, 0, 0);
504	578
505		# --------------------------------------------------------
506
507		#
508		~~# Tabellenstruktur f�~~elle `subdomain`
509		#
	579	-- --------------------------------------------------------
	580
	581	--
	582	-- Tabellenstruktur für Tabelle `subdomain`
	583	--
510	584
511	585	CREATE TABLE `subdomain` (
…	…
515	589	`subdomain_mount` varchar(200) default NULL,
516	590	`subdomain_status` varchar(255) default NULL,
	591	`subdomain_phpv` varchar(15) default NULL,
517	592	PRIMARY KEY (`subdomain_id`)
518		) TYPE=MyISAM AUTO_INCREMENT=1 ;
519
520		#
521		# Daten f�elle `subdomain`
522		#
523
524
525		# --------------------------------------------------------
526
527		#
528		# Tabellenstruktur f�elle `suexec_props`
529		#
	593	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	594
	595	-- --------------------------------------------------------
	596
	597	--
	598	-- Tabellenstruktur für Tabelle `suexec_props`
	599	--
530	600
531	601	CREATE TABLE `suexec_props` (
…	…
535	605	`usr` varchar(255) default NULL,
536	606	`grp` varchar(255) default NULL,
537		PRIMARY KEY (`id`),
538		UNIQUE KEY `id` (`id`)
539		) TYPE=MyISAM AUTO_INCREMENT=2 ;
540
541		#
542		# Daten f�elle `suexec_props`
543		#
544
545		#INSERT INTO `suexec_props` VALUES (1, 3001, 3001, 'vhcs0001', 'vhcs0001');
546
547		# --------------------------------------------------------
548
549		#
550		# Tabellenstruktur f�elle `syslog`
551		#
	607	PRIMARY KEY (`id`)
	608	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	609
	610	-- --------------------------------------------------------
	611
	612	--
	613	-- Tabellenstruktur für Tabelle `syslog`
	614	--
552	615
553	616	CREATE TABLE `syslog` (
…	…
559	622	`comment` text,
560	623	UNIQUE KEY `id` (`id`)
561		) TYPE=MyISAM AUTO_INCREMENT=1 ;
562
563		#
564		# Daten f�elle `syslog`
565		#
566
567
568		# --------------------------------------------------------
569
570		#
571		# Tabellenstruktur f�elle `tickets`
572		#
	624	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	625
	626	-- --------------------------------------------------------
	627
	628	--
	629	-- Tabellenstruktur für Tabelle `tickets`
	630	--
573	631
574	632	CREATE TABLE `tickets` (
…	…
584	642	`ticket_message` text,
585	643	PRIMARY KEY (`ticket_id`)
586		) TYPE=MyISAM AUTO_INCREMENT=2 ;
587
588		#
589		# Daten f�elle `tickets`
590		#
591
592
593		# --------------------------------------------------------
594
595		#
596		# Tabellenstruktur f�elle `user_gui_props`
597		#
	644	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	645
	646	-- --------------------------------------------------------
	647
	648	--
	649	-- Tabellenstruktur für Tabelle `user_gui_props`
	650	--
598	651
599	652	CREATE TABLE `user_gui_props` (
…	…
604	657	`logo` varchar(255) NOT NULL default '0',
605	658	UNIQUE KEY `id` (`id`)
606		) TYPE=MyISAM AUTO_INCREMENT=66 ;
607
608		#
609		# Daten f�elle `user_gui_props`
610		#
611
612		#INSERT INTO `user_gui_props` VALUES (3, 3, 'lang_Deutsch', 'yellow', 'admin.jpg');
613
614
615		# --------------------------------------------------------
616
617		#
618		# Tabellenstruktur Tabelle `ftp_users`
619		#
620
621		CREATE TABLE `ftp_users` (
622		`userid` varchar(255) default NULL,
623		`passwd` varchar(255) default NULL,
624		`uid` int(10) unsigned NOT NULL default '0',
625		`gid` int(10) unsigned NOT NULL default '0',
626		`shell` varchar(255) default NULL,
627		`homedir` varchar(255) default NULL,
628		UNIQUE KEY `userid` (`userid`)
629		) TYPE=MyISAM;
630
631		#
632		# Daten f�elle `ftp_users`
633		#
634
635
636		# --------------------------------------------------------
637
638		#
639		# Tabellenstruktur f�elle `quotalimits`
640		#
641
642		CREATE TABLE `quotalimits` (
643		`name` VARCHAR(30),
644		`quota_type` ENUM("user", "group", "class", "all") NOT NULL,
645		`per_session` ENUM("false", "true") NOT NULL,
646		`limit_type` ENUM("soft", "hard") NOT NULL,
647		`bytes_in_avail` FLOAT NOT NULL,
648		`bytes_out_avail` FLOAT NOT NULL,
649		`bytes_xfer_avail` FLOAT NOT NULL,
650		`files_in_avail` INT UNSIGNED NOT NULL,
651		`files_out_avail` INT UNSIGNED NOT NULL,
652		`files_xfer_avail` INT UNSIGNED NOT NULL
653		);
654
655		#
656		# Daten f�elle `quotalimits`
657		#
658
659
660		# --------------------------------------------------------
661
662		#
663		# Tabellenstruktur f�elle `quotatallies`
664		#
665
666		CREATE TABLE `quotatallies` (
667		`name` VARCHAR(30) NOT NULL,
668		`quota_type` ENUM("user", "group", "class", "all") NOT NULL,
669		`bytes_in_used` FLOAT NOT NULL,
670		`bytes_out_used` FLOAT NOT NULL,
671		`bytes_xfer_used` FLOAT NOT NULL,
672		`files_in_used` INT UNSIGNED NOT NULL,
673		`files_out_used` INT UNSIGNED NOT NULL,
674		`files_xfer_used` INT UNSIGNED NOT NULL
675		);
676
677		#
678		# Daten f�elle `quotatallies`
679		#
680
681
682		# --------------------------------------------------------
683
684		#
685		# Tabellenstruktur f�elle `auto_num`
686		#
687
688		CREATE TABLE `auto_num` (
689		`id` INT unsigned NOT NULL AUTO_INCREMENT,
690		`msg` VARCHAR(255),
691		UNIQUE KEY `id` (`id`)
692		);
693
694		#
695		# Daten f�elle `auto_num`
696		#
697
698
699		# --------------------------------------------------------
700
701		#
702		# Tabellenstruktur f�elle `config`
703		#
704
705		CREATE TABLE `config` (
706		`name` varchar(255) NOT NULL default '',
707		`value` varchar(255) NOT NULL default '',
708		PRIMARY KEY (`name`)
709		) TYPE=MyISAM;
710
711		#
712		# Daten f�elle `auto_num`
713		#
714
715		INSERT INTO `config` ( `name` , `value` )
716		VALUES (
717		'PORT_FTP', '21;tcp;FTP;1;0'
718		), (
719		'PORT_SSH', '22;tcp;SSH;1;0'
720		),(
721		'PORT_TELNET', '23;tcp;TELNET;1;0'
722		),(
723		'PORT_SMTP', '25;tcp;SMPT;1;0'
724		),(
725		'PORT_DNS', '53;tcp;DNS;1;0'
726		),(
727		'PORT_HTTP', '80;tcp;HTTP;1;0'
728		),(
729		'PORT_HTTPS', '443;tcp;HTTPS;1;0'
730		),(
731		'PORT_POP3', '110;tcp;POP3;1;0'
732		),(
733		'PORT_POP3-SSL', '995;tcp;POP3-SSL;1;0'
734		),(
735		'PORT_IMAP', '143;tcp;IMAP;1;0'
736		),(
737		'PORT_IMAP-SSL', '993;tcp;IMAP-SSL;1;0'
738		);
739
740		# --------------------------------------------------------
741
	659	) ENGINE=MyISAM DEFAULT CHARSET=latin1;

trunk/configs/fcgi/parts/php4.ini

r190	r285
204	204	;
205	205
206		open_basedir = ~~open_basedir = "{WWW_DIR}/{DMN_NAME}/:{WWW_DIR}/{DMN_NAME}/phptmp~~/:{PEAR_DIR}/"
	206	open_basedir = "{WWW_DIR}/{DMN_NAME}/:{PEAR_DIR}/"
207	207
208	208	; This directive allows you to disable certain functions for security reasons.

trunk/configs/fcgi/parts/php5.ini

r190	r285
151	151	; or per-virtualhost web server configuration file. This directive is
152	152	; NOT affected by whether Safe Mode is turned On or Off.
153		open_basedir = ~~open_basedir = "{WWW_DIR}/{DMN_NAME}/:{WWW_DIR}/{DMN_NAME}/phptmp~~/:{PEAR_DIR}/"
	153	open_basedir = "{WWW_DIR}/{DMN_NAME}/:{PEAR_DIR}/"
154	154
155	155	; This directive allows you to disable certain functions for security reasons.

trunk/docs/Debian/INSTALL

r282	r285
33	33	Debian (or even any other *NIX-Distribution)
34	34
35		All Sarge required packages are listed in ./docs/debian-packages-sarge
36		All Etch required packages are listed in ./docs/debian-packages-etch
	35	All Sarge required packages are listed in ./docs/Debian/debian-packages-sarge
	36	All Etch required packages are listed in ./docs/Debian/debian-packages-etch
37	37
38	38	================================================================================
…	…
64	64	for Debian Etch you can use:
65	65	# apt-get update && apt-get upgrade
66