Re: radgroupreply do not read (read_grous directive)

2008-01-18 Thread Alan DeKok
Arlinelson Fernandes dos Santos wrote:
 The pre1 version is buggy!!!

  Yes... which is why 2.0.0 was released.

 Now, I'm working to solver this: rlm_acct_unique: WARNING: Attribute
 Client-IP-Address was not found in request, unique ID MAY be inconsistent

  Grab the latest version from CVS.  It has this issue fixed.

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


Re: radgroupreply do not read (read_grous directive)

2008-01-16 Thread tnt
OK, since that's correct I had a look at the debug. You are not doing
group checking at all. You have done something to sql.conf to break it.
Go back to the original sql.conf and just alter the connection details
(user, pass, server). Leave rest as it is (we will sort out sumultaneous
use later). Default configuration will do group checking.

Remove Auth-Type from the radcheck table - let the server sort it out.
Put := as an operator for Simultaneous-Use.

Ivan Kalik
Kalik Informatika ISP


Dana 16/1/2008, Arlinelson Fernandes dos Santos [EMAIL PROTECTED]
piše:

Sorry! I was writing this post and correcting the align spaces when press the
e for accident. In my usergroup is test-pap. thanks.

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


Re: radgroupreply do not read (read_grous directive)

2008-01-16 Thread Arlinelson Fernandes dos Santos
Oh my God!!! This problem is killing me!I back the original sql.conf and
have no Auth-Type in radcheck and other no in tables too.I put := in
Simultaneous-Use.I test the connection and no groups table was read. The
radius log is the same.I did install freeradius in other server and do the
same. No radgroupreply.If you are using the freeradius version
2.0.0-pre1 working with reply attributes to NAS (same mine), PLEASE!!! Send me the
config files. I need to know what is buggy. OK, since that's correct I had a look at the debug. You are not doing
group checking at all. You have done something to sql.conf to break it. Go
back to the original sql.conf and just alter the connection details (user,
pass, server). Leave rest as it is (we will sort out sumultaneous use later).
Default configuration will do group checking.  Remove Auth-Type from
the radcheck table - let the server sort it out. Put := as an operator for
Simultaneous-Use.  Ivan Kalik Kalik Informatika ISP 
 Dana 16/1/2008, Arlinelson Fernandes dos Santos  pie:  Sorry! I was writing this post and correcting the align spaces when
press the e for accident. In my usergroup is test-pap.
thanks.  - List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html 
  



--
Acelerador POP
Acelere a sua conexo discada em at 19 x. Use o Acelerador POP.  grtis, pegue j o seu.
http://www.pop.com.br/acelerador
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radgroupreply do not read (read_grous directive)

2008-01-15 Thread tnt
OK, can we see database entries for a user (and group he belongs to) and
the debug of the access request? Or should I get my crystal ball back
from the polisher?

Ivan Kalik
Kalik Informatika ISP


Dana 15/1/2008, Arlinelson Fernandes dos Santos [EMAIL PROTECTED]
piše:

Yes! I did. And I put attributes into all tables ckeck and 
reply.
 Did you put something in usergroup table to link users and groups? 
Ivan Kalik Kalik Informatika ISP   Dana 14/1/2008,
Arlinelson Fernandes dos Santos:  Hi,I am
usind freeradius 2.0 an need to load radcheck, radreply, radgroupcheck
and radgroupreply tables. But radcheck and radreply work. To load
radgroupcheck e need to set Fall-Through = Yes, but radgroupreply don't work.
The read_groups directive is 'Yes' but not appers in the radius debug
mode.How can I do freeradius load radgroupreply? I have the
Simultaneous-Use attribut in this table, I need to use this attribute to
all users. Someone please?

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


Re: radgroupreply do not read (read_grous directive)

2008-01-15 Thread liran tal
Ivan,

While you're at it, can you check up on my forth-coming paperwork
grade for Statistics B class? :-)


Regards,
Liran.


