lightnb
May 5th, 2009, 09:38 AM
I'm trying to set-up mysql authentication on Ubuntu server 8.10.
There's very little documentation on how to do this, so alot of this is guesswork.... but when I added the common-auth line that's supposed to add Mysql as an authentication source, I can't login using either a mysql user (from the `Users` table) or as a regular system user.
Here's my common-auth file:
# here are the per-package modules (the "Primary" block)
auth [success=2 default=ignore] pam_unix.so nullok_secure
auth [success=1 default=ignore] pam_ldap.so use_first_pass
# Adding MySQL as an authentication method...
auth required /lib/security/pam_mysql.so user=root passwd=secret54 host=localhost db=AuthTest table=Users usercolumn=UserName passwdcolumn=Password crypt=0
# here's the fallback if no module succeeds
auth requisite pam_deny.so
# prime the stack with a positive return value if there isn't one already;
# this avoids us returning an error just because nothing sets a success code
# since the modules above will each just jump around
auth required pam_permit.so
# and here are more per-package modules (the "Additional" block)
auth optional pam_smbpass.so migrate
auth optional pam_ecryptfs.so unwrap
# end of pam-auth-update config
Any ideas?
Thanks,
Nick
There's very little documentation on how to do this, so alot of this is guesswork.... but when I added the common-auth line that's supposed to add Mysql as an authentication source, I can't login using either a mysql user (from the `Users` table) or as a regular system user.
Here's my common-auth file:
# here are the per-package modules (the "Primary" block)
auth [success=2 default=ignore] pam_unix.so nullok_secure
auth [success=1 default=ignore] pam_ldap.so use_first_pass
# Adding MySQL as an authentication method...
auth required /lib/security/pam_mysql.so user=root passwd=secret54 host=localhost db=AuthTest table=Users usercolumn=UserName passwdcolumn=Password crypt=0
# here's the fallback if no module succeeds
auth requisite pam_deny.so
# prime the stack with a positive return value if there isn't one already;
# this avoids us returning an error just because nothing sets a success code
# since the modules above will each just jump around
auth required pam_permit.so
# and here are more per-package modules (the "Additional" block)
auth optional pam_smbpass.so migrate
auth optional pam_ecryptfs.so unwrap
# end of pam-auth-update config
Any ideas?
Thanks,
Nick