Re: FR with MySQL - Stored Procedures

2007-05-07 Thread Gunther
I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my operating system (CentOS 4.4)). So

Re: sqlcounter monthly counter impementation problem

2007-05-07 Thread satish patel
Dear all Here I am shareing my Knowledge. for freeradius users. i have done freeradius-1.1.4 with mysql with cisco VPDN configuration as well as i have configuraed per user base bandwidth configuration and simultanious user login configuration i have sharing my configuration

Re: sqlcounter monthly counter impementation problem

2007-05-07 Thread Alan DeKok
Cory Robson wrote: I have the following configuration in my radius.conf file. The counter does function as such and if the user has utilized the allotted time it will not allow them to connect. However I'm looking to see how to also apply it to the session limit. (IE adjust the session

RE: sqlcounter monthly counter impementation problem

2007-05-07 Thread Cory Robson
I have it in Authorize but not accounting . maybe that's the problem! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok Sent: Monday, 7 May 2007 3:00 PM To: FreeRadius users mailing list Subject: Re: sqlcounter monthly counter impementation

Re: sqlcounter monthly counter impementation problem

2007-05-07 Thread Alan DeKok
Cory Robson wrote: I have it in Authorize but not accounting . maybe that's the problem! The SQL module needs to be listed in the accounting section in order to insert the accounting data needed by the sqlcounter module. Alan DeKok. -- http://deployingradius.com - The web site of

Re: FR with MySQL - Stored Procedures

2007-05-07 Thread Alan DeKok
Gunther wrote: I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my operating

RE: sqlcounter monthly counter impementation problem

