Re: [Pam-mysql-general] I can't figure out pam_mysql setting.

[Oded A. <ode...@ty...>]

On Wed, 2006-05-31 at 16:04 +0900, shi...@u-... wrote:

> I have successfully installed mysqlclient-*.rpm and pam_mysql-*.rpm on FC3
> and I configured /etc/pam.d/sshd as:
> 
> #auth       sufficient     pam_stack.so service=system-auth
> auth   optional        pam_mysql.so user=root passwd=password
> host=localhost db=vpn table=account usercolumn=user passwdcolumn=password
> auth       required     pam_nologin.so


I think you should have auth as at least sufficient, otherwise anybody
not mentioned in nologin can access the computer. I've set it to
"required".


> but it's not working.

Can't say why, except as above. Need more info.


> I don't get any log in /var/log/messages either.
> Why?

Because that's not where Fedora Core logs authentication and login
messages. try /var/log/secure - that's how it works on FC5. Also check
that the passwords are stored correctly in the database - IIRC if you
don't set "crypt", then the default is plain text passwords - probably
not what you want.

--

Oded

::..
"He was a modest, good-humored boy.  It was Oxford that made him
insufferable."