Hi,
Thanks for the information. Another question before trying on-air, i have
checked the date format in Oracle8 and it is DATE format. Which is date
only. It does not include time. Am I right? When I look at the sample data I
see that it is 22-Feb-99 (as an example) format. This does not fit with
integer-date format.
Should I create the field in varchar2 format?
Thanks again,
Ferhat
-----Original Message-----
From: Mike McCauley <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 06 Şubat 1999 Cumartesi 00:34
Subject: (RADIATOR) Re: integer-date format
>Hello Ferhat,
>
>The problem is that the spelling of Integer-Date should be integer-date.
Its
>case sensitive.
>
>Hope that helps.
>Cheers.
>
>
>On Feb 5, 4:39pm, Ferhat Dilman wrote:
>> Subject: integer-date format
>> Hi,
>>
>> I have tried the integer-date function but I guess I misunderstood
>> something. What I have done is: i have added a field in Oracle8 such as
>> ALTER TABLE "RADIUS"."ACCOUNTING" ADD(LOGDATE DATE NULL);
>> (should I create varchar2 field instead?)
>>
>> then in radius.cfg:
>>
>> AcctColumnDef LOGDATE,Timestamp,Integer-Date
>>
>> then the error:
>>
>> Fri Feb 5 16:14:39 1999: ERR: Radius::AuthSQL do failed for 'insert into
>> ACCOUNTING
>> (LOGDATE, CALLERID, USERNAME, ACCTSTATUSTYPE, TIME_STAMP,
>> FRAMED
>> ADDRESS, NASIDENTIFIER, ACCTTERMINATECAUSE, DATARATE, NASPORT,
>> ACCTSESSIONID, CL
>> IENTDNIS, ACCTINPUTOCTETS, XMITRATE, ACCTOUTPUTOCTETS, ACCTSESSIONTIME)
>> values
>> ('918224079', NULL, '1590370', 'Start', '918224079',
>> '62.248.11.
>> 5', '195.174.219.3', NULL, NULL, '103', '274746092', NULL, NULL, NULL,
NULL,
>> NUL
>> L)': ORA-01847: day of month must be between 1 and last day of month (DBD
>> ERROR:
>> OCIStmtExecute)
>>
>> By the way, why does it LOGDATE and CALLERID into beginning although they
>> are in the end in Acct statements?
>>
>> Thanks
>>
>> Ferhat
>>
>>
>>-- End of excerpt from Ferhat Dilman
>
>
>
>--
>Mike McCauley [EMAIL PROTECTED]
>Open System Consultants Pty. Ltd Unix, Motif, C++, WWW
>24 Bateman St Hampton, VIC 3188 Australia Consulting and development
>Phone, Fax: +61 3 9598-0985 http://www.open.com.au
>
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody
>===
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
