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 [EMAIL PROTECTED] 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 | >>+-------------------+-------------------+---------------+-------+--------+------+------+----------------+------------+--------------------------------+--------+-------+-------+ >>| [EMAIL PROTECTED] | [EMAIL PROTECTED] | 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 | >>+-------------------+---------+ >>| [EMAIL PROTECTED] | 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 [EMAIL PROTECTED] 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! >> >>stefan. >> >> >> >>_______________________________________________________________ >> >>Don't miss the 2002 Sprint PCS Application Developer's Conference >>August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm >> >>_______________________________________________ >>courier-users mailing list >>[EMAIL PROTECTED] >>Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users > > > >_______________________________________________________________ > >Don't miss the 2002 Sprint PCS Application Developer's Conference >August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > >_______________________________________________ >courier-users mailing list >[EMAIL PROTECTED] >Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
