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?


> <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.

Reply via email to