2007-05-07 Thread Cory Robson
Yes checked that is ok. It has been working so not the problem there. Only thing I can think of is the dialup-admin interface. The sql.attr map file may be placing it in the wrong spot. It is currently listed as a check item which should be correct. -Original Message- From: [EMAIL

Re: Proxy.conf regex

2007-05-07 Thread Santiago Balaguer García
DEFAULT User-Name =~ "(([a-zA-Z]+\.)*foo.com", Proxy-To-Realm := "foo.com" Will cause the following to be proxied to "foo.com": [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ... How can I integrate this entryof user file in a DB? Must I put this entries in radcheck table or in radreply

RE: FR with MySQL - Stored Procedures

2007-05-07 Thread Gunther
Alan DeKok wrote I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my

Proxying by Nas-Ip-Address (was Proxy.conf regex )

2007-05-07 Thread Andrea Cerrito
Hi to list, I've read the thread for Proxy.conf regex. I'd like to setup a proxy based on Nas-Ip-Address. I've tried two solutions: 1) add to users file (please note that 255.255.255.255 is done by radtest, and realm test.com is configured in proxy.conf) DEFAULT NAS-IP-Address ==

Re: Proxying by Nas-Ip-Address (was Proxy.conf regex )

2007-05-07 Thread Alan DeKok
Andrea Cerrito wrote: 1) add to users file (please note that 255.255.255.255 is done by radtest, and realm test.com is configured in proxy.conf) DEFAULT NAS-IP-Address == 255.255.255.255 Proxy-To-Realm = test.com The Proxy-To-Realm attribute belongs on the first line, along with the

IP billing with freeradius

2007-05-07 Thread satish patel
Dear Sir I am working in data center so i need ip base billing means which ip address useing how much bandwidth means i give 10 GB data transfer to my one customer and 10GB data transfer reached then i got mesge or i can block the port of server what ever this is example so

Re: EAP-TLS authentication

2007-05-07 Thread deepak kumar
Hi Alan I have downloaded freeradius 1.1.6 and implemented EAP-SIM using that. I have tested all the tests in src/tests and it worked fine. now i want to execute a script as and when radius receives acess-request for EAP-SIM I have written a script called notify.pl and in users file i made an

Re: MySQL Authentication

2007-05-07 Thread Joseph Sullivan
On 5/5/07 1:29 PM, liran tal [EMAIL PROTECTED] wrote: What version of mysql is it? For mysql5 you also need the libraries/dev, with debian these packages are called libmysqlclient15-dev and libmysqlclient15off MySQL ver 4.1 is running on a separate replication system. I installed MySQL 5.0

RE: Proxying by Nas-Ip-Address (was Proxy.conf regex )

2007-05-07 Thread Andrea Cerrito
Solved, thank you. For many NAS, the NAS-Ip-Address can be checked this way? DEFAULT NAS-Ip-Address =~ 1.2.3., Proxy-To-Real = test.com To match all network 1.2.3.0? I mean, can I check the ip address for the NAS as a regexp? Thank you -Original Message- From: [EMAIL PROTECTED]

Re: Proxying by Nas-Ip-Address (was Proxy.conf regex )

2007-05-07 Thread Arran Cudbard-Bell
Arran Cudbard-Bell wrote: Andrea Cerrito wrote: Solved, thank you. For many NAS, the NAS-Ip-Address can be checked this way? DEFAULT NAS-Ip-Address =~ 1.2.3., Proxy-To-Real = test.com To match all network 1.2.3.0? I mean, can I check the ip address for the NAS as a regexp? Thank you

Re: IP billing with freeradius

2007-05-07 Thread Peter Nixon
On Mon 07 May 2007, satish patel wrote: Dear Sir I am working in data center so i need ip base billing means which ip address useing how much bandwidth means i give 10 GB data transfer to my one customer and 10GB data transfer reached then i got mesge or i can block the

Re: Proxying by Nas-Ip-Address (was Proxy.conf regex )

2007-05-07 Thread Kevin Bonner
On Monday 07 May 2007 07:45:36 Andrea Cerrito wrote: Hi to list, I've read the thread for Proxy.conf regex. I'd like to setup a proxy based on Nas-Ip-Address. I've tried two solutions: 1) add to users file (please note that 255.255.255.255 is done by radtest, and realm test.com is

Re: IP billing with freeradius

2007-05-07 Thread tnt
If you are using sql accounting then make a sqlcounter that counts octets and send Auth-Type Reject if counter is over 10GB. Ivan Kalik Kalik Informatika ISP Dana 7/5/2007, satish patel [EMAIL PROTECTED] piše: Dear Sir I am working in data center so i need ip base billing

Re: Proxy.conf regex

2007-05-07 Thread tnt
It's a check item, so radcheck. Ivan Kalik Kalik Informatika ISP Dana 7/5/2007, Santiago Balaguer García [EMAIL PROTECTED] piše: DEFAULT User-Name =~ (([a-zA-Z]+\.)*foo.com, Proxy-To-Realm := foo.com Will cause the following to be proxied to foo.com: [EMAIL PROTECTED] [EMAIL PROTECTED]

Accept users by NAS-Identifier

2007-05-07 Thread AS Alex
How i can accept users by NAS-Identifier and not with NAS-AP-Address ?? How i can modify clients.conf (or other file) for use only nas identifier?? Thank - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

FreeRadius crash

2007-05-07 Thread Doug Hardie
I am encountering an infrequent problem where FreeRadius crashes about once a week on a fairly busy server. I have a primary and secondary authentication server and just a primary accounting server. Both the primary and secondary crash at the same time (well the secondary is about 30

MySQL and postauth_query

2007-05-07 Thread Hugh Messenger
Dear freeradius Alpha Geeks, Am I loosing my mind or is there a bug in the postauth_query in the MySQL version of sql.conf? I'm running freeradius 1.1.6 on RHEL4, and MySQL 5.0.37 on W2k. Don't ask. Out-of-box, this postauth query ... postauth_query = INSERT into ${postauth_table}

rlm_sqlippool in freeradius 1.1.6

2007-05-07 Thread Hugh Messenger
Is the rlm_sqlippool in 1.1.6 known to work with MySQL 5? Actually, I'm fairly sure it's not even getting as far as talking to the db. No matter what I try, it just tells me 'missing pool_name'. Which would seem to indicate that the Pool-Name checklist attribute isn't getting set. But If I

RE: MySQL and postauth_query

2007-05-07 Thread Cory Robson
. -- hugh - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 2248 (20070507) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list

Re: MySQL and postauth_query

2007-05-07 Thread George Embrey
= INSERT into ${postauth_table} (user, pass, reply, date) values ('%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW()) it works. -- hugh - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 2248 (20070507

Re: MySQL and postauth_query

2007-05-07 Thread Hugh Messenger
George Embrey [EMAIL PROTECTED] says: Queries to Windows MySQL servers from Linux Systems often fail unless the lower_case_table_names parameter is set to 0 in the my.ini file in the MySQL directory. I'm familiar with that issue, and I checked all the table case-ness. The problem seems to be

Re: rlm_sqlippool in freeradius 1.1.6

2007-05-07 Thread Hugh Messenger
I said: Is the rlm_sqlippool in 1.1.6 known to work with MySQL 5? Actually, I'm fairly sure it's not even getting as far as talking to the db. No matter what I try, it just tells me 'missing pool_name'. Turns out I borked something else in the users file which was breaking the Pool-Name

eap-tls authentication with free radius 1.1.5

2007-05-07 Thread anoop_c
Hi list I am tryinmg to do EAP_TLS certificate based authentication with free radius 1.1.5.The setup worked well with freeradius-snapshot-20021028.But as Windows vista is not supporting the same.So i am trying to do the authentication with 1.1.5 version Pls find the debug message.

Re: MySQL and postauth_query

2007-05-07 Thread George Embrey
Hugh Messenger wrote: George Embrey [EMAIL PROTECTED] says: Queries to Windows MySQL servers from Linux Systems often fail unless the lower_case_table_names parameter is set to 0 in the my.ini file in the MySQL directory. I'm familiar with that issue, and I checked all the table

Re: FreeRadius crash

2007-05-07 Thread A . L . M . Buxey
Hi, FreeRadius 1.1.2 on FreeBSD 6.1 using libpthread. I have tried using upgrade to 1.1.6 alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html