Hi,
I'm trying to move courier authentication to a mysql backend database. I
installed Debian packages described forward, did the configuration and the
only log message I receive is at mail.log=LOGIN FAILED. mysql.log is empty
so I think authdaemon->authmysql is not even reaching the database. I've
followed for this installation Keith Matthews's
http://www.sweeney.demon.co.uk/pfix_imap_virtual.html as I also moved
successfully Postfix. Something I did wrong but I don't know where, and the
log is not being very helpfull B-)
Thanks very much in advance for your help.
Debian Packages installed
=========================
courier-authdaemon (0.37.2-1)
courier-pop (0.37.2-1)
under Debian 2.2.r4 (Sparc)
My Scenario
===========
MailDirs : /var/spool/postfix/virtual/<virtual domain>/<user>
#ps axf
1547 ? S 0:00 /usr/lib/courier/authlib/authdaemond.mysql start
1548 ? S 0:00 \_ /usr/lib/courier/authlib/authdaemond.mysql
start
1549 ? S 0:00 \_ /usr/lib/courier/authlib/authdaemond.mysql
start
1550 ? S 0:00 \_ /usr/lib/courier/authlib/authdaemond.mysql
start
1551 ? S 0:00 \_ /usr/lib/courier/authlib/authdaemond.mysql
start
1552 ? S 0:00 \_ /usr/lib/courier/authlib/authdaemond.mysql
start
1602 ? S 0:00
/usr/sbin/couriertcpd -pid=/var/run/courier/pop3d.pid -stderrlogger=/usr/sbi
n/courierlogger -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup -addres
s=0 110 /usr/lib/courier/courier/courierpop3login
/usr/lib/courier/authlib/authdaemon /usr/lib/courier/courier/courierpop3d
Maildir
1605 ? S 0:00 /usr/sbin/courierlogger courierpop3login
#netstat -a
unix 0 [ ACC ] STREAM LISTENING 2567
/var/run/courier/authdaemon/socket.tmp
unix 0 [ ACC ] STREAM LISTENING 407
/var/run/mysqld/mysqld.sock
#netstat -ntap
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN
1897/couriertcpd
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
479/mysqld
Courier Config Files
====================
#/etc/courier/pop3d
##VERSION: $Id: pop3d.dist.in,v 1.4 2001/07/04 19:32:37 uid26639 Exp $
prefix=/usr
exec_prefix=/usr
sbindir="/usr/sbin"
PIDFILE=/var/run/courier/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
POP3AUTH="LOGIN"
POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1"
POP3AUTH_TLS="LOGIN PLAIN"
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=YES
#/etc/courier/authmysqlrc
##VERSION: $Id: authmysqlrc,v 1.9 2002/01/08 05:01:22 mrsam Exp $
MYSQL_SERVER localhost
MYSQL_USERNAME <user>
MYSQL_PASSWORD <password>
MYSQL_SOCKET /var/run/mysqld/mysql.sock
#MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE aliases
#MYSQL_CRYPT_PWFIELD crypt
MYSQL_CLEAR_PWFIELD password
# DEFAULT_DOMAIN example.com
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD alias
MYSQL_MAILDIR_FIELD maildir
# MYSQL_QUOTA_FIELD quota
#/etc/courier/authdaemonrc
##VERSION: $Id: authdaemonrc.in,v 1.8 2001/10/07 02:16:22 mrsam Exp $
#authmodulelist="authpam"
authmodulelist="authmysql"
authmodulelistorig="authcustom authcram authuserdb authldap authmysql
authpam"
daemons=5
version=""
authdaemonvar=/var/run/courier/authdaemon
MySQL
=====
# CREATE DATABASE mail;
# USE mail;
# Table structure for table 'aliases'
# DROP TABLE IF EXISTS aliases;
CREATE TABLE `aliases` (
`id` char(30) NOT NULL default '',
`password` char(20) NOT NULL default '',
`uid` int(10) unsigned NOT NULL default '0',
`gid` int(10) unsigned NOT NULL default '0',
`maildir` char(128) NOT NULL default '',
`home` char(128) NOT NULL default '',
`alias` char(128) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `alias` (`alias`)
) TYPE=MyISAM;
# Dumping data for table 'aliases'
INSERT INTO aliases VALUES
('testuser','test',101,102,'/var/spool/postfix/virtual/virtual_domain/testus
er/','/','test@virtual_domain');
POP3 test exercise
==================
#telnet localhost 110
+OK Hello there.
#USER testuser
+OK Password required.
#PASS test
-ERR login failed
Best Regards,
==========================
Adrian Caneva
NEXT TECHNOLOGY SRL
La Rioja 26
(T4000ISB) Tucuman
Tel/Fax +54 381 4219105
[EMAIL PROTECTED]
www.nexttech.com.ar
==========================
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
