(RADIATOR) No such user ?

Mon Jun 25 04:18:38 CDT 2001

Hi Hugh,

It's ok when I run query via Query Analyzer.  So,  I suspect that maybe
our Radmin host is expired ( I installed  Radmin on 25/5/2001 ).  And
that's why I cannot login  . Am I right?

Regards,
Chairath

Hugh Irvine wrote:

> Hello Chairarth - What happens when you issue the same query on the
> Database host? And have you verified the contents of the RADUSERS
> table? regards Hugh   At 1:27 PM +0700 6/25/01, chairarth wrote:
>
>> Hi ,
>> Today I wonder why I cann't logon any user on Radmin Database .  In
>> log file always show   "No such user"
>> .   I'm very sure that Radiator and Radmin host can connect to
>> Database host .
>> Can someone tell me what 's wrong ?
>
>> Thanks,
>> Chairath
>
>> --------------------------------------------- Log File
>> -----------------------------------------------
>
>> Mon Jun 25 10:55:48 2001: DEBUG: Packet dump:
>> *** Received from 10.2.0.1 port 49152 ....
>> Code:       Access-Request
>> Identifier: 20
>> Authentic:  <0><0>e<161><0><0>7/<0><0>`<20><0><0>u<178>
>> Attributes:
>>  User-Name = "david"
>>  User-Password =
>> "<186>e<128><206>L<30>n<223><183><174>G<209>r<13><166><216>"
>>  Acct-Session-Id = "56000e27"
>>  NAS-IP-Address = 10.10.0.2
>>  Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(17)"
>>  Service-Type = Framed-User
>>  Framed-Protocol = PPP
>>  Calling-Station-Id = "ldc_12200000069"
>>  NAS-Port = 1644167237
>
>> Mon Jun 25 10:55:48 2001: DEBUG: Handling request with Handler
>> 'Realm=DEFAULT'
>> Mon Jun 25 10:55:48 2001: DEBUG:  Deleting session for david,
>> 10.10.0.2, 1644167237
>> Mon Jun 25 10:55:48 2001: DEBUG: do query is: delete from RADONLINE
>> where
>> NASIDENTIFIER='10.10.0.2' and NASPORT=01644167237
>
>> Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into
>> RADMESSAGES (TIME_STAMP, TYPE,
>> MESSAGE) values (993441348, 4, 'Handling with Radius::AuthRADMIN')
>
>> Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into
>> RADMESSAGES (TIME_STAMP, TYPE,
>> MESSAGE) values (993441348, 4, 'Handling with Radius::AuthRADMIN')
>
>> Mon Jun 25 10:55:48 2001: DEBUG: Query is: select PASS_WORD,
>> STATICADDRESS, TIMELEFT,
>> MAXLOGINS from RADUSERS where USERNAME='david' and BADLOGINS < 5 and
>> VALIDFROM <
>> 993441348 and VALIDTO > 993441348
>
>> Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into
>> RADMESSAGES (TIME_STAMP, TYPE,
>> MESSAGE) values (993441348, 4, 'Radius::AuthRADMIN looks for match
>> with david')
>
>> Mon Jun 25 10:55:48 2001: DEBUG: Query is: select PASS_WORD,
>> STATICADDRESS, TIMELEFT,
>> MAXLOGINS from RADUSERS where USERNAME='DEFAULT' and BADLOGINS < 5
>> and VALIDFROM <
>> 993441348 and VALIDTO > 993441348
>
>> Mon Jun 25 10:55:48 2001: INFO: Access rejected for david: No such
>> user
>> Mon Jun 25 10:55:48 2001: DEBUG: Packet dump:
>> *** Sending to 10.2.0.1 port 49152 ....
>> Code:       Access-Reject
>> Identifier: 20
>> Authentic:  <0><0>e<161><0><0>7/<0><0>`<20><0><0>u<178>
>> Attributes:
>>  Reply-Message = "Request Denied"
>
>> ------------------------------------------- Configuration File
>> -------------------------------------------
>> Foreground
>> LogStdout
>> LogDir  d:/Radiator-Demo-2.18/log
>> DbDir  d:/Radiator-Demo-2.18
>> LogFile %L/logfile-%d-%m-%Y
>
>> # Dont turn this up too high, since all log messages are logged
>> # to the RADMESSAGES table in the database. 3 will give you
>> everything
>> # except debugging messages
>> Trace 4
>
>> # You will probably want to change this to suit your site.
>> # You should list all the clients you have, and their secrets
>> # If you are using the Radmin Clients table, you wil probably
>> # want to disable this.
>> #<Client DEFAULT>
>> # Secret mysecret
>> # DupInterval 0
>> #</Client>
>
>> # You can put additonal (or all) client details in your Radmin
>> # database table
>> # and get their details from there with something like this:
>> # You can then use the Radmin 'Add Radius Client' to add new
>> clients.
>> <ClientListSQL>
>>  DBSource dbi:ODBC:xxx
>>  DBUsername xxx
>>  DBAuth  xxx
>> </ClientListSQL>
>
>> #<AuthBy RADIUS>
>> # Identifier ProxyTofunk
>> # Host xxx
>> # Secret test
>> #</AuthBy>
>
>> #<Realm funk>
>> # strip Realm
>> # RewriteUsername s/^([^@]+).*/$1/
>> # AuthBy ProxyTofunk
>> #</Realm>
>
>> # Handle everyone with RADMIN
>> <Realm DEFAULT>
>>  <AuthBy RADMIN>
>>   # Change DBSource, DBUsername, DBAuth for your database
>>   # See the reference manual. You will also have to
>>   # change the one in <SessionDatabse SQL> below
>>   # so its the same
>
>>   DBSource dbi:ODBC:xxx
>>   DBUsername xxx
>>   DBAuth  xxx
>>   DateFormat %e %m  %Y %T
>>   # You can add to or change these if you want, but you
>>   # will probably want to change the database schema first
>>   AccountingTable RADUSAGE
>>   AcctColumnDef USERNAME,User-Name
>>   AcctColumnDef TIME_STAMP,Timestamp,integer
>>   AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer
>>   AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
>>   AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
>>   AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
>>   AcctColumnDef ACCTSESSIONID,Acct-Session-Id
>>   AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
>>   AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer
>>   AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
>>   AcctColumnDef NASIDENTIFIER,NAS-Identifier
>>   AcctColumnDef NASIDENTIFIER,NAS-IP-Address
>>   AcctColumnDef NASPORT,NAS-Port,integer
>>   AcctColumnDef DNIS,Called-Station-Id
>>   AcctColumnDef DATE,Timestamp,integer-date
>>   # This updates the time and octets left
>>   # for this user
>>   AcctSQLStatement update RADUSERS set
>> TIMELEFT=TIMELEFT-0%{Acct-Session-Time},
>> OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
>> OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} where
>> USERNAME='%n'
>
>>   # These are the classic things to add to each users
>>   # reply to allow a PPP dialup session. It may be
>>   # different for your NAS. This will add some
>>   # reply items to everyone's reply
>>   AddToReply Framed-Protocol = PPP,\
>>    Service-Type = Framed-User,\
>>           Framed-IP-Netmask = 255.255.255.255,\
>>           Framed-Routing = None,\
>>           Framed-MTU = 1500,\
>>    Framed-Compression = Van-Jacobson-TCP-IP,\
>>    Idle-Timeout = 600
>>  </AuthBy>
>> </Realm>
>
>> <SessionDatabase SQL>
>>  # This database spec usually should be exactly the same
>>  # as in <AuthBy RADMIN> above
>>  DBSource dbi:ODBC:xxx
>>  DBUsername xxx
>>  DBAuth  xxx
>>  ClearNasQuery
>> </SessionDatabase>
>
>> # You can also set up an address pool for Radiator to manage.
>> # The standard Radmin tables include a RADPOOL address pool table.
>> # see the example in addressallocator.cfg
>
>> --
>
>> NB: I am travelling this week, so there may be delays in our
>> correspondence.
>
>>  
>> Radiator: the most portable, flexible and configurable RADIUS server
>>
>> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>>
>> Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
>
> Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010625/65350801/attachment.html>