SQL acconting
Dear Members! I have installed Freeradius with mysql running fine for web administration i have installed ARA but when I click on (online user) the page is always blank the same problem i also faced on (Dailup Admin). I manually checked mysql table (radacct) the table always empty. So please help me what should i do to check my online users. Regards, Umar Draz _ Catch suspicious messages before you open themwith Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_protection_0507 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: 1.1.6 with rlm_sqlippool: ip=[] len=0
On Sat 12 May 2007, Guilherme Franco wrote: Ok, But a lot of times, on the process of server restart (every hour on cron.hourly), freeradius hangs and Error: There appears to be another RADIUS server running on the authentication port 1812 messages appears. I have to manually kill -9 radiusd and start it again. Version 1.1.6 hangs more in this matter than 1.1.4 do. Also, I've tried to update to the latest CVS (freeradius-server-snapshot-20070511.tar.bz2) just to check out (because Mr. Nixon have told earlier that the postgresql driver was fixed in CVS), but Floating point Exception occurred. OK. Well, please give us more information about this problem (Back trace etc) so that we can try to fix it. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
User-Name and Clear Text Password configurations
Hi All, I want to send out Authentication Request message with only the User-Name and Password. Moreover i want the password to be clear text. Is it possible to configure the free-radius server for just these requirements? I did configure the username and password in the users file but server seems to be looking for a encrypted password and is thus sending back a reject. Any way to configure a username and a clear text password? Thanks in advance, Shiv - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MySQL Attirbute Order
I am creating a custom web interface for my work and just wanted to put forward a simple question. When inserting data into the radreply or radgroupreply tables, does the order of the attributes matter? All the attributes are present and correct, but would it matter if say, Frame type attributes came before or after the Tunnel attributes? -- View this message in context: http://www.nabble.com/MySQL-Attirbute-Order-tf3731417.html#a10444812 Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re : User-Name and Clear Text Password configurations
I want to send out Authentication Request message with only the User-Name and Password. Moreover i want the password to be clear text. Is it possible to configure the free-radius server for just these requirements? YES I did configure the username and password in the users file but server seems to be looking for a encrypted password and is thus sending back a reject. Any way to configure a username and a clear text password? You can use CHAP to authenticate and ensure you send clear text from your access point but not EAP. You can see what you are receiving if you do radiusd -X == Benjamin K. Eshun - Message d'origine De : Diameter K [EMAIL PROTECTED] À : freeradius-users@lists.freeradius.org Envoyé le : Samedi, 12 Mai 2007, 11h05mn 47s Objet : User-Name and Clear Text Password configurations Hi All, I want to send out Authentication Request message with only the User-Name and Password. Moreover i want the password to be clear text. Is it possible to configure the free-radius server for just these requirements? I did configure the username and password in the users file but server seems to be looking for a encrypted password and is thus sending back a reject. Any way to configure a username and a clear text password? Thanks in advance, Shiv - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SQL acconting
Umar Draz wrote: Dear Members! I have installed Freeradius with mysql running fine for web administration i have installed ARA but when I click on (online user) the page is always blank the same problem i also faced on (Dailup Admin). I manually checked mysql table (radacct) the table always empty. So please help me what should i do to check my online users. See the FAQ. Is the NAS sending accounting packets? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL Attirbute Order
Frosty wrote: When inserting data into the radreply or radgroupreply tables, does the order of the attributes matter? No. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: User-Name and Clear Text Password configurations
Diameter K wrote: I want to send out Authentication Request message with only the User-Name and Password. Moreover i want the password to be clear text. Is it possible to configure the free-radius server for just these requirements? Yes. See the FAQ for an example of how to do this. I did configure the username and password in the users file but server seems to be looking for a encrypted password and is thus sending back a reject. Nonsense. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Performance Stats
Alan DeKok wrote: Arran Cudbard-Bell wrote: It was PAP... Running with debugging mode *off* yields much better results ! Well, yes. I liked the pretty text ?! Still with completely vanilla install , only getting [req] = 5000 [parallel] = 10 [total] = 5 [start] = 1178820825.99 [stop] = 1178820836.79 [period] = 10.791821003 [req_s] = 4633 That's pretty low. I'm a little surprised, in fact. I was getting that performance almost 6 years ago on machines available then. Yes it's worryingly low, This is with the G5 optimisation compiler flags passed to GCC... Though i'm not sure it's taking them ... should just be env CFLAGS=-O3 -mcpu=970 -mtune=970 -mpowerpc64 ./configure --prefix=/usr/local/freeradius-cvsfast make make install ... But the configure script doesn't seem to take notice of the CFLAGS env variable , so does not pass the flags to the compiler at build time. Have you had anyone else running FreeRADIUS on a G5 feed back about performance ? localhost to localhost Try from one machine to another. Maybe the client server are competing for resources on the same machine. Will try machine to machine on monday, or later today if I have time, though I suspect the performance will probably be worse. top reveals that radclient is running at about 70% utilization and radiusd at 104%. These boxes are not under any kind of load and have a pretty vanilla install of Mac OSX Server 10.4.9. Can't figure out why it's so slow. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeradius for windows + mssql problem
Hi all. I have installed freeradius for windows (www.freeradius.net) and it works well. Now I want to connect the service to an mssql database in the same machine. The error I receive (starting in debug mode) is (using mssql.conf): rlm_sql (sql): Could not link driver rlm_sql_unixodbc: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[10]: sql: Module instantiation failed. Could someone help me ? thanks -- View this message in context: http://www.nabble.com/freeradius-for-windows-%2B-mssql-problem-tf3731743.html#a10445786 Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius for windows + mssql problem
rodolfor wrote: Hi all. I have installed freeradius for windows (www.freeradius.net) and it works well. Now I want to connect the service to an mssql database in the same machine. The error I receive (starting in debug mode) is (using mssql.conf): rlm_sql (sql): Could not link driver rlm_sql_unixodbc: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[10]: sql: Module instantiation failed. Could someone help me ? thanks Similar to earlier versions of FreeRADIUS.net we claim _no_ support for any external Databases (namely mysql). Read the front page of the port your using before posting to the list ;) -- Arran - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: One day user account
Jan Mulders wrote: ...or if you're feeling lazy and know Perl, rlm_perl is an exellent tool to make your own policy decisions (as you can configure perl to talk to your mysql database). Hope this helps, Jan On 11/05/07, *Marc Miranda (GOWEX)* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Take a look at rlm_counter/rlm_sqlcounter (I don't know if it's exactly what you are looking for) or if you don't want to complicate, just work with a database logic and change the radius auth queries depending on certain timestamps and NOW(), for example, in the case of MySQL, in sql.conf. I'm not a guru, but it can be useful for starting looking for some of the options… *De:* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] *En nombre de *Aren Chua *Enviado el:* viernes, 11 de mayo de 2007 12:35 *Para:* freeradius-users@lists.freeradius.org mailto:freeradius-users@lists.freeradius.org *Asunto:* One day user account Hi All, I would like to create a user account which only allow user to use for 1 day. Once the user has been authenticated, the time will be start counting and ended after 24 hours. Although the user didn't fully used up their session time, radius still will reject user to login. Can any expert give me some suggestion on how to create this user account? Thanks Regards, Aren Chua Download Messenger. Start an i'm conversation. Support a cause. Join Now! http://im.live.com/messenger/im/home/?source=TAGWL_MAY07 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html This is achieved with sqlcounter. http://lists.cistron.nl/pipermail/freeradius-users/2005-October/047532.html Goksie - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: 1.1.6 with rlm_sqlippool: ip=[] len=0
Mr. Alan and Mr. Peter, Sorry for the lack of information. I'll give more details about the problem on Monday. Thank you very much. On 5/12/07, Peter Nixon [EMAIL PROTECTED] wrote: On Sat 12 May 2007, Guilherme Franco wrote: Ok, But a lot of times, on the process of server restart (every hour on cron.hourly), freeradius hangs and Error: There appears to be another RADIUS server running on the authentication port 1812 messages appears. I have to manually kill -9 radiusd and start it again. Version 1.1.6 hangs more in this matter than 1.1.4 do. Also, I've tried to update to the latest CVS (freeradius-server-snapshot-20070511.tar.bz2) just to check out (because Mr. Nixon have told earlier that the postgresql driver was fixed in CVS), but Floating point Exception occurred. OK. Well, please give us more information about this problem (Back trace etc) so that we can try to fix it. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html