Re: [postfix-users] postfix + mysql

2004-02-24 Thread adi
On Tue, Feb 24, 2004 at 11:13:52AM +0800, Abdullah Karim wrote:
 select_field = 'OK'
 where_field = pw_name

pw_name harus berisi email address, bukan hanya local part.

 Feb 21 18:35:27 mangubi postfix/smtpd[12738]: BE873547E7: reject: RCPT
 from unknown[202.152.167.67]: 451 [EMAIL PROTECTED]: Temporary lookup
 failure; from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] proto=ESMTP
 helo=proxy.olami.net.id

coba:

% egrep '(warning|fatal)' maillong

apakah smtpd run chrooted? postfix diinstall dengan library
mysql yang sesuai?

Salam,

P.Y. Adi Prasaja


Re: [postfix-users] postfix + mysql

2004-02-24 Thread Abdullah Karim
On Tue, 24 Feb 2004, adi wrote:

 On Tue, Feb 24, 2004 at 11:13:52AM +0800, Abdullah Karim wrote:
  select_field = 'OK'
  where_field = pw_name

 pw_name harus berisi email address, bukan hanya local part.

ini dia masalahnya, soalnya table vpopmail field 'pw_name' nya tidak
berisi email addres :(, dalam vpopmail ID dan domainnya terpisah jadi dua field

any idea ??


  Feb 21 18:35:27 mangubi postfix/smtpd[12738]: BE873547E7: reject: RCPT
  from unknown[202.152.167.67]: 451 [EMAIL PROTECTED]: Temporary lookup
  failure; from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] proto=ESMTP
  helo=proxy.olami.net.id
 coba:

 % egrep '(warning|fatal)' maillong

saya coba jalankan smtpnya dengan mode verbose dan lognya :

Feb 25 10:15:31 mangubi postfix/smtpd[23564]: match_list_match:
gorontalo.net: no match
Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql_lookup using sql
query: select 'OK' from vpopmail where pw_name = '@gorontalo.net'
Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql: successful query
from host 202.152.167.68
Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql_lookup: retrieved
0 rows
Feb 25 10:15:31 mangubi postfix/smtpd[23564]: maps_find:
relay_recipient_maps: @gorontalo.net: not found
Feb 25 10:15:31 mangubi postfix/smtpd[23564]: mail_addr_find:
[EMAIL PROTECTED] - (not found)


 apakah smtpd run chrooted?
tidak
postfix diinstall dengan library
 mysql yang sesuai?
library mysql yg sesuai maksudnya gmn yah pak ??

Salam,

Duken

 Salam,

 P.Y. Adi Prasaja




[postfix-users] error instal postfix+courier imap

2004-02-24 Thread sonjaya
dear  all

 lagi coba install postfix manualnya dapet dari
http://www.gfxcafe.com/Mail%20Howto.htm , nah pas bagian courier-imap
erros seperti ini :


checking whether -lresolv is needed for res_query... configure: error:
Cannot find function res_query
configure: error: /usr/local/bin/bash './configure' failed for authlib
$

aku pake freebsd 5.2 .

adapun script configurenya :
$ bzip2 -dc courier-imap-2.2.1.20031219.tar.bz2 | tar xvf -
$ ./configure \
--prefix=/usr/local/courier \
--with-mysql-libs=/usr/local/mysql/lib/mysql \
--with-mysql-includes=/usr/local/mysql/include/mysql/ \
--with-authmysql \
--with-authmysql=yes \
--with-authchangepwdir

nah kira kira kenapa dan mesti bagaimana  thx yach


Re: [postfix-users] postfix + mysql

