(RADIATOR) No such user

[Dirk Laan]

Hello Lisa,

The problem is that it looks for a realm, no realm is found so the user default
is used.
We also use radmin with postgres instead of mysql.
We don't use Realms, so we've left it out.
I think you've at least the following in the config file:

<AuthBy RADMIN>

        DBSource        dbi:mysql:radmin:localhost
        DBUsername    radmin
        DBAuth            radminpw

   AuthSelect select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS, MAXIDLETIME
from RADUSERS where USERNAME = '%n' and BADLOGINS < 5 and VALIDFROM < %t and
VALIDTO > %t

        AuthColumnDef 0, Idle-Timeout,reply

        AddToReply Service-Type=Framed-User, Framed-Protocol=PPP
</AuthBy>

Regards,

Dirk Laan

Lisa Goulet schreef:

> Hi,
>
> I'm testing a customer's radmin/mysql setup with fully licensed software.
> I've verified the user and password with mysql queries. I'm using the
> goodies/radmin.cfg file and testing with radpwtst. There is a query in the
> logfile with USERNAME='DEFAULT' resulting in "No such user".
>
> I appreciate any help.
>
> Regards,
> Lisa
>
> *** Received from 127.0.0.1 port 1025 ....
> Code:       Access-Request
> Identifier: 126
> Authentic:  1234567890123456
> Attributes:
>         User-Name = "rico"
>         Service-Type = Framed-User
>         NAS-IP-Address = xx.xx.xx.xx
>         NAS-Port = 1234
>         Called-Station-Id = "123456789"
>         Calling-Station-Id = "987654321"
>         NAS-Port-Type = Async
>         User-Password =
> "<139><226><<194><175>\<4><246><188>8<9><160><216>}x<153>"
>
> Tue Jul 31 17:18:51 2001: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Tue Jul 31 17:18:51 2001: DEBUG:  Deleting session for rico, 203.63.154.1,
> 1234
> Tue Jul 31 17:18:51 2001: DEBUG: do query is: delete from RADONLINE where
> NASIDENTIFIER='203.63.154.1' and NASPORT=01234
>
> Tue Jul 31 17:18:51 2001: DEBUG: do query is: insert into RADMESSAGES
> (TIME_STAMP, TYPE, MESSAGE) values (996614331, 4, 'Handling with
> Radius::AuthRADMIN')
>
> Tue Jul 31 17:18:51 2001: DEBUG: do query is: insert into RADMESSAGES
> (TIME_STAMP, TYPE, MESSAGE) values (996614331, 4, 'Handling with
> Radius::AuthRADMIN')
>
> Tue Jul 31 17:18:51 2001: DEBUG: Query is: select PASS_WORD, STATICADDRESS,
> TIMELEFT, MAXLOGINS from RADUSERS where USERNAME='rico' and BADLOGINS < 5
> and VALIDFROM < 996614331 and VALIDTO > 996614331
>
> Tue Jul 31 17:18:51 2001: DEBUG: do query is: insert into RADMESSAGES
> (TIME_STAMP, TYPE, MESSAGE) values (996614331, 4, 'Radius::AuthRADMIN looks
> for match with rico')
>
> Tue Jul 31 17:18:51 2001: DEBUG: Query is: select PASS_WORD, STATICADDRESS,
> TIMELEFT, MAXLOGINS from RADUSERS where USERNAME='DEFAULT' and BADLOGINS < 5
> and VALIDFROM < 996614331 and VALIDTO > 996614331
>
> Tue Jul 31 17:18:51 2001: INFO: Access rejected for rico: No such user
> Tue Jul 31 17:18:51 2001: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 1025 ....
> Code:       Access-Reject
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010731/1ebae601/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: d.laan.vcf
Type: text/x-vcard
Size: 142 bytes
Desc: Kaart voor Dirk Laan
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010731/1ebae601/attachment.vcf>