That did it!! My accounting is working just fine! And now I even see it updating the mysql tables! Thanks a TON!
Frank ----- Original Message ----- From: "Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 6:10 PM Subject: Re: freeradius and mysql > If you have a windows machine that you can use, then NTRADPing is a nice > (free) tool to help test RADIUS configs .... > http://www.mastersoft-group.com/download/ > > Despite mentioning 'NT', I've used it on a Windows 98SE machine with no > problems. > ----- Original Message ----- > From: "tywe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, April 05, 2002 4:38 PM > Subject: Re: freeradius and mysql > > > > 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 > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
