Re: MySQL Authentication Logging

2003-08-26 Thread Kostas Kalevras
On Mon, 18 Aug 2003, Adam Carmichael wrote: > Hi All! > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 for logging > accounting and retrieving authentication information. I am interested in knowing how > to log authentication attempts and even possibly why an attempt

Re: MySQL Authentication Logging

2003-08-20 Thread Adam Carmichael
- Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 6:57 PM Subject: Re: MySQL Authentication Logging > Adam Carmichael wrote: > > > I was considering relearning C/C++ all over a

Re: MySQL Authentication Logging

2003-08-20 Thread Nicolas Baradakis
Adam Carmichael wrote: > I was considering relearning C/C++ all over again so I could help > with this just because we need this feature quite badly. I'd love to > finally submit something back to an opensource product, but I don't > think my coding skills are quite up to scratch for this kind of

Re: MySQL Authentication Logging

2003-08-20 Thread Adam Carmichael
Nic, I would love to help you test this!!! Adam - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 6:16 PM Subject: Re: MySQL Authentication Logging > Alan DeKok wrote: > > > &

Re: MySQL Authentication Logging

2003-08-20 Thread Nicolas Baradakis
Alan DeKok wrote: > "Adam Carmichael" <[EMAIL PROTECTED]> wrote: > > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 > > for logging accounting and retrieving authentication information. I am > > interested in knowing how to log authentication attempts and even > > poss

Re: MySQL Authentication Logging

2003-08-19 Thread Alan DeKok
"Adam Carmichael" <[EMAIL PROTECTED]> wrote: > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 > for logging accounting and retrieving authentication information. I am > interested in knowing how to log authentication attempts and even > possibly why an attempt failled.

Re: MySQL Authentication Logging

2003-08-18 Thread Adam Carmichael
ios). If you'd like to further development, then I'll subscribe to freeradius-developers and help out where I can. Adam. - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 10:05 PM Subj

Re: MySQL Authentication Logging

2003-08-18 Thread Nicolas Baradakis
Chris van Meerendonk wrote: > On Mon, 2003-08-18 at 05:30, Adam Carmichael wrote: > > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with > > MySQL4 for logging accounting and retrieving authentication > > information. I am interested in knowing how to log authentication > > attem

Re: MySQL Authentication Logging

2003-08-18 Thread Chris van Meerendonk
On Mon, 2003-08-18 at 05:30, Adam Carmichael wrote: > Hi All! > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with > MySQL4 for logging accounting and retrieving authentication > information. I am interested in knowing how to log authentication > attempts and even possibly why an

MySQL Authentication Logging

2003-08-17 Thread Adam Carmichael
Hi All!   I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 for logging accounting and retrieving authentication information. I am interested in knowing how to log authentication attempts and even possibly why an attempt failled.   For example, if we have a customer who

Mysql Authentication

2003-06-06 Thread Mauro
I'm trying to pass wind value via dhcp to a remote client using mysql...every dhcp fields seems to be passed fine (dns,IP.)except wins ...during authentication on ras server I see the following 04:32:00: RADIUS: cisco AVPair ""ip:wins-servers=10.0.0.1"" not applied for ip the field in the radg

RE: MySQL Authentication

2003-03-24 Thread Mace . Scott
OK, it's working now. Here is what I changed: in sql.conf I changed from sql_user_name = "%{Stripped-User-Name}" to sql_user_name = "%{User-Name}" Not sure there's a difference, but that's what I did... in radius.conf in the authorize section commented out all but preprocess, chap, mschap,

RE: MySQL Authentication

2003-03-24 Thread Scott Bartlett
osted To: FreeRadius > Conversation: MySQL Authentication > Subject: RE: MySQL Authentication > > > Well, I used the Dialup Admin tool with the default setting > of using crypt > passwords. > > Here's my DB info, thanks for your help! > --- This message (and any

RE: MySQL Authentication

