iRedMail 技术交流 QQ 群：296792359。

2010-07-05 02:07:18

情况是这样的：在同一个局域网内有多部服务器，各服务器以内部网络名称命名（没有外部的DNS），各服务器的logwatch会定时将报告发出邮件给管理员，此时发件人就如：logwatch@fileserver.abc.com，而由于domainname非外网dns，被iRedMail拒收，log如下：
Jul 5 01:40:24 mail postfix/smtpd[3749]: NOQUEUE: reject: RCPT from unknown[192.168.0.1]: 450 4.1.8 logwatch@fileserver.abc.com>: Sender address rejected: Domain not found; from=<logwatch@fileserver.abc.com> to=<admin@abc.com> proto=ESMTP helo=<fileserver.abc.com>
因此，欲将logwatch@fileserver.abc.com以及fileserver.abc.com加入whitelist，SQL中policyd表的whitelist_sender及whitelist_dnsname中，但是情况依旧，似乎白名单未起作用，有何解决良策？

2010-06-26 04:02:59

服务器: localhost - 数据库: roundcubemail

* 结构
* SQL
* 搜索
* 查询
* 导出
* Import
* 操作
* 权限
* 删除

表操作记录数Tip 类型整理大小多余
cache 浏览结构搜索插入清空删除 214 InnoDB utf8_general_ci 128.0 KB -
contacts 浏览结构搜索插入清空删除 1 InnoDB utf8_general_ci 32.0 KB -
identities 浏览结构搜索插入清空删除 22 InnoDB utf8_general_ci 32.0 KB -
messages 浏览结构搜索插入清空删除 316 InnoDB utf8_general_ci 1.5 MB -
session 浏览结构搜索插入清空删除 6 InnoDB utf8_general_ci 32.0 KB -
users 浏览结构搜索插入清空删除 22 InnoDB utf8_general_ci 48.0 KB -
6 个表总计 581 MyISAM utf8_general_ci 1.8 MB 0 字节
选中项：全选 / 全部不选

查了，现有6个表如上，有没有遗漏的？

2010-06-26 03:48:47

Thank you! 问题解决！

2010-06-25 17:55:43

ssl_error_log:

[Fri Jun 25 16:23:21 2010] [error] [client 192.168.0.160] File does not exist: /var/www/html/favicon.ico
[Fri Jun 25 16:23:24 2010] [error] [client 192.168.0.160] File does not exist: /var/www/html/favicon.ico
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] Traceback (most recent call last):, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/application.py", line 241, in process, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return self.handle(), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/application.py", line 232, in handle, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return self._delegate(fn, self.fvars, args), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/application.py", line 411, in _delegate, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return handle_class(cls), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/application.py", line 386, in handle_class, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return tocall(*args), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/var/www/iredadmin/controllers/base.py", line 44, in proxyfunc, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return func(self, *args, **kw), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/var/www/iredadmin/controllers/panel/log.py", line 42, in GET, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] cur_page=self.cur_page,, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/var/www/iredadmin/controllers/base.py", line 44, in proxyfunc, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] return func(self, *args, **kw), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/var/www/iredadmin/libs/panel/log.py", line 59, in listLogs, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] self.count = db.query("""SELECT COUNT(*) as total FROM log """ + sql_raw), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/db.py", line 592, in query, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] self._db_execute(db_cursor, sql_query), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/web/db.py", line 543, in _db_execute, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] out = cur.execute(sql_query.query(paramstyle), sql_query.values()), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] self.errorhandler(self, exc, value), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] raise errorclass, errorvalue, referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] ProgrammingError: (1146, "Table 'iredadmin.log' doesn't exist"), referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
[Fri Jun 25 16:23:43 2010] [error] [client 192.168.0.160] , referer: https://192.168.0.21/iredadmin/dashboard?checknew=yes
(END)

不知少了什么呢？

2010-06-24 22:56:36

装好iRedAdmin-Pro-1.2.0后，进入管理系统点击“系统”菜单，显示“internal server error”，不知是何原因。

2010-06-24 10:48:56

但是自从执行mysql> SOURCE /var/www/roundcubemail/SQL/mysql.update.sql;这条指令起，没有一次执行时是没有出错信息的，会有什么影响呢？

2010-06-23 16:14:25

main.inc.php设置未完整，设好后Webmail已能正常进入，但是升级错误依旧如下：
mysql> SOURCE /var/www/roundcubemail/SQL/mysql.update.sql;
Query OK, 1 row affected (0.15 sec)

ERROR 1091 (42000): Can't DROP 'idx'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'cache_key'; check that column/key exists
ERROR 1061 (42000): Duplicate key name 'username_index'
Query OK, 18 rows affected (0.01 sec)
Records: 18 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'created_index'
ERROR 1091 (42000): Can't DROP 'session_id'; check that column/key exists
ERROR 1061 (42000): Duplicate key name 'changed_index'
ERROR 1061 (42000): Duplicate key name 'created_index'
Query OK, 18 rows affected (0.03 sec)
Records: 18 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'index_index'
Query OK, 1 row affected (0.00 sec)

