So, does this negate the need for using the /etc/passwd file to create
user accounts?? If so will ftp access still work? If so I would be
interested in setting this up on a linux and sun box.
Mike Miller
S�ren Peter Skou wrote:
>
> Okay, so far so good, I've got the pam_mysql working on FreeBSD with 3.1B10
> (Version correct this time :) and together with qpopper I'm now able to
> Authenticate users, but only if those users exists both in master.passwd and
> in the SQL Database I've setup for the purpose. The password the system
> checks against is the one from SQL so that part is fine and dandy.
>
> I then stepped back and looked at what I was trying once again, and it
> became apparent that it wasn't what I wanted, instead I wanted something
> along these lines:
>
> MySQL (Or other SQL for that matter) contains the equivalent of
> master.passwd
> Pop3 server then knows where to look for it's mailfile for a given user, ie.
> the user bork will have /var/mail/bork (yes, I am incredibly simpleminded)
> :).
> apache server looks into the same table to find users homedir, and can
> prepend whatever USER_DIR is defined to be in the httpd.conf
> MTA also looks here to find where to put the mail (ie, /var/spool).
>
> I'm imagining a table that looks something like this:
>
> id - Only inside the Database
> username - For the authentication and location of mailfiles.
> password - For authentication purposes
> home_dir - user's homedir
> mail_dir - Where to look for the users mailfile.
>
> As I see it this is more or less what I need, anyone who has done this, or
> are in the process of doing so, I'd be more than happy to help in anyway I
> can.
>
> Friendly Greetings
> S. P. Skou
