Re: Problem with freeradius and mysql

2007-04-09 Thread José Christian Rodríguez 
Thank all for your help.
My freeradius with mysql is working now.

Christian
  - Original Message - 
  From: satish patel 
  To: FreeRadius users mailing list 
  Sent: Friday, April 06, 2007 2:55 AM
  Subject: Re: Problem with freeradius and mysql


  Dear all

Here I am shareing my Knowledge. for freeradius users. i 
have done freeradius-1.1.4 with mysql with cisco VPDN configuration as well as 
i have configuraed per user base bandwidth configuration and simultanious user 
login configuration i have sharing my configuration for my freeradius users

  I have cisco router with this configuration

  aaa new-model
  !
  !
  aaa group server radius testing123
   server-private 71.5.250.243 auth-port 1812 acct-port 1813 key tulipconnect
   ip radius source-interface FastEthernet0/1
   deadtime 0
  !
  aaa authentication login default local group radius group testing123
  aaa authentication ppp default group testing123 local 
  aaa authorization exec default local group radius group testing123
  aaa authorization network default group testing123 local
  aaa accounting update periodic 1
  aaa accounting exec default start-stop group testing123
  aaa accounting network default start-stop group testing123
  aaa accounting connection default start-stop group testing123
  !

  _ 

  My all user databases in mysql and simultanius login also in mysql 

  mysql tables :-

  mysql> select * from radcheck;
  ++--+---++---+
  | id | UserName | Attribute | op | Value | 
  ++--+---++---+
  |  1 | satish   | User-Password | := | tulip |
  |  2 | priya| User-Password | := | tulip |
  ++--+---++---+
  2 rows in set (0.00 sec)


  mysql> select * from radgroupcheck;;
  ++---+--++---+
  | id | GroupName | Attribute| op | Value |
  ++---+--++---+
  |  1 | 64KB  | Simultaneous-Use | := | 1 |
  |  4 | 128KB | Simultaneous-Use | := | 1 |
  ++---+--++---+
  2 rows in set (0.00 sec)


  mysql> select * from radgroupreply;;
  
++---+-+++--+
 
  | id | GroupName | Attribute   | op | Value   
   | prio |
  
++---+-+++--+
 
  |  1 | 64KB  | Framed-Protocol | =  | PPP 
   |0 |
  |  2 | 64KB  | Framed-MTU  | =  | 1400
   |0 |
  |  3 | 64KB  | Service-Type| =  | Framed-User 
   |0 |
  |  4 | 128KB | Framed-Protocol | =  | PPP 
   |0 |
  |  5 | 128KB | Framed-MTU  | =  | 1450
   |0 |
  |  6 | 128KB | Service-Type| =  | Framed-User 
   |0 |
  |  7 | 128KB | Cisco-Avpair| =  | lcp:interface-config#1=rate-limit 
output 128000 1 1 conform-action continue exceed-action drop |0 | 
  
++---+-+++--+
  7 rows in set (0.00 sec)


  mysql> select * from usergroup;
  ++--+---+
  | id | UserName | GroupName |
  ++--+---+
  |  1 | satish   | 64KB  |
  |  3 | priya| 128KB |
  ++--+---+
  2 rows in set (0.00 sec)

  

  Simultanious Login configuration ( edit this file /etc/raddb/sql.conf )

   ### 
  # Simultaneous Use Checking Queries
  
###
  # simul_count_query - query for the number of current connections
  #   - If this is not defined, no simultaneouls 
use checking
  #   - will be performed by this module instance
  # simul_verify_query- query to return details of current 
connections for verification
  #

Re: Problem with freeradius and mysql

2007-04-06 Thread satish patel 
Dear all

  Here I am shareing my Knowledge. for freeradius users. i have 
done freeradius-1.1.4 with mysql with cisco VPDN configuration as well as i 
have configuraed per user base bandwidth configuration and simultanious user 
login configuration i have sharing my configuration for my freeradius users

I have cisco router with this configuration

aaa new-model
!
!
aaa group server radius testing123
 server-private  71.5.250.243 auth-port 1812 acct-port 1813 key tulipconnect
 ip radius source-interface FastEthernet0/1
 deadtime 0
!
aaa authentication login default local group radius group testing123
aaa authentication ppp default group testing123 local 
aaa authorization exec default local group radius group testing123
aaa authorization network default group testing123 local
aaa accounting update periodic  1
aaa accounting exec default start-stop group testing123
aaa accounting network default start-stop group testing123
aaa accounting connection default start-stop group testing123
!

_ 

My all user databases in mysql and simultanius login also in mysql 

mysql tables :-

mysql> select * from radcheck;
++--+---++---+
| id | UserName | Attribute | op | Value | 
++--+---++---+
|  1 | satish   | User-Password | := | tulip |
|  2 | priya| User-Password | := | tulip |
++--+---++---+
2 rows in set (0.00  sec)


mysql> select * from radgroupcheck;;
++---+--++---+
| id | GroupName | Attribute| op | Value  |
++---+--++---+
|  1 | 64KB  | Simultaneous-Use | := | 1 |
|  4 | 128KB | Simultaneous-Use | := | 1 |
++---+--++---+
 2 rows in set (0.00 sec)


mysql> select * from radgroupreply;;
++---+-+++--+
 
| id | GroupName | Attribute   | op | Value 
 | prio |
++---+-+++--+
 
|  1 | 64KB  | Framed-Protocol | =  | PPP   
 |0 |
|  2 | 64KB  | Framed-MTU  | =  | 1400  
 |0 |
|  3 | 64KB  | Service-Type| =  |  Framed-User  
  |0 |
|  4 | 128KB | Framed-Protocol | =  | PPP   
 |0 |
|  5 | 128KB | Framed-MTU  | =  | 1450  
 |0 |
|  6 | 128KB | Service-Type| =  |  Framed-User  
  |0 |
|  7 | 128KB | Cisco-Avpair| =  | lcp:interface-config#1=rate-limit 
output 128000 1 1 conform-action continue exceed-action drop |0 | 
++---+-+++--+
7 rows in set (0.00  sec)


mysql> select * from usergroup;
++--+---+
| id | UserName | GroupName |
++--+---+
|  1 | satish   | 64KB  |
|  3 | priya| 128KB |
 ++--+---+
2 rows in set (0.00 sec)



Simultanious Login configuration ( edit this file /etc/raddb/sql.conf )

 ### 
# Simultaneous Use Checking Queries
###
# simul_count_query - query for the number of current connections
#   - If this is not defined, no simultaneouls use 
checking
#   - will be performed by this module instance
# simul_verify_query- query to return details of current 
connections for verification
#   - Leave blank or commented out to disable 
verification step
#   - Note that the returned field order should not 
be changed.
###

# Uncomment simul_count_query to enable simultaneous use checking 
 simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE 
UserName='%{SQL-User-N

Re: Problem with freeradius and mysql

2007-04-05 Thread Alan DeKok 
José Christian Rodríguez wrote:
...
> *ERROR: Cannot find a configuration entry for module "sql".
> radiusd.conf[1801] Unknown module "sql".
> radiusd.conf[1730] Failed to parse authorize section.

  You didn't configure the SQL module.

  Read radiusd.conf, and look for the word "sql".  Configure it.  Also
see "sql.conf".

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html