Re: Problems with radzap: radclient:: failed to get value

2011-12-20 Thread Sean Reifschneider
On 12/19/2011 04:03 PM, Alan Buxey wrote:
 you talk to the server using the servers secretnot the NAS with
 the NAS secret, so send a radzap command to your FR server with its
 secret from the session you are on (eg on localhost thats testing123
 by default..)

Ah hah, ok, thanks!  This pointer plus the pointer from one of my
associates that it doesn't actually log the user out, it just modifies the
radutmp.

The problem ended up being (beyond trying to talk to the NAS rather than
the server):

   We had both radutmp and sradutmp defined, so it was writing to both
   locations.

   radwho -R is reporting a blank Framed-IP-Address = line, which
   causes radclient to choke (that was the source of the failed to get
   value messages).

So, if I modify the radzap script to grep -v '^Framed-IP-Address', that
should work.

Thanks!

Sean
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Problems with radzap: radclient:: failed to get value

2011-12-19 Thread Sean Reifschneider
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I'm trying to run a radzap and having no luck.  For example, if I try:

   radzap -d /etc/raddb -N $NAS_IP -P 1 -u las $NAS_IP $NAS_PW
   radclient:: failed to get value
   radclient: Nothing to send.

I've also tried it with the NAS name (52a2, from /etc/raddb/naslist)
rather than IP:

   radzap -d /etc/raddb -N $NAS_IP -P 1 -u las 52a2 $NAS_PW
   radclient: Failed to find IP address for host 52a2: Success

If I run radwho:

   radwho -ZR -N 216.138.63.130 -P 1 -u las

I get a reasonable-looking:

   User-Name = las
   Acct-Session-Id = 01C1
   Acct-Status-Type = Stop
   NAS-IP-Address = $NAS_IP
   NAS-Port = 1
   Service-Type = Framed-User
   Framed-Protocol = PPP
   Framed-IP-Address =
   Acct-Session-Time = 239370

However, if I pipe that through radclient:

   radclient -x -d /etc/raddb -f - $NAS_IP acct $NAS_PW

I get the error above:

   radclient:: failed to get value
   radclient: Nothing to send.

I've been trying various combinations of both the output of radwho, and
commands for radclient to log a user out, based on searches on the Internet
including things like sending the packet of disconnect (PoD), including
things on this page:

   http://wiki.freeradius.org/Disconnect_Messages

including trying sending to ports 1700 and 3799, using commands like
disconnect and 40, using packets like:

  Acct-Session-Id = 01C1
  User-Name = las
  NAS-IP-Address = $NAS_IP

Using the above packet looks most promising, in that I don't get an error,
it just hangs a few seconds and then fails with no response from server
for ID 141 socket 3 or similar.

Any pointers on this?

The version of FreeRADIUS is 2.1.10 from CentOS.  There are a couple of
micro version updates I could do, but I didn't see any mention in the
changelog of anything related to this issue being resolved.

Thanks,
Sean
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFO774BxUhyMYEjVX0RAu4aAJ0R/vUb8XSKO2J0lCW9UKsq0jUgVwCeJF7a
8wxcDliE2oHyfqtDzJrgA00=
=II6m
-END PGP SIGNATURE-
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: Beginner Question: Hotspot Login Failed

2010-09-10 Thread Sean Wingert
Yes, Alan, you were right. The SQL entries were causing the message about 
Please update your configuration so that the known good. Since DaloRadius 
created those entries, I will investigate it.

Sean

This message is intended only for the individual or entity to which it is 
addressed and may contain information that is privileged, confidential and 
exempt from disclosure under applicable law.  If you are not the intended 
recipient, or the agent responsible for delivering the message to the intended 
recipient, you are hereby notified that any dissemination, distribution or 
copying of this communication is strictly prohibited, and you are requested to 
return the original message to the sender.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Beginner Question: Hotspot Login Failed

2010-09-09 Thread Sean Wingert
Hi All,

In my testing lab (yes, I'm new to FreeRadius), usernames entered (e.g. with 
attribute User-Password in sql radcheck table) via my NAS (dd-wrt with 
Chillispot) refuse to authenticate (error below), whereas attribute=Auth-Type 
(what DaloRadius calls a PIN) works fine. I'm using the packaged MySQL 
(5.0.51a-24+lenny3) with FreeRadius (2.0.4+dfsg-6)and freeradius-dialupadmin 
(2.0.4+dfsg-6) on Debian Lenny, along with Daloradius 0.9-8 for GUI frontend.

Below is the Daloradius-populated mysql table (again, only 4321 works fine, 
regardless of password entered):

++--+++--+
| id | username | attribute  | op | value|
++--+++--+
|  9 | aaa  | MD5-Password   | := | 47bce5c74f589f4867dbd57e9ca9f808 |
|  7 | 123  | User-Password  | := | 123  |
|  8 | 4321 | Auth-Type  | := | Accept   |
| 10 | bbb  | SHA1-Password  | := | bbb  |
| 11 | ccc  | CHAP-Password  | := | ccc  |
| 12 | eee  | Cleartext-Password | := | eee  |
++--+++--+
6 rows in set (0.00 sec)

==
Debug output of working connection
==
rad_recv: Access-Request packet from host 192.168.0.72 port 2112, id=0, 
length=191
User-Name = 4321
User-Password = \223=\0322\343\233\361a\365\323\320\333_\245×¼
NAS-IP-Address = 0.0.0.0
Service-Type = Login-User
Framed-IP-Address = 192.168.182.3
Calling-Station-Id = C4-17-FE-1C-5C-9D
Called-Station-Id = 00-24-A5-6F-81-0A
NAS-Identifier = 1
Acct-Session-Id = 4c890e89
NAS-Port-Type = Wireless-802.11
NAS-Port = 0
Message-Authenticator = 0x468b4f124525571d6d37d6d1ec69cbdd
WISPr-Logoff-URL = http://192.168.182.1:3990/logoff;
+- entering group authorize
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
rlm_realm: No '@' in User-Name = 4321, looking up realm NULL
rlm_realm: No such realm NULL
++[suffix] returns noop
  rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop
++[unix] returns notfound
++[files] returns noop
expand: %{User-Name} - 4321
rlm_sql (sql): sql_set_user escaped user -- '4321'
rlm_sql (sql): Reserving sql socket id: 3
expand: SELECT id, username, attribute, value, op   FROM 
radcheck   WHERE username = '%{SQL-User-Name}'   ORDER BY id - 
SELECT id, username, attribute, value, op   FROM radcheck   
WHERE username = '4321'   ORDER BY id
rlm_sql (sql): User found in radcheck table
expand: SELECT id, username, attribute, value, op   FROM 
radreply   WHERE username = '%{SQL-User-Name}'   ORDER BY id - 
SELECT id, username, attribute, value, op   FROM radreply   
WHERE username = '4321'   ORDER BY id
expand: SELECT groupname   FROM radusergroup   WHERE 
username = '%{SQL-User-Name}'   ORDER BY priority - SELECT groupname   
FROM radusergroup   WHERE username = '4321'   ORDER BY 
priority
rlm_sql (sql): Released sql socket id: 3
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
rlm_pap: Found existing Auth-Type, not changing it.
++[pap] returns noop
  rad_check_password:  Found Auth-Type Accept
  rad_check_password: Auth-Type = Accept, accepting the user
