access problems

[Osvaldo Alvarez Pozo]

Hello there I have a postfix-cyrus-mysql-web-cyradm system . But I have 
access problems I
compiled cyrus-sasl with the patch for auxprop
patch -p0 < ../cyrus-sasl-2.1.19-checkpw.c.patch
patch -p0 < ../cyrus-sasl-2.1.19-sql.c.patch

cyrus-sasl
env CPPFLAGS="-I/usr/include/mysql"  LDFLAGS="-L/usr/lib/mysql -lmysqlclient 
-lz"
_______________
./configure --prefix=/usr --exec-prefix=/usr \
--bindir=/usr/bin --sbindir=/usr/sbin \
--sysconfdir=/etc --libdir=/usr/lib \
--includedir=/usr/include  --libexecdir=/usr/libexec \
--mandir=/usr/man --localstatedir=/var \
--with-saslauthd=/var/run/saslauthd \
--enable-sql --enable-login --disable-krb4 \
--with-plugindir=/usr/lib/sasl2

Then cyrus imap with
export CPPFLAGS="-I/usr/include/et"

./configure \
--with-sasl=/usr/lib \
--with-perl \
--with-auth=unix \
--without-ucdsnmp
The sistem works but i only can access via web or if I configured evolucion 
to acces de server via localhost in the same machine . Pop is not working at 
all.
this is my curys.conf
------------------------------------------------------------------------
# standard standalone server implementation

START {
  # do not delete this entry!
  recover       cmd="ctl_cyrusdb -r"

  # this is only necessary if using idled for IMAP IDLE
#  idled                cmd="idled"
}

# UNIX sockets start with a slash and are put into /var/imap/socket
SERVICES {
  # add or remove based on preferences
  imap          cmd="imapd" listen="192.168.40.5:imap" prefork=0
  imaplocal     cmd="imapd -C /etc/imapd-local.conf" listen="127.0.0.1:imap" 
prefork=0
  imaps         cmd="imapd -s" listen="192.168.40.5:imaps" prefork=0
  imapslocal    cmd="imapd -C /etc/imapd-local.conf" 
listen="127.0.0.1:imaps" prefork=0
  pop3          cmd="pop3d" listen="*:pop3" prefork=0
  pop3s         cmd="pop3d -s" listen="*:pop3s" prefork=0
  sieve         cmd="timsieved" listen="*:sieve" prefork=0
  sievelocal    cmd="timsieved -C /etc/imapd-local.conf" 
listen="127.0.0.1:sieve" prefork=0

  # at least one LMTP is required for delivery
#  lmtp         cmd="lmtpd" listen="lmtp" prefork=0
  lmtpunix      cmd="lmtpd" listen="/var/imap/socket/lmtp" prefork=0

  # this is only necessary if using notifications
#  notify       cmd="notifyd" listen="/var/imap/socket/notify" proto="udp" 
prefork=1
}

EVENTS {
  # this is required
  checkpoint    cmd="ctl_cyrusdb -c" period=30

  # this is only necessary if using duplicate delivery suppression
  #delprune      cmd="ctl_deliver -E 3" period=1440
delprune      cmd="cyr_expire -E 3" period=144
  # this is only necessary if caching TLS sessions
  tlsprune      cmd="tls_prune" period=1440
}
-------------------------------------------------------------------------------
this is my imapd.conf
----------------------------------------------------------------------------------
postmaster: postmaster
configdirectory: /var/imap
partition-default: /var/spool/imap
# admins: cyrus # no admins!
allowanonymouslogin: no
allowplaintext: yes
sasl_mech_list: PLAIN
servername: piscis.minsap.pri.sld.cu
autocreatequota: 10000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: localhost
sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sasl_password_format: crypt
sasl_sql_hostnames: localhost
sasl_sql_user: mail
sasl_sql_pass: somepass
sasl_sql_database: mail
sasl_sql_select: select password from accountuser where username='%u'
sasl_sql_verbose: true
sievedir: /usr/sieve
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
unixhierarchysep: yes
tls_ca_file: /var/imap/server.pem
tls_cert_file: /var/imap/server.pem
tls_key_file: /var/imap/server.pem
------------------------------------------------------------------------
Imap-local.conf is the same but it has
admins: cyrus

Any advices???
This are some log from /var/log/auth.log

Nov 17 08:41:36 piscis imap[1969]: sql plugin Parse the username laura
Nov 17 08:41:36 piscis imap[1969]: sql plugin try and connect to a host
Nov 17 08:41:36 piscis imap[1969]: sql plugin trying to open db 'radius' on 
host 'localhost'
Nov 17 08:41:36 piscis imap[1969]: sql plugin could not connect to host 
localhost
Nov 17 08:41:36 piscis imap[1969]: sql plugin couldn't connect to any host
Nov 17 08:41:36 piscis imap[1969]: sql plugin Parse the username laura
Nov 17 08:41:36 piscis imap[1969]: sql plugin try and connect to a host
Nov 17 08:41:36 piscis imap[1969]: sql plugin trying to open db 'radius' on 
host 'localhost'
Nov 17 08:41:36 piscis imap[1969]: sql plugin could not connect to host 
localhost
Nov 17 08:41:36 piscis imap[1969]: sql plugin couldn't connect to any host
Nov 17 08:41:36 piscis imap[1969]: sql plugin Parse the username laura
Nov 17 08:41:36 piscis imap[1969]: sql plugin try and connect to a host
Nov 17 08:41:36 piscis imap[1969]: sql plugin trying to open db 'radius' on 
host 'localhost'
Nov 17 08:41:36 piscis imap[1969]: sql plugin could not connect to host 
localhost
Nov 17 08:41:36 piscis imap[1969]: sql plugin couldn't connect to any host

but when i do
mysql -u mail -p
I get connected.

Thanks
Pozo

_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/

_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch