指令版 qmail的安装for FreeBSD( 二 ) _云知道

CREATE TABLE `lastauth` ( `user` char(32) NOT NULL default "", `domain` char(64) NOT NULL default "", `remote_ip` char(18) NOT NULL default "", `timestamp` bigint(20) NOT NULL default "0", PRIMARY KEY (`user`,`domain`)) TYPE=MyISAM;
CREATE TABLE `logs` ( `pw_id` int(5) default "0", `ip` varchar(15) NOT NULL default "", `action` varchar(15) NOT NULL default "", `time` datetime default NULL, `content` varchar(64) NOT NULL default "", `email` varchar(128) NOT NULL default "") TYPE=MyISAM;
CREATE TABLE `message` ( `id` int(5) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default "", `body` text NOT NULL, `createtime` datetime NOT NULL default "0000-00-00 00:00:00", `updatetime` datetime NOT NULL default "0000-00-00 00:00:00", `pw_domain` varchar(64) NOT NULL default "", UNIQUE KEY `id` (`id`)) TYPE=MyISAM ;
CREATE TABLE `personal` ( `id` int(11) unsigned NOT NULL auto_increment, `pw_id` int(5) NOT NULL default "0", `truename` varchar(10) NOT NULL default "", `fax` varchar(20) NOT NULL default "", `telephone` varchar(15) NOT NULL default "", `sex` int(1) NOT NULL default "0", `year` int(4) NOT NULL default "0", `MONTH` int(2) NOT NULL default "0", `DAY` int(2) NOT NULL default "0", `education` varchar(4) NOT NULL default "", `marital` int(1) NOT NULL default "0", `occupation` varchar(15) NOT NULL default "", `companyname` varchar(30) NOT NULL default "", `province` varchar(6) NOT NULL default "", PRIMARY KEY (`id`)) TYPE=MyISAM PACK_KEYS=1 ;
CREATE TABLE `scheduler` ( `id` int(11) unsigned NOT NULL auto_increment, `begin_time` int(11) unsigned default NULL, `end_time` int(11) unsigned default NULL, `title` varchar(255) NOT NULL default "", `body` varchar(255) NOT NULL default "", `pw_id` int(11) unsigned NOT NULL default "0", PRIMARY KEY (`id`)) TYPE=MyISAM ;
CREATE TABLE `stow` ( `id` int(5) unsigned NOT NULL auto_increment, `pw_id` int(5) unsigned NOT NULL default "0", `Name` varchar(128) NOT NULL default "", `http` varchar(255) NOT NULL default "http://", `memo` varchar(255) NOT NULL default "", PRIMARY KEY (`id`)) TYPE=MyISAM ;
CREATE TABLE `vpopmail` ( `pw_id` int(5) unsigned NOT NULL auto_increment, `pw_name` varchar(32) NOT NULL default "", `pw_domain` varchar(64) NOT NULL default "", `pw_passwd` varchar(40) NOT NULL default "", `pw_uid` int(11) default NULL, `pw_gid` int(11) default NULL, `pw_gecos` varchar(48) default NULL, `pw_dir` varchar(255) default NULL, `pw_shell` varchar(20) default NULL, `createtime` timestamp(14) NOT NULL, PRIMARY KEY (`pw_id`), KEY `pw_name` (`pw_name`,`pw_domain`)) TYPE=MyISAM PACK_KEYS=1 ;
ee /usr/local/php4/lib/php.ini
max_execution_time=60
memory_limit=20M
post_max_filesize=10M
file_uploads=on
upload_max_filesize=10M
register_globals=On
session.bug_compat_42=0
session.bug_compat_warn=0
Sendmail = /var/qmail/bin/qmail-inject

#cd /usr/ports/mail/sqwebmail
#make WITH_VCHKPW=YES WITH_ISPELL=YES install
根据提示：
#make configure
#make clean
#ee /etc/crontab
增加以下：
40 * * * * root /usr/local/share/sqwebmail/cleancache.pl
#cd /usr/local/share/sqwebmail/
#cp authdaemonrc.dist authdaemonrc
#/usr/local/libexec/sqwebmail/authlib/authdaemon start

指令版 qmail的安装for FreeBSD( 二 )

推荐阅读

腊肉切开后怎么保存?

手机wps有单倍行距吗

带底的淋浴房好不好

海带和鸡蛋可以一起食用吗

一两岁的孩子可以看什么样的书？

海马分公母吗

金额+流程+报销范围宜兴居民医保政策

旋风加速器怎么用旋风加速器用法

田文镜是清官吗

违章停车扣分吗违章停车如何处罚

神仙居景区多少1票，神仙居免费旅游日是那一天

乌木怎么鉴别

学生笔记本电脑排行榜学生笔记本电脑排行

碳酸氢铵使用时应该注意什么

手机开热点怎么连wifi 手机热点怎么开通连接

四大佛教名山分别是什么