5 messages in net.sourceforge.lists.courier-usersRe: [courier-users] courier-imap+auth...
FromSent OnAttachments
stefan radulianMay 20, 2002 2:02 pm 
brontoMay 20, 2002 2:23 pm 
Sam VarshavchikMay 20, 2002 3:36 pm 
stefan radulianMay 21, 2002 12:50 am 
stefan radulianMay 21, 2002 1:18 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] courier-imap+authmysql LOGIN FAILEDActions...
From:stefan radulian (stef@chello.at)
Date:May 21, 2002 1:18:42 am
List:net.sourceforge.lists.courier-users

okay, i checked over the other config files and found another white space at the end of a line... i removed it, now it works. stupid me.

stefan.

At Tuesday 09:50 21.05.2002 +0200, you wrote:

hi, i finally managed to connect to mysql. it was a very stupid mistake (had a whitespace after the mysql user and it escaped my notice...). but unfortunately it still doesn't work :-(

now i get the same in telnet Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. * OK Courier-IMAP ready. Copyright 1998-2002 Double Precision, Inc. See COPYING for distribution information. . login ste@symbion.at 3141592 . NO Login failed. . logout * BYE Courier-IMAP server shutting down . OK LOGOUT completed Connection closed by foreign host.

but i do get this in mysql.log: 020521 7:48:57 372 Connect root@localhost on 372 Quit

and syslogd still isnt't very verbose: May 21 07:48:44 www imapd: Connection, ip=[::ffff:127.0.0.1] May 21 07:49:02 www imapd: LOGIN FAILED, ip=[::ffff:127.0.0.1] May 21 07:49:12 www imapd: LOGOUT, ip=[::ffff:127.0.0.1]

so there is still a mistake - i hope it's not as stupid as the one with the user name (sorry for that... i was so tired i didnt notice it.)

thanx for any help! stefan.

At Monday 23:03 20.05.2002 +0200, you wrote:

hello courier-users!

i am new to this mailing list. i am experiencing several difficulties with courier-installation and couldnt find help out there - even google let me down :-( - so i hope you guys can give me a hand on this:

linux-distro: gentoo 1.1a (kernel 2.4.19)

i installed mysql postfix and courier (with mysql support). i set up the mysql database (maildb) with 3 tables like this: mysql> show tables; +------------------+ | Tables_in_maildb | +------------------+ | transport | | users | | virtual | +------------------+ 3 rows in set (0.00 sec)

mysql> describe transport; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | domain | varchar(128) | | PRI | | | | transport | varchar(128) | | MUL | | | +-----------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)

mysql> describe virtual; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | address | varchar(255) | | PRI | | | | goto | varchar(255) | | | | | +---------+--------------+------+-----+---------+-------+ 2 rows in set (0.01 sec)

mysql> describe users; +---------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+-------+

| id | varchar(128) | | PRI | | | | address | varchar(128) | | UNI | | | | crypt | varchar(128) | | | | | | clear | varchar(128) | | | | | | name | varchar(128) | | | | | | uid | smallint(5) unsigned | | | 0 | | | gid | smallint(5) unsigned | | | 0 | | | home | varchar(128) | | | / | | | domain | varchar(128) | | | | | | maildir | varchar(255) | | | | | | imapok | tinyint(3) unsigned | | | 1 | | | bool1 | tinyint(3) unsigned | | | 1 | | | bool2 | tinyint(3) unsigned | | | 1 | | +---------+----------------------+------+-----+---------+-------+

i filled the tables as followed: transport: +------------+-----------+ | domain | transport | +------------+-----------+ | symbion.at | virtual: | +------------+-----------+ 1 row in set (0.01 sec)

users: +-------------------+-------------------+---------------+-------+--------+------+------+----------------+------------+--------------------------------+--------+-------+-------+ | id | address | crypt | clear | name | uid | gid | home | domain | maildir | imapok | bool1 | bool2 | +-------------------+-------------------+---------------+-------+--------+------+------+----------------+------------+--------------------------------+--------+-------+-------+ | ste@symbion.at | ste@symbion.at | rL68ZT/NKOc1Q | | stefan | 1000 | 1000 | /home/lectrix/ | symbion.at | /home/lectrix/.maildir-stefan/ | 1 | 1 | 1 | +-------------------+-------------------+---------------+-------+--------+------+------+----------------+------------+--------------------------------+--------+-------+-------+ 1 row in set (0.00 sec)

