Hi Richard,

That doesnt look too good. What happens when you run the SQL command

insert into
RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
FramedAddress, NASPortType, ServiceType) values ('gut', '209.150.6.3', 517,
'33817274', 922070652, '209.150.16.71', '', 'Framed-User')

directly by mysql?


On Mar 22, 12:22pm, Richard Hawley wrote:
> Subject: Re: (RADIATOR) Console errors
> Sun Mar 21 21:44:12 1999: WARNING: SessSQL do failed for 'insert into
> RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
> FramedAddress, NASPortType, ServiceType) values ('gut', '209.150.6.3', 517,
> '33817274', 922070652, '209.150.16.71', '', 'Framed-User')': Got error -1
from
> table handler
> Sun Mar 21 21:44:29 1999: WARNING: SessSQL do failed for 'insert into
> RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
> FramedAddress, NASPortType, ServiceType) values ('fightbac', '209.150.6.3',
1294,
> '84738617', 922070669, '209.150.16.102', '', 'Framed-User')': Got error -1
from
> table handler
> Sun Mar 21 21:44:31 1999: WARNING: SessSQL do failed for 'insert into
> RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
> FramedAddress, NASPortType, ServiceType) values ('magnai', '209.150.6.5',
108,
> '0000057d', 922070671, '209.150.6.21', '', 'Framed-User')': Got error -1 from
table
> handler
> Sun Mar 21 21:44:39 1999: WARNING: SessSQL do failed for 'insert into
> RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
> FramedAddress, NASPortType, ServiceType) values ('dragontalon',
'209.150.6.3',
> 1801, '117965370', 922070679, '209.150.16.197', '', 'Framed-User')': Got
error -1
> from table handler
>
> As you can see, its happening every few seconds.
>
> ..Rich
>
> Mike McCauley wrote:
>
> > Hi Rich,
> >
> > On Mar 19, 12:36pm, Rich Hawley wrote:
> > > Subject: (RADIATOR) Console errors
> > > DBD::mysql::db do failed: Got error -1 from table handler at
> > > /usr/lib/perl5/site_perl/Radius/SessSQL.pm  line 103
> > >
> > > The radius logs show that the failure is happening when it tries to add
> > > an entry to the session database, but I'm not sure why that is failing.
> > > The radius.cfg file has the following session info.  The DBUsername and
> > > DBAuth is the same as the AuthBy section and that works, so I doubt its
> > > that.
> >
> > I havent seen that one before.
> >
> > It looks like an error thats been thrown back by mysql. It would be helpful
if
> > we could see the SQL query that caused this (you can see them by running
> > Radiator at a trace level of 4). We could then determine if Radiator has
sent a
> > bad query of if the problem originated in mysql.
> >
> > Is it happening all the time, or just occasionally?
> > What revisions of mysql, DBI and DBD-mysql are you running?
> >
> > Cheers.
> >
> > >
> > > <SessionDatabase SQL>
> > >         DBSource dbi:mysql:Radius
> > >         DBUsername ****
> > >         DBAuth ****
> > >         AddQuery \
> > >                 insert into RadiusSessions (UserName, NASIdent, NASPort,
> > > \
> > >                 AcctSessionID, TimeStamp, FramedAddress, NASPortType, \
> > >                ServiceType) values ('%n', '%N', %{NAS-Port},
> > > '%{Acct-Session-Id}', \
> > >                %{Timestamp}, '%{Framed-IP-Address}', '%{Port-Type}',
> > > '%{Service-Type}')
> > >        DeleteQuery \
> > >                 delete from RadiusSessions where UserName='%n' and \
> > >                 NASIdent='%N' and NASPort=%{NAS-Port}
> > >         ClearNasQuery \
> > >                 delete from RadiusSessions where NASIdent='%N'
> > >         CountQuery \
> > >                 select NASIdent, NASPort, AcctSessionID from
> > > RadiusSessions \
> > >                 where UserName='%n'
> > > </SessionDatabase>
> > >
> > >
> > >
> > > ===
> > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > 'unsubscribe radiator' in the body of the message.
> > >-- End of excerpt from Rich Hawley
> >
> > --
> > Mike McCauley                               [EMAIL PROTECTED]
> > Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> > 24 Bateman St Hampton, VIC 3188 Australia   Consulting and development
> > Phone, Fax: +61 3 9598-0985                 http://www.open.com.au
> >
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
> > ===
> > To unsubscribe, email '[EMAIL PROTECTED]' with
> > 'unsubscribe radiator' in the body of the message.
>
> --
> ------------------------------------
> Richard W. Hawley - Network Engineer
> CyberZone Internet Services
> http://www.cyberzone.net
> [EMAIL PROTECTED]
>
>
>
>-- End of excerpt from Richard Hawley



-- 
Mike McCauley                               [EMAIL PROTECTED]
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   Consulting and development
Phone, Fax: +61 3 9598-0985                 http://www.open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to