[postfix-users] Dovecot
Bos... ada yang pernah pake kombinasi postfix+dovecot+mysql gag? klo ada gimana performance nya si dovecot ini? *klo gag ada berarti gw yang pertama ngoprek nih :)* Thanks anwar
[postfix-users] change password lewat squiirelmail
ass wr wb saya udah berhasil install virtual domain di postfix dengan panduan dari tulisan mas asfik (Virtual domain di Postfix dengan tpop3d) dan untuk login default webmail sudah memakai script dari hanny wijaya (thx all) tapi yang jadi pertanyaan ada engg script ganti password (dari script vtadduse, vtadduserimap mas asfik) yang web-base atau bisa di addons kan ke plugin dari squirrelmail kalau ada yang punya boleh dong bagi.. atawa ada teman2 yang bisa kasih linknya thx wasalam zakier __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [postfix-users] Anti spam gateway
Cahyo wrote: Apakah tidak lebih baik di level MX filter pake antivirus dan policyd saja, kemudian di backend baru proses learning spam define per mailbox, karena kategori spam kan spesifik per user artinya kita bilang spam belum tentu orang lain bilang spam juga, dengan resiko resource di backend akan besar tergantung dengan jumlah mailbox karena auto learning akan membaca db setiap menerima email dan mengkategorikan spam/nonspam Waduh, itu dia yang repot justru kalo resource besar di backend :) Kepinginnya sih tetep di level MX aja, soalnya proses cukup untuk filter message sebelum diteruskan ke belakang. Kalo masalah learning, toh sama saja kasusnya di depan atau dibelakang kan? CMIIW Kalo pakai policyd, bisakah fitur greylisting nya dimatikan? -- - Cygnus -
Re: [postfix-users] Courier tidak bisa connect ke MySQL
Setelah dikoreksi, waktu itu kondisi nya : # bind-address = 127.0.0.1 # skip-networking Jalan! tapi apa benar begini ya ? karena kalau bind-address nya dipasang, mysql nya malah error. May 10 18:21:26 bntmail /etc/init.d/mysql[18674]: 0 processes alive and '/usr/bin/mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf ping' resulted in May 10 18:21:26 bntmail /etc/init.d/mysql[18674]: error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 13 May 10 18:21:26 bntmail /etc/init.d/mysql[18674]: Fatal error in defaults handling. Program aborted Sekarang sudah connect, tapi masih permission denied. ternyata ketukar: # GID dari user postfix MYSQL_UID_FIELD '100' seharusnya : # GID dari user virtual MYSQL_UID_FIELD '5000' # GID dari user postfix MYSQL_GID_FIELD '103' seharusnya : # GID dari user virtual MYSQL_GID_FIELD '5000' Alhamdulillah running well sekarang :) tapi masih penasaran yang bind-address ... Demikian, terimakasih atas perhatiannya =mufti= On 5/10/06, Mufti <[EMAIL PROTECTED]> wrote: On 5/10/06, Asmuri Anwar <[EMAIL PROTECTED]> wrote: > Share main.cf-nya di sini, pak ok, Berikut /etc/mysql/my.cnf # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # bind-address = 127.0.0.1 # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice= 0 [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 # Both location gets rotated by the cronjob. #log= /var/log/mysql.log log = /var/log/mysql/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-external-locking # # The skip-networking option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is "disable" - for security reasons. # skip-networking key_buffer = 16M max_allowed_packet = 16M thread_stack= 128K # # Query Cache Configuration # query_cache_limit = 1048576 query_cache_size= 26214400 query_cache_type= 1 # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin= /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # If you want to enable SSL support (recommended) read the manual or my # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M > > - Original Message - > From: "Mufti" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, May 10, 2006 2:58 PM > Subject: [postfix-users] Courier tidak bisa connect ke MySQL > > > 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=[:::127.0.0.1] > May 9 14:54:06 bntmail courierpop3login: LOGIN: DEBUG: > ip=[:::127.0.0.1], command=USER > May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: > ip=[:::127.0.0.1], command=PASS > May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: > ip=[:::127.0.0.1], username= [EMAIL PROTECTED] > May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: > ip=[:::127.0.0.1], password=akupass > May 9 14:54:11
Re: [postfix-users] tanya monitoring sendmail pada postix
Ichwan Nur Hakim wrote: alloo. Linuxer semuanyaaa saya ada kasus nehh... Saya menggunakan mail server postfix. terus bozz saya ingin semua sendmail user bisa dilihat atau di download oleh bozz saya ini (beserta contentnya). Jadi ceritanya bozz saya ini mo memantau setiap user itu mengirim email untuk apa saja. Dulu waktu pakai Micf. Exchange hal ini bisa dilakukan. Nah sekarang kalau pakai postfix bagaimana...??? mohon bantuan rekan-rekan semuanya... Thank's Coba gunain /always_bcc/ atau/ sender_bcc_map/s maupun /recipient_bcc_maps. always_bcc = [EMAIL PROTECTED] /deRegen
Re: [postfix-users] Courier tidak bisa connect ke MySQL
On 5/10/06, Asmuri Anwar <[EMAIL PROTECTED]> wrote: Share main.cf-nya di sini, pak ok, Berikut /etc/mysql/my.cnf # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # bind-address = 127.0.0.1 # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice= 0 [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 # Both location gets rotated by the cronjob. #log= /var/log/mysql.log log = /var/log/mysql/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-external-locking # # The skip-networking option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is "disable" - for security reasons. # skip-networking key_buffer = 16M max_allowed_packet = 16M thread_stack= 128K # # Query Cache Configuration # query_cache_limit = 1048576 query_cache_size= 26214400 query_cache_type= 1 # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin= /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # If you want to enable SSL support (recommended) read the manual or my # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M - Original Message - From: "Mufti" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 10, 2006 2:58 PM Subject: [postfix-users] Courier tidak bisa connect ke MySQL 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=[:::127.0.0.1] May 9 14:54:06 bntmail courierpop3login: LOGIN: DEBUG: ip=[:::127.0.0.1], command=USER May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: ip=[:::127.0.0.1], command=PASS May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: ip=[:::127.0.0.1], username= [EMAIL PROTECTED] May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG: ip=[:::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=[:::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: authdaemo
[postfix-users] tanya monitoring sendmail pada postix
alloo. Linuxer semuanyaaa saya ada kasus nehh... Saya menggunakan mail server postfix. terus bozz saya ingin semua sendmail user bisa dilihat atau di download oleh bozz saya ini (beserta contentnya). Jadi ceritanya bozz saya ini mo memantau setiap user itu mengirim email untuk apa saja. Dulu waktu pakai Micf. Exchange hal ini bisa dilakukan. Nah sekarang kalau pakai postfix bagaimana...??? mohon bantuan rekan-rekan semuanya... Thank's
Re: [postfix-users] Courier tidak bisa connect ke MySQL
Share main.cf-nya di sini, pak
- Original Message -
From: "Mufti" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 10, 2006 2:58 PM
Subject: [postfix-users] Courier tidak bisa connect ke MySQL
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=[:::127.0.0.1]
May 9 14:54:06 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], command=USER
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], command=PASS
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], username= [EMAIL PROTECTED]
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::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=[:::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_SERVERlocalhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfixp4ss
##NAME: MYSQL_SOCKET:0
MYSQL_SOCKET'/var/run/mysqld/mysqld.sock'
##NAME: MYSQL_PORT:0
# MYSQL_PORT3306
MYSQL_OPT 0
##NAME: MYSQL_DATABASE:0
MYSQL_DATABASE postfix
MYSQL_USER_TABLEmailbox
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_FIELDname
##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_FIELDauxoptions
# MYSQL_AUXOPTIONS_FIELD
CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail,",sharedgroup=",sharedgroup)
#
##NAME: MYSQL_WHERE_CLAUSE:0
# MYSQL_WHERE_CLAUSEserver='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=
[postfix-users] Courier tidak bisa connect ke MySQL
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=[:::127.0.0.1]
May 9 14:54:06 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], command=USER
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], command=PASS
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::127.0.0.1], username= [EMAIL PROTECTED]
May 9 14:54:11 bntmail courierpop3login: LOGIN: DEBUG:
ip=[:::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=[:::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_SERVERlocalhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfixp4ss
##NAME: MYSQL_SOCKET:0
MYSQL_SOCKET'/var/run/mysqld/mysqld.sock'
##NAME: MYSQL_PORT:0
# MYSQL_PORT3306
MYSQL_OPT 0
##NAME: MYSQL_DATABASE:0
MYSQL_DATABASE postfix
MYSQL_USER_TABLEmailbox
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_FIELDname
##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_FIELDauxoptions
# MYSQL_AUXOPTIONS_FIELD
CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail,",sharedgroup=",sharedgroup)
#
##NAME: MYSQL_WHERE_CLAUSE:0
# MYSQL_WHERE_CLAUSEserver='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=
