Re: Install - Freeradius can't connect to MySQL

2006-06-07 Thread N White
Cliff Hayes wrote: Hello, Warning - newbie installing Freeradius. I get this in the radius.log even though the sql.conf has the correct host/user/password (and I can access MySQL from the command line using the same login criteria): Wed Jun 7 14:01:52 2006 : Info: rlm_sql_mysql: Starting

Re: choosing userprofile by NAS

2005-09-22 Thread N White
Jonathan De Graeve wrote: I'm looking for the same thing but then with an SQL backend instead of LDAP J. Search for my previous post listed by the subject Authenticate/Attributes based on NAS-IP-Address. I did this same thing - it requires modifying the SQL SELECT statements in sql.conf,

Re: howto reset rlm_sqlcounter

2005-09-22 Thread N White
Bart van Daal wrote: Hi All, I'm authenticating users who can buy a specified amount of time to go online. I'm using the rlm_sqlcounter module with a reset=never option because there is no specified amount of time in which users have to use their minutes. A user can also buy additional

Re: radgroupreply table

2005-09-13 Thread N White
Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Can anyone explain to me the purpose and usage of the 'prio' column in the radgroupreply table? Order. SELECT ... by prio See the users file for examples: DEFAULT ... Foo-Stuff = 1 Bar-Junk = 2

radgroupreply table

2005-09-12 Thread N White
Can anyone explain to me the purpose and usage of the 'prio' column in the radgroupreply table? Much Googling has returned nothing, accept other questions. -- --- | Nick White | | Network Administrator | | Tele-NET Internet | |

Re: more debug?

2005-08-14 Thread N White
Nicolas Baradakis wrote: N White wrote: Is there any way to get the debug to tell me more. For example: freeradius -XX In some parts of the server you can get more debug messages with radiusd -xxx -l stdout but unfortunately not in rlm_sqlcounter. I'd like to see exactly what

debian install and modules

2005-08-14 Thread N White
I would like to get rlm_sqlcounter working, but I have FreeRADIUS installed via apt-get install freeradius freeradius-mysql from the Debian sources. They do not apparently include the experimental modules in this package, and there is not another package for these modules. I tried compiling,

more debug?

2005-08-13 Thread N White
Is there any way to get the debug to tell me more. For example: freeradius -XX Tue Jul 26 12:46:55 2005 : Debug: rlm_sqlcounter: Entering module authorize code Tue Jul 26 12:46:55 2005 : Debug: rlm_sqlcounter: Could not find Key value pair Tue Jul 26 12:46:55 2005 : Debug:

Re: rlm_sqlcounter noresetcounter

