vpopmail數(shù)據(jù)庫(kù)與郵件分開(kāi)很急的問(wèn)題

swh01

老板讓我把現(xiàn)有的qmail系統(tǒng)進(jìn)行數(shù)據(jù)庫(kù)郵件進(jìn)行分開(kāi)，原來(lái)是apache+php+mysql+vpopmail+qmail在一臺(tái)服務(wù)器上安裝，現(xiàn)在老板讓我把數(shù)據(jù)庫(kù)單獨(dú)用一臺(tái)機(jī)器，其他放在一臺(tái)機(jī)器上。我把vpopmail.mysql的格式改為：192.168.1.6|0|vpopmail|passwd|vpopmail，可是老是報(bào)錯(cuò)，192.168.1.6的數(shù)據(jù)庫(kù)賬戶如果不對(duì)報(bào)如下錯(cuò)誤：
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: sql error[2]: MySQL server has gone away
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection

我把賬戶設(shè)置正確出現(xiàn)
vmysql: sql error[2]: Access denied; you need the SUPER privilege for this operation
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection

我把vpopmail的權(quán)限改到最高也是報(bào)上面得錯(cuò)誤。請(qǐng)各位兄弟幫忙呀

我改怎么做呀

zlj2208

應(yīng)該是qmail服務(wù)器不能訪問(wèn)mysql數(shù)據(jù)。

在qmail服務(wù)器上的shell下執(zhí)行下面命令，看能否到mysql的命令行：
mysql -h192.168.1.6 -uvpopmail -ppasswd

如果不能進(jìn)入到mysql的命令行在mysql命令行上執(zhí)行：
GRANT ALL PRIVILEGES ON vpopmail.* TO 'vpopmail'@'Your Qmail IP' IDENTIFIED BY 'passwd';

flush privileges;

原帖由 swh01 于 2009-5-19 01:48 發(fā)表
老板讓我把現(xiàn)有的qmail系統(tǒng)進(jìn)行數(shù)據(jù)庫(kù)郵件進(jìn)行分開(kāi)，原來(lái)是apache+php+mysql+vpopmail+qmail在一臺(tái)服務(wù)器上安裝，現(xiàn)在老板讓我把數(shù)據(jù)庫(kù)單獨(dú)用一臺(tái)機(jī)器，其他放在一臺(tái)機(jī)器上。我把vpopmail.mysql的格式改為：192 ...

swh01

在qmail服務(wù)器上的shell下執(zhí)行下面命令，看能否到mysql的命令行：
mysql -h192.168.1.6 -uvpopmail -ppasswd


是可以執(zhí)行命令的

zlj2208

把結(jié)果貼出來(lái)看看

swh01

vmysql: sql error[2]: Access denied; you need the SUPER privilege for this operation
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection

zlj2208

從錯(cuò)誤上看就是mysql的權(quán)限問(wèn)題，用mysql的root用戶進(jìn)入到mysql的命令行提示符下；執(zhí)行下面命令：

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 63980
Server version: 5.0.67-community-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON vpopmail.* TO 'vpopmail'@'Your Qmail IP' IDENTIFIED BY 'passwd';
Query OK, 0 rows affected (0.16 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)

mysql> quit

藍(lán)色的為你輸入的，注意把IP地址換成你的IP

然后觀察一下看看還有沒(méi)有錯(cuò)誤出現(xiàn)。

[ 本帖最后由 zlj2208 于 2009-5-19 09:35 編輯 ]

ruochen

原帖由 swh01 于 2009-5-19 09:19 發(fā)表
vmysql: sql error[2]: Access denied; you need the SUPER privilege for this operationFailed while attempting to add user to auth backend
Error: (vadduser) no auth connection

應(yīng)該是訪問(wèn)mysql的權(quán)限問(wèn)題

swh01

已經(jīng)搞定但是qmail又出現(xiàn)問(wèn)題，上面報(bào)錯(cuò)我根據(jù)幾位哥們的提示進(jìn)行重新授權(quán)，然后重啟MYSQL就好了

現(xiàn)在出現(xiàn)以下問(wèn)題：
@400000004a124c7936ad006c tcpserver: status: 1/20
@400000004a124c7936b01d4c tcpserver: pid 4065 from 192.168.1.182
@400000004a124c7936b0d8cc tcpserver: ok 4065 0:192.168.1.9:25 :192.168.1.182::1687
@400000004a124c793759d29c /home/vpopmail/bin/vchkpw: error while loading shared libraries: libcrypt.so.1: failed to map segment from shared object: Cannot allocate memory
@400000004a124c7e3768c6bc tcpserver: end 4065 status 256
@400000004a124c7e3768caa4 tcpserver: status: 0/20
@400000004a124f74209f287c tcpserver: status: 1/20
@400000004a124f7420a1eb84 tcpserver: pid 4093 from 192.168.1.182
@400000004a124f7420a2be74 tcpserver: ok 4093 0:192.168.1.9:25 :192.168.1.182::1706
@400000004a124f74236de0ac /home/vpopmail/bin/vchkpw: error while loading shared libraries: libcrypt.so.1: failed to map segment from shared object: Cannot allocate memory
@400000004a124f79237b753c tcpserver: end 4093 status 256
@400000004a124f79237b7924 tcpserver: status: 0/20


不能發(fā)送郵件，smtp好像不工作

zlj2208

原帖由 swh01 于 2009-5-19 15:11 發(fā)表
已經(jīng)搞定但是qmail又出現(xiàn)問(wèn)題，上面報(bào)錯(cuò)我根據(jù)幾位哥們的提示進(jìn)行重新授權(quán)，然后重啟MYSQL就好了

@400000004a124c793759d29c /home/vpopmail/bin/vchkpw: error while loading shared libraries: libcrypt.so.1: failed to map segment from shared object: Cannot allocate memory

從這個(gè)錯(cuò)誤看因該是smtp 啟動(dòng)腳本內(nèi)存分配的太小了，將softlimit后面的參數(shù)改大一些，比如改成8M試試。
腳本一般在/var/qmail/supervise/目錄下，的一個(gè)子目錄，看你怎么配置了。
我的服務(wù)器是腳本是/var/qmail/supervise/smtp/run

exec /usr/bin/softlimit -m 8000000