Re: SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-14 Thread Tim Evans
>Shouldn't this be passwd=bar instead of password=bar ? > >Tim Evans wrote: > >> >> #%PAM-1.0 >> authoptional/lib/security/pam_mysql.so user=foo password=bar >> db=healthhub table=auth usercolumn=username passwdcolumn=password crypt=1 >> account required/lib/security/pam_mysql.

Re: SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-10 Thread Paul Wiechman
This is a MySQL error, not Cyrus. You need to give the user foo access to SELECT from the database on localhost. Paul Tim Evans wrote: > > >It would greatly assist us in helping you if you post some configuration > >details, error messages, or symptoms for those of us that are familiar > >with

Re: SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-10 Thread Ross Golder
Tim Evans wrote: > > While this would appear to be the way to go here, I've not been able to make > it work. The doc's with the pam_mysql module are pretty skimpy. I'd like > to hear from someone who has made this work, and get some additional help. > It would greatly assist us in helping you

Re: SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-10 Thread Patrick Boutilier
Shouldn't this be passwd=bar instead of password=bar ? Tim Evans wrote: > > #%PAM-1.0 > authoptional/lib/security/pam_mysql.so user=foo password=bar > db=healthhub table=auth usercolumn=username passwdcolumn=password crypt=1 > account required/lib/security/pam_mysql.so user=f

Re: SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-10 Thread Tim Evans
>It would greatly assist us in helping you if you post some configuration >details, error messages, or symptoms for those of us that are familiar >with this combination. > Thanks, the system is a Cobalt RAQ4i, running Cobalt's modified Red Hat 6.x, Apache 1.3.12. I have separately installed PHP

SUMMARY (Well, sort of): Authentication against MySQL Database

2000-12-10 Thread Tim Evans
Earlier, I asked: >We already have all the userid's and passwords for the >portal site in MySQL and would like to let users log into >their IMP/Webmail accounts with the same password. > >I believe Cyrus/SASL authentication using PAM may be one way of doing this, >but would hope this is a wheel so

Re: Authentication against MySQL Database

2000-12-08 Thread Scot W. Hetzel
From: "Tim Evans" <[EMAIL PROTECTED]> > I am adding Web-based e-mail to an existing portal-like site, using > IMP and Cyrus imapd. The site is built pretty much exclusively with > PHP and MySQL. > > We already have all the userid's and passwords for the > portal site in MySQL and would like to le

Re: Authentication against MySQL Database

2000-12-08 Thread Ross Golder
Tim Evans wrote: > > I believe Cyrus/SASL authentication using PAM may be one way of doing this, > but would hope this is a wheel someone else has already invented. > Yes, indeed. I have Cyrus working w/pam_mysql. It's fairly trivial once you've got the pam_mysql distribution and read the docs e

Re: Authentication against MySQL Database

2000-12-08 Thread Paul Wiechman
Yes, it has... use PAM with the pam_mysql modules. I am using it quit effectively, one caveat... make sure you have unique ID's. The module doesn't like it when you return more than one row on a select. Paul Tim Evans wrote: > > I am adding Web-based e-mail to an existing portal-like site, usin

Re: Authentication against MySQL Database

2000-12-08 Thread Jeremy Howard
Tim Evans wrote: > I am adding Web-based e-mail to an existing portal-like site, using > IMP and Cyrus imapd. The site is built pretty much exclusively with > PHP and MySQL. > > We already have all the userid's and passwords for the > portal site in MySQL and would like to let users log into > th

Authentication against MySQL Database

2000-12-07 Thread Tim Evans
I am adding Web-based e-mail to an existing portal-like site, using IMP and Cyrus imapd. The site is built pretty much exclusively with PHP and MySQL. We already have all the userid's and passwords for the portal site in MySQL and would like to let users log into their IMP/Webmail accounts with