postfix邮件系统0511

anstan

as4+postfix+cyrus-sasl+mysql+postfixadmin+courier-imap+courier-maildrop+squirrelmail+clamav+spamassassin+amavisd-new

转载请注明出处
最后更新日期：2005年11月5日
2004年10左右成稿

我以前那篇文章中密码加密有问题（密码一加密，smtp认证就通不过），所以利用这个周末更新一下。这次sasl密码验证机制改为authdaemond（感谢网友606），并把测试部分单独列出来。很多人问起我的安装环境，我安装linux的时候，只选了开发工具，其他的都没选，还有，这些软件包安装的时候都没有依赖性问题，有的话，我也提出来了。

1.安装 mysql 5.0.15
# wget http://dev.mysql.com/get/Downloa ... ://mysql.new21.com/
# tar zxvf mysql-5.0.15.tar.gz
# cd cd mysql-5.0.15
# groupadd mysql
# useradd -g mysql mysql
# CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=/usr/local/mysql \
--enable-assembler --with-mysqld-ldflags=-all-static --with-charset=gbk
# make
# make install
# cp support-files/my-medium.cnf /etc/my.cnf

设置自启动
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld

安装完以后要初始化数据库
# cd /usr/local/mysql
# /usr/local/mysql/bin/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql var
# chgrp -R mysql .

好了，至此mysql安装完毕，你可以这样起动你的mysql服务
# service mysqld start

为了能让系统找到mysql，请运行如下命令
# PATH=$PATH:/usr/local/mysql/bin
# export PATH
# echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
# ldconfig

2.安装 apache 2.0.55
# wget http://apache.freelamp.com/httpd/httpd-2.0.55.tar.bz2
# tar jxvf httpd-2.0.55.tar.bz2
# cd httpd-2.0.55
# ./configure --prefix=/usr/local/apache
# make
# make install

设置自启动
# cp support/apachectl /etc/init.d/httpd

修改/etc/init.d/httpd
# vi /etc/init.d/httpd(前面几行改成如下样子)
#!/bin/sh
#
# Startup script for the Apache Web Server
# chkconfig: - 85 15
# description: Apache is a World Wide Web server. It is used to serve \
# HTML files and CGI.
# processname: httpd
# pidfile: /usr/local/apache/log/httpd.pid
# config: /usr/local/apache/conf/httpd.conf

# chkconfig --add httpd
# chmod 755 /etc/init.d/httpd
# chkconfig httpd on

创建网页根目录
# mkdir /var/www

修改apache配置文件
# vi /usr/local/apache/conf/httpd.conf
//存放网页的目录,原来为DocumentRoot ""，改成：
DocumentRoot "/var/www"
//这句应该和DocumentRoot 的目录保持一致，原来为<Directory "">，改成：
<Directory "/var/www">
//Indexes：当在目录中找不到DirectoryIndex列表中指定的文件就生成当前目录的文件列表
//FollowSymlinks：允许符号链接跟随，访问不在本目录下的文件
Options Indexes FollowSymLinks
//禁止读取.htaccess配置文件的内容
AllowOverride None
//指定先执行Allow（允许）访问规则，再执行Deny（拒绝）访问规则
Order allow,deny
//设置Allow（允许）访问规则，允许所有连接
Allow from all
</Directory>

启动服务
# service httpd start

3.安装php 4.4.1
# wget http://cn.php.net/get/php-4.4.1.tar.bz2/from/this/mirror
# tar jxvf php-4.4.1.tar.bz2
# cd php-4.4.1
# ./configure \
--prefix=/usr/local/php \
--with-mysql=/usr/local/mysql \
--with-apxs2=/usr/local/apache/bin/apxs
# make
# make install
# cp php.ini-dist /usr/local/php/lib/php.ini

# vi /usr/local/php/lib/php.ini
;default_charset = "iso-8859-1"
在这行下面加一行
default_charset = "gbk"

# vi /usr/local/apache/conf/httpd.conf
找到#AddType application/x-tar .tgz 这行，在下面加两行
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
找到下面一行在后面加上index.php，这表示网站的默认页也能够为index.php
DirectoryIndex index.html index.html.var index.php
注意：改变了http.conf后，要重启apache服务

4.安装 cyrus-sasl 2.1.21
先关闭as4默认安装的sasl
# mv /usr/lib/sasl /usr/lib/sasl.OFF
# mv /usr/lib/sasl2 /usr/lib/sasl2.OFF

