I am having problems with authdaemond.mysql and since it isn't logging 
anything, I don't know what to fix.

I have searched the archives without luck using google.com as a search
front end for geocrawler.

20:08:58 Tue Jun 18 # ls -l /usr/local/libexec/courier-imap/authlib/
total 118
-r-xr-xr-x  1 root  wheel  15504 Jun 13 16:17 authdaemon
-rwxr-xr-x  1 root  wheel    408 Jun 13 16:17 authdaemond
-r-xr-xr-x  1 root  wheel  56412 Jun 13 16:17 authdaemond.mysql
-r-xr-xr-x  1 root  wheel  43908 Jun 13 16:17 authdaemond.plain

  354  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start
  356  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start
  357  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start
  358  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start
  359  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start
  360  ??  I      0:00.00 /usr/local/libexec/courier-imap/authlib/authdaemond.mysql 
start


20:19:35 Tue Jun 18 # grep ^[[:alnum:]] authdaemonrc
authmodulelist="authcustom authuserdb authmysql authpam"
authmodulelistorig="authcustom authuserdb authmysql authpam"
daemons=5
version=""
authdaemonvar=/usr/local/var/authdaemon

20:20:03 Tue Jun 18 # grep ^[[:alnum:]] authmysqlrc 
MYSQL_SERVER            localhost
MYSQL_USERNAME          postfix
MYSQL_PASSWORD          InChM1pW
MYSQL_SOCKET            /var/mysql/mysql.sock
MYSQL_OPT               0
MYSQL_DATABASE          maildb
MYSQL_USER_TABLE        users
MYSQL_CRYPT_PWFIELD     crypt
DEFAULT_DOMAIN          inch.com
MYSQL_UID_FIELD         uid
MYSQL_GID_FIELD         gid
MYSQL_LOGIN_FIELD       id
MYSQL_HOME_FIELD        home
MYSQL_NAME_FIELD        name

user test1 lives in /etc/passwd (and friends).

user blah lives in maildb.users

With that configuration I get:

20:19:09 Tue Jun 18 # authtest -m authdaemon blah
Temporary authentication failure from module authdaemon
Authentication FAILED!

20:19:25 Tue Jun 18 # authtest -m authdaemon test1
Temporary authentication failure from module authdaemon
Authentication FAILED!

I get the same thing if I set:
authmodulelist="authmysql"
in authdaemonrc.

If I change authdaemonrc to use:
authmodulelist="authpam"

I then get:

19:52:37 Tue Jun 18 # authtest test1
Authenticated: module authdaemon
Home directory: /home/test1
UID/GID: 1001/1001
AUTHADDR=test1
AUTHFULLNAME=test1 Get rid of Me

So that much is working.

19:54:53 Tue Jun 18 # authtest blah 
Authentication FAILED!

No log records are ever created.  Not even a connect line in the
database query log. grep -i authdaemon /var/log/* returns an empty set.

I have tried using both TCP and UNIX socket methods of accessing MySQL.

Postfix, with the same username and password is able to access the 
MySQL server.  So, MySQL is ok.

20:28:30 Tue Jun 18 # uname -a
FreeBSD newmail.inch.com 4.6-RC FreeBSD 4.6-RC #6: Mon May 27 19:27:53 EDT 2002     
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC  i386

20:31:57 Tue Jun 18 # pkg_info | egrep -i '(postfix|sasl|mysql|imap)'
courier-imap-1.4.6.20020613 IMAP (and POP3) server that provides access to Maildir mail
cyrus-sasl-1.5.27_3 RFC 2222 SASL (Simple Authentication and Security Layer)
mysql-client-3.23.49 Multithreaded SQL database (client)
mysql-server-3.23.49 Multithreaded SQL database (server)
p5-Mysql-modules-1.2216 Perl5 modules for accessing MySQL databases
pflogsumm-1.0.3,1   Postfix Log Entry Summarizer
postfix-1.1.10-20020514,1 An alternative to widely-used Sendmail

I rolled the courier-imap port myself from the 1.4.3 port.  It was
configured --with-mysql.  I was seeing the same behavior with 1.4.3.

You can have the config.cache file if it is important.  Here are the
MySQL related lines:

20:04:59 Tue Jun 18 # grep -i mysql config.cache 
ac_cv_func_mysql_connect=${ac_cv_func_mysql_connect='yes'}
ac_cv_path_MYSQL_CONFIG=${ac_cv_path_MYSQL_CONFIG='/usr/local/bin/mysql_config'}

If I could just be pointed in the direction of a DEBUG flag for the mysql 
module, I could probably get it lined out.  If I have to add my own debug
code to authlib/*mysql*, it will take me a week that I don't have availible
right now.  My C foo is very rusty.

-- 
Scott Lambert
System Administrator

----------------------------------------------------------------------------
                   Bringing you mounds of caffeinated joy
                   >>>     http://thinkgeek.com/sf    <<<

_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to