2003-03-24 Thread Mace . Scott
gt; Sent by: [EMAIL PROTECTED] 03/22/2003 05:54 AM Please respond to freeradius-users To: <[EMAIL PROTECTED]> cc: Subject:RE: MySQL Authentication Scott, Your debug notes you've got PAP encryption set - is this the issue? I'd try with it se

Re: MySQL Authentication

2003-03-24 Thread Mace . Scott
ROTECTED]> Sent by: [EMAIL PROTECTED] 03/21/2003 07:29 PM Please respond to freeradius-users To: [EMAIL PROTECTED] cc: Subject: Re: MySQL Authentication El Fri, 21 Mar 2003 17:31:16 -0500 [EMAIL PROTECTED] escribió: > I've seen quite a few messa

Re: MySQL Authentication

2003-03-24 Thread Mace . Scott
t; <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/21/2003 07:05 PM Please respond to freeradius-users To: [EMAIL PROTECTED] cc: Subject: Re: MySQL Authentication Hello Scott: It looks like you might be trying to use unix passwd/shadow authenticatio

RE: MySQL Authentication

2003-03-22 Thread Scott Bartlett
m>. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Posted At: 21 March 2003 22:31 Posted To: FreeRadius Conversation: MySQL Authentication Subject: MySQL Authentication I've seen quite a few messages in the archives regarding different issues with MySQL authentica

Re: MySQL Authentication

2003-03-21 Thread Pablo Veliz
El Fri, 21 Mar 2003 17:31:16 -0500 [EMAIL PROTECTED] escribió: > I've seen quite a few messages in the archives regarding different issues > with MySQL authentication. I can get nothing to work. I tried this > patch, > http://www.mail-archive.com/[EMAIL PROTECTED]/msg12306

Re: MySQL Authentication

2003-03-21 Thread Ed H
# wtmp file sql # radutmp # sradutmp } session { # radutmp sql } Ed From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MySQL Authentication Date: Fri, 21 Mar 2003 17:31:16 -0500 I've seen quite a few messages i

MySQL Authentication

2003-03-21 Thread Mace . Scott
I've seen quite a few messages in the archives regarding different issues with MySQL authentication. I can get nothing to work. I tried this patch, http://www.mail-archive.com/[EMAIL PROTECTED]/msg12306.html and this patch, http://www.mail-archive.com/[EMAIL PROTECTED]/msg14684.html (

Re: Mysql Authentication

2003-01-22 Thread Ossama Suleiman
Alan DeKok wrote: Ossama Suleiman <[EMAIL PROTECTED]> wrote: i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql authentication, the problem is that i want to authenticate users depending on Calling-Station-Id, so i added an entry (blank username) Why?

Re: Mysql Authentication

