I just downloaded the latest Radiator and 
setup the session sql db with mysql.
We have a Nortel Aptis terminal server.
It all works great except for the admin user that is telneting
into the box has no port ID and I get the following errors in
the radiator log whenever this user logs into the box:

Tue Jun  8 01:10:02 1999: ERR: do failed for 'insert into RADONLINE
(USERNAME, N
ASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORTTYPE,
SERVICETYPE) values ('admin', '209.144.212.11', , '08002DEA', 928829402,
'', '',
 'Administrative-User')': parse error near ' '08002DEA', 928829402, '',
'', 'Adm
inistrative-User')' at line 1
DBD::mysql::db do failed: parse error near '' at line 1 at
/usr/lib/perl5/site_p
erl/5.005/Radius/SqlDb.pm line 189.
Tue Jun  8 01:10:02 1999: ERR: do failed for 'delete from RADONLINE where
NASIDE
NTIFIER='209.144.212.11' and NASPORT=': parse error near '' at line 1


I think these errors are caused because in:

        SessSQL.pm

in sub initialize {
The SQL statements that get defined do not have enclosing 
single quotes around: %{NAS-Port}
i.e.

        %{NAS-Port} needs to be '%{NAS-Port}'

in the insert and delete statements.


While this is easily worked around by updating the source
or definations in the radius.cfg file.  It seems like
it should be fixed in the distribution.

Thanks.

Jim
[EMAIL PROTECTED]



===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to