At 19.59 11/10/02, you wrote:
>I'll confess that I know more about Oracle than free-radius at this time (I
>am just now setting up free-radius) however, I suspect that to_date is not
>being evaluated by FreeRadius, only by Oracle. However, the format provided
>to 'to_date' must match the format
erly.
Hope this helps. If not, I'll just defer to Alan.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mieczyslaw
Maciejewski (EPO)
Sent: Friday, October 11, 2002 12:38 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle accounting
I was not pre
n 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) [ma
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 man
nt: 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]]
S
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 acco
<[EMAIL PROTECTED]> wrote:
> 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?
It's a macro/variable defined by the server.
See: doc/variables.txt
Alan DeKok.
-
List info/subscribe/unsubscribe? See h
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'
