<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Mensaje</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=376361015-18032008><FONT face=Arial size=2>Hi
everybody,</FONT></SPAN></DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial size=2>i have one question
to the list, not very simple:</FONT></SPAN></DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial size=2>investigating a
performance problem on the SQL database that is running the session database for
radiator, we have seen the following sql statements:</FONT></SPAN></DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=376361015-18032008><FONT face=Arial size=2>080318
16:08:47 2
Query delete from RADONLINE where
NASIDENTIFIER='XX.XX.XX.XX' and ACCTSESSIONID=''</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=376361015-18032008>this query is
repeating hundres per hour. We have confirmed that all the packets have the
Acct-Session-ID on the request.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=376361015-18032008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=376361015-18032008>I have Radiator 3.8
on Linux, with Perl 5.8.3. My config for the SQL session database
is:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=376361015-18032008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=376361015-18032008><SessionDatabase
SQL><BR>
AddQuery
insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID,
TIMESTAMP, FRAMEDIPADDRESS, PORTLIMIT, REALM) values ('%n', '%N', '%{NAS-Port}',
'%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}', '%{Port-Limit}',
'%R')<BR>
ClearNasQuery delete
from RADONLINE where
NASIDENTIFIER='%N'<BR>
CountQuery
select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE where
USERNAME='%n'<BR>
DeleteQuery
delete from RADONLINE where NASIDENTIFIER='%N' and
ACCTSESSIONID='%{Acct-Session-Id}'<BR>
DBSource
dbi:mysql:auth:192.168.116.102:3306<BR>
DBSource
dbi:mysql:auth:192.168.116.105:3306<BR>
DBUsername
auth<BR>
DBAuth
auth2134<BR>
FailureBackoffTime
10<BR>
Timeout
30<BR>
Identifier
SDB1<BR></SessionDatabase></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=376361015-18032008>Anybody knows why is
it happening?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=376361015-18032008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=376361015-18032008>Thanks
all.</SPAN></FONT></DIV><DIV><FONT face=Arial color=green><SPAN style='COLOR: green; FONT-FAMILY: Arial'>Antes de imprimir este e-mail piense bien si es necesario hacerlo</SPAN></FONT><FONT face=Arial color=green size=1><SPAN style='FONT-SIZE: 7.5pt; COLOR: green; FONT-FAMILY: Arial'>.</SPAN></FONT><FONT face=Webdings color=green size=5></FONT><br><br><HR><b>Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningun sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electronico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepcion. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilizacion del correo electronico via Internet y la grabacion de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinion expresada en este mensaje pertenece unicamente al autor remitente, y no representa necesariamente la opinion de JAZZTEL, a no ser que expresamente se diga y el remitente este autorizado para hacerlo.<br><br><HR><br>This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so. <b><HR></BODY></HTML>