virtual: +-------------------+---------+ | address | goto | +-------------------+---------+ | ste@symbion.at | lectrix | +-------------------+---------+ 1 row in set (0.00 sec)

here are the cruicial files i modiefied according to several how-to's...

/etc/courier-imap/egrep ^[^#] authdaemonrc authmodulelist="authmysql" authmodulelistorig="authcustom authcram authuserdb authmysql authpam" daemons=5 version="authdaemond.mysql" authdaemonvar=/var/lib/courier-imap/authdaemon

/etc/courier-imap/egrep ^[^#] authmysqlrc MYSQL_SERVER localhost MYSQL_USERNAME root MYSQL_PASSWORD XXXXXXXXX MYSQL_SOCKET /tmp/mysql.sock MYSQL_PORT 3306 MYSQL_OPT 0 MYSQL_DATABASE maildb MYSQL_USER_TABLE users MYSQL_CRYPT_PWFIELD crypt MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELD home MYSQL_NAME_FIELD name MYSQL_MAILDIR_FIELD maildir

/etc/courier-imap/egrep ^[^#] imapd ADDRESS=0 PORT=143 MAXDAEMONS=40 MAXPERIP=4 PIDFILE=/var/run/imapd.pid TCPDOPTS="-nodnslookup -noidentlookup" AUTHMODULES="authdaemon" AUTHMODULES_ORIG="authdaemon" IMAP_CAPABILITY="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT" IMAP_CAPABILITY_ORIG="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT AUTH=CRAM-MD5 AUTH=CRAM-SHA1 IDLE" IMAP_IDLE_TIMEOUT=60 IMAP_CAPABILITY_TLS="$IMAP_CAPABILITY AUTH=PLAIN" IMAP_CAPABILITY_TLS_ORIG="$IMAP_CAPABILITY_ORIG AUTH=PLAIN" IMAP_DISABLETHREADSORT=0 IMAP_CHECK_ALL_FOLDERS=0 IMAP_OBSOLETE_CLIENT=0 IMAP_ULIMITD=65536 IMAP_USELOCKS=0 IMAP_EMPTYTRASH=Trash:7 IMAP_MOVE_EXPUNGE_TO_TRASH=0 IMAPDSTART=NO MAILDIR=.maildir

just to prove that authdaemon is here...

symbion courier-imap # ll /usr/lib/courier-imap/authlib/ total 148 drwxr-xr-x 2 root root 4096 May 20 16:37 . drwxr-xr-x 3 root root 4096 May 20 16:37 .. -rwxr-xr-x 1 root root 16772 May 20 16:37 authdaemon -rwxr-xr-x 1 root root 398 May 20 16:37 authdaemond -rwxr-xr-x 1 root root 62376 May 20 16:37 authdaemond.mysql -rwxr-xr-x 1 root root 48192 May 20 16:37 authdaemond.plain

... and running...

root 2927 0.0 0.1 2596 784 ? S 20:57 0:00 /usr/lib/courier-imap/authlib/authdaemond.mysql start root 2928 0.0 0.1 2596 784 ? S 20:57 0:00 /usr/lib/courier-imap/authlib/authdaemond.mysql start root 2929 0.0 0.1 2596 784 ? S 20:57 0:00 /usr/lib/courier-imap/authlib/authdaemond.mysql start root 2930 0.0 0.1 2596 784 ? S 20:57 0:00 /usr/lib/courier-imap/authlib/authdaemond.mysql start root 2931 0.0 0.1 2596 784 ? S 20:57 0:00 /usr/lib/courier-imap/authlib/authdaemond.mysql start

mysql and imapd is also running ok.

so far so good. here is the problem:

symbion courier-imap # telnet localhost 143 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. * OK Courier-IMAP ready. Copyright 1998-2002 Double Precision, Inc. See COPYING for distribution information. . login ste@symbion.at XXXXXXXXX . NO Login failed. . logout * BYE Courier-IMAP server shutting down . OK LOGOUT completed Connection closed by foreign host. symbion courier-imap #

while syslogd logs:

May 20 21:01:02 www imapd: Connection, ip=[::ffff:127.0.0.1] May 20 21:01:14 www imapd: LOGIN FAILED, ip=[::ffff:127.0.0.1]

i am not an expert but i need this get running pretty soon, i hope i gave you enough information and someone can give me a hint or a solution to this.

thanks!

Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm