AuthBy PLATYPUS works slightly differently to AuthBy SQL when
it comes to how the user attribute selection query is assembled.
BasicSelect specifies the SQL query used to fetch user attributes
from the Platypus database. It is expected to return the following
attributes in this order:
- password
- active
- timeleft
- blockuser
- guarantor
- possibly other attributes as selected by AuthSelect
%0 is replaced with the contents of AuthSelect, which is
expected to be a list of additional columns to select from the database.
For more information, see
Section 3.47.4.
%1 is replaced with the
user name.
The default will work with the standard Platypus database
and need not be changed:
BasicSelect select password, active, timeleft, blockuser, \
guarantor %0 from customer where username=%1