2008/1/15 [EMAIL PROTECTED]:

 OK, can we see database entries for a user (and group he belongs to) and
 the debug of the access request? Or should I get my crystal ball back
 from the polisher?

 Ivan Kalik
 Kalik Informatika ISP


 Dana 15/1/2008, Arlinelson Fernandes dos Santos [EMAIL PROTECTED]
 piše:

 Yes! I did. And I put attributes into all tables ckeck and
 reply.
 Did you put something in usergroup table to link users and groups?
 Ivan Kalik Kalik Informatika ISP   Dana 14/1/2008,
 Arlinelson Fernandes dos Santos:  Hi,I am
 usind freeradius 2.0 an need to load radcheck, radreply, radgroupcheck
 and radgroupreply tables. But radcheck and radreply work. To load
 radgroupcheck e need to set Fall-Through = Yes, but radgroupreply don't
 work.
 The read_groups directive is 'Yes' but not appers in the radius debug
 mode.How can I do freeradius load radgroupreply? I have the
 Simultaneous-Use attribut in this table, I need to use this attribute to
 all users. Someone please?

 -
 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: radgroupreply do not read (read_grous directive)

2008-01-15 Thread Arlinelson Fernandes dos Santos
Don't take your ball, not good. ;)Here's informations:##
radcheck++---+++-+|
id | UserName | Attribute 
 | op | Value  |++---+++-+| 3 |
test-pap  | Cleartext-Password | := | pw123 |++---+++-+##
radreply++---+-++---+| id
 | UserName | Attribute   
 | op | Value |++---+-++---+| 6 |
test-pap  | Upstream-Speed | =  | 800 
|| 7 | test-pap | Downstream-Speed |
= | 800 |++---+-++---+##
radgroupcheck+++++---+| id | GroupName | Attribute  
  | op  | Value |+++++---+|
5 | f_pppoe_250k | Auth-Type  
 | =  | PAP  || 6  | f_pppoe_250k |
Simultaneous-Use | =  | 1 |+++++---+  ##
radgroupreply
++--+---++--+|
id | GroupName | Attribute   
 | op |
Value
 |++--+---++--+|
13 | f_pppoe_250k | Framed-Protocol| = |
PPP
  || 14 | f_pppoe_250k |
Framed-MTU   | = |
1492   
 || 15 | f_pppoe_250k |
Framed-Compression | = | Van-Jacobsen-TCP-IP || 16 | f_pppoe_250k |
Service-Type| = |
Framed-User   |+---++--++--+
## radusergroup (same usergroup table in 1.3 version freeradius, I have both
tables) +---++--+ | UserName |
GroupName | priority |
+---++--+ | teste-pap | f_pppoe_250k
| 1 |
+---++--+  ## radiusd -X
rad_recv: Access-Request packet from host 7.7.7.1 port 32790, id=163,
length=73  Service-Type =
Framed-User  Framed-Protocol =
PPP  User-Name =
test-pap  User-Password
= pw123  NAS-IP-Address
=   NAS-Port = 0 
Processing the authorize section of radiusd.conf +- entering group
authorize ++[preprocess] returns ok ++[chap] returns noop
++[mschap] returns noop  rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop radius_xlat: 'test-pap' rlm_sql (sql):
sql_set_user escaped user -- 'test-pap' rlm_sql (sql): Reserving sql
socket id: 3 radius_xlat: 'SELECT id, UserName, Attribute, Value,
op FROM
radcheck WHERE Username
= 'test-pap' ORDER BY
id'  loading radcheck table ## rlm_sql
(sql): User found in radcheck table radius_xlat: 'SELECT id, UserName,
Attribute, Value, op
FROM radreply WHERE
Username = 'test-pap'
ORDER BY id' ### loading radreply table ## rlm_sql
(sql): Released sql socket id:
3
 if found Fall-Through = Yes attribute, radgroupcheck is loaded,
but not radgroupreply # ++[sql] returns ok ++[expiration]
returns noop ++[logintime] returns noop ++[pap] returns updated
+- group authorize returns updated  rad_check_password: Found
Auth-Type auth: type PAP  Processing the authenticate
section of radiusd.conf +- entering group PAP rlm_pap: login attempt
with password ngc0bqi rlm_pap: Using clear text password. rlm_pap: User
authenticated successfully ++[pap] returns ok +- group PAP returns
ok  Processing the post-auth section of radiusd.conf +- entering
group post-auth rlm_sql (sql): Processing sql_postauth rlm_sql (sql):
sql_set_user escaped user -- 'test-pap' radius_xlat: 'INSERT into
radpostauth (id, user, pass, reply, date) values ('', 'test-pap', 'ngc0bqi',
'Access-Accept', '2008-01-15 20:33:58')' rlm_sql (sql) in sql_postauth: query
is INSERT into radpostauth (id, user, pass, reply, date) values ('', 'test-pap',
'pw123', 'Access-Accept', '2008-01-15 20:33:58') rlm_sql (sql): Reserving sql
socket id: 2 rlm_sql (sql): Released sql socket id: 2 ++[sql] returns
ok +- group post-auth returns ok Sending Access-Accept of id 163 to
7.7.7.1 port 32790 # Here is
when radius server send items reply to radiusclient
#  Upstream-Speed =
800  attribute in
radreply   Downstream-Speed
= 800 ## attribute in radreply  Finished
request 0 state 5 Going to the next request rad_recv:
Accounting-Request packet from host 7.7.7.1 port 32790, id=164, length=101
 Acct-Session-Id =
