(RADIATOR) <SessionDatabase SQL>

[Mike McCauley]

--- Forwarded mail from owner-radiator at open.com.au

Date: Wed, 16 May 2001 12:12:59 -0500
From: owner-radiator at open.com.au
To: radiator-approval at open.com.au
Subject: BOUNCE radiator at open.com.au:    Non-member submission from ["Mariano
Absatz" <baby at baby.com.ar>]

>From mikem at server1.open.com.au Wed May 16 12:12:55 2001
Received: from dedos.pert.com.ar (dedos.pert.com.ar [200.49.76.34])
	by server1.open.com.au (8.11.0/8.11.0) with ESMTP id f4GHCr404624;
	Wed, 16 May 2001 12:12:55 -0500
Received: from cosa.intranet.pert.com.ar ([192.168.1.10]:24584 "EHLO COSA"
	whoson: "popbaby") by dedos.pert.com.ar with ESMTP
	id <S34932AbREPTJk> convert rfc822-to-8bit; Wed, 16 May 2001 16:09:40
-0300
From: "Mariano Absatz" <baby at baby.com.ar>
To: Hugh Irvine <hugh at open.com.au>
Date: 	Wed, 16 May 2001 16:09:57 -0300
MIME-Version: 1.0
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: 8BIT
Subject: Re: (RADIATOR) <SessionDatabase SQL>
CC: Radiator List <radiator at open.com.au>
Message-ID: <3B02A655.16270.39C03238 at localhost>
Priority: normal
In-reply-to: <a04320407b728237d40c9@[202.151.220.5]>
References: <3B011628.8566.33A4EC07 at localhost>
X-mailer: Pegasus Mail for Win32 (v3.12c)

El 16 May 2001, a las 22:40, Hugh Irvine escribió:

> >
> >So now I have it working, now for the "theoretical" part of the question,
> >if I had a radius attribute with an arbitrary date-time in it (say, the
> >birthday -and time- of the nas manufacturer's mother) and I would like to
> >put it in a column in my on-line users database, what would be the idiom
> >to do it so?. That is I understand (I think) how to put it in an
> >accounting database by means of a
> >
> >AcctColumnDef   DB_COLUMN,Radius-Attribute-Name,integer-date, \
> >                 TO_DATE('%Y-%m-%d %H:%M:%S', 'YYYY-MM-DD HH24:MI:SS')
> >
> >but in the AddQuery (or AnythingQuery) I don't know how to use Radius-
> >Attribute-Name here.
>
> For this you would have to write some code - probably in a hook. But
> again, you need to understand if you are dealing with a numeric
> number of seconds (as above), or whether you just have some string
> that happens to represent a date in some ASCII format as you describe
> for your database. They are very different representations of
> (possibly) the same thing.
>

The point is, I have a numeric attribute representing an epoch, if I want
to insert it into a database like oracle where the date is represented as
something else, I have to translate the epoch to a string in a hook (e.g.
generating a fake attribute) and then I can insert it as TO_DATE(%{My-New-
Attr},'YYYY-MM-DD HH24:MI:SS')?

In this hook, do I have a function to use the date formatting characters
from section 6.3 in the manual?


--
Mariano Absatz - El Baby
mailto:baby at baby.com.ar
http://www.baby.com.ar/
    PGP KEYS: http://www.baby.com.ar/datos/personales.html#claves_pgp
  |\  _
  _\\/'>     Powered by Pegasus Mail
 /|__)       http://www.pmail.com
  ) )\
-----------------------------------------------------------
Double your drive space - delete Windows!



---End of forwarded mail from owner-radiator at open.com.au

-- 
Mike McCauley                               mikem at open.com.au
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.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.