itu tergantung seting smtpd.conf yg ada di sasl anda. jika query anda
ke password yg terenkripsi maka setting nya juga terenkripsi. kalo mau sih add field baru di table mailbox, isi nya clear password. set query di smtpd.conf ke clear password. moga membantu


sizzle wrote:
Assalaamu'alaikum,

aku lagi coba Virtual Users and Domains with Courier-IMAP and MySQL,

main.cf :
---
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql_virtual_quota_maps.cf
virtual_mailbox_base = /home/virtual
virtual_transport = virtual
virtual_uid_maps = static:502
virtual_gid_maps = static:503

# Additional for SMTP AUTH Support
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_security_options = noanonymous
smtpd_recipient_restrictions = permit_sasl_authenticated , reject,
check_relay_domains
#smtpd_sender_login_maps = hash:/etc/postfix/login_maps
#smtpd_sender_restrictions = reject_sender_login_mismatch
---

# tail -f /var/log/maillog
Apr 17 20:45:36 localhost postfix/smtpd[25019]: connect from
localhost.localdomain[127.0.0.1]
Apr 17 20:45:41 localhost postfix/smtpd[25019]: 11057259F4:
client=localhost.localdomain[127.0.0.1], sasl_method=PLAIN,
[EMAIL PROTECTED]
Apr 17 20:45:41 localhost postfix/cleanup[25042]: 11057259F4:
message-id=<[EMAIL PROTECTED]>
Apr 17 20:45:41 localhost postfix/qmgr[24790]: 11057259F4:
from=<[EMAIL PROTECTED]>, size=582, nrcpt=1 (queue active)
Apr 17 20:45:41 localhost postfix/smtpd[25019]: disconnect from
localhost.localdomain[127.0.0.1]
Apr 17 20:45:42 localhost postfix/virtual[25047]: 11057259F4:
to=<[EMAIL PROTECTED]>, relay=virtual, delay=2, status=sent (delivered
to maildir)
Apr 17 20:45:42 localhost postfix/qmgr[24790]: 11057259F4: removed


cuman yang menjadi permasalahannya ialah authentificationnya harus
menggunakan "Encrypted Passwords"

mysql> select password from mailbox;
+------------------------------------+
| password                           |
+------------------------------------+
| $1$a3bdf0e7$Ahn7HkS5D5lGkezpuOFbm1 |
| $1$fe8923ed$63oGgiXtjjNFNbVYQ//mP/ |
+------------------------------------+
2 rows in set (0.00 sec)

apakah emang seharusnya begitu?
aku ga kebayang bagaimana user dapat mengingat passwordnya.

yang kedua bagaimana agar sasl_username cukup berformat "user" saja tidak
seperti : sasl_method=PLAIN, [EMAIL PROTECTED]
mungkin kalo di qmail kita bisa tambahkan nama domainnya di
~vpopmail/etc/defaultdomain.


Regards,
---
Anton


__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam http://id.mail.yahoo.com
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis

Kirim email ke