RE: loading files to oracle

2005-11-10 Thread Eyas Sarabi
Hi Alan;
I have dialup connection detail file having the information for each
connected session,a hard disk was corrupted so when the radius tried to
write directly to Oracle database it could because of the HD failure.
Now I have file per each day including all information about the session was
connected each day and want to load it to DB. Is there any tools that can be
Used to write the contents of files to database directly the same way it is 
Automated through freeradius.


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:freeradius- 
 [EMAIL PROTECTED] On Behalf Of freeradius-users-   
 [EMAIL PROTECTED]
 Sent: Thursday, November 10, 2005 8:40 AM
 To: freeradius-users@lists.freeradius.org
 Subject: Freeradius-Users Digest, Vol 7, Issue 31

 Send Freeradius-Users mailing list submissions to
   freeradius-users@lists.freeradius.org

 To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.freeradius.org/mailman/listinfo/freeradius-users
 or, via email, send a message with subject or body 'help' to
   [EMAIL PROTECTED]

 You can reach the person managing the list at
   [EMAIL PROTECTED]

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of Freeradius-Users digest...


 Today's Topics:

1. Re: FreeBSD anyone?  (Alan DeKok)
2. Re: Failed attempts log  (Alan DeKok)
3. Re: Failed attempts log (Nicolas Baradakis)
4. Re: JRadius (Raoul Demour)
5. Re: Proxy not sending out packets (was Re: Proxying a PEAP
   request to an IAS server) (Dan Newcombe)
6. Re: Problem with loading files from free radius  (Alan DeKok)
7. Re: simultaneous use, checkrad, and MPP attempts  (Alan DeKok)
8. Re: simultaneous use, checkrad, and MPP attempts (Kevin Bonner)
9. authenticate against bytes in and out with sqlcounter
   (Martin Potgieter)
   10. Problem with loading files from free radius (Eyas Sarabi)


--

Message: 1
Date: Wed, 09 Nov 2005 13:00:27 -0500
From: Alan DeKok [EMAIL PROTECTED]
Subject: Re: FreeBSD anyone? 
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Message-ID: [EMAIL PROTECTED]

christian meutes [EMAIL PROTECTED] wrote:
 Can you point me to the explanation, i cant find it?

 
http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/man/man5/rlm_sql_log.5?
rev=1.2content-type=text/x-cvsweb-markup

  Alan DeKok.


--

Message: 2
Date: Wed, 09 Nov 2005 13:01:48 -0500
From: Alan DeKok [EMAIL PROTECTED]
Subject: Re: Failed attempts log 
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Message-ID: [EMAIL PROTECTED]

Thierry Hoferlin [EMAIL PROTECTED] wrote:
 Is there a way to log failed authentification records to SQL  ?

  Not really, no.

  Alan DeKok.


--

Message: 3
Date: Wed, 9 Nov 2005 19:08:55 +0100
From: Nicolas Baradakis [EMAIL PROTECTED]
Subject: Re: Failed attempts log
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii

Thierry Hoferlin wrote:

 I've configured a freeradius 1.0.5 with MSSQL authentification. 
 It works fine.

 Is there a way to log failed authentification records to SQL  ?

Please don't post HTML on the list.

Search the archives for detailed instructions, but the general
idea is to use the module sql in section post-auth.

http://freeradius.org/radiusd/doc/Post-Auth-Type

-- 
Nicolas Baradakis



--

Message: 4
Date: Wed, 9 Nov 2005 10:12:06 -0800 (PST)
From: Raoul Demour [EMAIL PROTECTED]
Subject: Re: JRadius
To: freeradius-users@lists.freeradius.org
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=iso-8859-1

Hello

thanks for all the answers!

 Regarding EAP-SIM, JRadius has no specific support
 for it. What is it
 you are trying to do?

What I have understood:
FreeRADIUS is able to authenticate using EAP-SIM. But
you need to set the attributes:
EAP-SIM-Rand1
EAP-SIM-SRES1
EAP-SIM-KC1
EAP-SIM-Rand2
EAP-SIM-SRES2
EAP-SIM-KC2
EAP-SIM-Rand3
EAP-SIM-SRES3
EAP-SIM-KC3

(do you really need to set all the 9 attributes? or
just one rand, one SRES and one Kc is enough?)

I dont have access to GSM network and I dont know Ki
(share secret). But to check if the system is
correctly set up, I would like to give manually the
attributes (on the serveur). (In a way I cheat...). Or
to reproduce the generation of Rand, SRES and Kc
(using my own algorithm) and on the supplicant I
simulate SIM card...

With JRadius it is possible to create object like
Attr_UserPassword (according to the given example of
JRadius). After what, it is used to set the attribut
UserPassord for FreeRADIUS.

So I think it would not be too complicate to create
new attribute like:
Attr_EAP_SIM_Rand, Attr_EAP-SIM-SRES, Attr_EAP-SIM-KC.

In a way, I would like to use JRadius to avoid 

Re: loading files to oracle

2005-11-10 Thread Alan DeKok
Eyas Sarabi [EMAIL PROTECTED] wrote:
 Now I have file per each day including all information about the session was
 connected each day and want to load it to DB. Is there any tools that can be
 Used to write the contents of files to database directly the same way it is 
 Automated through freeradius.

  radrelay.  Read the detail files, and send them to FreeRADIUS.

  It comes with the server.

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html