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]
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