478D34D61E1F00 
User-Name = test-pap 
Acct-Status-Type = Start 
Service-Type = Framed-User 
Framed-Protocol = PPP 
Acct-Authentic = RADIUS 
NAS-Port-Type = Virtual 
Framed-IP-Address = 7.7.7.123 
NAS-IP-Address = 7.7.7.1  NAS-Port
= 0  Acct-Delay-Time = 0
 Processing the preacct section of radiusd.conf +- entering group
preacct ++[preprocess] returns ok rlm_acct_unique: Hashing 'NAS-Port =
0,Framed-IP-Address = 7.7.7.123,NAS-IP-Address = 7.7.7.1,Acct-Session-Id =
478D34D61E1F00,User-Name = test-pap' rlm_acct_unique:
Acct-Unique-Session-ID = a5e052f9f07c2f6f. ++[acct_unique]
returns ok +- group preacct returns ok  Processing the accounting
section of radiusd.conf +- entering group accounting radius_xlat:

Re: radgroupreply do not read (read_grous directive)

2008-01-15 Thread tnt
There is a typo in usergroup table. Group is set as teste-pap, while
other tables have group test-pap.

Ivan Kalik
Kalik Informatika ISP


Dana 15/1/2008, Arlinelson Fernandes dos Santos [EMAIL PROTECTED]
piše:

Don't take your ball, not good. ;) Here's informations:##
radcheck++---+++-+|
id  | UserName  | Attribute 
   | op  | Value
 |++---+++-+|  3  |
test-pap   | Cleartext-Password  | := | pw123  
|++---+++-+##
radreply++---+-++---+| id
  | UserName | Attribute  
   | op  | Value  |++---+-++---+|  6  |
test-pap   | Upstream-Speed | =   | 800  
||  7  | test-pap   | Downstream-Speed  |
=   | 800   |++---+-++---+##
radgroupcheck+++++---+| id   | 
GroupName| Attribute 
   | op   | Value 
 |+++++---+| 
5   | f_pppoe_250k | Auth-Type
  | =   | PAP||  6   | f_pppoe_250k |
Simultaneous-Use | =   | 1   
|+++++---+  ##
radgroupreply
++--+---++--+|
id | GroupName| Attribute   
 | op  |
Value 
  
 |++--+---++--+|
13 | f_pppoe_250k | Framed-Protocol| =  |
PPP   
   || 14 | f_pppoe_250k |
Framed-MTU   | =  |
1492   
 || 15 | f_pppoe_250k |
Framed-Compression | =  | Van-Jacobsen-TCP-IP || 16 | f_pppoe_250k |
Service-Type| =  |
Framed-User   
|+---++--++--+
## radusergroup (same usergroup table in 1.3 version freeradius, I have both
tables) +---++--+ | UserName |
GroupName| priority|
+---++--+ | teste-pap  | f_pppoe_250k
|1|
+---++--+  ## radiusd -X
 rad_recv: Access-Request packet from host 7.7.7.1 port 32790, id=163,
length=73 Service-Type =
Framed-User Framed-Protocol =
PPP User-Name =
test-pap User-Password
= pw123 NAS-IP-Address
=  NAS-Port = 0  
Processing the authorize section of radiusd.conf +- entering group
authorize ++[preprocess] returns ok ++[chap] returns noop
++[mschap] returns noop   rlm_eap: No EAP-Message, not doing EAP
++[eap] returns noop radius_xlat:  'test-pap' rlm_sql (sql):
sql_set_user escaped user -- 'test-pap' rlm_sql (sql): Reserving sql
socket id: 3 radius_xlat:  'SELECT id, UserName, Attribute, Value,
op   FROM
radcheck   WHERE Username
= 'test-pap'   ORDER BY
id' loading radcheck table ## rlm_sql
(sql): User found in radcheck table radius_xlat:  'SELECT id, UserName,
Attribute, Value, op  
FROM radreply   WHERE
Username = 'test-pap'  
ORDER BY id'   ### loading radreply table ## rlm_sql
(sql): Released sql socket id:
3 
 if found Fall-Through = Yes attribute, radgroupcheck is loaded,
