(RADAR) new beta

[Mike McCauley]

Hi Thomas,

This one is due to a fix in 3.0. From the history file:

In AuthLog SQL SuccessQuery and FailureQuery did not quote the reason 
   string. %1 is now quoted and escaped. 

I will add some extra remarks to draw attention to it for the future. You 
will need to remove the quotes from around the %1 in your FailureQuery.

Cheers.

On Wed, 20 Mar 2002 11:08, Thomas Hartley/NCO/CEtv wrote:
> Mike,
>
> Here's another one;
>
> Using AuthLog SQL, since upgrading to 3beta, I am seeing this error;
>
> DBD::mysql::db do failed: You have an error in your SQL syntax near 'Bad
> Password'', '203.63.154.1', '', '53210241', '987654321')' at line 1 at
> Radius/SqlDb.pm line 218.
> DBD::mysql::db do failed: You have an error in your SQL syntax near 'Bad
> Password'', '203.63.154.1', '', '53210241', '987654321')' at line 1 at
> Radius/SqlDb.pm line 218.
> DBD::mysql::db do failed: You have an error in your SQL syntax near 'No
> such user'', '172.27.33.3', '', '40549041', '740337534')' at line 1 at
> Radius/SqlDb.pm line 218.
>
> Here's my FailureQuery;
>
>     FailureQuery insert into FAILLOG (USERNAME, REASON, NASIDENTIFIER,
> FRAMEDIPADDRESS, DNIS, CLID) \
>                 values ('%n', '%1', '%{NAS-IP-Address}',
> '%{Framed-IP-Address}', \
>                 '%{Called-Station-Id}', '%{Calling-Station-Id}')
>
>
>
> TH
>
>
>
> ------------------------------
> Thomas Hartley
> Senior ISP Systems Engineer
> Austar United Broadband
> Phone: +61 7 55606761
> thartley at austar.com.au
>
> http://www.austarnet.com.au
>
>
>
>
>
>                       Mike McCauley
>                       <mikem at open.com.a        To:       "Thomas
> Hartley/NCO/CEtv" <thartley at austar.com.au>, radar at open.com.au u>           
>            cc:
>                                                Subject:  Re: (RADAR) new
> beta 20/03/2002 09:56
>
>
>
>
>
>
> Hi Thomas,
>
> thanks for reporting this.
>
> Fixed.
>
> On Wed, 20 Mar 2002 10:35, Thomas Hartley/NCO/CEtv wrote:
> > Mike,
> >
> > Radiator 3 has compiled, tested and installed on the 'troublesome' host
> > from yesterday. Some early testing seemed ok, but...
> >
> > When I tried to drop the debug level, Radiator crashed with this error;
> >
> > [root at syd-dns1 Radiator-3.0beta]# kill -USR2 6870
> > [root at syd-dns1 Radiator-3.0beta]# Can't locate object method
>
> "adjustTrace"
>
> > via package "Radius::MonitorConnection" at Radius/Log.pm line 40.
> >
> > I was logged in with Radar when I did this, other then that, everything
>
> was
>
> > 'normal'
> >
> > The trace level was increased a few minutes earlier with no problem (but
> > Radar wasn't connected then)
> >
> >
> >
> > TH
> >
> > ------------------------------
> > Thomas Hartley
> > Senior ISP Systems Engineer
> > Austar United Broadband
> > Phone: +61 7 55606761
> > thartley at austar.com.au
> >
> > http://www.austarnet.com.au
> >
> >
> >
> >
> >
> >                       Mike McCauley
> >                       <mikem at open.com.a        To:
>
> radar at open.com.au
>
> >                       u>                       cc:
> >                       Sent by:                 Subject:  (RADAR) new beta
> >                       owner-radar at open.
> >                       com.au
> >
> >
> >                       19/03/2002 21:22
> >
> >
> >
> >
> >
> >
> > Hi Radar testers,
> >
> > Very quiet today.
> >
> > Did anyone not get my announcement about a new version of Radiator 3.0
>
> beta
>
> > and new Radar beta available today?

-- 
Mike McCauley                               mikem at open.com.au
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, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.open.com.au/archives/radar/
Announcements on radar-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radar' in the body of the message.