I get a 0.
The other way to fix this would be make sure that
%{NAS-Port} is never undef or an empty string when
the SQL template statements are used.
On Thu, 10 Jun 1999, Mike McCauley wrote:
> On Jun 9, 1:41am, James H. Thompson wrote:
> > Subject: Re: SessSQL errors, was: No Subject
> > Fix seems to be working for me.
> > I'm using Mysql
>
> So, when it inserts '' for that integer, do you actually get a NULL in the
> database or a 0?
>
> Cheers.
>
> >
> > On Wed, 9 Jun 1999, Mike McCauley wrote:
> >
> > > 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
> > >
> > >
> >
> > Jim
> > [EMAIL PROTECTED]
> >
> >
> >-- 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
>
>
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.
