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