编译安装cyrus-sasl2.1.21
# wget http://ftp.andrew.cmu.edu/pub/cyrus-mail/cyrus-sasl-2.1.21.tar.gz
# tar zxvf cyrus-sasl-2.1.21.tar.gz
# cd cyrus-sasl-2.1.21
# ./configure \
--disable-anon -enable-plain --enable-login \
--enable-sql --with-mysql=/usr/local/mysql \
--with-mysql-includes=/usr/local/mysql/include/mysql \
--with-mysql-libs=/usr/local/mysql/lib/mysql \
--with-authdaemond
# make
# make install

更新lib库
# echo "/usr/local/lib" >> /etc/ld.so.conf
# ldconfig

重要
# ln -s /usr/local/lib/sasl2 /usr/lib/sasl2

yjf417

40楼 发表于 2006-12-12 15:59   
gcc -Wmissing-prototypes -Wformat -DHAS_MYSQL -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH -I/usr/local/include/sasl -g -O -I. -I../../include -DLINUX2 -c dict_mysql.c
dict_mysql.c:173:19: mysql.h: No such file or directory
dict_mysql.c:198: error: syntax error before "MYSQL"
dict_mysql.c:198: warning: no semicolon at end of struct or union
dict_mysql.c:206: error: syntax error before '}' token
dict_mysql.c:206: warning: data definition has no type or storage class
dict_mysql.c:210: error: syntax error before "HOST"
dict_mysql.c:210: warning: no semicolon at end of struct or union
dict_mysql.c:212: warning: data definition has no type or storage class
dict_mysql.c:226: error: syntax error before "PLMYSQL"
dict_mysql.c:226: warning: no semicolon at end of struct or union
dict_mysql.c:227: warning: data definition has no type or storage class
dict_mysql.c:241: error: syntax error before '*' token
dict_mysql.c:241: warning: data definition has no type or storage class
dict_mysql.c:242: error: syntax error before '*' token
dict_mysql.c:242: error: syntax error before '*' token
dict_mysql.c:242: warning: data definition has no type or storage class
dict_mysql.c:243: error: syntax error before '*' token
dict_mysql.c:244: error: syntax error before '*' token
dict_mysql.c:245: error: syntax error before '*' token
dict_mysql.c:246: error: syntax error before '*' token
dict_mysql.c:250: error: syntax error before '*' token
dict_mysql.c:251: error: syntax error before '*' token
dict_mysql.c:251: warning: data definition has no type or storage class
dict_mysql.c: In function `dict_mysql_quote':
dict_mysql.c:257: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:257: error: (Each undeclared identifier is reported only once
dict_mysql.c:257: error: for each function it appears in.)
dict_mysql.c:257: error: syntax error before ')' token
dict_mysql.c: In function `dict_mysql_lookup':
dict_mysql.c:287: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:287: error: syntax error before ')' token
dict_mysql.c:288: error: `pldb' undeclared (first use in this function)
dict_mysql.c:289: error: `MYSQL_RES' undeclared (first use in this function)
dict_mysql.c:289: error: `query_res' undeclared (first use in this function)
dict_mysql.c:290: error: `MYSQL_ROW' undeclared (first use in this function)
dict_mysql.c:290: error: syntax error before "row"
dict_mysql.c:348: error: `row' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:368: error: syntax error before '*' token
dict_mysql.c: In function `dict_mysql_check_stat':
dict_mysql.c:371: error: `host' undeclared (first use in this function)
dict_mysql.c:373: error: `t' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:382: error: syntax error before '*' token
dict_mysql.c:382: error: syntax error before '*' token
dict_mysql.c:383: warning: no previous prototype for 'dict_mysql_find_host'
dict_mysql.c: In function `dict_mysql_find_host':
dict_mysql.c:390: error: `PLDB' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:414: error: syntax error before '*' token
dict_mysql.c:414: error: syntax error before '*' token
dict_mysql.c:416: warning: no previous prototype for 'dict_mysql_get_active'
dict_mysql.c: In function `dict_mysql_get_active':
dict_mysql.c:418: error: `host' undeclared (first use in this function)
dict_mysql.c:422: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:443: error: `dbname' undeclared (first use in this function)
dict_mysql.c:443: error: `username' undeclared (first use in this function)
dict_mysql.c:443: error: `password' undeclared (first use in this function)
dict_mysql.c: In function `dict_mysql_event':
dict_mysql.c:456: error: `host' undeclared (first use in this function)
dict_mysql.c:456: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:469: error: syntax error before '*' token
dict_mysql.c:469: error: syntax error before '*' token
dict_mysql.c:474: warning: no previous prototype for 'plmysql_query'
dict_mysql.c: In function `plmysql_query':
dict_mysql.c:475: error: `host' undeclared (first use in this function)
dict_mysql.c:476: error: `MYSQL_RES' undeclared (first use in this function)
dict_mysql.c:476: error: `res' undeclared (first use in this function)
dict_mysql.c:478: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:478: error: `dbname' undeclared (first use in this function)
dict_mysql.c:478: error: `username' undeclared (first use in this function)
dict_mysql.c:478: error: `password' undeclared (first use in this function)
dict_mysql.c:479: error: `query' undeclared (first use in this function)
dict_mysql.c:481: warning: format argument is not a pointer (arg 2)
dict_mysql.c:490: warning: format argument is not a pointer (arg 2)
dict_mysql.c: At top level:
dict_mysql.c:503: error: syntax error before '*' token
dict_mysql.c:504: warning: 'plmysql_connect_single' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_connect_single':
dict_mysql.c:505: error: `host' undeclared (first use in this function)
dict_mysql.c:509: error: `username' undeclared (first use in this function)
dict_mysql.c:510: error: `password' undeclared (first use in this function)
dict_mysql.c:511: error: `dbname' undeclared (first use in this function)
dict_mysql.c:521: warning: format argument is not a pointer (arg 3)
dict_mysql.c: At top level:
dict_mysql.c:527: error: syntax error before '*' token
dict_mysql.c:528: warning: 'plmysql_close_host' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_close_host':
dict_mysql.c:529: error: `host' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:538: error: syntax error before '*' token
dict_mysql.c:539: warning: 'plmysql_down_host' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_down_host':
dict_mysql.c:540: error: `host' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:549: error: syntax error before '*' token
dict_mysql.c: In function `mysql_parse_config':
dict_mysql.c:558: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:558: error: `mysqlcf' undeclared (first use in this function)
dict_mysql.c: In function `dict_mysql_open':
dict_mysql.c:620: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:629: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:645: error: syntax error before '*' token
dict_mysql.c: In function `plmysql_init':
dict_mysql.c:647: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:650: error: syntax error before ')' token
dict_mysql.c:654: error: syntax error before ')' token
dict_mysql.c:654: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:664: error: syntax error before '*' token
dict_mysql.c: In function `host_init':
dict_mysql.c:667: error: `host' undeclared (first use in this function)
dict_mysql.c:667: error: syntax error before ')' token
dict_mysql.c: In function `dict_mysql_close':
dict_mysql.c:711: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:711: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:730: error: syntax error before '*' token
dict_mysql.c:731: warning: 'plmysql_dealloc' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_dealloc':
dict_mysql.c:734: error: `PLDB' undeclared (first use in this function)
make: *** [dict_mysql.o] Error 1
make: *** [update] Error 1
[root@localhost postfix-2.2.5]#


这是为什么啊?系统RHEL4 -U1
数据库5.0.27

=================================================================================
gcc -Wmissing-prototypes -Wformat -DHAS_MYSQL -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH -I/usr/local/include/sasl -g -O -I. -I../../include -DLINUX2 -c dict_mysql.c
dict_mysql.c:173:19: mysql.h: No such file or directory

你的mysql.h和你在make的时候定义的位置不一样，所以：mysql.h: No such file or directory

lovegqin

make sasl的时候
digestmd5.c:2095: warning: dereferencing type-punned pointer will break strict-aliasing rule                s
digestmd5.c:2112: warning: dereferencing type-punned pointer will break strict-aliasing rule                s

看一下资料说是GCC的版本问题？

Linux@初学者

gcc -Wmissing-prototypes -Wformat -DHAS_MYSQL -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH -I/usr/local/include/sasl -g -O -I. -I../../include -DLINUX2 -c dict_mysql.c
dict_mysql.c:173:19: mysql.h: No such file or directory
dict_mysql.c:198: error: syntax error before "MYSQL"
dict_mysql.c:198: warning: no semicolon at end of struct or union
dict_mysql.c:206: error: syntax error before '}' token
dict_mysql.c:206: warning: data definition has no type or storage class
dict_mysql.c:210: error: syntax error before "HOST"
dict_mysql.c:210: warning: no semicolon at end of struct or union
dict_mysql.c:212: warning: data definition has no type or storage class
dict_mysql.c:226: error: syntax error before "PLMYSQL"
dict_mysql.c:226: warning: no semicolon at end of struct or union
dict_mysql.c:227: warning: data definition has no type or storage class
dict_mysql.c:241: error: syntax error before '*' token
dict_mysql.c:241: warning: data definition has no type or storage class
dict_mysql.c:242: error: syntax error before '*' token
dict_mysql.c:242: error: syntax error before '*' token
dict_mysql.c:242: warning: data definition has no type or storage class
dict_mysql.c:243: error: syntax error before '*' token
dict_mysql.c:244: error: syntax error before '*' token
dict_mysql.c:245: error: syntax error before '*' token
dict_mysql.c:246: error: syntax error before '*' token
dict_mysql.c:250: error: syntax error before '*' token
dict_mysql.c:251: error: syntax error before '*' token
dict_mysql.c:251: warning: data definition has no type or storage class
dict_mysql.c: In function `dict_mysql_quote':
dict_mysql.c:257: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:257: error: (Each undeclared identifier is reported only once
dict_mysql.c:257: error: for each function it appears in.)
dict_mysql.c:257: error: syntax error before ')' token
dict_mysql.c: In function `dict_mysql_lookup':
dict_mysql.c:287: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:287: error: syntax error before ')' token
dict_mysql.c:288: error: `pldb' undeclared (first use in this function)
dict_mysql.c:289: error: `MYSQL_RES' undeclared (first use in this function)
dict_mysql.c:289: error: `query_res' undeclared (first use in this function)
dict_mysql.c:290: error: `MYSQL_ROW' undeclared (first use in this function)
dict_mysql.c:290: error: syntax error before "row"
dict_mysql.c:348: error: `row' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:368: error: syntax error before '*' token
dict_mysql.c: In function `dict_mysql_check_stat':
dict_mysql.c:371: error: `host' undeclared (first use in this function)
dict_mysql.c:373: error: `t' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:382: error: syntax error before '*' token
dict_mysql.c:382: error: syntax error before '*' token
dict_mysql.c:383: warning: no previous prototype for 'dict_mysql_find_host'
dict_mysql.c: In function `dict_mysql_find_host':
dict_mysql.c:390: error: `PLDB' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:414: error: syntax error before '*' token
dict_mysql.c:414: error: syntax error before '*' token
dict_mysql.c:416: warning: no previous prototype for 'dict_mysql_get_active'
dict_mysql.c: In function `dict_mysql_get_active':
dict_mysql.c:418: error: `host' undeclared (first use in this function)
dict_mysql.c:422: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:443: error: `dbname' undeclared (first use in this function)
dict_mysql.c:443: error: `username' undeclared (first use in this function)
dict_mysql.c:443: error: `password' undeclared (first use in this function)
dict_mysql.c: In function `dict_mysql_event':
dict_mysql.c:456: error: `host' undeclared (first use in this function)
dict_mysql.c:456: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:469: error: syntax error before '*' token
dict_mysql.c:469: error: syntax error before '*' token
dict_mysql.c:474: warning: no previous prototype for 'plmysql_query'
dict_mysql.c: In function `plmysql_query':
dict_mysql.c:475: error: `host' undeclared (first use in this function)
dict_mysql.c:476: error: `MYSQL_RES' undeclared (first use in this function)
dict_mysql.c:476: error: `res' undeclared (first use in this function)
dict_mysql.c:478: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:478: error: `dbname' undeclared (first use in this function)
dict_mysql.c:478: error: `username' undeclared (first use in this function)
dict_mysql.c:478: error: `password' undeclared (first use in this function)
dict_mysql.c:479: error: `query' undeclared (first use in this function)
dict_mysql.c:481: warning: format argument is not a pointer (arg 2)
dict_mysql.c:490: warning: format argument is not a pointer (arg 2)
dict_mysql.c: At top level:
dict_mysql.c:503: error: syntax error before '*' token
dict_mysql.c:504: warning: 'plmysql_connect_single' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_connect_single':
dict_mysql.c:505: error: `host' undeclared (first use in this function)
dict_mysql.c:509: error: `username' undeclared (first use in this function)
dict_mysql.c:510: error: `password' undeclared (first use in this function)
dict_mysql.c:511: error: `dbname' undeclared (first use in this function)
dict_mysql.c:521: warning: format argument is not a pointer (arg 3)
dict_mysql.c: At top level:
dict_mysql.c:527: error: syntax error before '*' token
dict_mysql.c:528: warning: 'plmysql_close_host' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_close_host':
dict_mysql.c:529: error: `host' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:538: error: syntax error before '*' token
dict_mysql.c:539: warning: 'plmysql_down_host' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_down_host':
dict_mysql.c:540: error: `host' undeclared (first use in this function)
dict_mysql.c: At top level:
dict_mysql.c:549: error: syntax error before '*' token
dict_mysql.c: In function `mysql_parse_config':
dict_mysql.c:558: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:558: error: `mysqlcf' undeclared (first use in this function)
dict_mysql.c: In function `dict_mysql_open':
dict_mysql.c:620: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:629: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:645: error: syntax error before '*' token
dict_mysql.c: In function `plmysql_init':
dict_mysql.c:647: error: `PLDB' undeclared (first use in this function)
dict_mysql.c:650: error: syntax error before ')' token
dict_mysql.c:654: error: syntax error before ')' token
dict_mysql.c:654: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:664: error: syntax error before '*' token
dict_mysql.c: In function `host_init':
dict_mysql.c:667: error: `host' undeclared (first use in this function)
dict_mysql.c:667: error: syntax error before ')' token
dict_mysql.c: In function `dict_mysql_close':
dict_mysql.c:711: error: `dict_mysql' undeclared (first use in this function)
dict_mysql.c:711: error: syntax error before ')' token
dict_mysql.c: At top level:
dict_mysql.c:730: error: syntax error before '*' token
dict_mysql.c:731: warning: 'plmysql_dealloc' was used with no prototype before its definition
dict_mysql.c: In function `plmysql_dealloc':
dict_mysql.c:734: error: `PLDB' undeclared (first use in this function)
make: *** [dict_mysql.o] Error 1
make: *** [update] Error 1
[root@localhost postfix-2.2.5]#


这是为什么啊?系统RHEL4 -U1
数据库5.0.27

wming_dl

按照这个配置，邮箱和附件的大小各是多少？如果需要更改是否仅改这两项值就可以了？
message_size_limit =
virtual_mailbox_limit =
或者还需要做其他的改动？

xiaodixiaodi

真晕!只能手工建目录了,结果可以了!虽然没人回答!多找些资料还是能解决的!现在开始装11.webmail了,希望成功!

xiaodixiaodi

问题解决了!是authmysql文件里改一下就行了!
又出新问题了!
chdir test.com/test/: No such file or directory
Jun 16 10:41:42 localhost authdaemond: received userid lookup request: test@test
.com
这个应该大家能帮我解决了!

xiaodixiaodi

原因找到了!maillog日志
authdaemond: SQL query: SELECT username, crypt, "", '1
001', '1001', '/var/mailbox/', maildir, concat(quota,'S'), name, "" FROM mailbox
WHERE username = "test@test.com" AND (active='1')
Jun 16 09:35:27 localhost authdaemond: mysql_query failed, reconnecting: Unknown
column 'crypt' in 'field list'
Jun 16 09:35:27 localhost authdaemond: mysql_query failed second time, giving up
: Unknown column 'crypt' in 'field list'

请问!在哪里改这条SQL语句,我找不到这个语句,把crypt改成password!谢谢大家了!

xiaodixiaodi

[root@localhost etc]# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
220 www.test.com ESMTP "Version not Available"
ehlo www.test.com
250-www.test.com
250-PIPELINING
250-SIZE 14336000
250-VRFY
250-ETRN
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN PLAIN
250 8BITMIME
auth login
334 VXNlcm5hbWU6
dGVzdEB0ZXN0LmNvbQ==
334 UGFzc3dvcmQ6
dGVzdA==
535 Error: authentication failed

Jun 15 13:20:56 localhost postfix/smtpd[3572]: connect from localhost.localdomai
n[127.0.0.1]
Jun 15 13:22:28 localhost postfix/smtpd[3572]: warning: SASL authentication fail
ure: could not verify password
Jun 15 13:22:28 localhost postfix/smtpd[3572]: warning: localhost.localdomain[12
7.0.0.1]: SASL login authentication failed

请求帮助!谢谢!

guopengxiang998

晕,怎么弄出这么多表情来.