Hi again
What do you think about this:
accounting_start_query = "INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId,
UserName, Realm, NASIPAddress,
NASPortId, NASPortType, AcctStartTime, , AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, Acct
InputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAdd
ress, AcctStartDelay, AcctStopDelay) values('', '%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Real
m}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', to_date('%S', 'YYYY-MM-DD
HH24:MI:SS'), to_date('0001-01-01 01:01
:01', 'YYYY-MM-DD HH24:MI:SS') , '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0',
:'0', '%{Called-Station-Id}', '%{Calling
-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{Acct-Delay-Time}', '0')"
I'm really new in freeRadius. I don't know if the mentioned above instruction will
have some bad implications in some areas?
I mean using date '0001-01-01 01:01:01' instead of 0 in AcctStopTime column (in
starting accounting).
MM
-----Original Message-----
From: Mieczyslaw Maciejewski (EPO) [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 7:38 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle accounting
I was not precise, I meant:
"please comment if using to_date in "insert into radacct" will be OK for freeradius"
Another problem will arise with AcctStopTime equal to 0 during starting accounting, it
will not work with "to_date"
-----Original Message-----
From: Tim D. McCracken [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 7:27 PM
To: [EMAIL PROTECTED]
Subject: RE: Oracle accounting
'to_date' is an Oracle function for converting dates from strings in a
non-oracle
standard format. It is well documented in any Oracle reference manuals.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mieczyslaw
Maciejewski (EPO)
Sent: Friday, October 11, 2002 9:37 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle accounting
Thx
Could you comment using "to_date" in "INSERT into radacct.... "
instruction, please.
MM
-----Original Message-----
From: Mieczyslaw Maciejewski (EPO)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 4:16 PM
To: '[EMAIL PROTECTED]'
Subject: Oracle accounting
Solaris 8, freeradius 0.71.
I just edited sql.conf (for oracle accounting only purposes).
What I noticed: it doesn't work
When I changed SQL instruction from (I publish here only a fragment):
accounting_start_query = "INSERT into radacct (AcctStartTime) values('%S')"
Into instruction:
accounting_start_query = "INSERT into radacct (AcctStartTime )
values(to_date('%S', 'YYYY-MM-DD HH24:MI:SS'))"
then the data began to be written in table. For tests I use radius client
NTRadPing 1.2 for Windows. The client generates accounting requests.
I don't know if I made some mistake during ./configure?
I guess that %S means 'system time'. I didn't find explanation of %S in SQL
nor Unix shell documentation. Could you comment it, please?
Thanks
MM
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