Query OK, 30 rows affected (0.01 sec)
Records: 30 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'user_contacts_index'
mysql> quit;
Bye

2010-06-23 09:50:28

邮件收发正常，/var/log/maillog信息正常，只是roundcubemail不正常，改回0.2.1（rm -i roundcubemail,ln -s roundcubemail-0.2.1 roundcubemail）后，还能正常运作，只是升级到0.3.1出错。/var/www/roundcubemail/logs/里没有任何东东。现在进入webmail界面，没有了DATABASE ERROR的警告，但是无法登录，出现connection to IMAP server failed.

2010-06-22 23:37:49

已将原来0.2.1的db.inc.php中：
$rcmail_config['db_dsnw'] = "mysqli://roundcube:mDF3vZGS3jr9SoNs83qxg4r2zuXUpr@localhost/roundcubemail";
的一行，更新到新的db.inc.php了，又重启了，再试，问题依旧，晕啊！顶不住啦！

2010-06-22 22:29:48

并且Webmail出错：
DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

2010-06-22 22:28:03

重启整个系统也一样如此。

2010-06-22 17:11:33

因新的iRedAdmin-Pro-1.2.0 只支持 iRedMail-0.6.0，按说明步骤升级Roundcubemail时，遇到下列错误：
mysql> SOURCE /var/www/roundcubemail/SQL/mysql.update.sql;
Query OK, 1 row affected (0.03 sec)

ERROR 1091 (42000): Can't DROP 'idx'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'cache_key'; check that column/key exists
ERROR 1061 (42000): Duplicate key name 'username_index'
Query OK, 17 rows affected (0.01 sec)
Records: 17 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'created_index'
ERROR 1091 (42000): Can't DROP 'session_id'; check that column/key exists
ERROR 1061 (42000): Duplicate key name 'changed_index'
ERROR 1061 (42000): Duplicate key name 'created_index'
Query OK, 17 rows affected (0.03 sec)
Records: 17 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'index_index'
Query OK, 1 row affected (0.00 sec)

Query OK, 12 rows affected (0.01 sec)
Records: 12 Duplicates: 0 Warnings: 0

ERROR 1061 (42000): Duplicate key name 'user_contacts_index'
mysql> quit;
Bye
[root@mail www]#
其后进入Webmail提示database出错，本菜鸟请教该如何解决，谢谢各位。

2010-05-15 13:16:57

如题，原有系统是postfix,用户是系统用户（用passwd,shadow,/etc/aliases）,邮件用Mdir格式，存于/home/用户名/Maildir/下,配合MailScanner,Spamassassin的黑白名单。
如何不须用户介入，将原系统迁移到iRedMail+ldap后台？主要指如何将用户及其密码和aliases迁移到ldap内，将用户的邮件迁移到新的邮箱，原来的黑白名单如何迁移，迁移到哪？

恳请赐教！

2010-04-13 13:27:33

能否向我们这些菜鸟再详细说明一下迁移的步骤？

iRedMail 技术交流 QQ 群：296792359。

搜索选项

搜索到的文章数 [ 14 ]

1 kingshum发表 2010-07-05 02:07:18

主题: whitelist似乎不起作用 (0 篇回复，发表在 iRedMail 技术支持)

2 kingshum回复 2010-06-26 04:02:59

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

3 kingshum回复 2010-06-26 03:48:47

回复: 在iRedAdmin-Pro-1.2.0中不能进入“系统”菜单 (4 篇回复，发表在 iRedAdmin-Pro 技术支持)

4 kingshum回复 2010-06-25 17:55:43

回复: 在iRedAdmin-Pro-1.2.0中不能进入“系统”菜单 (4 篇回复，发表在 iRedAdmin-Pro 技术支持)

5 kingshum发表 2010-06-24 22:56:36

主题: 在iRedAdmin-Pro-1.2.0中不能进入“系统”菜单 (4 篇回复，发表在 iRedAdmin-Pro 技术支持)

6 kingshum回复 2010-06-24 10:48:56

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

7 kingshum回复 2010-06-23 16:14:25

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

8 kingshum回复 2010-06-23 09:50:28

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

9 kingshum回复 2010-06-22 23:37:49

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

10 kingshum回复 2010-06-22 22:29:48

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

11 kingshum回复 2010-06-22 22:28:03

回复: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

12 kingshum发表 2010-06-22 17:11:33

主题: roundcubemail从0.2.1升级到0.3.1时的问题 (13 篇回复，发表在 iRedMail 技术支持)

13 kingshum发表 2010-05-15 13:16:57

主题: 新手请教如何从原来的邮件系统迁移到iRedMail (0 篇回复，发表在 iRedMail 技术支持)

14 kingshum回复 2010-04-13 13:27:33

回复: 请问如何把sendmail的邮件导入iredmail? (5 篇回复，发表在 iRedMail 技术支持)

搜索到的文章数 [ 14 ]