On Aug 3, 9:37am, Paul Black wrote:
> Subject: Radmin: Need to Create SessionDatabase
> I've got my Radmin up and running and would now like to get the
> SessionDatabase setup in Radiator so I can see who is online through Radmin.
> The problem is that I do not have a script or clear description of how to
> create the SessionDatabase tables. Can someone post the SQL which I will need
> to run in order to create the required tables or point me to the SQL in an
> online document?
Radmin installation automatically creates a table (RADONLINE) for use with
SessionDatabase SQL. All you should need to do is add this to your Radiator
config:
<SessionDatabase SQL>
# This database spec usually should be exactly the same
# as in <AuthBy RADMIN> above
DBSource dbi:mysql:radius
DBUsername mikem
DBAuth fred
</SessionDatabase>
where DBSource, DBUsername and DBAuth are the same as for your <AuthBy RADMIN>
clause.
Cheers.
>
> Regards. Paul
>
>
>
> PS The error message which I am getting in relation to the SessionDatabase
> is:
>
>
> Tue Aug 3 19:34:26 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
>
> Tue Aug 3 19:34:26 1999: DEBUG: Deleting session for XXXX, 203.63.235.10, 5
> Tue Aug 3 19:34:26 1999: DEBUG: do query is: delete from RADONLINE where
> NASIDENTIFIER='203.63.235.10' and NASPORT=5
>
> Tue Aug 3 19:34:26 1999: ERR: do failed for 'delete from RADONLINE where
> NASIDENTIFIER='203.63.235.10' and NASPORT=5': Table 'radius.RADONLINE'
doesn't
> exist
> Tue Aug 3 19:34:26 1999: ERR: do failed for 'delete from RADONLINE where
> NASIDENTIFIER='203.63.235.10' and NASPORT=5': Table 'radius.RADONLINE'
doesn't
> exist
> Tue Aug 3 19:34:26 1999: DEBUG: Handling with Radius::AuthRADMIN
> Tue Aug 3 19:34:26 1999: DEBUG: do query is: insert into RADMESSAGES
> (TIME_STAMP, TYPE, MESSAGE)
> values (933672866, 4, 'Handling with Radius::AuthRADMIN')
>
> Tue Aug 3 19:34:26 1999: DEBUG: Handling accounting with Radius::AuthRADMIN
> Tue Aug 3 19:34:26 1999: DEBUG: do query is: insert into RADMESSAGES
> (TIME_STAMP, TYPE, MESSAGE)
> values (933672866, 4, 'Handling accounting with Radius::AuthRADMIN')
>
> Tue Aug 3 19:34:26 1999: DEBUG: do query is: update RADUSERS set
> TIMELEFT=TIMELEFT-0362, OCTETSINLEFT=OCTETSINLEFT-068324,
> OCTETSOUTLEFT=OCTETSOUTLEFT-0316183 where USERNAME='jXXXX'
>
>
>
>-- End of excerpt from Paul Black
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
