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=01234Tue 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 > 996614331Tue 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 > 996614331Tue 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