Login OK: [4321/\223=\0322\343\233\361a\365\323\320\333_\245×¼] (from client 
Subnet port 0 cli C4-17-FE-1C-5C-9D)
+- entering group post-auth
rlm_sql (sql): Processing sql_postauth
expand: %{User-Name} - 4321
rlm_sql (sql): sql_set_user escaped user -- '4321'
expand: %{User-Password} - =93=3D=1A2=E3=9B=F1a=F5=D3=D0=DB_=A5=D7=BC
expand: INSERT INTO radpostauth   (username, 
pass, reply, authdate)   VALUES (   
'%{User-Name}',   
'%{%{User-Password}:-%{Chap-Password}}',   
'%{reply:Packet-Type}', '%S') - INSERT INTO radpostauth
   (username, pass, reply, authdate)   VALUES ( 
  '4321',   
'=93=3D=1A2=E3=9B=F1a=F5=D3=D0=DB_=A5=D7=BC',   
'Access-Accept', '2010-09-09 08:36:57')
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth 
  (username, pass, reply, authdate)   VALUES (  
 '4321',   
'=93=3D=1A2=E3=9B=F1a=F5=D3=D0=DB_=A5=D7=BC',   

RE: Beginner Question: Hotspot Login Failed

2010-09-09 Thread Sean Wingert
Thanks to Alan and Stephen, I am closer to a solution. I realized the scrambled 
password was due to hotspotlogin.php (I need to study Chillispot more), so for 
now I commented out its uamsecret line, which -- although it still fails on the 
123 account -- provides different output in debugging mode:


rad_recv: Access-Request packet from host 192.168.0.72 port 2116, id=0, 
length=209
User-Name = 123
CHAP-Challenge = 0x176af9b56c5cd047480bbaa4e88b04fd
CHAP-Password = 0x00a6498cb1313e02eb187f93dc05302b50
NAS-IP-Address = 0.0.0.0
Service-Type = Login-User
Framed-IP-Address = 192.168.182.3
Calling-Station-Id = C4-17-FE-1C-5C-9D
Called-Station-Id = 00-24-A5-6F-81-0A
NAS-Identifier = 1
Acct-Session-Id = 4c892dd4
NAS-Port-Type = Wireless-802.11
NAS-Port = 0
Message-Authenticator = 0x5a8e0072ed810540ab6baf61b668b2bd
WISPr-Logoff-URL = http://192.168.182.1:3990/logoff;
+- entering group authorize
++[preprocess] returns ok
  rlm_chap: Setting 'Auth-Type := CHAP'
++[chap] returns ok
++[mschap] returns noop
rlm_realm: No '@' in User-Name = 123, looking up realm NULL
rlm_realm: No such realm NULL
++[suffix] returns noop
  rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop
++[unix] returns notfound
++[files] returns noop
expand: %{User-Name} - 123
rlm_sql (sql): sql_set_user escaped user -- '123'
rlm_sql (sql): Reserving sql socket id: 4
expand: SELECT id, username, attribute, value, op   FROM 
radcheck   WHERE username = '%{SQL-User-Name}'   ORDER BY id - 
SELECT id, username, attribute, value, op   FROM radcheck   
WHERE username = '123'   ORDER BY id
rlm_sql (sql): User found in radcheck table
expand: SELECT id, username, attribute, value, op   FROM 
radreply   WHERE username = '%{SQL-User-Name}'   ORDER BY id - 
SELECT id, username, attribute, value, op   FROM radreply   
WHERE username = '123'   ORDER BY id
expand: SELECT groupname   FROM radusergroup   WHERE 
username = '%{SQL-User-Name}'   ORDER BY priority - SELECT groupname   
FROM radusergroup   WHERE username = '123'   ORDER BY 
priority
rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
rlm_pap: Found existing Auth-Type, not changing it.
++[pap] returns noop
  rad_check_password:  Found Auth-Type CHAP
!!!
!!!Replacing User-Password in config items with Cleartext-Password. !!!
!!!
!!! Please update your configuration so that the known good   !!!
!!! clear text password is in Cleartext-Password, and not in User-Password. !!!
!!!
auth: type CHAP
+- entering group CHAP
  rlm_chap: login attempt by 123 with CHAP password
  rlm_chap: Using clear text password 123 for user 123 authentication.
  rlm_chap: Password check failed
++[chap] returns reject
auth: Failed to validate the user.
Login incorrect (rlm_chap: Wrong user password): [123/CHAP-Password] (from 
client Subnet port 0 cli C4-17-FE-1C-5C-9D)
  Found Post-Auth-Type Reject
+- entering group REJECT
expand: %{User-Name} - 123
 attr_filter: Matched entry DEFAULT at line 11
++[attr_filter.access_reject] returns updated
Delaying reject of request 10 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 10
Sending Access-Reject of id 0 to 192.168.0.72 port 2116
Waking up in 4.9 seconds.
Cleaning up request 10 ID 0 with timestamp +3707
Ready to process requests.

This message is intended only for the individual or entity to which it is 
addressed and may contain information that is privileged, confidential and 
exempt from disclosure under applicable law.  If you are not the intended 
recipient, or the agent responsible for delivering the message to the intended 
recipient, you are hereby notified that any dissemination, distribution or 
copying of this communication is strictly prohibited, and you are requested to 
return the original message to the sender.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: Beginner Question: Hotspot Login Failed

2010-09-09 Thread Sean Wingert
 from host 192.168.0.72 port 2126, id=4, 
length=124
Acct-Status-Type = Start
User-Name = 123
Calling-Station-Id = C4-17-FE-1C-5C-9D
Called-Station-Id = 00-24-A5-6F-81-0A
NAS-Port-Type = Wireless-802.11
NAS-Port = 0
NAS-Port-Id = 
NAS-IP-Address = 0.0.0.0
NAS-Identifier = 1
Framed-IP-Address = 192.168.182.2
Acct-Session-Id = 4c8944db
+- entering group preacct
++[preprocess] returns ok
rlm_acct_unique: Hashing 'NAS-Port = 0,Client-IP-Address = 
192.168.0.72,NAS-IP-Address = 0.0.0.0,Acct-Session-Id = 
4c8944db,User-Name = 123'
rlm_acct_unique: Acct-Unique-Session-ID = acc24399d8fb1504.
++[acct_unique] returns ok
rlm_realm: No '@' in User-Name = 123, looking up realm NULL
rlm_realm: No such realm NULL
++[suffix] returns noop
++[files] returns noop
+- entering group accounting
expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d 
- /var/log/freeradius/radacct/192.168.0.72/detail-20100909
rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d 
expands to /var/log/freeradius/radacct/192.168.0.72/detail-20100909
expand: %t - Thu Sep  9 11:34:59 2010
++[detail] returns ok
++[unix] returns ok
expand: /var/log/freeradius/radutmp - /var/log/freeradius/radutmp
expand: %{User-Name} - 123
++[radutmp] returns ok
expand: %{User-Name} - 123
rlm_sql (sql): sql_set_user escaped user -- '123'
expand: %{Acct-Delay-Time} -
expand:INSERT INTO radacct (acctsessionid,
acctuniqueid, username,  realm,nasipaddress, 
nasportid,  nasporttype,  acctstarttime,acctstoptime,   
   acctsessiontime,  acctauthentic,connectinfo_start,  
connectinfo_stop, acctinputoctets,  acctoutputoctets,  
calledstationid,  callingstationid, acctterminatecause,  
servicetype,  framedprotocol,   framedipaddress,  
acctstartdelay,   acctstopdelay,xascendsessionsvrkey)   VALUES  
   ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',  
'%{SQL-User-Name}',  '%{Realm}', '%{NAS-IP-Address}', 
'%{NAS-Port}',  '%{NAS-Port-Type}', '%S', NULL,  '0', 
'%{Acct-Authentic}', '%{Connect-Info}',  '', '0', '0',  
'%{Called-Station-Id}', '%{Calling-Station-Id}', '',  
'%{Service-Type}', '%{Framed-Protoc!
 ol}', '%{Framed-IP-Address}',  '%{%{Acct-Delay-Time}:-0}', '0', 
