(RADIATOR) Platypus and Radiator

Daniel Lowe daniel at mcs.net.au
Thu Jun 14 19:15:36 CDT 2001


Can someone please help

I am currently trying to set up a MAX 3000 unit to do it's authentication via radiator running on an NT4 box. We also use platypus ISP version 3.0 (build 582-pu).
I have used the example platypus.cfg file in the goodies directory to get started. When trying to dial into the max, radiator gives out the following error;

Fri Jun 15 09:54:52 2001: INFO: Server started: Radiator 2.18.1 on server.mcs.net.au (DEMO)
Fri Jun 15 09:56:12 2001: DEBUG: Packet dump:
*** Received from 210.8.26.6 port 1026 ....
Code:       Accounting-Request
Identifier: 220
Authentic:  C<0><195><144>T<229>W-<236>c<187>9<223><251><142>>
Attributes:
 NAS-IP-Address = 210.8.26.6
 NAS-Port = 20108
 NAS-Port-Type = Async
 Acct-Status-Type = Stop
 Acct-Delay-Time = 0
 Acct-Session-Id = "361110318"
 Ascend-Disconnect-Cause = sessFailSecurity
 Ascend-Connect-Progress = prIPNCPOpened
 Ascend-Xmit-Rate = 50667
 Ascend-Data-Rate = 28800
 Ascend-PreSession-Time = 35
 Ascend-Pre-Input-Octets = 257
 Ascend-Pre-Output-Octets = 252
 Ascend-Pre-Input-Packets = 12
 Ascend-Pre-Output-Packets = 13
 Ascend-Modem-PortNo = 27
 Ascend-Modem-SlotNo = 2
 Called-Station-Id = "49694000"

Fri Jun 15 09:56:12 2001: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Fri Jun 15 09:56:12 2001: DEBUG:  Deleting session for , 210.8.26.6, 20108
Fri Jun 15 09:56:12 2001: DEBUG: do query is: insert into radiusdat 
            (username, callstart, callend, sessid ) 
            values ('', 'Jun 15, 2001 09:56', 'Jun 15, 2001 09:56', 
                    '361110318' )

Fri Jun 15 09:56:12 2001: ERR: do failed for 'insert into radiusdat 
            (username, callstart, callend, sessid ) 
            values ('', 'Jun 15, 2001 09:56', 'Jun 15, 2001 09:56', 
                    '361110318' )': [Microsoft][ODBC SQL Server Driver][SQL Server]View 'radiusdat' is not updatable because a column of the view is derived or constant. (SQL-37000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Fri Jun 15 09:56:12 2001: ERR: do failed for 'insert into radiusdat 
            (username, callstart, callend, sessid ) 
            values ('', 'Jun 15, 2001 09:56', 'Jun 15, 2001 09:56', 
                    '361110318' )': [Microsoft][ODBC SQL Server Driver][SQL Server]View 'radiusdat' is not updatable because a column of the view is derived or constant. (SQL-37000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Fri Jun 15 09:56:12 2001: DEBUG: do query is: update appdata set date='Jun 15, 2001 09:56' 
                  where name='Last Radius'

Fri Jun 15 09:56:13 2001: DEBUG: Accounting accepted
Fri Jun 15 09:56:13 2001: DEBUG: Packet dump:
*** Sending to 210.8.26.6 port 1026 ....
Code:       Accounting-Response
Identifier: 220
Authentic:  C<0><195><144>T<229>W-<236>c<187>9<223><251><142>>
Attributes:

Looking into the platypus database there is no radiusdat table that I can see

This is my current cfg file

#plat.cfg

Foreground
LogStdout
Trace 4
AuthPort 1645
AcctPort 1646
LogDir  .
DbDir  .

#<Log EMERALD>
# DBSource dbi:ODBC:Radiator
# DBUsername xxxxx
# DBAuth  xxxxx
#</Log>


<Client 210.8.26.6>
 Secret xxxxx
 DupInterval 0
</Client>

<Realm DEFAULT>
 <AuthBy PLATYPUS>
  # Change DBSource, DBUsername, DBAuth for your database
  # See the reference manual
  DBSource dbi:ODBC:Radiator
  DBUsername xxxxxx
  DBAuth  xxxxx

  # The basic PLATPYPUS module will 
  # insert values for 
  #    username, callstart, callend, sessid 
  # into the table 'radiusdat'
  # You can log additional data from each Stop by
  # adding AcctColumnDef lines like this, if you
  # have additional columns in your accounting table
  # As an example, here are some additional fields 
  # that you might have added by following the 
  # Instructions in the Platypus Help file under
  # 'Importing Additional Radius Information'
  #
  #AcctColumnDef data_in,Acct-Input-Octets,integer
  #AcctColumnDef data_out,Acct-Output-Octets,integer
  #AcctColumnDef ipaddress,Framed-IP-Address

  # You can optionally fetch your own 
  # additional columns from the user
  # database when you fetch the password
  # in a similar way to AuthSQL. In this
  # example, you define an additional column in the
  # customer table called
  # maxsessions, which (if not NULL) will be used to
  # set Simultaneous-Use for the user. AuthSelect
  # is the SQL required to select _additional_ columns
  # from customer, so the comma is required
#  AuthSelect ,maxsessions
#  AuthColumnDef 0,Simultaneous-Use,check


 </AuthBy>
 # If you also need to add extra check and reply items,
 # Platypus has a RadiusNT compatibility package
 # that does allow you to set up per-user and per-service
 # reply items. If you want to use that, then you
 # should use AuthBy EMERALD instead. See emerald.cfg
 # If you dont want to use it, you can put generic check and
 # reply items in a separate users file:
# AuthByPolicy ContinueWhileAccept
# <AuthBy FILE>
#  # Put a DEFAULT user in the file with the extra
#  # check and reply items you want applied to all users.
#  # You could also
#  # add user-specific check and reply items if you want.
#  Filename <whatever it is>
# </AuthBy>
</Realm>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010615/2c605932/attachment.html>


More information about the radiator mailing list