<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<p>Hey Patrik -</p>
<p>Very good to hear from old friends!</p>
<p>As it happens, this is very much by design.</p>
<p>Radiator has a "special" user called DEFAULT as described in the
manual:</p>
<p><br>
</p>
<p> </p>
<div class="page" title="Page 195">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12.000000pt; font-family:
'Helvetica'; font-weight: 700">3.32.13. NoDefault
</span></p>
</div>
</div>
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 10.000000pt; font-family: 'Times'">Normally
if Radiator searches for a user in the database and either
does not find one, or finds one but the users
check items fail, Radiator will then consult the DEFAULT
user entry. However, if the NoDefault parameter is
set, Radiator will never look for a DEFAULT. <br>
</span></p>
<p><span style="font-size: 10.000000pt; font-family: 'Times'"><br>
</span></p>
<p><span style="font-size: 12.000000pt; font-family:
'Helvetica'; font-weight: 700">3.32.14. NoDefaultIfFound
</span></p>
<p><span style="font-size: 10.000000pt; font-family: 'Times'">Normally
if Radiator searches for a user in the database and finds
one, but the users check items fail, Radiator
will then consult the DEFAULT user entry. However, if the
NoDefaultIfFound parameter is set, Radiator will
only look for a DEFAULT if there were no entries found in
the user database for the user.
</span></p>
</div>
</div>
</div>
<p><br>
</p>
<p>My suggestion is don't use it as you are trying to do.</p>
<p>cheers from Oz</p>
<p>Hugh<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 22/8/2023 17:38, Patrik Forsberg via
radiator wrote:<br>
</div>
<blockquote type="cite"
cite="mid:PRAP191MB206610BDA9F3C47A4CA51954961FA@PRAP191MB2066.EURP191.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal">I’m using the ”blacklist” knob in an authby
to reject people I don’t like
<span style="font-family:"Segoe UI
Emoji",sans-serif">😝</span><o:p></o:p></p>
<p class="MsoNormal">I had an issue this weekend where the user
“DEFAULT” was added to the list of users, for some reason, and
after that no one could login anymore.<o:p></o:p></p>
<p class="MsoNormal">After deleting this user all went back to
normal again ..<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Question.. is this a by design feature or
bug/flaw ?<o:p></o:p></p>
<p class="MsoNormal">Seems a bit odd that I can’t reject a user
by the name “DEFAULT” in a blacklist
<span style="font-family:"Segoe UI
Emoji",sans-serif">😊</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The AuthBy is an AuthBy SQL so the list of
users is in an mariadb table.<o:p></o:p></p>
<p class="MsoNormal">The authby looks like this
(username/password and so forth replaced)<o:p></o:p></p>
<p class="MsoNormal">“<o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:Consolas"><AuthBy
SQL><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
Identifier AuthenticateSQLBlacklist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
DBSource
dbi:<a class="moz-txt-link-freetext" href="MariaDB:database=db;host=host;port=3306">MariaDB:database=db;host=host;port=3306</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
DBUsername dbuser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
DBAuth dbauth<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
UsernameMatchesWithoutRealm<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
AuthSelect SELECT NULL FROM `blacklist` WHERE
BINARY `username` = ?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
AuthSelectParam %0<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
AuthColumnDef 0, User-Password, check<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas">
Blacklist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"></AuthBy><o:p></o:p></span></p>
<p class="MsoNormal">“<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;mso-ligatures:none">---<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;mso-ligatures:none">Best
Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;mso-ligatures:none">Patrik<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
radiator mailing list
<a class="moz-txt-link-abbreviated" href="mailto:radiator@lists.open.com.au">radiator@lists.open.com.au</a>
<a class="moz-txt-link-freetext" href="https://lists.open.com.au/mailman/listinfo/radiator">https://lists.open.com.au/mailman/listinfo/radiator</a></pre>
</blockquote>
</body>
</html>