Nicolas,
Thanks a ton for the reply about my accounting issue. I thought the same
thing at first about it being due to an unknown NAS, but even when the NAS
is recognized, it still doesn't do any accounting. And now, every time I
test it, the NAS is recognized anyways, and still no accounting. Are you
sure it isn't due to me using radtest to test this? I have tried to run
radclient to do a test, but I can't seem to find any docs that explain how
to test the accounting part. I did see something that said to do this:
echo "User-Name = fnord" | radclient 1.2.3.4 auth testing123
so, I did that, and it responded with:
Received response ID 98, code 3, length = 20
I checked the radius.log and it had rejected me, which was correct. But,
still no accounting.
So, I tried this just to see what would happen:
echo "User-Name = fnord" | radclient 1.2.3.4 acct testing123
And I got some accounting!!
var/log/radius/radacct/2.3.4.5/detail
Thu Apr 4 05:27:33 2002
User-Name = "fnord"
NAS-IP-Address = 2.3.4.5
Client-IP-Address = 2.3.4.5
Timestamp = 1017916053
So I guess accounting is working? But, I don't know how to use radclient to
properly test it? Can someone give an example that I can try, so that I can
see what a real accounting session will look like? Also, even though I found
a little bit of accounting in the radacct folder, I noticed that nothing
showed up in the mysql radacct table? And yes, I do have sql listed in the
accounting section of radiusd.conf.
And, as for full-debugging is concerned, yes, I have tried watching a debug
session to see if it gives any clues, but I don't see much of anything being
listed that concerns accounting? I see a couple of things about accounting
files and the mysql accounting tables when the radiusd first starts up, but
doing a test with radtest, it doesn't cause any info at all to show up about
accounting?
Thanks again!
Frank
----- Original Message -----
From: "Nicolas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 2:03 AM
Subject: Re: freeradius and mysql
> I have the same problem concerning clients.conf, you should use "clients"
> also, for me it works !
>
> concerning your accounting pb, it's probably the same reason: unknown NAS,
> are you Full-Debugging ?
>
> Nicolas
> ----- Original Message -----
> From: "tywe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 05, 2002 12:21 AM
> Subject: Re: freeradius and mysql
>
>
> > Ya, I don't know much about that file either. I just made an entry that
> > looked about like the default one, and added it below the default one:
> >
> > client 1.2.3.4 {
> > secret = testing123
> > shortname = anyname
> > }
> >
> > And it seemed to work. It's kind of weird though, because the logs show
> the
> > correct shortname sometimes, but then other times, it says UNKNOWN-NAS,
> but
> > still processes the request anyways. Haven't quite nailed down what is
> > causing this yet.
> >
> > And I think my accounting problem (no accounting records) might be due
to
> me
> > using radtest right now. I think I might have to use radclient to
actually
> > see the accounting kick in. Not sure though, but I'll let you know how
it
> > goes.
> >
> > Frank
> >
> > ----- Original Message -----
> > From: "Juan Hernandez" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, April 04, 2002 2:27 PM
> > Subject: Re: freeradius and mysql
> >
> >
> > > the only problem I am having is I dont understand the clients.conf, is
> > there
> > > a site that explains it, and etc.
> > > ----- Original Message -----
> > > From: "tywe" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, April 04, 2002 9:41 AM
> > > Subject: Re: freeradius and mysql
> > >
> > >
> > > > I guess so, but we can also do it on the list too so that others may
> > > benefit
> > > > in the future?
> > > >
> > > > Anyhow, I mainly just followed the instructions at:
> > > > http://www.frontios.com/freeradius.html
> > > >
> > > > I had to install the MySQL-devel rpm before I did anything. The only
> > thing
> > > I
> > > > had to do different than what it says is that I had to remove "sql"
> from
> > > the
> > > > authenticate section and put it back into the authorize section,
even
> > > though
> > > > the above website said to do the opposite.
> > > >
> > > > The only thing I'm a little stuck on right now is the accounting
> stuff.
> > I
> > > > added sql to the accounting section, but I don't see anything
showing
> up
> > > in
> > > > the mySQL tables, or even anything in the /var/log/radius/radacct
> > folder?
> > > I
> > > > do have all the logging turned on right now, and that is working,
> > because
> > > I
> > > > see a /var/log/radius/radius.log file, but I have no idea why
> accounting
> > > > isn't working. Anyone have any ideas? Let me know what info I should
> > post
> > > to
> > > > help figure this out?
> > > >
> > > > Anyhow, let me know what you are stuck on, and I'll try to help. I'm
> > > > definitely a newbie right now though, so don't be surprised if you
> > already
> > > > know more than me. :)
> > > >
> > > > Frank
> > > >
> > > > ----- Original Message -----
> > > > From: "Juan Hernandez" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Thursday, April 04, 2002 12:10 PM
> > > > Subject: Re: freeradius and mysql
> > > >
> > > >
> > > > > hey could you and I discouse off list what you did with free
radius
> > and
> > > > > mysql?
> > > > > ----- Original Message -----
> > > > > From: "tywe" <[EMAIL PROTECTED]>
> > > > > To: <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, April 04, 2002 12:55 AM
> > > > > Subject: Re: freeradius and mysql
> > > > >
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Thanks to all for the help, I now have freeradius and mysql
> working
> > > > > together
> > > > > > quite nicely :)
> > > > > >
> > > > > > My only question: Is it normal to see "Info: Sending duplicate
> > > > > > authentication reply to client" whenever the request is
rejected?
> > > > > Everything
> > > > > > seems to work great, I was just wondering if that duplicate
> message
> > > was
> > > > > > anything to worry about or not.
> > > > > >
> > > > > > Thanks again!
> > > > > >
> > > > > > Frank
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Nicolas" <[EMAIL PROTECTED]>
> > > > > > To: <[EMAIL PROTECTED]>
> > > > > > Sent: Thursday, April 04, 2002 1:50 AM
> > > > > > Subject: Re: freeradius and mysql
> > > > > >
> > > > > >
> > > > > > > To use Mysql, you'd better have to set the good directories
> during
> > > > > > Building
> > > > > > > process (./configure --with-mysql-lib=/usr/lib ....) then
> compile
> > > and
> > > > > > > install binaries.
> > > > > > >
> > > > > > > After that , take care to validate ld.so.conf with these
> > directories
> > > > in
> > > > > it
> > > > > > > and run ldconfig.
> > > > > > >
> > > > > > > Build your database in mysql (with the sql dump file, grant
> > > privileges
> > > > > to
> > > > > > > your user and fill in sql.conf) fill also clients.conf and
> clients
> > > and
> > > > > > > create a user in users in order to validate radiusd itself,
> after
> > > that
> > > > > > > create entries in radcheck table and test again with mysql.
You
> > > should
> > > > > > tune
> > > > > > > your radiusd.conf to validate the use of sql in auth and acct
> > > chapters
> > > > > > >
> > > > > > > Do some tests (radiusd -X)and come back
> > > > > > >
> > > > > > > Nicolas
> > > > > > > ----- Original Message -----
> > > > > > > From: "tywe" <[EMAIL PROTECTED]>
> > > > > > > To: <[EMAIL PROTECTED]>
> > > > > > > Sent: Thursday, April 04, 2002 5:20 AM
> > > > > > > Subject: Re: freeradius and mysql
> > > > > > >
> > > > > > >
> > > > > > > http://www.frontios.com/freeradius.html
> > > > > > >
> > > > > > > That's the only one I've came across so far. If anyone knows
of
> > > > others,
> > > > > > > please let us know. I'm trying to get this working right now
> too.
> > > > > > >
> > > > > > > Hope that helps!
> > > > > > >
> > > > > > > Frank
> > > > > > >
> > > > > > > ----- Original Message -----
> > > > > > > From: Juan Hernandez
> > > > > > > To: [EMAIL PROTECTED]
> > > > > > > Sent: Wednesday, April 03, 2002 7:37 PM
> > > > > > > Subject: freeradius and mysql
> > > > > > >
> > > > > > >
> > > > > > > I know freeradius has the ability to work with mysql, to
read
> > from
> > > a
> > > > > > mysql
> > > > > > > db, how do I configure it to do this?
> > > > > > > you dont have to tell me, I just need to get to a website
> that
> > > > > explains
> > > > > > > it. thanks for any help
> > > > > > >
> > > > > > > Juan
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -
> > > > > > > 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
> > > >
> > >
> > >
> > > -
> > > 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