but not radgroupreply # ++[sql] returns ok ++[expiration]
returns noop ++[logintime] returns noop ++[pap] returns updated
+- group authorize returns updated   rad_check_password:  Found
Auth-Type auth: type PAP   Processing the authenticate
section of radiusd.conf +- entering group PAP rlm_pap: login attempt
with password ngc0bqi rlm_pap: Using clear text password. rlm_pap: User
authenticated successfully ++[pap] returns ok +- group PAP returns
ok   Processing the post-auth section of radiusd.conf +- entering
group post-auth rlm_sql (sql): Processing sql_postauth rlm_sql (sql):
sql_set_user escaped user -- 'test-pap' radius_xlat:  'INSERT into
radpostauth (id, user, pass, reply, date) values ('', 'test-pap', 'ngc0bqi',
'Access-Accept', '2008-01-15 20:33:58')' rlm_sql (sql) in sql_postauth: query
is INSERT into radpostauth (id, user, pass, reply, date) values ('', 
'test-pap',
'pw123', 'Access-Accept', '2008-01-15 20:33:58') rlm_sql (sql): Reserving sql
socket id: 2 rlm_sql (sql): Released sql socket id: 2 ++[sql] returns
ok +- group post-auth returns ok Sending Access-Accept of id 163 to
7.7.7.1 port 32790# Here is
when radius server send items reply to radiusclient
# Upstream-Speed =
800   attribute in
radreply  Downstream-Speed
= 800 ## attribute in radreply  Finished
request 0 state 5 Going to the next request rad_recv:
Accounting-Request packet from host 7.7.7.1 port 32790, id=164, length=101
Acct-Session-Id =
478D34D61E1F00
User-Name = test-pap

Re: radgroupreply do not read (read_grous directive)

2008-01-15 Thread Arlinelson Fernandes dos Santos
Sorry! I was writing this post and correcting the align spaces when press the
e for accident. In my usergroup is test-pap.thanks. There is a typo in usergroup table. Group is set as teste-pap, while other
tables have group test-pap.  Ivan Kalik Kalik Informatika ISP   Dana 15/1/2008, Arlinelson Fernandes dos Santos 
pie:  Don't take your ball, not good. ;) Here's
informations:##
radcheck++---+++-+| id  |
UserName  | Attribute | op  | Value   
|++---+++-+|  3  | test-pap  
| Cleartext-Password  | := | pw123 
|++---+++-+##
radreply++---+-++---+| id   |
UserName | Attribute  | op  | Value 
|++---+-++---+|  6  | test-pap  
| Upstream-Speed | =   | 800   ||  7  | test-pap   | Downstream-Speed
 | =   | 800  
|++---+-++---+##
radgroupcheck+++++---+| id   |
GroupName| Attribute | op   | Value
|+++++---+|  5   |
f_pppoe_250k | Auth-Type   | =   | PAP||  6   | f_pppoe_250k
| Simultaneous-Use | =   | 1  
|+++++---+  ##
radgroupreply
++--+---++--+| id | GroupName| Attribute | op  |
Value   
|++--+---++--+|
13 | f_pppoe_250k | Framed-Protocol| =  | PPP  
|| 14 | f_pppoe_250k | Framed-MTU   | =  | 1492 || 15 | f_pppoe_250k |
Framed-Compression | =  | Van-Jacobsen-TCP-IP || 16 | f_pppoe_250k |
Service-Type| =  | Framed-User  
|+---++--++--+
## radusergroup (same usergroup table in 1.3 version freeradius, I have both tables) +---++--+ | UserName |
GroupName| priority|
+---++--+ | teste-pap  | f_pppoe_250k
|1| +---++--+  ## radiusd
-X  rad_recv: Access-Request packet from host 7.7.7.1 port 32790,
id=163, length=73 Service-Type Framed-User
Framed-Protocol PPP User-Name test-pap
User-Password = pw123 NAS-IP-Address = 
NAS-Port = 0   Processing the authorize section of radiusd.conf +-
entering group authorize ++[preprocess] returns ok ++[chap] returns
noop ++[mschap] returns noop   rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop radius_xlat:  'test-pap' rlm_sql (sql):
sql_set_user escaped user -- 'test-pap' rlm_sql (sql): Reserving sql
socket id: 3 radius_xlat:  'SELECT id, UserName, Attribute, Value, op
  FROM radcheck   WHERE Username = 'test-pap'  
