Project

General

Profile

[Answered] mod_authn_mysql how can manage the table

Added by mckaygerhard almost 7 years ago

i see the new featured mod_auth:mysql thanks.. but:

method of password do not documented and how can manage the table

there's no documentation about table format, only column names, how password are manage/stored and how can be implemented!?


Replies (1)

RE: mod_authn_mysql how can manage the table - Added by gstrauss almost 7 years ago

I added a comment to the template at Docs_ModAuth:
A query from lighttpd mod_authn_mysql using defaults looks like: SELECT password FROM mysql_users_table WHERE user='%s' AND realm='%s'

If using basic auth, the password field in the database is plain text. If using digest auth, the password field in the database is the digest.

You get to implemented and manage the tables as you see fit. lighttpd mod_authn_mysql accesses the tables read-only (and more secure configurations will grant only read-access to the user/pass used by lighttpd to access the database)

    (1-1/1)