Hi James,
thanks for telling us about this, and the proposed fix. Trouble is that Im not
sure that fix will work for _all_ SQL servers. Does it work for yours? What
type of SQL are you using?

Cheers.

On Jun 8,  8:24pm, James H. Thompson wrote:
> Subject:
> 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.
>-- End of excerpt from James H. Thompson



-- 
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.

Reply via email to