2004-02-24 Thread adi
On Wed, Feb 25, 2004 at 11:30:18AM +0800, Abdullah Karim wrote:
 ini dia masalahnya, soalnya table vpopmail field 'pw_name' nya tidak
 berisi email addres :(, dalam vpopmail ID dan domainnya terpisah jadi dua field

pakai concat() ? ditch vpopmail ganti dengan maildrop? :-))

 saya coba jalankan smtpnya dengan mode verbose dan lognya :
 
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: match_list_match:
 gorontalo.net: no match
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql_lookup using sql
 query: select 'OK' from vpopmail where pw_name = '@gorontalo.net'
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql: successful query
 from host 202.152.167.68
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: dict_mysql_lookup: retrieved
 0 rows
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: maps_find:
 relay_recipient_maps: @gorontalo.net: not found
 Feb 25 10:15:31 mangubi postfix/smtpd[23564]: mail_addr_find:
 [EMAIL PROTECTED] - (not found)

artinya query mysql sudah tidak bermasalah. kalau masih berakhir
dengan tempfail, artinya ada di tempat lain. saran masih tetap
sama:

% egrep '(warning|fatal)' maillog

  apakah smtpd run chrooted?
 tidak
 postfix diinstall dengan library
  mysql yang sesuai?
 library mysql yg sesuai maksudnya gmn yah pak ??

tidak relevan lagi, karena query dengan mysql: OK.

Salam,

P.Y. Adi Prasaja


Re: [postfix-users] error instal postfix+courier imap

2004-02-24 Thread adi
On Wed, Feb 25, 2004 at 09:42:00AM -0700, [EMAIL PROTECTED] wrote:
 checking whether -lresolv is needed for res_query... configure: error:
 Cannot find function res_query

% locate libresolv

masukkan di ld.so.conf dan jalankan ldconfig.
tapi saya ndak ngerti soal freebsd :-) bisa jadi configure
script courier-imap buggy untuk di freebsd.

Salam,

P.Y. Adi Prasaja


Re: [postfix-users] error instal postfix+courier imap

2004-02-24 Thread jelantix
sinkron ?
saya kira tadi masalah nya hanya
instalasi courier-imap dengan mysql support di freebsd 5.2

regards
-yudhi-

On Wed, 25 Feb 2004 11:43:40 - (GMT)
budhi [EMAIL PROTECTED] wrote:

 sinkroninnya?
 biasanya seh kalo aku nginstall pake port di BSD dia
 langsung sinkron palingan dikit2 ngubah file .conf nya courier-imap
 di /usr/local/etc/courier-imap (or wherever it is)
 dan (biasanya lageeh) kalo nginstall lewat port
 dia langsung bisa sinkron (pengalamanku sebagai pemalas yang biasa
 nginstall lewat port... :p)
 
 Budhi,
 
 jelantix said:
  On Wed, 25 Feb 2004 09:42:00 -0700 (WIT)
  [EMAIL PROTECTED] wrote:
 
  dear  all
 
   lagi coba install postfix manualnya dapet dari
  http://www.gfxcafe.com/Mail%20Howto.htm , nah pas bagian courier-imap
  erros seperti ini :
 
 
  checking whether -lresolv is needed for res_query... configure: error:
  Cannot find function res_query
  configure: error: /usr/local/bin/bash './configure' failed for authlib
  $
 
  aku pake freebsd 5.2 .
 
  adapun script configurenya :
  $ bzip2 -dc courier-imap-2.2.1.20031219.tar.bz2 | tar xvf -
  $ ./configure \
  --prefix=/usr/local/courier \
  --with-mysql-libs=/usr/local/mysql/lib/mysql \
  --with-mysql-includes=/usr/local/mysql/include/mysql/ \
  --with-authmysql \
  --with-authmysql=yes \
  --with-authchangepwdir
 
  nah kira kira kenapa dan mesti bagaimana  thx yach
 
  kalau saya yang pemalas ini sih cuman
  cd /usr/ports/mail/courier-imap
  make install clean
 
  kalau mau supporting mysql
  make WITH_MYSQL=YES install clean
 
  detailed more /usr/port/mail/courier-imap/Makefile
 
  regards
  -yudhi-
 
 
 
 
 Budhi
 Sys-admin Dept Biologi ITB