I'd change it to auth optional /lib/security/pam_mysql.so ...
is user cyr without password? also, you need db= table= usercolumn= Nick -----Original Message----- From: Vincent Stoessel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 00:59 To: Nick Ustinov Cc: [EMAIL PROTECTED] Subject: Re: cyrus/pam tutorial? yeah ,killed and started master again. here is the file wc reports 3 lines. My email may have broken it up though [root@web pam.d]# cat imap auth optional pam_mysql.so user=cyr host=securedb passwdcolumn=Password crypt=2 auth required pam_warn.so account required pam_mysql.so user=cyr host=securedb passwdcolumn=Password crypt=2 Nick Ustinov wrote: > No, should be fine. Did you restart master after making changes in > imapd.conf? Did you enable #define DEBUG in pam_mysql? What is exactly in > your /etc/pam.d/imap file? > > Nick > > -----Original Message----- > From: Vincent Stoessel [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 00:15 > To: Nick Ustinov > Cc: [EMAIL PROTECTED] > Subject: Re: cyrus/pam tutorial? > > > Changed but still no mysql connection. :-( > > > I compiled cyrus-imapd-2.0.16 with these flags: > > ./configure --with-auth=unix --without-krb --with-perl=/usr/bin/perl > > and cyrus-sasl-1.5.24 with : > > > ./configure --with-openssl=/usr/local/ssl --enable-netscapehack > --with-sasl=/usr/local --with-pam --disable-krb4 > --disable-gssapi --disable-cram > --disable-digest > > > > > > should I have included anything else > > Nick Ustinov wrote: > > >>it should be sasl_pwcheck_method, not sasl_passwd_check >> >>Nick >> >>-----Original Message----- >>From: Vincent Stoessel [mailto:[EMAIL PROTECTED]] >>Sent: Monday, October 01, 2001 23:47 >>Cc: [EMAIL PROTECTED] >>Subject: Re: cyrus/pam tutorial? >> >> >>This what my /etc/imapd.conf looks like: >> >> >>configdirectory: /var/imap >>partition-default: /var/spool/imap >>admins: admin >>srvtab: /var/imap/srvtab >>allowanonymouslogin: no >>sasl_passwd_check: PAM >>allowplaintext: yes >> >> >>Like you , I am using the following params >> >> > auth optional ...(params for pammysql)... >> > account required ...(same params for pammysql)... >> >>I am tail -f ing my mysql.log (mysql is running in logging mode) >> >>and I can see connections that I make from the command line but not >>from the imap pam >> >> >>I have the same config in sudo , sudo makes the connection but not imap. >> >> >> >> >> >>Nick Ustinov wrote: >> >> >> >>>Vincent, >>> >>>I have rh7 and exactly the same situation -- pam_mysql, mysql and web >>>interface for user creation, which inserts necessary records to mysql >>> >>> >>tables >> >> >>>upon user creation. >>> >>>As for pam_mysql -- the tricky part here may be that you have unneeded >>> >>> >>line >> >> >>>break in end of /etc/pam.d/imap file (I was fighting this for a couple of >>>days :) >>> >>>Also, what format do you use in /etc/pam.d/imap ? >>> >>>I have >>> >>>auth optional ...(params for pammysql)... >>>account required ...(same params for pammysql)... >>> >>>and worked just fine. Did you check /var/log/messages file? also, i'd >>>recommend #define DEBUG in pam_mysql.c so you can see whats going on. >>> >>> >>>Nick >>> >>>-----Original Message----- >>>From: Vincent Stoessel [mailto:[EMAIL PROTECTED]] >>>Sent: Monday, October 01, 2001 22:46 >>>To: Nick Ustinov >>>Cc: [EMAIL PROTECTED] >>>Subject: Re: cyrus/pam tutorial? >>> >>> >>>This is great. I have been banging my head against the wall here. >>>Let me tell you what I want to do and you tell me if it even possible. >>> >>> >>>1. I moved to cyrus from UW because of the ability to create virtual >>>mailboxes >>> and sasl has worked fine >>> >>>2, I also have a mysql database that contains user info and is also used >>> >>> >>to >> >> >>>authenticate >>> users for various parts of the website including my web based imap >>>client. >>> >>>what I want to do is >>> >>>1. combine the creation of cyrus mailboxes with record creation in the sql >>>db >>>2. have cyrus use pam_mysql to look up and authenticate passwords from the >>>sql database >>> >>> >>>are 1 or 2 possible ? >>> >>>I have compiled pam_mysql as directed and tested it with pam module for >>> >>> >>the >> >> >>>sudo >>>and it definetely checks the database when I use it there. The same is not >>>true for imap, >>>no queries are made to the database and nothing seems to work except sasl >>> >>>I am working on an intel redhat linux 7.1 system. >>> >>>Thanks in advance. >>> >>>Nick Ustinov wrote: >>> >>> >>> >>> >>>>Vincent, >>>> >>>>I am using cyrus with pam_mysql. Let me know what are the problems you >>>> > are > >>>>facing and I will try to help. In general, you compile pam module, create >>>>entries in /etc/pam.d (files imap and pop) with settings pam modules >>>> >>>> >>>> >>>require >>> >>> >>> >>>>and set in /etc/imapd.conf sasl_pwcheck_method: pam >>>> >>>>Sincerely, >>>>Nick >>>> >>>>-----Original Message----- >>>>From: Vincent Stoessel [mailto:[EMAIL PROTECTED]] >>>>Sent: Monday, October 01, 2001 21:40 >>>>To: [EMAIL PROTECTED] >>>>Subject: cyrus/pam tutorial? >>>> >>>> >>>>Hello , I am having a hard time getting cyrus to >>>>use pam authentication. It only seems to want to work >>>>with sasl. Any tuttorials or hints? >>>> >>>> >>>> >>>> >>> >> >> > > > -- Vincent Stoessel [EMAIL PROTECTED] Java Linux Apache Mysql Php (JLAMP) Engineer (301) 362-1750 Mobile (410) 419-8588