2003-01-20 Thread Ossama Suleiman
Alan DeKok wrote: Ossama Suleiman <[EMAIL PROTECTED]> wrote: i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql authentication, the problem is that i want to authenticate users depending on Calling-Station-Id, so i added an entry (blank us

Re: Mysql Authentication

2003-01-16 Thread Alan DeKok
Ossama Suleiman <[EMAIL PROTECTED]> wrote: > i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql > authentication, the problem is that i want to authenticate users > depending on Calling-Station-Id, so i added an entry (blank username) Why? What's wr

Mysql Authentication

2003-01-16 Thread Ossama Suleiman
Hi, i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql authentication, the problem is that i want to authenticate users depending on Calling-Station-Id, so i added an entry (blank username) into the table radcheck with Auth-Type=Accept and added another attribute Calling

mysql authentication with multiple CLIs

2002-10-25 Thread Mark Terry
All, i'm using freeradius with mysql to authentication users based on username, password, and their calling station id. but now i have some users that wish to dial up from two or more different CLIs. I need a bit of help on setting up the database records in the radcheck table, this is

Re: MySql authentication fails

2002-10-10 Thread Alan DeKok
"Valakos Yorgos" <[EMAIL PROTECTED]> wrote: > I have a SuSe Linux 8.0 on Intel system and and 0.7.1 freeradius and > latest version of MySql . When I try to authenticate a user against my > passwd and shadow file it works but it doesn't when I try the same with > users inserted in radius database

MySql authentication fails

2002-10-10 Thread Valakos Yorgos
Dear friends I am totally newbie -yet fascinated - in both the linux and Freeradius stuff so I beg you to bare with me . I have a SuSe Linux 8.0 on Intel system and and 0.7.1 freeradius and latest version of MySql . When I try to authenticate a user against my passwd and shadow file it works b

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread NetNITCO Systems Administration
> > If you want it to look at the 'users' file, then, absolutely. > Since I didn't care for it to look at the 'users' file, then the entry of: | 3 | DialUp| Auth-Type| PAP | := | in the 'radgroupcheck' table should have taken care of the Auth-Type issue, correct? The list

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread Alan DeKok
NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > I was however under the impression that 'Auth-Type' would be > retrieved from the 'radgroupcheck' table for the group my test user > is associated with under MySQL rather than the users file. Is that > not the case? Yes. > Do I in

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread NetNITCO Systems Administration
> > I don't know. Read the debugging output of the server. Is it even > looking at that line from 'users'? > I have killed and restarted radius with debugging and tried authenticating. I have not seen any mention of the users file or the loading of any of the DEFAULT values specified in th

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread Alan DeKok
NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > Ok, that is what I have. Do you have any ideas why radius appears > to still be unable to determine an Auth-Type when trying to > authenticate the user? I don't know. Read the debugging output of the server. Is it even looking at t

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread NetNITCO Systems Administration
> > Yes. > Ok, that is what I have. Do you have any ideas why radius appears to still be unable to determine an Auth-Type when trying to authenticate the user? --Josh Snyder NetNITCO Systems Administration - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread Alan DeKok
etNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > I currently have the following in the users file: > > DEFAULT Auth-Type := PAP > Fall-Through = 1 ... > Is this what you were talking about Alan? Yes. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradi

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread NetNITCO Systems Administration
> > Read the 'users' file that comes with the server. > > The Auth-Type attribute tells the server HOW the user is to be > authenticated. > I currently have the following in the users file: DEFAULT Auth-Type := PAP Fall-Through = 1 DEFAULT Service-Type == Framed-User Framed-

Re: Freeradius/MySQL Authentication Problem

2002-09-11 Thread Alan DeKok
> Alright, everything seems to be working fine now from my previous > post regarding initial configuration of Freeradius 0.7 and MySQL, > however, now I cannot authenticate a user. I'm not sure what I'm > supposed to set Auth-Type to or where I'm supposed to set it. Read the 'users' file that

Freeradius/MySQL Authentication Problem

2002-09-10 Thread NetNITCO Systems Administration
Alright, everything seems to be working fine now from my previous post regarding initial configuration of Freeradius 0.7 and MySQL, however, now I cannot authenticate a user. I'm not sure what I'm supposed to set Auth-Type to or where I'm supposed to set it. I want to just use PAP clear text

Re: mysql authentication

2002-07-25 Thread Chris Parker
At 02:07 AM 7/26/2002 +0800, Ador Dauz wrote: >thank's Chris... >I have a question again, In the table of radcheck, radgroupcheck >radreply thiers a field called "op" whats this for? and also in the >radgroupreply a field called "prio" I don't know what should I put >that fields. This field is f

Re: mysql authentication

2002-07-25 Thread Ador Dauz
thank's Chris... I have a question again, In the table of radcheck, radgroupcheck radreply thiers a field called "op" whats this for? and also in the radgroupreply a field called "prio" I don't know what should I put that fields. Thanks again, -ador On Friday 26 July 2002 01:29, you wrote: > A

Re: mysql authentication

2002-07-25 Thread Chris Parker
At 01:24 AM 7/26/2002 +0800, Ador Dauz wrote: >Hello all, >Need help please, I can't make it my MySql configuration. >I got this mesages when I run radiusd -x > >Module: Instantiated sql (sql) >radiusd.conf: "SQL" modules aren't allowed in 'authenticate' sections -- they >have no such method. Yup

mysql authentication

2002-07-25 Thread Ador Dauz
Hello all, Need help please, I can't make it my MySql configuration. I got this mesages when I run radiusd -x Starting - reading configuration files ... Module: Loaded System HASH: Reinitializing hash structures and lists for caching... HASH: Stored 31 entries from /etc/passwd HASH: Stored 4

Re: Problems with MySQL authentication

2002-05-31 Thread Nick Davis
> > root@localhost# radtest radman2 testing localhost 10 2 > hostname> Sending Access-Request of id 128 to 127.0.0.1:1812 > > User-Name = "radman2" > > User-Password = "\2529M\234\353,\006w\2657K\346m\301\022@" > > NAS-IP-Address = > > NAS-Port-Id = "10" > >

Re: Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-31 Thread Chris Parker
At 08:52 AM 5/31/2002 +0200, Simon wrote: >On Thu, May 30, 2002 at 07:14:14PM -0500, Nick Davis wrote: > >[...] > > > root@localhost# radtest radman2 testing localhost 10 2 hostname> > > Sending Access-Request of id 128 to 127.0.0.1:1812 > > User-Name = "radman2" > > User-Passwor

Re: Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 07:14:14PM -0500, Nick Davis wrote: [...] > root@localhost# radtest radman2 testing localhost 10 2 > Sending Access-Request of id 128 to 127.0.0.1:1812 > User-Name = "radman2" > User-Password = "\2529M\234\353,\006w\2657K\346m\301\022@" > NAS-IP-

Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-30 Thread Nick Davis
ok I think I am really close to getting this working (having everything in mysql db). as a side note. i use a table called user instead of radcheck with different titles for the columns because this db is for other stuff too.. here are the tables: mysql> select * from user; +--+--

Re: checkrad don't work with freeradius-0.5 and mysql authentication

2002-04-24 Thread Dirk Tanneberger
Thank you, it works! regards Dirk Tanneberger - Original Message - From: "Chris Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 5:02 PM Subject: Re: checkrad don't work with freeradius-0.5 and mysql authentication &g

Re: checkrad don't work with freeradius-0.5 and mysql authentication

2002-04-24 Thread Chris Parker
At 04:59 PM 4/24/2002 +0200, Dirk Tanneberger wrote: >I have the following checkitems in radcheck-table: >- >id UserName AttributeValue op >1 test password >13test

Re: checkrad don't work with freeradius-0.5 and mysql authentication

2002-04-24 Thread Dirk Tanneberger
== - regards Dirk Tanneberger - Original Message - From: "Chris Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 4:42 PM Subject: Re: checkrad don't work with freeradius-0

Re: checkrad don't work with freeradius-0.5 and mysql authentication

2002-04-24 Thread Chris Parker
At 04:39 PM 4/24/2002 +0200, Dirk Tanneberger wrote: >Hello all, > >I use freeradius-0.5 with mysql authentication and accounting. >Normal authentication and accounting works fine, but >when I use "Simutaneous-Use", it don't work. >when I run Freeradius in debug

checkrad don't work with freeradius-0.5 and mysql authentication

2002-04-24 Thread Dirk Tanneberger
Hello all, I use freeradius-0.5 with mysql authentication and accounting. Normal authentication and accounting works fine, but when I use "Simutaneous-Use", it don't work. when I run Freeradius in debug mode, I see no entry that calling checkrad. I set checkrad with debugging als

Re: Debian - Freeradius MySQL Authentication

2002-01-12 Thread aland
"chrisv" <[EMAIL PROTECTED]> wrote: > At this point, I restarted freeradius, so that the changes > to /etc/raddb/radiusd.conf would take effect. All appears to go > well as the radiusd comes up without error. > > Figuring that MySQL authentication was now config

Debian - Freeradius MySQL Authentication

2002-01-12 Thread chrisv
+-+ | 1 | testuser | Framed-IP-Address | 255.255.255.254 | ++--+---+-+ 1 row in set (0.00 sec) --- End Screen Output --- At this point, I restarted freeradius, so that the changes to /etc/raddb/radiusd.conf would take ef