Salam kenal semua,
 sy anggota baru di milis ini.

 Sy coba authmysql tapi belum bisa-bisa nih, semoga ada yang bisa membantu.

 Ketika mencoba telnet localhost 110

 [EMAIL PROTECTED]:/etc/courier # telnet localhost 110
 Trying 127.0.0.1...
 Connected to localhost.localdomain.
 Escape character is '^]'.
 +OK Hello there.
 user [EMAIL PROTECTED]
 +OK Password required.
 pass akupass
 -ERR Login failed.
 Connection closed by foreign host.

 pesan di /var/log/mail.log adalah sebagai berikut :

 May  9 14:53:56 bntmail courierpop3login: Connection, ip=[::ffff:127.0.0.1]
 May  9 14:54:06 bntmail courierpop3login: LOGIN: DEBUG:
ip=[::ffff:127.0.0.1], command=USER
 May  9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[::ffff:127.0.0.1], command=PASS
 May  9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[::ffff:127.0.0.1], username= [EMAIL PROTECTED]
 May  9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[::ffff:127.0.0.1], password=akupass
 May  9 14:54:11 bntmail courierpop3login: authdaemon: starting client module
 May  9 14:54:11 bntmail authdaemond.mysql: failed to connect to
mysql server (server=localhost, userid=postfix)
 May  9 14:54:12 bntmail courierpop3login: authdaemon: TEMPFAIL - no
more modules will be tried
 May  9 14:54:17 bntmail courierpop3login: LOGIN FAILED, ip=[::ffff:127.0.0.1]

 Di my.cnf sudah di skip-networking
 Sy coba dengan:

 [EMAIL PROTECTED]:~ # mysql -u postfix -ppostfixp4ss -h127.0.0.1
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 310 to server version:
4.0.23_Debian-3ubuntu2.2-log

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

 mysql>

 -> berfungsi
 artinya connection degan tcp/ip ke mysql bisa (CMIIW)

 Berikut ini authdaemonrc

 ##VERSION: $Id: authdaemonrc.in,v 1.8 2001/10/07 02:16:22 mrsam Exp $
 ##NAME: authmodulelist:0
 # authmodulelist="authpam"
 authmodulelist="authmysql"

 ##NAME: authmodulelistorig:1

 authmodulelistorig="authcustom authcram authuserdb authldap
authpgsql authmysql authpam"

 ##NAME: daemons:0

 daemons=5

 ##NAME: version:0

 ##NAME: authdaemonvar:0
 #
 authdaemonvar=/var/run/courier
/authdaemon

Dan berikut adalah authmysqlrc :

##VERSION: $Id: authmysqlrc,v 1.17 2004/04/20 01:38:17 mrsam Exp $
##NAME: LOCATION:0
# The server name, userid, and password used to log in.
MYSQL_SERVER    localhost
MYSQL_USERNAME  postfix
MYSQL_PASSWORD  postfixp4ss

##NAME: MYSQL_SOCKET:0
MYSQL_SOCKET    '/var/run/mysqld/mysqld.sock'

##NAME: MYSQL_PORT:0
# MYSQL_PORT    3306
MYSQL_OPT       0

##NAME: MYSQL_DATABASE:0
MYSQL_DATABASE          postfix
MYSQL_USER_TABLE        mailbox
MYSQL_CRYPT_PWFIELD     password
# MYSQL_CLEAR_PWFIELD   password

##NAME: MYSQL_UID_FIELD:0
# UID dari user postfix
MYSQL_UID_FIELD         '100'

##NAME: MYSQL_GID_FIELD:0
# GID dari user postfix
MYSQL_GID_FIELD         '103'

##NAME: MYSQL_LOGIN_FIELD:0
MYSQL_LOGIN_FIELD       username
MYSQL_HOME_FIELD        '/var/spool/vmail'
MYSQL_NAME_FIELD        name

##NAME: MYSQL_MAILDIR_FIELD:0
# MYSQL_MAILDIR_FIELD   maildir
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/')

##NAME: MYSQL_QUOTA_FIELD:0
MYSQL_QUOTA_FIELD       quota

##NAME: MYSQL_AUXOPTIONS:0
# MYSQL_AUXOPTIONS_FIELD        auxoptions
# MYSQL_AUXOPTIONS_FIELD CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail,",sharedgroup=",sharedgroup)
#

##NAME: MYSQL_WHERE_CLAUSE:0
# MYSQL_WHERE_CLAUSE    server='mailhost.example.com'

FYI : postfix-mysql nya sudah berjalan, semua telnet ke 25 sudah bisa
tersimpan di maildir
/var/spool/vmail/[EMAIL PROTECTED]/new

Kira-kira dimana ya salah ku ... thx

=mufti=

Reply via email to