Re: (RADIATOR) Console errors
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,
> '057d', 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.
> >
> > >
> > >
> > > 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'
> > >
> > >
> > >
> > >
> > > ===
> > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > 'unsubscribe radiator' in the body of the message.
> > >-- End of excerpt from Rich Hawley
> >
> > --
> > Mike McCauley
Re: (RADIATOR) Console errors
Forgot to list the revisions. MySQL is 3.21.33c, for pc-linux-gnu (i686) DBI is 1.02 DBD-mysql is 1.2009 ..Rich Mike McCauley wrote: > Is it happening all the time, or just occasionally? > What revisions of mysql, DBI and DBD-mysql are you running? > > Cheers. > === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
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,
'057d', 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.
>
> >
> >
> > 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'
> >
> >
> >
> >
> > ===
> > 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. LtdUnix, 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.
Re: (RADIATOR) Console errors
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.
>
>
> 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'
>
>
>
>
> ===
> 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. LtdUnix, 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.
(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.
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'
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