'%{X-Ascend-Session-Svr-Key}') -INSERT INTO radacct 
(acctsessionid,acctuniqueid, username,  realm,
nasipaddress, nasportid,  nasporttype,  acctstarttime,
acctstoptime,  acctsessiontime,  acctauthentic,
connectinfo_start,  connectinfo_stop, acctinputoctets,  
acctoutputoctets,  calledstationid,  callingstationid, 
acctterminatecause,  servicetype,  framedprotocol,   
framedipaddress,  acctstartdelay,   acctstopdelay,
xascendsessionsvrkey)   VALUES ('4c8944db', 
'acc24399d8fb1504',  '123',  '', '0.0.0.0', '0',
  'Wireless-802.11', '2010-09-09 11:34:59', NULL,  '0', '', '', 
 '', '0', '0',  '00-24-A5-6F-81-0A', 
'C4-17-FE-1C-5C-9D', '',  '', '', '192.16!
 8.182.2',  '0', '0', '')
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok
expand: %{User-Name} - 123
 attr_filter: Matched entry DEFAULT at line 12
++[attr_filter.accounting_response] returns updated
Sending Accounting-Response of id 4 to 192.168.0.72 port 2126
Finished request 48.
Cleaning up request 48 ID 4 with timestamp +6565
Going to the next request
Waking up in 4.9 seconds.
Cleaning up request 47 ID 0 with timestamp +6565
Ready to process requests.


Thanks,

Sean

This message is intended only for the individual or entity to which it is 
addressed and may contain information that is privileged, confidential and 
exempt from disclosure under applicable law.  If you are not the intended 
recipient, or the agent responsible for delivering the message to the intended 
recipient, you are hereby notified that any dissemination, distribution or 
copying of this communication is strictly prohibited, and you are requested to 
return the original message to the sender.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Restricting user to specific NAS Port

2008-11-11 Thread Sean Preston
Hi

2008/11/11  [EMAIL PROTECTED]:
I need to restrict a specifc user to say 2 specific NAS ports and then
define a different account to some different specific NAS ports.
Currently as long as an account is only ever going to use one NAS port
I can restrict it by adding the entry to the radcheck table.  So for
example if I have 10 users, I have 10 entries with the NAS port and
the == operator.  However if I want to add some accounts with multiple
entries then

 .. use huntgroups.

Ok I think I understand what needs to be done.  So the next question
then is how do I setup huntgroups to be in the same database as
everything else because as it stands it looks like it can only be a
file and I am going to have hundreds of groups and it would be easier
to manage in the database.

Regards
Sean

-- 
Sean Preston
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Restricting user to specific NAS Port

2008-11-11 Thread Sean Preston
Hi

2008/11/11  [EMAIL PROTECTED]:
 Use huntgroups to group ports.

 [EMAIL PROTECTED]   Huntgroup-Name  ==  whatever

Thanks.  I took a look at huntgroups and it looks userful but I think
it is not right for what I am trying to do.  I think I did not explain
well enough.

I need to restrict a specifc user to say 2 specific NAS ports and then
define a different account to some different specific NAS ports.
Currently as long as an account is only ever going to use one NAS port
I can restrict it by adding the entry to the radcheck table.  So for
example if I have 10 users, I have 10 entries with the NAS port and
the == operator.  However if I want to add some accounts with multiple
entries then if I put more than one entry in radcheck for the same
username then it never authenticates because I assume it is trying to
ensure the user matches all entries which it obviously does not.  If I
use the += operator or := operators then it never seems to restrict
but always authenticates no matter what the port is.

I hope this explains what I am trying to do a little better.

Regards
Sean


-- 
Sean Preston
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Restricting user to specific NAS Port

2008-11-11 Thread Sean Preston
Hi

I have gone through the archives and either I am searching on the
wrong terms or there is not  much on this topic.  I am using
FreeRadius 1.1.3 on Debian with a database backend to FreeRadius and I
need to restrict some ADSL users to specific NAS Ports.  I found that
adding an entry to radcheck like:
[EMAIL PROTECTED]   NAS-Port-Id ==  abc

restricts the user to this port  Now how do I add additional NAS ports
so that they still authenticate because the same useraccount needs to
be able to log in from multiple NAS ports.
I tried putting in multiple entries but it does not seem to work.  I
get an authentication accepted response for the first port and then
additional ones always reject.

Any help or pointers would be greatly appreciated.

Regards
Sean

--
Sean Preston
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Access-Reject in a php script (manIP)

2007-10-26 Thread Sean Bracken

Hi,

I have a working PHP script that may help. You can load it from 
http://swarmhotspots.com/bb.php.txt The sript is designed to reply to 
Chillispot authentication requests but should be easy to modify for other 
NAS's.


Hope it helps.

Regards,

Sean Bracken

http://swarmhotspots.com 


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Strange problem

2007-08-21 Thread Sean Bracken
Hi, I am using Freeradius with a MySQL backend and the users log in through 
Chillispot running on Buffalo and Linksys routers running DD-WRT. The 
problem is that randomly users are recorded up to five times in radacct with 
one login. This is not a problem for users with expiration acccounts but 
users with max-all-session accounts are thrown out before they have really 
used up their time. Has anyone come accross this before? I'd appreiate any 
help.

Sean
- Original Message - 
From: [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Tuesday, August 21, 2007 4:28 PM
Subject: Freeradius-Users Digest, Vol 28, Issue 73


 Send Freeradius-Users mailing list submissions to
 freeradius-users@lists.freeradius.org

 To subscribe or unsubscribe via the World Wide Web, visit
 http://lists.freeradius.org/mailman/listinfo/freeradius-users
 or, via email, send a message with subject or body 'help' to
 [EMAIL PROTECTED]

 You can reach the person managing the list at
 [EMAIL PROTECTED]

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of Freeradius-Users digest...


 Today's Topics:

   1. RE: PAM Radius (Sayan S)
   2. customise dialup admin (Carl aniams)
   3. I am a first timer ! (Joshua Mashiane)
   4. Database Population problem with mysql (ram)
   5. RE: Database Population problem with mysql (Josh Howlett)
   6. Re: I am a first timer ! (Alan DeKok)
   7. Re: Database Population problem with mysql (ram)


 --

 Message: 1
 Date: Tue, 21 Aug 2007 04:22:20 -0700 (PDT)
 From: Sayan S [EMAIL PROTECTED]
 Subject: RE: PAM Radius
 To: FreeRadius users mailing list
 freeradius-users@lists.freeradius.org
 Cc: Josh Howlett [EMAIL PROTECTED]
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=iso-8859-1

 yes josh, as you guessed it, it doesn't work with HP-UX and Solaris (to 
 some extent, as it provides a warning during useradd command with '@' in 
 the username).
 We don't plan to use LDAP for NSS immediately.

 thanks to all.

 sayan

 Josh Howlett [EMAIL PROTECTED] wrote: Hi Sayan,

 I think I have tried this previously, and it was possible (on
 Linux/glibc anyway - YMMV with other unices).

 TBH, I don't really see the point in using RADIUS when you'll (probably)
 want to use LDAP anyway for nss resolution, so you might as well just
 use LDAP for PAM.

 josh.

 -Original Message-
 From:
 [EMAIL PROTECTED]
 org
 [mailto:[EMAIL PROTECTED]
 eradius.org] On Behalf Of Sayan S
 Sent: 20 August 2007 14:04
 To: FreeRadius users mailing list
 Subject: Re: PAM Radius

 Thanks Alan for the quick response.
 I am referring to realm here, as RADIUS support realms, and
 we are using RADIUS to authenticate the users to Linux, so
 seems like we need to have all users contained in the same realm.

 Is having username in [EMAIL PROTECTED] form a valid unix format? I
 was thinking the first part of the [EMAIL PROTECTED] should be the
 unix username though the radius request is sent as
 [EMAIL PROTECTED] Otherwise we need to have a comprehensive
 [EMAIL PROTECTED] to Unix-userid mapping.

 regards,
 sayan

 Alan DeKok  wrote:

  Sayan S wrote:
   Greetings, I am very new to RADIUS and PAM RADIUS.
   I am trying to configure PAM Radius to authenticate
 users on a Linux
   host. I would like to know, how to configure PAM
 Radius to authenticate
   users from different realms, as the current
 configuration doesn't seem
   to take realm.

  You don't use realms in Unix logins.

   please help me with this as I have configured users
 to be part of
   different realms on radius server and now want to
 authenticate all those
   users to the same Linux host.

  You just login as [EMAIL PROTECTED]. That might work.

  Alan DeKok.
  -
  List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html



 

 Park yourself in front of a world of choices in alternative vehicles.
 Visit the Yahoo! Auto Green Center.
 n_center/;
 _ylc=X3oDMTE5cDF2bXZzBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ
 3JlZW4tY2VudGVy


 -
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/users.html



 -
 Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, 
 news, photos  more.
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070821/8287c4ad/attachment-0001.html

 --

 Message: 2
 Date: Tue, 21 Aug 2007 15:32:04 +0200
 From: Carl aniams [EMAIL PROTECTED]
 Subject: customise dialup admin
 To: freeradius-users@lists.freeradius.org
 Message-ID:
 [EMAIL PROTECTED]
 Content-Type: text/plain; charset=iso-8859-1

 Hi

 i'm presently using dialup admin for client connexion to the net.
 but my handicap is the time counter. i would like to know if it would be
 possible
 to set

rlm_eap_tls: SSL_read failed in a system call

2007-04-24 Thread Sean McNamara
Hello all,
   
I saw there was a bit of talk in 2006 over this issue, but, I wasn't 
able to track down a definitive solution. We're running FreeRADIUS 
1.1.5 with EAP/TTLS (openSSL 0.9.8d) on Solaris 10.   The server will 
come up and process clients for a few days, but, every now and then it 
begins denying all auth-requests with the following error:

Apr 24 09:56:12 as2.villanova.edu radiusd[1033]: [ID 702911 
daemon.notice] Login incorrect (rlm_ldap: User not found): [anonymous] 
(from client VillanovaWireless port 5191 cli 000b.7d22.b3a9)
Apr 24 09:56:12 as2.villanova.edu radiusd[1033]: [ID 702911 
daemon.error] TLS Alert write:fatal:bad record mac
Apr 24 09:56:12 as2.villanova.edu radiusd[1033]: [ID 702911 
daemon.error] TLS_accept:error in SSLv3 read certificate verify A
Apr 24 09:56:12 as2.villanova.edu radiusd[1033]: [ID 702911 
daemon.error] rlm_eap: SSL error error:1408F119:SSL 
routines:SSL3_GET_RECORD:decryption failed or bad record mac
Apr 24 09:56:12 as2.villanova.edu radiusd[1033]: [ID 702911 
daemon.error] rlm_eap_tls: SSL_read failed in a system call (-1), TLS 
session fails.

A restart makes the server happy and it goes back to properly auth'ing 
clients...

As of the moment I'm compiling FreeRADIUS 1.1.6 and hoping for some 
improvement, but, does anyone have any additional advice or experience 
with this issue.  .. or better yet, does anyone know the fix? 

Thanks for your time!

..Sean.




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


LDAP server per realm

2007-04-16 Thread Sean McNamara
Hello everyone,

I'm working on finding a way to define multiple local realms and have 
each have a unique ldap profile associated with them.We want one 
associated with a particular realm, and the other to be the 
catchall/default case.  In addition to this, we're also using EAP/TTLS, 
which may or not complicate the situation..  After googling a bit, I was 
under the impression that something along the following lines should work:
Here are the relevant parts of the the files I modified:

in proxy.conf:
realm VLS {
type= radius
authhost= LOCAL
accthost= LOCAL
}

in dictionary:
VALUE   Auth-Type   VU  1
VALUE   Auth-Type   VLS 2

VALUE   Autz-Type   VU  1
VALUE   Autz-Type   VLS 2

in users:
DEFAULT Domain == VLS, Autz-Type := VLS


in radiusd.conf:

ldap vlsldap {

set_auth_type = yes
}

ldap vuldap {

set_auth_type = yes
}

authorize {
...
...
Autz-Type VLS {
   vlsldap
}
vuldap

...
}

authenticate {
   ...
Auth-Type VLS {
vlsldap
}
vuldap
   ...
}


When I attempt to authenticate, regardless of whether I specify a realm 
or not, it only checks the vuldap servers.  Any suggestions would be 
greatly appreciated!

Thank you..

..Sean.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Counter

2006-12-12 Thread Sean
 Hi Alan, Thanks for all the help last night. I've made a lot of
progress today. Max-Daily-Session is now being recognised as a valid
attribute and users with the attribute are being authenticated. The
problem I now have is that the users are being disconnected after their
allocated time has expired but they can log back in again straight away
instead of having to wait 24 hours.

I have this in the users file 

 DEFAULTMax-Daily-Session := 300

This in radiusd.conf

$INCLUDE  ${confdir}/sql.conf


sqlcounter dailycounter {
   counter-name = Daily-Session-Time
 check-name = Max-Daily-Session
 sqlmod-inst = sql
 key = User-Name
 reset = daily
 query = SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime  '%b'
 }

instantiate {
 
exec 
expr
noresetcounter   
daily
}

Could you please give me some pointers to where I'm going wrong. I've
scoured the list archives and Google looking for answers.

Regards,

Sean

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Counter

2006-12-12 Thread Sean
On Tue, 2006-12-12 at 22:35 +0100,
[EMAIL PROTECTED] wrote:
 Sean wrote:
   Hi Alan, Thanks for all the help last night. I've made a lot of
  progress today. Max-Daily-Session is now being recognised as a valid
  attribute and users with the attribute are being authenticated. The
  problem I now have is that the users are being disconnected after
 their
  allocated time has expired but they can log back in again straight
 away
  instead of having to wait 24 hours.
 
   Is the NAS sending accounting packets?  If not, the server has no
 way
 of knowing that the time was used up.
Yes it is. It's a Linksys 54G running DD-WRT and Chillispot. The
accounting works for Max-All-Session and Expiration. Also the user is
disconnected after the correct time has elapsed under Max-Daily-Session.
The problem is that he can log back on again straight away, instead of
having to wait twenty four hours. 

 
   Did you list sql in the accounting section?  If not, the
 accounting information won't be written to SQL.

Yes sql is listed in accounting and the accounting information is being
written into radacct. 

I think the problem might be in my sql code in sql.conf. I'll puzzle
over it tonight although it works fine with the other attributes. 

Regards,

Sean






 
   Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


SQL Counter

2006-12-11 Thread Sean
Hi,

Sorry if this is a repeat. I'm not sure if an email I sent yesterday got
through.

Clearly I'm missing something simple here. I'm trying to create accounts
that will renew on a daily or monthly basis.

I've put this code into my radiusd.conf file to test daily renewals.

$INCLUDE  ${confdir}/sql.conf


sqlcounter dailycounter {
 counter-name = Daily-Session-Time
 check-name = Max-Daily-Session
 sqlmod-inst = sql
 key = User-Name
 reset = daily
 query = SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'
 }

I've created this account in the MySQL radcheck table.

ropgis12 User-Password := gisnopum
ropgis12 Simultaneous-Use:= 1 
ropgis12 Max-Daily-Session := 1800

radiusd -X gives the following result.

rlm_sql (sql): Reserving sql socket id: 0
rlm_sql: Failed to create the pair: Unknown attribute
Max-Daily-Session
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 0
  modcall[authorize]: module sql returns fail for request 39
modcall: group authorize returns fail for request 39


I can't understand why Max-Daily-Session is an unknown attribute when
it's declared in the radiusd.conf and radius loads with no errors.

As usual any help would be appreciated.

Sean Bracken 
 


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Counter

2006-12-11 Thread Sean

  I can't understand why Max-Daily-Session is an unknown attribute
 when
  it's declared in the radiusd.conf and radius loads with no errors.
 
   Because attributes are defined in the dictionaries.
 
   Arguably, the sqlcounter module should look up that attribute, and
 either complain if it doesn't exist, or else create it.  That doesn't
 happen right now.
 

Okay, thanks Alan. Should I edit a dictionary file and if so which one? 

Regards,

Sean

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: SQL Counter (Enrique Acosta)

2006-12-11 Thread Sean
 1. Fwd: SQL Counter (Enrique Acosta)

Thanks Enrique. I upgraded to 1.1.3 but the error is still there. Alan
gave me a hint that the attribute is not in the dictionary, so I've
spent all evening searching the dictionary files looking for SQL
attributes with no luck. My searches of the list archives suggest that
Max-Daily-Session and Max-Monthly-Session are valid attributes. I think
that the code I added to radiusd.conf is okay. I've listed it below.

$INCLUDE  ${confdir}/sql.conf


sqlcounter dailycounter {
 counter-name = Daily-Session-Time
 check-name = Max-Daily-Session
 sqlmod-inst = sql
 key = User-Name
 reset = daily
 query = SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'
 }

So where am I going wrong? If it was a problem in my SQL queries I
wouldn't expect the following reply that comes from radius.


rlm_sql (sql): Reserving sql socket id: 0
rlm_sql: Failed to create the pair: Unknown attribute
Max-Daily-Session
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 0
  modcall[authorize]: module sql returns fail for request 39
modcall: group authorize returns fail for request 39

Did you ever get it to work? The guy I'm doing this for is putting me
under a lot of pressure to get it finished.

Regards,

Sean Bracken


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Counter

2006-12-11 Thread Sean
 Read /etc/raddb/dictionary

Alan, that directory doesn't exist on either of my systems. One system
is running 1.0.4 and the other is running 1.1.3. I've tried searching
the dictionaries for Max-All-Session, because that attribute works as
does Expiration. The dictionaries that I'm searching are
in /local/share/freeradius.  

Thanks for giving me your time with this. Do you think that there is a
basic flaw in my setup? Should I delete everything and start from
scratch? Are Max-Daily-Session and Max-Monthly-Session valid attributes
that I can use in the same way that I use Expiration and
Max-All-Session? 

I doubt that it is a FreeRadius problem, and more likely that I'm
mistaken in how I think it works. 

Regards,

Sean

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Expiration

2006-11-28 Thread Sean
Hi,

Just a quick question. Is expiration := Never valid in radcheck? At the
moment I set dates a few years into the future for accounts that I don't
want to expire, but I'm sure that they'll come back to haunt me later.

Regards,

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Open access

2006-10-27 Thread Sean
Hi, 

I want to grant access to any user or password on my backup server. I
found DEFAULT Auth-Type := Accept in the FAQ, however it gives no hint
as to where to put the code. I've been trying various parts of
raddb.conf with no success.

Any help appreciated as usual.

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: Open access (Jonathan De Graeve)

2006-10-27 Thread Sean
Hi Jonatahan,

Thanks for the quick response. It worked first time.

Regards,

Sean

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: SQL Accounting oddness

2006-10-11 Thread Sean
Hi,

Check that you have all the ports used by FreeRadius open. It looks as
if the accounting traffic is not getting through to the server.

Let me know if I'm right.


Regards,

Sean Bracken

http://swarmhotspots.com


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Accounting Stopped

2006-09-29 Thread sean
Hi Alan,

Thanks for taking the time to respond. I've already fixed the problem. It
only took a bit of lateral thinking. The ADSL modem wasn't exchanging any
information on port 1813. For the life of me I can't understand how it
could re-boot and only loose a bit of it's setup. It would have been much
better if it had lost everything. I wasted the best part of a week testing
syslogd, reinstalling FreeRadius, MySQL and setting up a new test server.
Anyway, once again thanks. I really appreciate the time and effort you
take to give support to end users.

Regards,

Sean


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


syslog.conf

2006-09-27 Thread sean
Hi,

I've been running a trouble free Radius server for over a year. Last
weekend a local power company substation went on fire. This resulted in a
massive power surge and a major system crash. Since then Radius has been
validating users from MySQL no problem. However it is not updating its log
files or radacct in the database. After a lot of searching I discovered
that the Linux (Mandriva 2006) syslog.conf was corrupted. I've created a
new syslog and reinstalled Radius version 1.0.5. The problem has
persisted. I reckon I must be missing something in the log config. Any
advice or help would be very much appreciated. Two nights now with no
sleep.

Regards and thanks in advance.

Sean


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Disconnect

2006-08-31 Thread Sean
Hi,

Does anyone know how to get disconnect to work with radclient? I can get
it to return status but when I try disconnect radiusd -X returns the
following:-

rad_recv: Disconnect-Request packet from host 127.0.0.1:57181, id=9,
length=29
Unknown packet code 40 from client swarm:57181 - ID 9 : IGNORED

Any help or hints would be much appreciated.

Thanks,

Sean

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: Report Generator

2006-08-28 Thread Sean
 Hi Andre,

You can download the work to date here
http://swarmhotspots.com/phpreports.tar.gz I'm integrating phpMyPrepaid
and Dialup Admin into it at the moment, so there are a lot of redundant
files included in the tar file. You can have a look at how it works at
http://topup.ie/reports username testuser, password testuser. Some
reports ask for a client user name use seanb52, some reports ask for a
NAS ID use palm1 and some reports request the NAS IP use 82.153.112.235

Please give me some feedback. I'd like to know if any of this would be
useful or worth putting onto Sourceforge when it's ready for release.
There is no documentation ready yet but if you need help send me an
email. Don't tie up the FreeRadius list with private correspondence.

Regards,

Sean Bracken

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re:Report Generator

2006-08-26 Thread Sean
Hi, 

I'm developing a full reporting and statistics suite at the moment. I'm
integrating it into phpMyPrepaid and have used Carl Peterson's menu
structures and style sheets. The site usage report uses the Radius log
files. I changed the logging to store one months data in a separate file
for each hotspot. The individual user report gets its information from
radacct. The ticket reports are not finished yet. I've added an extra
field to radacct called hotspot and edited the accounting sections of
sql.conf to put the Radius NAS ID into this field. When it's finished
site owners will be able to generate used, unused and partly used ticket
reports for their sites. You can download my work to date here
http://swarmhotspots.com/phpreports.tar.gz 

I hope you find it useful. As usual I welcome any advice, improvements
or comments. 

Regards 

Sean

http://swarmhotspots.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Report Generator

2006-08-25 Thread Sean
Hi Morder,

I've also written a utility to allow users to see their usage. I'm tying
it into a complete reporting and statistics package, I expect to have a
test version ready over the weekend. As soon as it's ready I'll post a
download link here. By the way an official forum for FreeRadius users
would be a good idea. I've started an informal forum at
http://topup.ie/phpBB2/ I hope it grows into a good site for people to
share experience and help each other.

Regards,

Sean Bracken

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Report Generator

2006-08-23 Thread Sean
Hi,

Ive written a report generator in PHP and HTML that will allow your
clients to generate usage reports from the FreeRadius log files. When
the user logs in he/she is asked for their IP address and the Month that
they want to display. If anyone wants a copy let me know. If there is
enough interest I'll make it available for public download.

Regards,

Sean Bracken

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: mysql accounting

2006-06-14 Thread Sean Taylor
Thanks for that,
I cant believe I didnt find it.  I scoured the wiki.  I seriously don't
like to ask for help unless I just cant find it anywhere.  Anyways, I'm
working on a pretty neat php5 driven interface for this whole thing that
I would be happy to share after it's finished if there would be an
interest in that sort of thing.

On Wed, 2006-06-14 at 12:06 +0200, Nicolas Baradakis wrote:
 Seferovic Edvin wrote:
 
  I do NOT want to be rude, but sometimes searching the archives helps A LOT !
  BELIEVE ME ! But for the lazy developers among you people - here is the part
  that describes the needed feature. Thanks to Jamal ( of course ). This is
  copy paste - so do NOT blame me ;)
 
 You're right, but unfortunately you didn't pick up the easiest method.
 This question has been asked so many many times on the mailing list
 that now it's in the FAQ. (but it appears people are too lazy to read
 the FAQ)
 
 http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ
 
 Nicolas Baradakis
 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


mysql accounting

2006-06-13 Thread Sean Taylor
I have a quick question on the mysql accounting.  I am working on my own
interface for managing the freeradius+mysql setup.  Everything is
working great, I can view all my users, see who's connected, add new
users, manage static vs. dynamic IP's, etc..The problem is it doesnt
seem to log authentication failures into the radacct table.  It logs all
the successes just fine, but it would be very beneficial to have it log
the failures too.  I have the sql module turned on in the accounting
section of the config and have uncommented all of the accounting
queries.  Any help appreciated.

Thanks
Sean Taylor
Systems Administrator
Valutel Communications

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: mysql accounting

2006-06-13 Thread Sean Taylor
I actually did search the archives quite a bit, just not for the right 
thing apparently.  I usually won't post to a list until I've exhausted 
all other options.  Anyways,  has someone actually turned this giberish 
into working SQL code they are willing to share?


Thanks

Seferovic Edvin wrote:

Hello,

I do NOT want to be rude, but sometimes searching the archives helps A LOT !
BELIEVE ME ! But for the lazy developers among you people - here is the part
that describes the needed feature. Thanks to Jamal ( of course ). This is
copy paste - so do NOT blame me ;)

 START 
Create a table in the radius schema (called fails_log) to include three
columns: trial_date, username, password. 
Create a function in the database (called fails). The main statements
which you should write are 



 fails ( username1 in out char, password1 in char) return char is

v_user char:='';

v_password:='';

begin

select username , value into v_user from radcheck  where
attribute='password' and username= username1 and password=password1;

if v_user = '' then insert into fails_log values
(sysdate,username1,password1);

else return v_user;

end if;

end; 

 

   

Update authorize_ceck_query module in sql.conf  file to be as follows: 
authorize_check_query = SELECT id,Username,Attribute,Value,op FROM

${authcheck_table} WHERE Username =(select
fails('%{SQL-User-Name}','%{User-Password}') from dual) ORDER BY id

 


That is all. Then you can find all failed logs inside the new created table
fails_log.

 END 

Regards,

Edvin Seferovic

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
g] On Behalf Of Sean Taylor
Sent: Donnerstag, 15. Juni 2006 07:13
To: freeradius-users@lists.freeradius.org
Subject: mysql accounting

I have a quick question on the mysql accounting.  I am working on my own
interface for managing the freeradius+mysql setup.  Everything is
working great, I can view all my users, see who's connected, add new
users, manage static vs. dynamic IP's, etc..The problem is it doesnt
seem to log authentication failures into the radacct table.  It logs all
the successes just fine, but it would be very beneficial to have it log
the failures too.  I have the sql module turned on in the accounting
section of the config and have uncommented all of the accounting
queries.  Any help appreciated.

Thanks
Sean Taylor
Systems Administrator
Valutel Communications

- 
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


Re: Segmentation fault when launching freeradius 1.1.1 with sql authorization on debian 1:3.3.5-13

2006-05-13 Thread Sean
Make sure that you have the MySQL development module installed and
configure FreeRadius with experimental extensions. My tutorial might
help at http://swarmhotspots.com/faq

Sean

On Sat, 2006-05-13 at 12:01 +0200,
[EMAIL PROTECTED] wrote:
 Segmentation fault when launching freeradius 1.1.1 with sql
 authorization on debian 1:3.3.5-13
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Running prepaid apps on freeradius

2006-05-03 Thread Sean
On Wed, 2006-05-03 at 12:13 +0200,
[EMAIL PROTECTED] wrote:
 Running prepaid apps on freeradius 

Hi

 Checkout phpMyPreaid on sourceforge and http://swarmhotspots/faq for a
tutorial.

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: prepaid cards

2006-04-28 Thread Sean
 Hi Morder,

Why don't you create a page that allows your users to change their
username and password themselves. This would be very easy to do with
PHP. For example a user logs on to your site with his PIN code and
password and you present him/her with an option to change his details.
By the way if your users are using cell/mobile phones you could add to
the security by sending an SMS message that includes a confirmation code
that they would need to complete the update. 

Regards,

Sean

http://swarmhotspots.com
 Thanks Yves but i tried phpmyprepaid and it is a hackof dialup admin and not
 realy stable , what i want is a way to let the user to be able to change his
 pin code to a username for example : from 15478855 - mark password :Zx43ed
 - stealit
 
 pin and password are stored in the database
 
  any ideas?
 thanks
 On 4/27/06, YvesDM [EMAIL PROTECTED] wrote:
 
 
 
  On 4/27/06, Mordor Networks [EMAIL PROTECTED] wrote:
 
   Hi
  i want to make prepaid system for my dialup users ex: username : 15789546
  password 123456
  How i can make freeradius change the pin code to a valid username in my
  database ?
  i use mysql as a backend for my radius
  ppp/pppoe
  and dialup admin
  thank u
 
  -
  List info/subscribe/unsubscribe? See
  http://www.freeradius.org/list/users.html
 
  Well there is something out there called  phpmyprepaid which is made for
  that purpose.
  I have no experience with it, but maybe you can give it a try.
 
  Yves
 
 
 
  -
  List info/subscribe/unsubscribe? See
  http://www.freeradius.org/list/users.html
 
 
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 https://list.xs4all.nl/pipermail/freeradius-users/attachments/20060428/6d747a09/attachment-0001.html
 
 --
 
 - 
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 
 
 End of Freeradius-Users Digest, Vol 12, Issue 109
 *
 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: (Cannot assign requested address) bind() failed

2006-02-13 Thread Sean
On Mon, 2006-02-13 at 12:08 +0100,
[EMAIL PROTECTED] wrote:
 Re: (Cannot assign requested address) bind() failed

Hi Tommy,

If you are using DD-WRT you might be making a common mistake. It won't
accept a Web name for re-direction. You have to use an IP address. EG
123.123.123.123/hotspotlogin.cgi/ It is also vital to put a / at the end
of the address. I've written a tutorial that might help you at
http://swarmhotspots.com/faq.html and I also provide free FreeRadius
testing for Chillispot at http://swarmhotspots.com/Chilli-Test-Area

Regards,

Sean Bracken

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Thanks Alan

2006-02-13 Thread Sean
On Mon, 2006-02-13 at 19:58 +0100,
[EMAIL PROTECTED] wrote:
 Phil Mayers [EMAIL PROTECTED] wrote:
  Alan, in case anyone hasn't said it recently - you do an excellent
 job 
  maintaining this project under difficult conditions. You have my and
 I 
  suspect many other peoples sincere gratitude, and I can only hope
 it's 
  as rewarding for you as it is helpful for us.
 
   Thanks.
 
   FreeRADIUS is being used as part of the core product in at least 3
 startups I know of, and possibly as many as 5.  It's at the point now
 where it's getting me more professional attention than my other work
 activities.
 
   Alan DeKok.

Alan, I'd like to add my thanks also. FreeRadius is at the core of
swarmhotspots.com and I'm amazed at the help and support that is
available from you and the open source community. 

The best way to show your appreciation is to contribute something back.

Regards,

Sean

http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re:problem with simultanous use...any idea (tommy garsia)

2006-02-11 Thread Sean

  Thanks seanit works great!!
  
   is there any way to limit  user's bandwidth?? 
   can i specify how many user's content/total bandwidth which can be 
  downloaded?
   e.gi give only 10 MB to user A...
   
   regards,
   
  
  Sean [EMAIL PROTECTED] wrote: On Fri, 2006-02-10 at 11:15 +0100,
  [EMAIL PROTECTED] wrote:
   problem with simultanous use...any idea???tommy garsia
  
  
   Hi guys...
 
 I've finished compile and install freeradius v1.1.0 with mysql...and
   work great...
 and i'm happy with it...
 now i have a problem during the accounting
 what should i do if i want to limit only one connection per one
   user..??
 what should i do with my freeradius configuration? 
 
 best regards,
 
 
 tommy
 
  Set simultaneous-use :=1 in radcheck
  and enable simultaneous use checking in sql.conf
  
Hi Tommy,
Glad I could help. 

I'm working on MySQL commands to limit total usage using AccInputOctets and 
AccOutputOctets in Radacct.
I'll let you know when I have it finished and tested.

Regards,

Sean Bracken
http://swarmhotspots.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re:problem with simultanous use...any idea

2006-02-10 Thread Sean
On Fri, 2006-02-10 at 11:15 +0100,
[EMAIL PROTECTED] wrote:
 problem with simultanous use...any idea???tommy garsia


 Hi guys...
   
   I've finished compile and install freeradius v1.1.0 with mysql...and
 work great...
   and i'm happy with it...
   now i have a problem during the accounting
   what should i do if i want to limit only one connection per one
 user..??
   what should i do with my freeradius configuration? 
   
   best regards,
   
   
   tommy
   
Set simultaneous-use :=1 in radcheck
and enable simultaneous use checking in sql.conf

Regards,

Sean
http://swarmhotspots.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Usage instead of time accounting

2006-02-03 Thread Sean
Hi'

I've been using FreeRadius authorisation and accounting for my Internet
Hotspot service for some time. It performs perfectly. Up to now all of
my clients use time based tickets(One hour, one day, one week and one
month) I now have a client that wants to supply tickets that will limit
the usage in bytes of a user. Can this be done and if so can anyone
recommend a source for documentation. I've Googled for the last few days
and checked the DD-WRT and Chillispot forums to no avail.

Regards and rhanks in advance,

Sean Bracken

http://swarmhotspots.com

On Fri, 2006-02-03 at 17:55 +0100,
[EMAIL PROTECTED] wrote:
 Send Freeradius-Users mailing list submissions to
   freeradius-users@lists.freeradius.org
 
 To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.freeradius.org/mailman/listinfo/freeradius-users
 or, via email, send a message with subject or body 'help' to
   [EMAIL PROTECTED]
 
 You can reach the person managing the list at
   [EMAIL PROTECTED]
 
 When replying, please edit your Subject line so it is more specific
 than Re: Contents of Freeradius-Users digest...
 
 
 Today's Topics:
 
1. (Fwd) Detail Filter method (Breuer Nicolas)
2. Re: Detail Filter method (Nicolas Baradakis)
3. R: SQL.conf new query (Carlo Prestopino)
4. Re: how to log username in uppercase in radacct
   (Nicolas Baradakis)
5. Root Certificate via ADS (Armin Kr?mer)
6. Re: FDS + Freeradius = pain. (Joey McDonald)
 
 
 --
 
 Message: 1
 Date: Fri, 03 Feb 2006 14:14:54 +0100
 From: Breuer Nicolas [EMAIL PROTECTED]
 Subject: (Fwd) Detail Filter method
 To: freeradius-users@lists.freeradius.org
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=iso-8859-1
 
  In /etc/raddb/acct_users file:
 
 DEFAULT Acct-Status-Type == Interim-Update, Acct-Type := empty
 
 And in /etc/raddb/radiusd.conf:
 
 modules {
 
   always ok {
   rcode = ok
   }
 
   ...
 }
 
 ...
 
 accounting {
 
   # Log start  stop
   detail
 
   Acct-Type empty {
   ok
   }
 }
 
 -- 
 Nicolas Baradakis
 
 
 
  Can i also put the empty section only in detail module
  because i have a sql line in account (to log everything)
 
  I wouldlike only to disable it in detail accounting.
 
 
 
 
 
 --- Forwarded message follows ---
 From: Breuer Nicolas [EMAIL PROTECTED]
 To:   freeradius-users@lists.freeradius.org
 Subject:  Detail Filter method
 Send reply to:[EMAIL PROTECTED]
 Date sent:Fri, 03 Feb 2006 10:54:43 +0100
 
 
  Hello all,
 
  I'm using the detailled logs with FreeRadius.
 
  I wouldlike to filter the interim updates to not logged
  them. Is it possible ??
 
  I wouldlike to only have a logs files with start  stop..
 
  It would be a nice option, i think..
 
  
 
 --- End of forwarded message ---
 
 Breuer Nicolas
 Content  Marketing Manager.
 Network Supervisor.
 
 BELCENTER ISP  PORTALS
 Avenue Henri Conscience, 94 
 B -1140 Bruxelles
 Tl. :+32 2 243 0 243
 Fax :+32 2 243 0 244
 Mobile :+32 486 50 27 87
 E-Mail : [EMAIL PROTECTED]
 http://www.BelCenter.be | http://www.BelCenter.net
 http://www.BelCenter.lu  | http://www.BelCenter.nl
 
 -- next part --
 An HTML attachment was scrubbed...
 URL: 
 https://list.xs4all.nl/pipermail/freeradius-users/attachments/20060203/6a9e517f/attachment-0001.html
 
 --
 
 Message: 2
 Date: Fri, 3 Feb 2006 15:01:02 +0100
 From: Nicolas Baradakis [EMAIL PROTECTED]
 Subject: Re: Detail Filter method
 To: freeradius-users@lists.freeradius.org
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=us-ascii
 
 Breuer Nicolas wrote:
 
   Can i also put the empty section only in detail module
   because i have a sql line in account (to log everything)
 
   I wouldlike only to disable it in detail accounting.
 
 Please no HTML to the list.
 
 You can add the sql module in the subsection, as explained in the
 provided documentation: http://freeradius.org/radiusd/doc/Acct-Type
 
 For example, in acct_users:
 
 DEFAULT Acct-Status-Type == Interim-Update, Acct-Type := interim
 
 And in radiusd.conf:
 
 accounting {
 
   sql
   detail
 
   Acct-Type interim {
   sql
   }
 }
 
 -- 
 Nicolas Baradakis
 
 
 
 --
 
 Message: 3
 Date: Fri, 3 Feb 2006 15:02:55 +0100
 From: Carlo Prestopino [EMAIL PROTECTED]
 Subject: R: SQL.conf new query
 To: 'FreeRadius users mailing list'
   freeradius-users@lists.freeradius.org
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=us-ascii
 
 Ok, problem solved, as you can see at this post
 http://lists.freeradius.org/pipermail/freeradius-devel/2006-February/009446.
 html
 
 Thank you to everyone
 
 Regards,
 Carlo
 
 
 
 
 
 --
 
 Message: 4
 Date: Fri, 3 Feb 2006 15:51

Re: New accounting database each month

2006-01-31 Thread Sean
Yes. I can do that for you.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: how to compile freeradius without ssl

2006-01-10 Thread Sean
Hi,

If you are using FreeRadius to manage WiFi hotspots with Chillispot I
have a PHP login script that works without SSL. Email me if you want a
copy.

Regards,

Sean Bracken

http://swarmhotspots.com

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL settings causing FreeRADIUS to segfault

2006-01-10 Thread Sean
Hi,

Have you installed the MySQL development extensions? They are essential.
You also need to compile FreeRadius with experimental modules to enable
MySQL.

Regards,

Sean

http://swarmhotspots.com

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


David Bustmante

2006-01-01 Thread Sean
Can someone block this guys auto-responder?

Happy New Year

http://swarmhotspots.com

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Freeradius-Users Digest, Vol 8, Issue 108

2005-12-26 Thread Sean
Hi,

Sorry that my PHP script didn't work straight out of the box. Have you
tried the CGI script? Failing that you will have to tell your users to
enable popups for your site.

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Happy Christmas

2005-12-24 Thread Sean
Wishing Alan DeKok and everyone involved with FreeRadius a very happy
Christmas and thanks for all the work put into developing and supporting
one of the best open source products available. 

Regards,

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Any Good Documentation for newbies

2005-12-23 Thread Sean
 Hello
   As I am new to this free radius, could you please suggest me a
good
 documentation(free) available on the net.
 Version I am using is Free RADIUS 1.0.5.


 Regards
 Manuj

Hi, I've written a tutorial that you might find helpful. You'll find it
here http://www.swarmhotspots.com/faq.html Let me know how you get on.

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Freeradius-Users Digest, Vol 8, Issue 57

2005-12-14 Thread Sean
Hi,

I have written written a howto that explains how to setup FreeRadius and
Chillispot here http://swarmhotspots.com/faq.html. If you need any help
you will find contact details on the site.

Regards,

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE:Configuring freeRADIUS and NAS

2005-12-07 Thread Sean
Hi,

I use Linksys WRT54G Routers and I suggest that you check out DD-WRT
firmware. It includes Chillispot and is easy to setup. I've posted a
tutorial here http://swarmhotspots.com/faq.html

BTW the new WRT54G (Release 5 Firmware) uses VxWorks and not Linux
anyone needing to use third party firmware like DD-WRT should buy
WRT54GL instead.

I hope this helps.

Regards,

Sean Bracken 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Dialupadmin wont connect to mysql

2005-12-07 Thread Sean Ali

Hello,

I've got Dialupadmin running however when I click through the various 
menus it keeps telling me that it cannot connect to sql database.


This is no surprise to me as I have not setup anything on the mysql 
side of things for dialupadmin nor have I told dialupadmin what user 
and password to connect with.


My question is where do I go to set the database options? And what, if 
any, database items do I need to create on the mysql side for it to 
work?


Thanks,
Sean.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Free Radius and Squid

2005-12-05 Thread Sean Ali

Hello,

I'm very new to free raduis and would like to know if it will run with 
squid proxy server. If so how would this work? What I am looking to do 
is to allow users to access the internet via the transparent squid 
proxy for limited time sessions. Eg. a user who wishes to use the 
system would be greeted by a web page asking for a code. The code 
(which they would get from the system admin) would grant them access 
for 1 hour. Can this be done using FreeRadius and Squid?


Sean.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Radius Server

2005-11-15 Thread Sean
Hi Tarun,

I've written a how to for FreeRadius that might help you, You will find
it here http://swarmhotspots.com/faq.html BTW You should be very
explicit with questions posted to the mailing list. You will find people
very helpful but don't ask questions if the answer can be found in the
docs.

Regards,

Sean Bracken




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: SQL Documentation

2005-09-15 Thread Sean
 Sean [EMAIL PROTECTED] wrote:
 Can anyone recommend a good source for documentation for FreeRadius.

  The files that come with it, and the web pages?

  There really isn't any secret treasure trove of documentation that
you get told about only if you ask for it.

  I'm trying to understand the processes that occur between
 Chillispot, FreeRadius and MySql. In particular I need to understand
 how the Counter works and how to use the counter in MySQL.

  the counter?  Please be specific.

  rlm_sqlcounter exists in the server source.  It has sample
configurations and documentation.  What part of that do you have
questions about?

  Alan DeKok.

In particular I want to use the following in my radiusd.conf.

counter daily{
reset =24h
}
counter weekly{
reset =7d
}
counter monthly{
reset=30
}

What I need to know is do I have to add extra fields to my radius
database and if so which tables need to be changed and how to address
them from sql.conf.

Regards,

Sean


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


SQL Documentation

2005-09-14 Thread Sean
Hi All,

Can anyone recommend a good source for documentation for FreeRadius. I'm
trying to understand the processes that occur between Chillispot,
FreeRadius and MySql. In particular I need to understand how the Counter
works and how to use the counter in MySQL.

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Session Time

2005-09-12 Thread Sean
 Hi All,

I want to allow the SQL counter to continue deducting time from users
after they log out until they reach a certain amount of time left. I
have tried several ways to do it  for example the following in sql.conf.

accounting_stop_query = UPDATE ${acct_table2} SET AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}',
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =
'%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress = '%{NAS-IP-Address}' where Acct-Session-Time  3600

I'm fairly sure that it's a question of creating the right sql command
into radacc. I hope I have explained myself properly.

Any advice will be much appreciated.

Regards,

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL radacct not updated

2005-08-26 Thread sean
 Hi Thor,

I'm just posting this to thank you for your help and let you know that
it was appreciated and also to help anyone else with a similar problem
to see the solution.

In order to enable the accounting packets between Chilli and Radius I
removed all of the pin holes in my ADSL modem and instead set up a NAT
default server pointing to my Radius/WEB/Jabber/POP/SMTP/SMPP/Apache
server. This allows all of the trafic arriving to the ADSL modem to pass
through to the server and solved the problem. I not sure about the
security of this fix so I'm setting up a firewall on the server. This
will give me better control over the trafic than the ADSL modem did.

Anyway once again thanks a million Thor you pointed me in the right
direction and saved me another week with no sleep.

Regards,

Sean Bracken

http://freetextworld.com
http://topup.ie
http://swarmhotspots.com


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL radacct not updated

2005-08-24 Thread sean
 Hi ALL,

I have made no progress in resolving the radaccct problem.
Radius is loading with no error messages and I've gone over the
radiusd.conf and sql.conf a million times.

below is the output from Radius when a client logs in.

rad_recv: Access-Request packet from host 82.141.232.132:51214, id=0,
length=218
--- Walking the entire request list ---
Waking up in 31 seconds...
Thread 2 got semaphore
Thread 2 handling request 1, (1 handled so far)
User-Name = sipkek10
CHAP-Challenge = 0x8a37e2835fe0e45acf9680564cb660c3
CHAP-Password = 0x003c7507dd1f4ecf4389429af1a1e74e9d
NAS-IP-Address = 0.0.0.0
Service-Type = Login-User
Framed-IP-Address = 192.168.182.14
Calling-Station-Id = 00-C0-49-5C-40-48
Called-Station-Id = 00-12-17-4A-01-A9
NAS-Identifier = wasp1
Acct-Session-Id = 430c042e0001
NAS-Port-Type = Wireless-802.11
NAS-Port = 1
Message-Authenticator = 0x6df308586dc9a8df5dc7a274fa008a88
WISPr-Logoff-URL = http://192.168.182.1:3990/logoff;
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 1
  modcall[authorize]: module preprocess returns ok for request 1
  rlm_chap: Setting 'Auth-Type := CHAP'
  modcall[authorize]: module chap returns ok for request 1
  modcall[authorize]: module mschap returns noop for request 1
rlm_realm: No '@' in User-Name = sipkek10, looking up realm NULL
rlm_realm: No such realm NULL
  modcall[authorize]: module suffix returns noop for request 1
radius_xlat:  'sipkek10'
rlm_sql (sql): sql_set_user escaped user -- 'sipkek10'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'sipkek10' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
radius_xlat:  'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
  FROM radgroupcheck,usergroup WHERE usergroup.Username = 'sipkek10' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'sipkek10' ORDER BY id'
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
  FROM radgroupreply,usergroup WHERE usergroup.Username = 'sipkek10' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 2
  modcall[authorize]: module sql returns ok for request 1
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand:  'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{User-Name}''
radius_xlat:  'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='sipkek10''
sqlcounter_expand:  '%{sql:SELECT SUM(AcctSessionTime) FROM radacct
WHERE UserName='sipkek10'}'
radius_xlat: Running registered xlat function of module sql for string
'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sipkek10''
rlm_sql (sql): - sql_xlat
radius_xlat:  'sipkek10'
rlm_sql (sql): sql_set_user escaped user -- 'sipkek10'
radius_xlat:  'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='sipkek10''
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql (sql): row[0] returned NULL
rlm_sql (sql): Released sql socket id: 1
radius_xlat:  ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user sipkek10, check_item=1800, counter=0
rlm_sqlcounter: Sent Reply-Item for user sipkek10, Type=Session-Timeout,
value=1800
  modcall[authorize]: module noresetcounter returns ok for request 1
modcall: group authorize returns ok for request 1
  rad_check_password:  Found Auth-Type CHAP
auth: type CHAP
  Processing the authenticate section of radiusd.conf
modcall: entering group Auth-Type for request 1
  rlm_chap: login attempt by sipkek10 with CHAP password
  rlm_chap: Using clear text password bigdogut for user sipkek10
authentication.
  rlm_chap: chap user sipkek10 authenticated succesfully
  modcall[authenticate]: module chap returns ok for request 1
modcall: group Auth-Type returns ok for request 1
  Processing the session section of radiusd.conf
modcall: entering group session for request 1
  modcall[session]: module sql returns noop for request 1
modcall: group session returns noop for request 1
Sending Access-Accept of id 0 to 82.141.232.132:51214
Session-Timeout = 1800
Finished request 1
Going to the next request
Thread 2 waiting to be assigned a request
--- Walking the entire request list ---
Cleaning up request 1 ID 0 with timestamp 430c7430
Nothing to do.  Sleeping until we see a request.

Can anyone spot something in this that might point me in the right
direction?

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Mobile phone authentication

2005-08-24 Thread sean
 Hi,

If I understand you properly you are trying to authenticate users by
their mobile phone number.If that's right you need Kannel. You can
download the latest version from http://www.kannel.org There is a bit of
a learning curve but once you have authenticated the user you can pass
them off to your Radius billing system. I presume that the
authentication will arrive via SMS, WAP or HTTP if it's 3G.

I hope this helps. If you need more advice you can email me at
[EMAIL PROTECTED]

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL radacct not updated (Thor Spruyt)

