--- Forwarded mail from [EMAIL PROTECTED]
Date: Wed, 22 Nov 2000 04:10:34 +1100 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["marc"
<[EMAIL PROTECTED]>]
>From mikem Wed Nov 22 04:10:30 2000
Received: by oscar.open.com.au (8.9.0/8.9.0) id EAA27461
for [EMAIL PROTECTED]; Wed, 22 Nov 2000 04:10:29 +1100 (EST)
>Received: from lh04.opsion.fr (lh04.opsion.fr [212.73.208.230]) by
perki.connect.com.au with SMTP id DAA09929
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Wed, 22 Nov 2000 03:46:09 +1100
(EST)
Received: from lh04.opsion.fr (lh04.opsion.fr [212.73.208.230]) by
perki.connect.com.au with SMTP id DAA09929
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Wed, 22 Nov 2000 03:46:09 +1100
(EST)
Received: from 62.161.120.241 [62.161.120.241] by lh04.opsion.fr; Tue, 21 Nov
2000 16:46:57 GMT
From: "marc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: problem with RADONLINE : don't adding, just delete
Date: Tue, 21 Nov 2000 17:44:58 +0100
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Importance: Normal
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_005E_01C053E2.C44849C0"
C'est un message de format MIME en plusieurs parties.
------=_NextPart_000_005E_01C053E2.C44849C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
hi
I use Radiator 2.16.3 with mysql and RedBack SMS
I want to know who are connecting at one time so I configure <Session
Database SQL> like this :
<SessionDatabase SQL>
DBAuth test
DBSource dbi:mysql:radius
DBUsername root
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and
NASPORT=0%{NAS-Port};
Identifier online
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, SERVICETYPE) values ('%u',
'%N', 0%{NAS-Port}, '%{Acct-Session-Id}','%{Timestamp}',
'%{Framed-IP-Address}', '%{Service-Type}')
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where
NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from
RADONLINE where USERNAME='%u'
</SessionDatabase>
and <Auth By> like this :
<Realm Default>
AcctLogFileName /home/httpd/cgi-bin/detail
#AuthByPolicy ContinueWhileIgnore
SessionDatabase online
<AuthBy SQL>
DBAuth test
DBSource dbi:mysql:radius
DBUsername root
DynamicReply RB-PPPOE-URL
DynamicReply RB-Context-Name
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS
where USERNAME='%n'
</AuthBy>
</Realm>
and when I look at log with (Trace 4)
I have just a delete :
DEBUG: online Deleting session for marc@marco, 10.0.2.2, 117440514
DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.0.2.2' and
NASPORT=0117440514;
and no adding
is someone can help me ?????????
------=_NextPart_000_005E_01C053E2.C44849C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000>hi</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>I use =
Radiator=20
2.16.3 with mysql and RedBack SMS</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>I want =
to know who=20
are connecting at one time so I configure <Session Database SQL> =
like this=20
:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000><EM><SessionDatabase=20
SQL><BR> DB=
Auth=20
test<BR> DBSource=20
dbi:mysql:radius<BR>  =
;=20
DBUsername=20
root<BR> Delet=
eQuery=20
delete from RADONLINE where NASIDENTIFIER=3D'%N' and=20
NASPORT=3D0%{NAS-Port};<BR> &nbs=
p; =20
Identifier online</EM></SPAN></FONT></DIV>
<DIV><EM><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000> &nbs=
p; AddQuery=20
insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID,=20
TIME_STAMP, FRAMEDIPADDRESS, SERVICETYPE) values =
('%u',=20
'%N', 0%{NAS-Port}, '%{Acct-Session-Id}','%{Timestamp}',=20
'%{Framed-IP-Address}', =20
'%{Service-Type}')<BR> &nb=
sp;=20
ClearNasQuery delete from RADONLINE where=20
NASIDENTIFIER=3D'%N'<BR> &=
nbsp;=20
CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where=20
NASIDENTIFIER=3D'%N'<BR> &=
nbsp;=20
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE =
where=20
USERNAME=3D'%u'<BR></SPAN></FONT><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SessionDatabase> &nbs=
p;  =
; =
&=
nbsp; &n=
bsp; &nb=
sp; =20
</SPAN></FONT></EM></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>and =
<Auth By>=20
like this :</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D137272916-21112000><EM><Realm=20
Default><BR> AcctLogFileName =
/home/httpd/cgi-bin/detail<BR> =20
#AuthByPolicy ContinueWhileIgnore<BR> SessionDatabase =
online<BR><AuthBy=20
SQL><BR> DBAuth=20
test<BR> DBSource=20
dbi:mysql:radius<BR> =
DBUsername=20
root<BR> DynamicReply=20
RB-PPPOE-URL<BR> DynamicReply=20
RB-Context-Name<BR> </EM><=
/SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D137272916-21112000></SPAN></FONT><FONT=20
face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000><EM> =
=20
AccountingTable ACCOUNTING<BR> =
AcctColumnDef =
USERNAME,User-Name<BR> =20
AcctColumnDef=20
TIME_STAMP,Timestamp,integer<BR>  =
;=20
AcctColumnDef=20
ACCTSTATUSTYPE,Acct-Status-Type<BR> &n=
bsp;=20
AcctColumnDef=20
ACCTDELAYTIME,Acct-Delay-Time,integer<BR> &n=
bsp; =20
AcctColumnDef=20
ACCTINPUTOCTETS,Acct-Input-Octets,integer<BR> &nbs=
p; =20
AcctColumnDef=20
ACCTOUTPUTOCTETS,Acct-Output-Octets,integer<BR> &n=
bsp; =20
AcctColumnDef=20
ACCTSESSIONID,Acct-Session-Id<BR> &nbs=
p;=20
AcctColumnDef=20
ACCTSESSIONTIME,Acct-Session-Time,integer<BR> &nbs=
p; =20
AcctColumnDef=20
ACCTTERMINATECAUSE,Acct-Terminate-Cause<BR> =
=20
AcctColumnDef=20
NASIDENTIFIER,NAS-Identifier<BR>  =
;=20
AcctColumnDef=20
NASPORT,NAS-Port,integer<BR> =20
AcctColumnDef=20
FRAMEDIPADDRESS,Framed-IP-Address<BR> =
=20
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where=20
USERNAME=3D'%n'<BR> <BR>&n=
bsp; =20
</AuthBy><BR></Realm></EM>  =
; =
&=
nbsp; &n=
bsp; &nb=
sp; &nbs=
p;  =
; </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D137272916-21112000> and when I=20
look at log with (Trace 4)</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>I have =
just a delete=20
:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D137272916-21112000><EM>DEBUG: online=20
Deleting session for </EM><A=20
href=3D"mailto:marc@marco"><EM>marc@marco</EM></A><EM>, 10.0.2.2,=20
117440514<BR>DEBUG: do query is: delete from RADONLINE where=20
NASIDENTIFIER=3D'10.0.2.2' and =
NASPORT=3D0117440514;</EM></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D137272916-21112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>and no =
adding</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D137272916-21112000>is =
someone can help=20
me ?????????</SPAN></FONT></DIV></BODY></HTML>
------=_NextPart_000_005E_01C053E2.C44849C0--
______________________________________________________________________________
Vous avez un site perso ?
2 millions de francs � gagner sur i(france) !
Webmasters : ZE CONCOURS ! http://www.ifrance.com/_reloc/concours.emailif
---End of forwarded mail from [EMAIL PROTECTED]
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