2005-08-09 Thread N White
Anyone have advice/input? N White wrote: I'm having trouble setting up the noresetcounter(Max-All-Session). I'm running freeradius 1.0.4(Debian). I have compiled and added the rlm_sqlcounter.so files to the proper folder in Debian, and freeradius -X shows the module starting up(I have

rlm_sqlcounter noresetcounter

2005-08-07 Thread N White
I'm having trouble setting up the noresetcounter(Max-All-Session). I'm running freeradius 1.0.4(Debian). I have compiled and added the rlm_sqlcounter.so files to the proper folder in Debian, and freeradius -X shows the module starting up(I have renamed it hotspotcounter). If you would like to

Re: Re. Max-Daily-Session

2005-08-06 Thread N White
Shannon Sariman wrote: Nick White wrote: Can I set Max-Daily-Session = 1800 in the radgroupcheck table (MySQL), and if so is the max of 1800 set for the entire group, or for each user in that group? The max of 1800 will be set for the entire group. I you want to apply max of 1800 for

Max-Daily-Session

2005-08-05 Thread N White
Can I set Max-Daily-Session = 1800 in the radgroupcheck table (MySQL), and if so is the max of 1800 set for the entire group, or for each user in that group? Thanks -- --- | Nick White | | [EMAIL PROTECTED] | --- - List

Re: Disconnect-Request packet

2005-07-29 Thread N White
Alan DeKok wrote: [EMAIL PROTECTED] (Paul Hampson) wrote: This last point seems trivial until you try to proxy backwards through a chain you have only the last hop of, and the last hop doesn't neccessarily know what the previous hop was. Exaclty. Coupled with the problem that the

Re: Disconnect-Request packet

2005-07-28 Thread N White
Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Yes 192.168.1.1 is the NAS. Then it's running FreeRADIUS. The error message you quoted above: ad_recv: Disconnect-Request packet from host 192.168.1.2:47874, id=139, length=31 Unknown packet code 40 from client 192.168.1.2

Disconnect-Request packet

2005-07-27 Thread N White
Ok. I am trying to figure out how to disconnect a user, or to tell the radius server to send a disconnect packet to the NAS for a specific user. This is the command I am using: echo User-Name = nickwhite | radclient 192.168.1.1 disconnect mysecret -x This is the debug output from the radius

Re: Disconnect-Request packet

2005-07-27 Thread N White
Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Ok. I am trying to figure out how to disconnect a user, or to tell the radius server to send a disconnect packet to the NAS for a specific user. This is the command I am using: echo User-Name = nickwhite | radclient 192.168.1.1

Re: Disconnect-Request packet

2005-07-27 Thread N White
N White wrote: Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Ok. I am trying to figure out how to disconnect a user, or to tell the radius server to send a disconnect packet to the NAS for a specific user. This is the command I am using: echo User-Name = nickwhite | radclient

Re: Authenticate/Attributes based on NAS-IP-Address - SOLVED

2005-06-09 Thread N White
. -Nick Graeme Hinchliffe wrote: Hiya, Use Client-IP rather than NAS-IP as NAS-IP can be spoofed. Graeme On Wed, 2005-06-08 at 15:30 -0700, N White wrote: Graeme Hinchliffe wrote: Hiya perhaps you could do it using huntgroups. Put the static attributes

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-08 Thread N White
? Regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of N White Sent: 07 June 2005 22:29 To: FreeRadius users mailing list Subject: Authenticate/Attributes based on NAS-IP-Address Using MySQL as a backend, is there any way to configure

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-08 Thread N White
by HuntGroup, NAS-IP, Client-IP, whatever. See my previous post to this list archived here: http://www.mail-archive.com/freeradius-users@lists.freeradius.org/msg16842.h tml Cheers, _Mike -Original Message- Message: 6 Date: Tue, 07 Jun 2005 19:20:28 -0700 From: N White [EMAIL PROTECTED

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-08 Thread N White
nevermind, i added tml to it. haha. -Nick N White wrote: That link doesn't give me anything. Page Not Found. I've done a lot of searching through the archives though and haven't really found anything like this. -Nick Mike Lampson wrote: Nick, Extend the MySQL schema and change the SQL

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-08 Thread N White
Zoltan A. Ori wrote: On Wednesday 08 June 2005 15:54, N White wrote: That link doesn't give me anything. Page Not Found. I've done a lot of searching through the archives though and haven't really found anything like this. -Nick Mike Lampson wrote: Nick, http://www.mail

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-08 Thread N White
Graeme Hinchliffe wrote: Hiya perhaps you could do it using huntgroups. Put the static attributes for the user in the radreply table, then assign each nas to a huntgroup, so say NAS-dynamic Then in radgroupreply you put the attributes for for dynamic IP assignment on

Authenticate/Attributes based on NAS-IP-Address

2005-06-07 Thread N White
Using MySQL as a backend, is there any way to configure Authentication and Attribute (replies), based on the NAS-IP-Address sent to the FreeRADIUS server? Allow requests from NAS1 to authenticate and have certain attributes for users in that group and then allow requests from NAS2 to

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-07 Thread N White
Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Using MySQL as a backend, is there any way to configure Authentication and Attribute (replies), based on the NAS-IP-Address sent to the FreeRADIUS server? Yes. Use it as a check item, like anything else. Alan DeKok. - List info

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-07 Thread N White
Alan DeKok wrote: N White [EMAIL PROTECTED] wrote: Yeah, but I want to use MySQL, not the users file. I don't use MySQL, sorry. If you want someone to give you the exact answer you're looking for, I suggest you hire a contracter. Alan Dekok. - List info/subscribe/unsubscribe

Re: Authenticate/Attributes based on NAS-IP-Address

2005-06-07 Thread N White
Dustin Doris wrote: On Tue, 7 Jun 2005, N White wrote: Well, thanks for the input. With MySQL, 1500 users is easier to maintain. Perhaps I should just run a second FreeRADIUS server for the second NAS. It means more equipment, but whatever it takes. -Nick You don't need to do

Port-Limit/Simultaneous Use based on NAS IP

2005-06-06 Thread N White
Is this possible? Set a Port-Limit/Simultaneous-Use based on the NAS-IP that is sent to the FreeRadius server? Here is the setup I am looking at: I have several users on Dial-Up that are only allowed 1 login at a time. Now I have several Wireless users that will be logging in twice via PPPoE

monthly hourly statistics per user

2005-02-17 Thread N White
I currently have freeradius 1.0.1 running with the dialupadmin from 1.0.2 on Debian Sarge. I was just curious if there is anyway to pull monthly total hours for all users. The user statistics isn't exactly what i need, it shows daily user statistics, so if I show a week of statistics, i get 7