2005-08-24 Thread sean
: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName,
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId,
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND
AcctStopTime = 0
 sql: postauth_table = radpostauth
 sql: postauth_query = INSERT into radpostauth (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%
{reply:Packet-Type}', NOW())
 sql: safe-characters =
@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
 acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-
IP-Address, NAS-Port
Module: Instantiated acct_unique (acct_unique)
Module: Loaded detail
 detail: detailfile = /usr/local/var/log/radius/radacct/%{Client-IP-
Address}/detail-%Y%m%d
 detail: detailperm = 384
 detail: dirperm = 493
 detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded System
 unix: cache = no
 unix: passwd = (null)
 unix: shadow = (null)
 unix: group = (null)
 unix: radwtmp = /usr/local/var/log/radius/radwtmp
 unix: usegroup = no
 unix: cache_reload = 300
Module: Instantiated unix (unix)
Module: Loaded eap
 eap: default_eap_type = md5
 eap: timer_expire = 60
 eap: ignore_unknown_eap_types = no
 eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
 gtc: challenge = Password: 
 gtc: auth_type = PAP
rlm_eap: Loaded and initialized type gtc
 mschapv2: with_ntdomain_hack = no
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Initializing the thread pool...
 thread: start_servers = 5
 thread: max_servers = 32
 thread: min_spare_servers = 3
 thread: max_spare_servers = 10
 thread: max_requests_per_server = 0
 thread: cleanup_delay = 5
Thread 1 waiting to be assigned a request
Thread spawned new child 1. Total threads in pool: 1
Thread spawned new child 2. Total threads in pool: 2
Thread 2 waiting to be assigned a request
Thread 3 waiting to be assigned a request
Thread spawned new child 3. Total threads in pool: 3
Thread spawned new child 4. Total threads in pool: 4
Thread 4 waiting to be assigned a request
Thread 5 waiting to be assigned a request
Thread spawned new child 5. Total threads in pool: 5
Thread pool initialized
Listening on authentication *:1812
Listening on accounting *:1813
Listening on proxy *:1814
Ready to process requests.

Regards,

Sean

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL radacct not updated

2005-08-24 Thread sean
 Hi Thor,

Once again thanks for your help.

 I'm sorry but I don't understand your answer. Can you explain the debug
of an accounting packet? Do you mean something like an Ethereal trace?
How do I do a tcp dump on the Radius server.

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


MySQL radacct not updated

2005-08-23 Thread sean
 Hi,

 I have a strange problem with MySQL and FreeRadius. 
The system had been performing perfectly but it is no longer updating
radacct. The result is that when users login the counter on their login
page counts down their remaining time. But when they logout and then
login again the counter is reset back to its origional value. This means
that user names and passwords last forever. 

The sql log file used to show 
 Quote:
  SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='bebbik6'; 
   INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm,
   NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
  AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop,
 AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,
   AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
   AcctStartDelay, AcctStopDelay) values('42e44944',
 '3f1c519e5a66e2fe', 'bebbik6', '', '0.0.0.0', '0', 'Wireless-802.11',
  '2005-07-26 06:04:07', '0', '0', '', '', '', '0', '0', '00-12-17-B7-
  A1-70', '00-C0-49-5C-40-48', '', '', '', '192.168.182.2', '', '0'); 
UPDATE radacct SET AcctStopTime = '2005-07-26 06:04:13', AcctSessionTime
  = '6', AcctInputOctets = '1403', AcctOutputOctets = '5179',
AcctTerminateCause = 'User-Request', AcctStopDelay = '',
   ConnectInfo_stop = '' WHERE AcctSessionId = '42e44944' AND
  UserName = 'bebbik6' AND NASIPAddress = '0.0.0.0'; 



But now it only shows 
 Quote:
   SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='bebbik6';


I'd really appreciate any help to solve this problem. 

Regards from Ireland. 

Sean Bracken
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Elapsed time billing.

2005-08-22 Thread sean
 Hi everyone,

Thanks to the advice and help I got from the list I now have a fully
working FreeRadius server with MySQL. I can issue user names and
passwords for set amounts of time e.g. 1 hour or 24 hours.What I'd like
to do is issue names and passwords that will last for passed time e.g.
one day or one month. Has anyone done this and can you advise me on how
to go about it.

Thanks for all the help in the past.

Regards,

Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


filter id stored in LDAP

2005-07-20 Thread sean wagoner
Can the actual Filter ID be store in and retreived by the radius
server. By this I mean not just the name of the filter but it's actual
contents?  If so how?

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: No communication between FreeRadius and Chilli

2005-07-20 Thread sean
On Wed, 2005-07-20 at 21:29 +0200, freeradius-users-
[EMAIL PROTECTED] wrote:
 sean [EMAIL PROTECTED] wrote:
  The problem is
  that Chilli can't communicate with my Radius server. Ethereal tells
 me
  that the destination is unreachable when replying to the Chilli box.
 
   It looks like the port isn't open.
 
  No. TimeSourceDestination
 Protocol Info
  540 142.622909  192.168.1.6   82.141.232.132
 RADIUS   Access Request(1) (id=0, l=195)
 
   Ok...
 
  The Radius server and the Chilli AP get their IP's from DHCP on a
 Caymen
  DSL modem with static IP. The Modem is 82.141.232.132. The Radius
 server
  is 192.168.1.2
 
   What's the problem?  The Ethereal output you showed above disagrees
 with your statement about the IP address of the RADIUS server.
 
   You have the Chilli AP configured to send RADIUS packets to the DSL
 modem.  The Ethereal output is telling you this.
 
   Alan DeKok.

I have UDP and TCP Pinholes open in the modem for ports 1812, 1813 and
1814 pointing to 192.168.1.2 This should be directing trafic to
82.141.232.132:1812 etc to 192.168.1.2:1812. That is what I had to do
for Apache, Jabber and other services. Does Radius use any other ports
and should I have any ports opened to 192.168.1.6

Thanks for your help.

Regards Sean
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Freeradius-Users Digest, Vol 3, Issue 15

2005-07-15 Thread sean
Hi,

I can now get Chillispot to reach the CGI login on my server. The
application loads and runs, but times out while trying to process the
login. FreeRadius isn't getting any requests from Chilli but does
process local requests from radtest. 

This is the way my network is structured. 
DSL modem with static ip 82.141.232.132 running firewall and DHCP 
File server IP 192.168.1.2 from DHCP 
Running Apache, Kannel, Jabber, MySQL, PHP and FreeRadius 
DSL Modem has pinholes set up directing traffic coming to the static ip
out to the same ports on 192.168.1.2 IE 82.141.232.132:1812 sent to
192.168.1.2:1812 
This works fine for Kannel, Apache etc. 
Radius listens on 1812, 1813 and 1814 
Chilli is running on WRT54G with DD-WRT on port 192.168.1.6 from DHCP
with internal address 192.169.10.1 
DHCP is switched off in DD-WRT and Chilli is assigning IP to wireless
clients and directing them to the CGI login script on the file server.
This loads fine but times out after entering user and password. Radius
can't see any requests coming from Chilli, but processes requests from
radtest on the fileserver. I suspect that the DSL modem firewall needs
to have some other ports opened but I can't add any software to it so I
can't run Ethereal. 
I hope I've explained clearly. Thanks for any advice you can give.

Regards Sean

http://topup.ie
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Chillispot FreeRadius

2005-07-15 Thread sean
On Fri, 2005-07-15 at 20:58 +0200, freeradius-users-
[EMAIL PROTECTED] wrote:
  I have setup pinholes for both tcp and udp on ports 1812, 1813 and
 1814.
  They all point to the Radius server on 192.168.1.2. The Chillispot
 on
  192.168.1.6 can direct traffic to the CGI login but sends nothing to
  Radius. What I'm trying to understand is the sequence of events.
 When
  the hospotlogin.cgi script gets a request from a Chillispot user
 from
  the AP, does the cgi script initiate the Radius request?
 
  No, it's the chillispot server - not the cgi. Server is in case you
  run chilli on the wlan-router the wlan-router, in case you ran chilli
  on an linux-box the linux-server.
I don't understand, Chilli is running on a WRT54G AP under DD-WRT and
directing users to the login. What sends the Radius requests Chilli or
the CGI script?

This is what Chilli sends to the hotspotlogin.cgi script
https://82.141.232.132/cgi-bin/hotspotlogin.cgi/?
res=notyetuamip=192.168.182.1uamport=3990challenge=1b23fb5583173741fcfcb91b7b4e5e7auserurl=nasid=nas01mac=00-C0-49-5C-40-48
 Radius gets no requests at all. The script just times out while waiting to 
login.

192.168.182.1 is the DSL modem which has been told to send traffic
arriving on ports 1812, 1813, and 1814 to the Radius server. I have also
opened port 3990 on the DSL modem to the Radius server. ie. DSL modem
static ip 82.141.232.132. all traffic to 192.168.182.1
(82.141.232.132:1812) goes to 192.168.1.2:1812
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


hotspotlogin.cgi problem

2005-07-09 Thread sean
Hi,

I have set up a FreeRadius server which I am trying to access from
Chilli  on a Linksys AP running DD-WRT and Chilli. Radtest shows that
the Radius server is running and Chilli is directing users to /cgi-
bin/hotspotlogin.cgi. However this produces an internal server error
from Apache. If I send users to /cgi-bin/test.cgi the test page loads
with no errors. I have no idea where to start looking for a solution.
Any advice or pointers to where I've gone wrong would be very much
appreciated.

Regards,

Sean Bracken


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Accounting string is interpreted as raw data instead of ascii.

2005-02-07 Thread Sean
I have a vendor-specific attribute in my dictionary that is a atring
type. As an attribute that is set, it comes to my authenticating
device, a network switch, as a string. However, when I use it as
an accounting attribute, it shows up in my accounting log on my
RADIUS server not as a string but as raw data. Is there a way to
get it to appear as the original string?
Thanks.
sean



__ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


More same attribute, multiple entries.

2005-01-14 Thread Sean
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 how do I access the second, third, etc. value for a duplicate attribute 
 in sql.conf ?
 I have read doc/variables.txt and I did not figure out.
 Can it be done ?

  In the current CVS snapshot.  Not in 1.0.1

  Alan DeKok.

I found the above in the January 2005 archives. Perhaps my problem
is too different, but I now have the current CVS snapshot 
(radiusd: FreeRADIUS Version 1.1.0-pre0, for host i686-pc-linux-gnu, 
built on Jan 14 2005 at 14:29:35), have built and run it, and it isn't
helping with my problem. I have a vendor-specific attribute that I need
to repeat several times. The freeRadius server still only sends it one time.

For example, my dictionary file looks like:
VENDOR  BB 11
BEGIN-VENDORBB
ATTRIBUTE   BB-QOS 20 string
ATTRIBUTE   BB-RATE-LIMIT  25 integer
ATTRIBUTE   BB-ACL-ENTRY   61   string
END-VENDOR  BB

And my users file looks like:

pepsi Auth-Type:= Local, User-Password == coke
BB-ACL-ENTRY = deny in ip from any to 10.0.8.10/24 30-35 log,
BB-ACL-ENTRY = deny in ip from any to 10.0.9.20/24 10-20 log,
BB-ACL-ENTRY = deny in ip from any to 10.0.10.30/24 15, 20 log,
BB-ACL-ENTRY = deny in ip from any to 10.0.11.40/24 17 log,
BB-ACL-ENTRY = permit in ip from any to 10.0.12.50/24 20-50, 18

The server (in -X, debug mode) always only sends the first attribute. I've
tried interspersing the BB-ACL-ENTRY with the other two attributes, but it
still sends just the first BB-ACL-ENTRY attribute and then the other two
attributes.  Was this supposed to work in the current snapshot or is my
problem different or can my problem be solved in some other way?

Thank you very much.
sean



__ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: How to get PAM to use RADIUS to authenticate a user?

2004-05-20 Thread Sean O'Malley
the radiusd.conf file needs the pam entry uncommented.
you need a /etc/pam.d/radiusd file.

(I never got the pam_auth argument in the radiusd.conf file to work
correctly, I don't believe you want to use the login file anyway since
that checks out what tty you are using and in this case you are not using
any..)

Your 'users' file needs to include something like:
DEFAULT Auth-Type :=Pam
pam-auth=radius,
Fall-Through = Yes

I am not sure pam-auth= should read pam-auth=radiusd here.

You can crank up debugging on the pam modules, I think it is the -d
pam or -debug or something similar.

Try something like this in your /etc/pam.d/radius.d file:

auth   required /lib/security/pam_unix.so
auth   required /lib/security/pam_nologin.so
accountrequired /lib/security/pam_permit.so
password   required /lib/security/pam_permit.so
sessionrequired /lib/security/pam_permit.so


On Thu, 20 May 2004, Maqbool Hashim wrote:


 I posted the following to the list yesterday, I thought I would post it
 again in case anyone else has any ideas regarding this...? (Are there
 any experts on PAM on the list?)  I know this may
 be a little of topic if it is a PAM problem, but I would appreciate help
 from anyone who has got RADIUS to work with PAM.

 Thanks and please forgive me for posting it twice

 Maqbool Hashim wrote:

 
 
  FreeRadius version:  0.9.3
  Redhat Linux 9.0
 
  I have installed FreeRadius on my system and to get familiar with it I
  am attempting to the Unix login program to authenticate using the
  radius server.In order to this I am using the radius pam module
  pam_radius_auth.  So PAM is the radius client.  (All programs are
  running on the same machine, client and radius server).
 
  Heres what I have in /etc/pam.d/login :
 
  #%PAM-1.0
  auth   required pam_securetty.so
  auth   sufficient   /lib/security/pam_radius_auth.so debug
  auth   required pam_stack.so service=system-auth
  auth   required pam_nologin.so
  accountrequired pam_stack.so service=system-auth
  password   required pam_stack.so service=system-auth
  sessionrequired pam_stack.so service=system-auth
  sessionoptional pam_console.so
 
  and in  /raddb/users I have the following default line:
  DEFAULT Auth-Type := System
  Service-Type = Login-User
 
  I start the radius server as follows:
 
  radiusd -i 127.0.0.1 -X
 
  then in another terminal I execute login and try to login as a normal
  user.  The login program returns with:
 
  Authentication service cannot retrieve authentication info.
 
  Now I check the radius server debugging info and from that side it
  seems to be authenticating the user fine:
  users: Matched DEFAULT at 140
modcall[authorize]: module files returns ok for request 0
modcall[authorize]: module mschap returns noop for request 0
  modcall: group authorize returns ok for request 0
rad_check_password:  Found Auth-Type System
  auth: type System
  modcall: entering group authenticate for request 0
modcall[authenticate]: module unix returns ok for request 0
  modcall: group authenticate returns ok for request 0
  Sending Access-Accept of id 206 to 127.0.0.1:5735
  Service-Type = Login-User
  Finished request 0
 
 
  This problem has me confused.  If anyone can shed any light on the
  matter I would appreciate it.  Perhaps the problem lies in the
  .../pam.d/login configuration?
 
 
 
 
 
 
 
  - 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


Re: Juniper Attributes and OpenLDAP

2004-03-22 Thread Sean O'Malley


On Mon, 22 Mar 2004, Robert Banniza wrote:

 I'm not sure I'm following you...Let's say I want to add the
 Juniper-Allow-Commands and Juniper-Deny-Commands to my user's profile
 within OpenLDAP. Wouldn't I have to define these attributes within some
 LDAP schema whether it be in the RADIUS-LDAPv3.schema or some other
 schema in order for OpenLDAP to know how to interpret the attribute?

I can't talk about how freeradius interprets the juniper values, but
openldap will need to have attribute and objectclass definitions to match what
juniper has most likely. I am not that familiar with much about Juniper or
FreeRadius but I have been working with ldap some.

http://www.juniper.net/techpubs/software/management/sdx/sdx400/sw-sdx-install/html/sw-sdx-installTOC.html
search down to openldap they have instructions on how to load the
openldap server, I assume that installs the schema too which is what
defines all the juniper attributes for you and you should be off to the
races with the correct attributes and objectclasses.

The rest of this is crap I wrote if you have to do it the hard way, which
it doesn't look like you do but i am including it so _I_ don't forget what
I am doing.

The another way to get these is to set up the Juniper LDAP server,
perform an ldapsearch on their database equivalent to an dump of the
database into LDIF format. I don't know how well jumipers ldap server will
respond to that. Sun's responded fairly well. You migh poke around and
find a schema or an ldif file in the Juniper install media too.

basically you need a lot of the attributes like on:
http://www.juniper.net/techpubs/software/management/sdx/sdx310/sdx310-sw-developer/html/ldap-object-mapping6.html

You need to figure out what they are looking for for the attribute syntax,
since you need the long number representation of it.
but you can cross reference from http://www.faqs.org/rfcs/rfc2252.html
section 4.3.2 lists them.

The rest of it is fairly straightforward if you look at another schema.
The object identifier (OID) number _technically_ just has to be unique,
but they supply one for you, I would use it only for the fact you wont
have to worry about getting stuff mixed up if you try to do something else
with the server. (technically the Juniper ones should be registered aand
unique. C  You will find examples of the syntax of the matching rules in
the openldap schema.

It isn't particularly hard just tedious as all hell.

Sean


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: pam-radius ?

2004-03-01 Thread Sean O'Malley
IIRC (I had this set up and working but we had to opt for a different
solution and I don't have a working configuration to use.)

In your radiusd.conf
you need the pam section uncommented
the pam_auth = radiusd
^
this part needs to match up with your systems /etc/pam.d stuff
like linux you need to create a radiusd file in /etc/pam.d/
or on solaris in the /etc/pam.conf you need to add entries beginning with
radiusd or it could be the radius in the users section. (I had them
linked to each other which is probably bad =)

in your users file you need:

DEFAULT Auth-Type := Pam
pam-auth=radius,
Fall-Through = Yes




 Greetings,
   I need some help with pam-radius and freeradius.  I have a server that I
 need to do raduis Auth from for access to certian programs.  I tried
 setting up pam-radius like the instructions state, but it keeps telling me
 that the radius server has not been specified.  I put the configuration
 file where the instructions tell me to (/etc/raddb/server/pam.conf and
 pam_radius_auth.conf) as well as trying some of the alternate locations
 (/usr/local/etc) and it still doesn't detect it.  Could someone point me to
 the right location for this file?
   Thank you in advance.

 --
 ·William Ragsdale   ·http://www.netonecom.net



 -
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html