None Stop timer?
Just wondering is there a way of when a user is restricted to 2 hours browsing time, the account expires after 2 hours from the time the user logs in? for example: User logs in at 1:00pm and logs off at 1:30pmthen he tries to logon again at 3:01 the account will have expired. that is a requirement of a hotel. Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: 30Day Limit
Hi Chalie What you said below makes a lot of sense but considering i dont know where to start to get to produce a script like that. Do you have anything which does that if not can you give me some hints. Sarky On Tue, 17 Aug 2004 16:04:27 -0700, Charles J. Boening wrote: That would give a user 30 days total. They could take 6 months to use it right? If you're issuing a scratch type ticket I'm assuming it has a username and password on it. So you should already have those users in your database. If your accounting is working right, you could run a nightly query to see what accounts don't have an expiration and then if those accounts have ever logged in. If they've logged in and don't have an expiration, set the expiration for 30 days from the initial login. Charlie - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
any Scripters on here?
Any scripters on here for hire, I want to do a script please contact me offlist at [EMAIL PROTECTED] Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Version 1. Pre3 RadZap
Hi all Just wondering did anything change with the way Radzap works on the latest version? I have installed it on a test system, and i have noticed i can not radzap the users on the system with radzap -p 1813 -r localhost 'nasip' Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Advice on remote radius server.
So from what you are saying it is best to get the authentication done remotely. what does proxy setting do? would that be able to play apart in this setup ? thanks Sarky You could do that, but that means distributing the user database. Not a good idea. If the satellite link is too clogged to handle RADIUS packets, it's too clogged to handle *any* network traffic. And there shouldn't be more than 10-20 RADIUS packets a second from any POP, at MOST, which is a tiny amount of bandwidtj. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Advice on remote radius server.
Hi everyone Right i have a Satellite link which has a 550ms delay from the world, and i am running an internal radius server but due to the fact that i want to have more than one pop I want to localize the radius server and maybe have a local one on each site, that will save lookup over the satlink which could be clogged up or something of that nature. Any advice on how to do it ? Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin replacement
Actualy I care i dont know about the rest, but i have been using freeradius/dialup-admin for a while and development just seem to have stoped on dialup-admin, hence i was loosing hope. Sarky Thanx On Mon, 26 Jul 2004 11:48:05 +0300 (EEST), Kostas Kalevras wrote: On Sat, 24 Jul 2004, sarky wrote: Hello all, I am looking for a web interface which does what dialup admin does and allows users to access it via there login/password and get all the information they require download limits, what they have downloaded and so on. You are actually describing the functionality of dialupadmin? Why are you asking for a replacement instead of just adding this capability to dialupadmin? Anyway, after i 've finished with my security audit of dialupadmin i 'll add that functionality. If you care you can use it. Anything out there which does that ? Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas KalevrasNetwork Operations Center [EMAIL PROTECTED]National Technical University of Athens, Greece Work Phone:+30 210 7721861 'Go back to the shadow'Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin replacement
maybe a fault of mine for not going through the logs, when i look at patches or release i always see it the same so i assumed that it is not active. but now i know and as for an email asking for features never did cause of the above reason but now i know. Sarky On Mon, 26 Jul 2004 16:28:54 +0300 (EEST), Kostas Kalevras wrote: On Mon, 26 Jul 2004, sarky wrote: Actualy I care i dont know about the rest, but i have been using freeradius/dialup-admin for a while and development just seem to have stoped on dialup-admin, hence i was loosing hope. 1. It never stoped. Have you looked in the Changelog, or in the dialupadmin CVS? 2. I don't remember ever seeing an email asking for such a feature like the one you asked. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: dialup admin replacement
cool if you can send it over to me that will be great. I think the dialup admin author is on this list, you can ask Sarky On Sun, 25 Jul 2004 09:21:21 -0700, issa rabba' wrote: I did some thing like that, but it's not a part of the dialupadmin, it web interface for our customers, I will customize it and send it to you. Or if you know how can we publish it to be part of the dialup admin project. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sarky Sent: Saturday, July 24, 2004 10:21 AM To: freeradius- [EMAIL PROTECTED] Subject: dialup admin replacement Hello all, I am looking for a web interface which does what dialup admin does and allows users to access it via there login/password and get all the information they require download limits, what they have downloaded and so on. Anything out there which does that ? Sarky - 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
dialup admin replacement
Hello all, I am looking for a web interface which does what dialup admin does and allows users to access it via there login/password and get all the information they require download limits, what they have downloaded and so on. Anything out there which does that ? Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
username's and password
Hello all I have an excel sheet with 10,000 username's and password and i am trying to import them into mysql databse, does anyone out there know of a way to do it.. Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: username's and password
Thanx for the info, i know where to start from now. just a quick one if i use phpmyadmin how would i be able to tell it for example username how will i be able to tell it which field to enter username in? Thanx once more Sarky On Wed, 21 Jul 2004 17:24:40 +0100, Alain Perry wrote: Le mer 21/07/2004 à 17:08, sarky a écrit : I have an excel sheet with 10,000 username's and password and i am trying to import them into mysql databse, does anyone out there know of a way to do it.. You can save it as a .CSV file (using file-save as...) in excel, and then make a script using your favorite language or use phpmyadmin to import it into mysql. You may also be able to import directly using the MySQL ODBC driver that allows MS Office to exchange data with it IIRC. Hope this helps, - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SQL.conf to force user case Sensitive
Alan; Yeah that is what i want to do but for some reason nothing i am doing is working can you give me a hint on where to start or what i need to edit to fix that little problem? Sarky - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 14, 2004 12:13 PM Subject: Re: SQL.conf to force user case Sensitive sarky [EMAIL PROTECTED] wrote: Well i have asked this question before now i have edited sql.conf and hashed the lines below in the other way 2 and the system still doesnt check case sensitive anyone know any solution to double login? Mash all usernames to lowercase when they log in. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
SQL.conf to force user case Sensitive
Hello all Well i have asked this question before now i have edited sql.conf and hashed the lines below in the other way 2 and the system still doesnt check case sensitive anyone know any solution to double login? # Use these for case sensitive usernames. WARNING: Slower queries!authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM${authcheck_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BYid"authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM${authreply_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BYid"# authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"# authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM${authreply_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id" # Use these for case sensitive usernames. WANRING: Slower queries! authorize_group_check_query = "SELECT${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.opFROM ${groupcheck_table},${usergroup_table} WHERESTRCMP(${usergroup_table}.Username, '%{SQL-User-Name}') = 0 AND${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id" authorize_group_reply_query = "SELECT${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${groupreply_table}.Value,${groupreply_table}.opFROM ${groupreply_table},${usergroup_table} WHERESTRCMP(${usergroup_table}.Username, '%{SQL-User-Name}') = 0 AND${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"# authorize_group_check_query = "SELECT${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.opFROM ${groupcheck_table},${usergroup_table} WHERE${usergroup_table}.Username = '%{SQL-User-Name}' AND${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"# authorize_group_reply_query = "SELECT${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${groupreply_table}.Value,${groupreply_table}.opFROM ${groupreply_table},${usergroup_table} WHERE${usergroup_table}.Username = '%{SQL-User-Name}' AND${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id" Sarky
Re: [MikroTik] PPPoE Only one user connection
Thanks man it is working fine no probs at all :) just trying to see the easiest way to kill Ghost connections at the moment i have 5 Ghost connections where the users are trying to come back on but not happening becasue radius have them loged on sarky - Original Message - From: Evren Yurtesen [EMAIL PROTECTED] To: sarky [EMAIL PROTECTED]; mailto:free?? Sent: Sunday, February 01, 2004 9:22 PM Subject: Re: [MikroTik] PPPoE Only one user connection I think this was the latest patch I sent to list. Let me know if this doesnt work. sarky wrote: Hi again I have looked through my archive of all the freeradius emails and couldnt find the relevant patch from yourself. And i know you are not going to send it out to every single person but can you make an exception :) this time pretty please .. now the perl side is working i got the module installed i just need to get the checkrad to kick in :) anyways one by one need the patch and then i will document this because there is no documentation around. Thank you Sarky - Original Message - From: Evren Yurtesen [EMAIL PROTECTED] To: sarky [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 01, 2004 7:47 PM Subject: Re: [MikroTik] PPPoE Only one user connection If you are registered to freeradius mailing list, you should have received my patches for the checkrad program. Please apply that patch to freeradius before compilation, then you can use SNMP or Perl-Telnet to control this one user situation. But the patch only works up to 1 user limit. If you want to limit your users to 2, then you are in trouble. But 1 works fine! This is because I cant get which port the user is connected to from mikrotik. At least mikrotik gives a port number to Radius but there is no way to get the same number for the same user with snmp or telnet. You should set naspasswd, clients.conf files and uncomment a line in sql.conf about simultaneous-use counts. You need net-snmp installed or p5-Net-Telnet. If you get stuck, then you can ask me more :) But please dont ask for step by step instructions. I think most of the things are self explanatory. But you could write a step by step dokument for making Freeradius user check work with mikrotik and send to mikrotik guys, maybe they would include in their documentation and you might get a free license for your work :) Mikrotik guys say that they sometimes give free licenses for this kind of things. But then the other main point is that you will become famous etc :) I also would suggest you to force freeradius developers to patch the freeradius distribution. This is essential, because I am not going to send this patch to people one by one. (Perhaps you can find from freeradius mailing lists though). If you dont know what is checkrad program, then please learn it first. You will find the information of why we need this program very useful and educating. Evren sarky wrote: sorry evren i saw you replying on list about the PPPOE only one user. Well i am having a similar problem but with Freeradius at the other end. please can you explain it to me :) i know you offered it to the guy if he was using radiusd thank you Sarky --- src/main/checkrad.pl.in Thu Aug 28 18:28:47 2003 +++ checkrad.pl.in.new Sun Jan 11 15:42:54 2004 @@ -29,7 +29,8 @@ # versanet_snmp1.0Author: [EMAIL PROTECTED] # bay_finger 1.0 Author: [EMAIL PROTECTED] # cisco_l2tp 1.14 Author: [EMAIL PROTECTED] -# mikrotik_telnet 1.0Author: Evren Yurtesen [EMAIL PROTECTED] +# mikrotik_telnet 1.1Author: Evren Yurtesen [EMAIL PROTECTED] +# mikrotik_snmp1.0Author: Evren Yurtesen [EMAIL PROTECTED] # redback_telnet Author: Eduardo Roldan # # Config: $debug is the file you want to put debug messages in @@ -37,6 +38,7 @@ # $snmpwalk is the location of your ``snmpwalk'' program # $snmp_timeout is the timeout for snmp queries # $snmp_retries is the number of retries for timed out snmp queries +# $snmp_version is the version of to use for snmp queries [1,2c,3] # $rusers is the location of your ``rusers'' program # $naspass is the location of your NAS admin password file # @@ -54,6 +56,7 @@ $snmpwalk = @SNMPWALK@; $snmp_timeout = 5; $snmp_retries = 1; +$snmp_version = 2c; $rusers = @RUSERS@; $naspass = $raddbdir/naspasswd; @@ -148,8 +151,8 @@ my ($host, $community, $oid) = @_; local $_; - print LOG snpwalk: $snmpwalk -r $snmp_retries -t $snmp_timeout -v2c -c '$community' $host $oid\n; - $_ = `$snmpwalk -r $snmp_retries -t $snmp_timeout -v2c -c '$community' $host $oid`; + print LOG snpwalk: $snmpwalk -r $snmp_retries -t $snmp_timeout -v$snmp_version -c '$community' $host $oid\n; + $_ = `$snmpwalk -r $snmp_retries -t $snmp_timeout -v
Simultaneous-logon
Hello all Right i have been trying to get this to work all day, but something is wrong please can someone tell me what exactly i need to do? Another thing mikrotik what type of NAS would 1 set it as. Thank you Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Getting Freeradius to bootup with hte machine
Hello all, Just wondering what you guys out there use to make sure radiusd boots up with the machine, i think the PID file just kills it on coming up the next time. Thanks Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin not giving results
Hi all I have installed Freeradius and it is working fine with mysql, now for ease of configuration i have installed Dialup-Admin now i can add all users in there but i am having problems with statistics/user statistics/online users/bad users/failed logins none of the above work. another thing i have noticed that if i add a user I have a 4hour limit per day and i dont know how to change those basic settings. Thank you Sarky IncrediMail - Email has finally evolved - Click Here