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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

begin:vcard 
n:Laan;Dirk
tel;work:020-5497967
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Dirk Laan
end:vcard

Reply via email to