ORDER BY id' loading radcheck table ##
rlm_sql (sql): User found in radcheck table radius_xlat:  'SELECT id,
UserName, Attribute, Value, op   FROM radreply 
 WHERE Username = 'test-pap'   ORDER BY id'   ###
loading radreply table ## rlm_sql (sql): Released sql socket
id: 3
  if found Fall-Through = Yes attribute, radgroupcheck is
loaded, but not radgroupreply # ++[sql] returns ok
++[expiration] returns noop ++[logintime] returns noop ++[pap] returns
updated +- group authorize returns updated   rad_check_password: 
Found Auth-Type auth: type PAP   Processing the
authenticate section of radiusd.conf +- entering group PAP rlm_pap: login
attempt with password ngc0bqi rlm_pap: Using clear text password.
rlm_pap: User authenticated successfully ++[pap] returns ok +- group PAP
returns ok   Processing the post-auth section of radiusd.conf +-
entering group post-auth rlm_sql (sql): Processing sql_postauth rlm_sql
(sql): sql_set_user escaped user -- 'test-pap' radius_xlat:  'INSERT
into radpostauth (id, user, pass, reply, date) values ('', 'test-pap',
'ngc0bqi', 'Access-Accept', '2008-01-15 20:33:58')' rlm_sql (sql) in
sql_postauth: query is INSERT into radpostauth (id, user, pass, reply,
date) values ('', 'test-pap', 'pw123', 'Access-Accept', '2008-01-15
20:33:58') rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql):
Released sql socket id: 2 ++[sql] returns ok +- group post-auth returns
ok Sending Access-Accept of id 163 to 7.7.7.1 port 32790   
# Here is when radius server send items reply to
radiusclient # Upstream-Speed 800 
 attribute in radreply  Downstream-Speed
= 800 ## attribute in radreply  Finished request 0
state 5 Going to the next request 

Re: radgroupreply do not read (read_grous directive)

2008-01-14 Thread tnt
Did you put something in usergroup table to link users and groups?

Ivan Kalik
Kalik Informatika ISP


Dana 14/1/2008, Arlinelson Fernandes dos Santos [EMAIL PROTECTED]
piše:

Hi,I am usind freeradius 2.0 an need to load radcheck, radreply,
radgroupcheck and radgroupreply tables. But radcheck and radreply work. To load
radgroupcheck e need to set Fall-Through = Yes, but radgroupreply don't work. 
The
read_groups directive is 'Yes' but not appers in the radius debug mode.How
can I do freeradius load radgroupreply? I have the Simultaneous-Use attribut in
this table, I need to use this attribute to all users. Someone
please? 



--
Acelerador POP
Acelere a sua conex#227;o discada em até 19 x. Use o Acelerador POP. É 
grátis, pegue já o seu.
http://www.pop.com.br/acelerador



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


Re: radgroupreply do not read (read_grous directive)

2008-01-14 Thread Arlinelson Fernandes dos Santos
Yes! I did. And I put attributes into all tables ckeck and reply. Did you put something in usergroup table to link users and groups? 
Ivan Kalik Kalik Informatika ISP   Dana 14/1/2008,
Arlinelson Fernandes dos Santos  pie:  Hi,I am
usind freeradius 2.0 an need to load radcheck, radreply, radgroupcheck
and radgroupreply tables. But radcheck and radreply work. To load
radgroupcheck e need to set Fall-Through = Yes, but radgroupreply don't work.
The read_groups directive is 'Yes' but not appers in the radius debug
mode.How can I do freeradius load radgroupreply? I have the
Simultaneous-Use attribut in this table, I need to use this attribute to
all users. Someone please?
-- Acelerador POP Acelere a sua conexo discada em at
19 x. Use o Acelerador POP.  grtis, pegue j o seu.
http://www.pop.com.br/acelerador-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



--
Acelerador POP
Acelere a sua conexo discada em at 19 x. Use o Acelerador POP.  grtis, pegue j o seu.
http://www.pop.com.br/acelerador
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html