[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: Configuring Freeradius to authenticate with MySQL
From:       bhalchandra sawant <bssawant () yahoo ! com>
Date:       2004-11-29 9:46:28
Message-ID: 20041129094628.5503.qmail () web41309 ! mail ! yahoo ! com
[Download RAW message or body]

Hi,
Yes it is there.
-bs sawant
--- Mohammed Petiwala <mhpetiwala@yahoo.com> wrote:

> Hi:
> Based on the error message - check whether your
> clients.conf file has local host 127.0.0.1 setup as
> a
> valid client and also check the shared-secret used
> is
> the correct....
> 
> client 127.0.0.1 {
> 	secret		= omeya
> 	shortname	= spacecable
> 	nastype     	= other
> }
> 
> -Mohammed.
> 
> 
> Mohammed H. Petiwala
> Senior Staff Engineer
> iDEN-WLAN, Motorola Inc.
> 
> 
> --- bhalchandra sawant <bssawant@yahoo.com> wrote:
> 
> > Hello,
> > 
> > I am configuring Freeradius with Mysql.  I think I
> > have configured correctly, as I am not getting any
> > error message in debugging mode.  The result is as
> > below :
> > 
> > [root@spacecable root]# radiusd -X
> > Starting - reading configuration files ...
> > reread_config:  reading radiusd.conf
> > Config:   including file: /etc/raddb/sql.conf
> >  main: prefix = "/usr"
> >  main: localstatedir = "/var"
> >  main: logdir = "/var/log/radius"
> >  main: libdir = "/usr/lib"
> >  main: radacctdir = "/var/log/radius/radacct"
> >  main: hostname_lookups = no
> >  main: max_request_time = 90
> >  main: cleanup_delay = 5
> >  main: max_requests = 1024
> >  main: delete_blocked_requests = 0
> >  main: port = 0
> >  main: allow_core_dumps = no
> >  main: log_stripped_names = no
> >  main: log_file = "/var/log/radius/radius.log"
> >  main: log_auth = no
> >  main: log_auth_badpass = no
> >  main: log_auth_goodpass = no
> >  main: pidfile = "/var/run/radiusd/radiusd.pid"
> >  main: user = "radiusd"
> >  main: group = "radiusd"
> >  main: usercollide = no
> >  main: lower_user = "no"
> >  main: lower_pass = "no"
> >  main: nospace_user = "no"
> >  main: nospace_pass = "no"
> >  main: checkrad = "/usr/sbin/checkrad"
> >  main: proxy_requests = no
> >  security: max_attributes = 200
> >  security: reject_delay = 1
> >  security: status_server = no
> >  main: debug_level = 0
> > read_config_files:  reading dictionary
> > read_config_files:  reading naslist
> > Using deprecated naslist file.  Support for this
> > will
> > go away soon.
> > read_config_files:  reading clients
> > Using deprecated clients file.  Support for this
> > will
> > go away soon.
> > read_config_files:  reading realms
> > Using deprecated realms file.  Support for this
> will
> > go away soon.
> > radiusd:  entering modules setup
> > Module: Library search path is /usr/lib
> > Module: Loaded expr
> > Module: Instantiated expr (expr)
> > Module: Loaded PAP
> >  pap: encryption_scheme = "crypt"
> > Module: Instantiated pap (pap)
> > Module: Loaded CHAP
> > Module: Instantiated chap (chap)
> > Module: Loaded MS-CHAP
> >  mschap: use_mppe = yes
> >  mschap: require_encryption = yes
> >  mschap: require_strong = yes
> >  mschap: passwd = "(null)"
> >  mschap: authtype = "MS-CHAP"
> > Module: Instantiated mschap (mschap)
> > Module: Loaded preprocess
> >  preprocess: huntgroups = "/etc/raddb/huntgroups"
> >  preprocess: hints = "/etc/raddb/hints"
> >  preprocess: with_ascend_hack = no
> >  preprocess: ascend_channels_per_line = 23
> >  preprocess: with_ntdomain_hack = no
> >  preprocess: with_specialix_jetstream_hack = no
> >  preprocess: with_cisco_vsa_hack = no
> > Module: Instantiated preprocess (preprocess)
> > Module: Loaded detail
> >  detail: detailfile =
> >
>
"/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d"
> >  detail: detailperm = 384
> >  detail: dirperm = 493
> >  detail: locking = no
> > Module: Instantiated detail (auth_log)
> > Module: Loaded realm
> >  realm: format = "suffix"
> >  realm: delimiter = "@"
> > Module: Instantiated realm (suffix)
> > Module: Loaded SQL
> >  sql: driver = "rlm_sql_mysql"
> >  sql: server = "spacecable"
> >  sql: port = ""
> >  sql: login = ""
> >  sql: password = ""
> >  sql: radius_db = "radius"
> >  sql: acct_table = "radacct"
> >  sql: acct_table2 = "radacct"
> >  sql: authcheck_table = "radcheck"
> >  sql: authreply_table = "radreply"
> >  sql: groupcheck_table = "radgroupcheck"
> >  sql: groupreply_table = "radgroupreply"
> >  sql: usergroup_table = "usergroup"
> >  sql: nas_table = "nas"
> >  sql: dict_table = "dictionary"
> >  sql: sqltrace = yes
> >  sql: sqltracefile =
> "/var/log/radius/sqltrace.sql"
> >  sql: deletestalesessions = yes
> >  sql: num_sql_socks = 5
> >  sql: sql_user_name =
> > "%{Stripped-User-Name:-%{User-Name:-DEFAULT}}"
> >  sql: default_user_profile = ""
> >  sql: query_on_not_found = no
> >  sql: authorize_check_query = "SELECT
> > id,UserName,Attribute,Value,op FROM radcheck WHERE
> > Username = '%{SQL-User-Name}' ORDER BY id"
> >  sql: authorize_reply_query = "SELECT
> > id,UserName,Attribute,Value,op FROM radreply WHERE
> > Username = '%{SQL-User-Name}' ORDER BY id"
> >  sql: authorize_group_check_query = "SELECT
> >
>
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
> >  FROM radgroupcheck,usergroup WHERE
> > usergroup.Username
> > = '%{SQL-User-Name}' AND usergroup.GroupName =
> > radgroupcheck.GroupName ORDER BY radgroupcheck.id"
> >  sql: authorize_group_reply_query = "SELECT
> >
>
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
> >  FROM radgroupreply,usergroup WHERE
> > usergroup.Username
> > = '%{SQL-User-Name}' AND usergroup.GroupName =
> > radgroupreply.GroupName ORDER BY radgroupreply.id"
> >  sql: accounting_onoff_query = "UPDATE radacct SET
> > AcctStopTime='%S',
> > AcctSessionTime=unix_timestamp('%S') -
> > unix_timestamp(AcctStartTime),
> > AcctTerminateCause='%{Acct-Terminate-Cause}',
> > AcctStopDelay = %{Acct-Delay-Time} WHERE
> > AcctSessionTime=0 AND AcctStopTime=0 AND
> > NASIPAddress=
> > '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
> >  sql: accounting_update_query = "UPDATE radacct
> SET
> > FramedIPAddress = '%{Framed-IP-Address}' WHERE
> > AcctSessionId = '%{Acct-Session-Id}' AND UserName
> =
> > '%{SQL-User-Name}' AND NASIPAddress=
> > '%{NAS-IP-Address}' AND AcctStopTime = 0"
> >  sql: accounting_start_query = "INSERT into
> radacct
> > (RadAcctId, 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('', '%{Acct-Session-Id}',
> > '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
> > '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
> > '%{NAS-Port-Type}', '%S', '0', '0',
> > '%{Acct-Authentic}', '%{Connect-Info}', '', '0',
> > '0',
> > '%{Called-Station-Id}', '%{Calling-Station-Id}',
> '',
> > '%{Service-Type}', '%{Framed-Protocol}',
> > '%{Framed-IP-Address}', '%{Acct-Delay-Time}',
> '0')"
> >  sql: accounting_start_query_alt = "UPDATE radacct
> > SET
> 
=== message truncated ===



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]