Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug mode the

How to use RADACCT in freeradius?

2012-05-29 Thread faizal ghazali
Hi, My lecturer had give me an assignment to setup a freeradius server on ubuntu and print out an accounting report from the server. i have success setup this marvellous server with this tutorial link *

Re: How to use RADACCT in freeradius?

2012-05-29 Thread Alan DeKok
faizal ghazali wrote: The problem is i dont know what data to fill in the attribute in radacct phpmyadmin table You don't. The server does this automatically when it receives accounting packets. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Alan DeKok
Turamarth wrote: I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i

Re: How to use RADACCT in freeradius?

2012-05-29 Thread DOMINIE.ORG
As Alan said: A radacct row is inserted automatically by FreeRADIUS for each user session. The session information is sent by the NAS when the user logs out. The following are the most important field: UserName - self explanatory AcctStartTime - session start time AcctStopTime - session stop time

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
i have no chance to change the OS. of server, and yes im using Freeradius.net. i review the sql.conf and radiussd.conf files looking for errors and nothing, the radius server still dont connect to mysql server. -- From: Alan DeKok

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread DOMINIE.ORG
Have you installed MySQL on the new machine and also is it started? localhost indicates that freeradius is looking for mysql on the machine from which it is running. Or is it running from a different machine? In which case you need to change the server parameter in sql.conf. You may need to open

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
the mysql server is on same machine, is and server that is running for 1 year at least, i connect with same user and password that all other aplications, so is not login problem, or firewall problem, but radius still stop trying to connect, but never says error or something like this, just

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Alan DeKok
Turamarth wrote: the mysql server is on same machine, is and server that is running for 1 year at least, i connect with same user and password that all other aplications, so is not login problem, or firewall problem, but radius still stop trying to connect, but never says error or

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Alan DeKok
Turamarth wrote: i have no chance to change the OS. of server, Nonsense. It should take you all of 2 hours to download a Linux distribution, and run it inside of a VM. and yes im using Freeradius.net. i review the sql.conf and radiussd.conf files looking for errors and nothing, the

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
the matter is not change the server Os. i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work. i just cant change the os or run a vm with a linux inside. From: Alan DeKok-2 [via FreeRadius] Sent: Tuesday,

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Alan DeKok
Turamarth wrote: the matter is not change the server Os. The problem is that we don't KNOW what the problem is. And we CANNOT help you. i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work. Sure. Do

FreeRadius autoreply the access chanllenge

2012-05-29 Thread sam
I setup the pam_radius_auth.so in pam.d/sshd to verify the user using the remote Radius server. As the protocol, When used in an Access-Challenge, it MAY indicate a dialog message to prompt the user for a response. like following flow 1) server sends the access-challenge message with

Re: FreeRadius autoreply the access chanllenge

2012-05-29 Thread Alan DeKok
sam wrote: I setup the pam_radius_auth.so in pam.d/sshd to verify the user using the remote Radius server I think the message flow is right, but at the point-2 and point-4, the prompt should be popped and ask us to input the passwd. However, our freeradius sends the access-Request

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Fajar A. Nugraha
On Tue, May 29, 2012 at 7:03 PM, Turamarth ad...@turamarth.com wrote: i have the same version of Freeradius.net running in a Win 7 64, and now need move it to Win server 2008r2, must be a way to make it work. Yes, there is. A sufficiently-knowledgable windows sysadmin would know what

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
FWIW though, you might be able to workaround your problem by using IP of mysql server (e.g. 127.0.0.1) instead of localhost. IIRC mysql treats those two differently. i had this problem on test machine with win 7, and i tried with all ips of machine. From: Fajar A. Nugraha-2 [via

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread alan buxey
Hi, I have installed Freeradius and mysql to use it for a Hostpot network on a Windows 7 64b on test lab and everithing is working fine. Now we are moving it to real server (Win server 2008r2 64b) to auth network clients in radius, and when i uncoment sql in radiussd.conf and i start in debug

Tunnel TLS Authentication with PAP

2012-05-29 Thread val john
Hi.. i have freeradius that uses LDAP authentication password in md5 format and have ubuntu client that users WPA supplicant with following details, Authentication : Tunneled TLS CA certificate : ca.pem Inner Authentication : PAP Then the username and password , because

Re: Problem with Freeradius.net + Mysql in Win server 2008r2

2012-05-29 Thread Turamarth
the mysql server is running, 2 websites uses it, and the radius uses the same credentials to log in. From: Alan Buxey [via FreeRadius] Sent: Tuesday, May 29, 2012 10:27 AM To: Turamarth Subject: Re: Problem with Freeradius.net + Mysql in Win server 2008r2 Hi, I have installed Freeradius

Re: Tunnel TLS Authentication with PAP

2012-05-29 Thread John Dennis
On 05/29/2012 09:49 AM, val john wrote: Hi.. i have freeradius that uses LDAP authentication password in md5 format and have ubuntu client that users WPA supplicant with following details, Authentication : Tunneled TLS CA certificate : ca.pem Inner Authentication : PAP

Re: FreeRadius autoreply the access chanllenge

2012-05-29 Thread sam
Thanks. i think i get the correct direction. just now checked the sshd_config. and i get following line # Change to no to disable s/key passwords #ChallengeResponseAuthentication yes ChallengeResponseAuthentication no I think use flag ChallengeResponseAuthentication yes can help me. Since my

Re: Tunnel TLS Authentication with PAP

2012-05-29 Thread alan buxey
Hi, because im using CA� certificate(ca.pem) of the radius in the client side ,�� server and client communication should be secure ...correct me if im� worng.. yes, secure - well, so long as the client is configured to only trust that CA and the CN of the real RADIUS server

more EAP/TTLS trouble

2012-05-29 Thread Steve Hopps
The only computer in our office which causes certificate errors is a Windows 7 machine. So I attempted to connect using EAP/TTLS and MSCHAPv2 using my linux machine and my Android phone. Now I get a different error. I also tried using PEAP on my Android phone, and received no certificate errors.

Re: more EAP/TTLS trouble

2012-05-29 Thread Aman Arneja
Steve Windows is trying to validate the server Cert. By default we have server Cert Validation enabled. You can disable this from the properties. Regards Aman Arneja On Wed, May 30, 2012 at 1:47 AM, Steve Hopps steve.ho...@gmail.com wrote: The only computer in our office which causes

Re: more EAP/TTLS trouble

2012-05-29 Thread alan buxey
Hi, certificate errors. What could the windows machine be doing different? Why does the machine even enter the picture when the authentication is between the Access Point and the server? authentication is between the client and the server - mediated over 802.1X by the Access point. thats why

Re: more EAP/TTLS trouble

2012-05-29 Thread Steve Hopps
But according to the configuration file: # The suffix module takes care of stripping the domain # (e.g. @example.com) from the User-Name attribute, and the # next few lines ensure that the request is not proxied. # # If you want the inner tunnel request to be

rlm_python configTuple question

2012-05-29 Thread PENZ Robert
Hi! The python functions should return (return, replyTuple, configTuple). return is one of the following constants #RLM_MODULE_REJECT = 0 # /* immediately reject the request */ #RLM_MODULE_FAIL = 1 # /* module failed, don't reply */ #RLM_MODULE_OK = 2 # /* the module is OK,