Re: Why Freeradius and Mysql dont work?

permalink · #1 (**permalink**) 01-29-2007

--===============0898726146==
Content-Type: multipart/alternative;
boundary="----=_Part_67755_4523449.1170033787632"

------=_Part_67755_4523449.1170033787632
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sorry. The debug result I listed is only the response to access request. The
original display of "radiusd -X" is as follows:
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /usr/local/etc/raddb/proxy.conf
Config: including file: /usr/local/etc/raddb/clients.conf
Config: including file: /usr/local/etc/raddb/snmp.conf
Config: including file: /usr/local/etc/raddb/eap.conf
Config: including file: /usr/local/etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/usr/local/var"
main: logdir = "/usr/local/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/usr/local/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
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 = "/usr/local/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = yes
proxy: wake_all_if_all_dead = 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
read_config_files: reading realms
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded exec
exec: wait = yes
exec: program = "(null)"
exec: input_pairs = "request"
exec: output_pairs = "(null)"
exec: packet_type = "(null)"
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
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 = no
mschap: require_strong = no
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded preprocess
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
preprocess: hints = "/usr/local/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 realm
realm: format = "suffix"
realm: delimiter = "@"
realm: ignore_default = no
realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "root"
sql: password = "123"
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 = "/usr/local/var/log/radius/sqltrace.sql"
sql: readclients = no
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,ra dgroupcheck.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,ra dgroupreply.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}', AcctSessionTime =
'%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets =
'%{Acct-Output-Octets}' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress= '%{NAS-IP-Address}'"
sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay)
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} +
%{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}',
'', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '0')"
sql: accounting_start_query = "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('%{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 AcctStartTime = '%S',
AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}'
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress = '%{NAS-IP-Address}'"
sql: accounting_stop_query = "UPDATE radacct 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}'"
sql: accounting_stop_query_alt = "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('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} +
%{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}',
'%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE
UserName='%{SQL-User-Name}'"
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: 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 =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV WXYZ0123456789.-_: /"
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to root@localhost:/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_mysql: Couldn't connect socket to MySQL server root@localhost:radius
rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2)'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.
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 = 600
Module: Instantiated unix (unix)
Module: Loaded radutmp
radutmp: filename = "/usr/local/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: case_sensitive = yes
radutmp: check_with_nas = yes
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
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)
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.

Is anything wrong?

2007/1/29, A.L.M.Buxey@lboro.ac.uk <A.L.M.Buxey@lboro.ac.uk>:
>
> Hi,
>
> > 3.Edit radiusd.conf and sql.conf;
> > Debug Result:
> > Nothing to do. Sleeping until we see a request.
>
>
> no. thats not the debug result. you've edited all the lines before
> that output.
>
> alan
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>

------=_Part_67755_4523449.1170033787632
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Sorry. The debug result I listed is only the response to a=
ccess request. The original display  of   "radiusd -X&q=
uot;  is as  follows: Starting - reading configuration =
files ... reread_config:  reading=20
radiusd.conf Config:   including file: /usr/local/etc/raddb/pr=
oxy.conf Config:   including file: /usr/local/etc/raddb/client=
s.conf Config:   including file: /usr/local/etc/raddb/snmp.con=
f Config:   including file: /usr/local/etc/raddb/eap.conf
 Config:   including file: /usr/local/etc/raddb/sql.conf &n=
bsp;main: prefix =3D "/usr/local"  main: localstatedir =
=3D "/usr/local/var"  main: logdir =3D "/usr/local/v=
ar/log/radius"  main: libdir =3D "/usr/local/lib"
  main: radacctdir =3D "/usr/local/var/log/radius/radacct&quot=
;  main: hostname_lookups =3D no  main: max_request_time =
=3D 30  main: cleanup_delay =3D 5  main: max_requests =3D 1=
024  main: delete_blocked_requests =3D 0
  main: port =3D 0  main: allow_core_dumps =3D no  =
main: log_stripped_names =3D no  main: log_file =3D "/usr/loca=
l/var/log/radius/radius.log"  main: log_auth =3D no  m=
ain: log_auth_badpass =3D no  main: log_auth_goodpass =3D no
  main: pidfile =3D "/usr/local/var/run/radiusd/radiusd.pid&qu=
ot;  main: user =3D "(null)"  main: group =3D &qu=
ot;(null)"  main: usercollide =3D no  main: lower_user=
=3D "no"  main: lower_pass =3D "no"
  main: nospace_user =3D "no"  main: nospace_pass=
=3D "no"  main: checkrad =3D "/usr/local/sbin/check=
rad"  main: proxy_requests =3D yes  proxy: retry_delay=
=3D 5  proxy: retry_count =3D 3
  proxy: synchronous =3D no  proxy: default_fallback =3D ye=
s  proxy: dead_time =3D 120  proxy: post_proxy_authorize =
=3D yes  proxy: wake_all_if_all_dead =3D no  security: max_=
attributes =3D 200  security: reject_delay =3D 1
  security: status_server =3D no  main: debug_level =3D 0<b=
r>read_config_files:  reading dictionary read_config_files:  r=
eading naslist Using deprecated naslist file.  Support for this wil=
l go away soon. read_config_files:  reading clients
 read_config_files:  reading realms radiusd:  entering modu=
les setup Module: Library search path is /usr/local/lib Module: Loade=
d exec  exec: wait =3D yes  exec: program =3D "(null)&=
quot;  exec: input_pairs =3D "request"
  exec: output_pairs =3D "(null)"  exec: packet_t=
ype =3D "(null)" rlm_exec: Wait=3Dyes but no output defined. D=
id you mean output=3Dnone? Module: Instantiated exec (exec) Module: L=
oaded expr 
Module: Instantiated expr (expr) Module: Loaded PAP  pap: encryp=
tion_scheme =3D "crypt" Module: Instantiated pap (pap) Modu=
le: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CH=
AP 
 mschap: use_mppe =3D yes  mschap: require_encryption =3D no<b=
r> mschap: require_strong =3D no  mschap: with_ntdomain_hack =
=3D no  mschap: passwd =3D "(null)"  mschap: auth=
type =3D "MS-CHAP"  mschap: ntlm_auth =3D "(null)&qu=
ot;
 Module: Instantiated mschap (mschap) Module: Loaded preprocess &n=
bsp;preprocess: huntgroups =3D "/usr/local/etc/raddb/huntgroups"<=
br> preprocess: hints =3D "/usr/local/etc/raddb/hints" &n=
bsp;preprocess: with_ascend_hack =3D no
  preprocess: ascend_channels_per_line =3D 23  preprocess: =
with_ntdomain_hack =3D no  preprocess: with_specialix_jetstream_hac=
k =3D no  preprocess: with_cisco_vsa_hack =3D no Module: Instant=
iated preprocess (preprocess)
 Module: Loaded realm  realm: format =3D "suffix" &=
nbsp;realm: delimiter =3D "@"  realm: ignore_default =3D =
no  realm: ignore_null =3D no Module: Instantiated realm (suffix=
) Module: Loaded SQL 
 sql: driver =3D "rlm_sql_mysql"  sql: server =3D &q=
uot;localhost"  sql: port =3D ""  sql: login=
=3D "root"  sql: password =3D "123"  s=
ql: radius_db =3D "radius" 
 sql: acct_table =3D "radacct"  sql: acct_table2 =3D=
"radacct"  sql: authcheck_table =3D "radcheck"=
  sql: authreply_table =3D "radreply"  sql: group=
check_table =3D "radgroupcheck"
  sql: groupreply_table =3D "radgroupreply"  sql:=
usergroup_table =3D "usergroup"  sql: nas_table =3D &quo=
t;nas"  sql: dict_table =3D "dictionary"  sq=
l: sqltrace =3D yes  sql: sqltracefile =3D "/usr/local/var/log=
/radius/sqltrace.sql"
  sql: readclients =3D no  sql: deletestalesessions =3D yes=
  sql: num_sql_socks =3D 5  sql: sql_user_name =3D "%{=
Stripped-User-Name:-%{User-Name:-DEFAULT}}"  sql: default_user=
_profile =3D ""  sql: query_on_not_found =3D no
  sql: authorize_check_query =3D "SELECT id, UserName, Attribu=
te, Value, op            F=
ROM radcheck            WH=
ERE Username =3D '%{SQL-User-Name}'     &n=
bsp;     ORDER BY id"  sql: authorize_repl=
y_query =3D "SELECT id, UserName, Attribute, Value, op  &nbs=
p;        FROM radreply  &nbsp=
;        WHERE Username =3D '%{SQL-U=
ser-Name}'       &n bsp;   =
ORDER BY id"
  sql: authorize_group_check_query =3D "SELECT <a href=3D"http=
://radgroupcheck.id">radgroupcheck.id</a>,radgroupcheck.GroupName,radgroupc=
heck.Attribute,radgroupcheck.Value,radgroupcheck.o p  FROM radgroupchec=
k,usergroup WHERE=20
usergroup.Username =3D '%{SQL-User-Name}' AND usergroup.GroupName =
=3D radgroupcheck.GroupName ORDER BY <a href=3D"http://radgroupcheck.id">ra=
dgroupcheck.id</a>"  sql: authorize_group_reply_query =3D &quo=
t;SELECT <a href=3D"http://radgroupreply.id">
radgroupreply.id</a>,radgroupreply.GroupName,radgroupreply.Attribute ,radgro=
upreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE use=
rgroup.Username =3D '%{SQL-User-Name}' AND usergroup.GroupName =3D =
radgroupreply.GroupName
ORDER BY <a href=3D"http://radgroupreply.id">radgroupreply.id</a>"<br=
> sql: accounting_onoff_query =3D "UPDATE radacct SET AcctStopTim=
e=3D'%S', AcctSessionTime=3Dunix_timestamp('%S') - unix_tim=
estamp(AcctStartTime), AcctTerminateCause=3D'%{Acct-Terminate-Cause}&#3=
9;, AcctStopDelay =3D '%{Acct-Delay-Time}' WHERE AcctSessionTime=3D=
0 AND AcctStopTime=3D0 AND NASIPAddress=3D '%{NAS-IP-Address}' AND =
AcctStartTime <=3D '%S'"
  sql: accounting_update_query =3D "UPDATE radacct  =
       &nbsp ; SET FramedIPAddress =3D &#=
39;%{Framed-IP-Address}',      &nbs p;&nbs=
p;   AcctSessionTime =3D '%{Acct-Session-Time}', &nb=
sp;       &nbsp ; AcctInputOctets =3D &#3=
9;%{Acct-Input-Octets}',      &nbsp ;&nbsp=
;   AcctOutputOctets =3D '%{Acct-Output-Octets}' &nb=
sp;       &nbsp ; WHERE AcctSessionId =3D=
'%{Acct-Session-Id}'       &nbs =
p;   AND UserName =3D '%{SQL-User-Name}'  &nbsp=
;        AND NASIPAddress=3D '%{NAS-=
IP-Address}'"
  sql: accounting_update_query_alt =3D "INSERT into radacct (A=
cctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPo=
rtType, AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, A=
cctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, Servic=
eType, FramedProtocol, FramedIPAddress, AcctStartDelay) values('%{Acct-=
Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name=
}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}&#=
39;, '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Ses=
sion-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}&#=
39;, '%{Acct-Authentic}', '', '%{Acct-Input-Octets}&#39=
;, '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{=
Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol=
}', '%{Framed-IP-Address}', '0')"
  sql: accounting_start_query =3D "INSERT into radacct (AcctSe=
ssionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortTyp=
e, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo=
_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationI=
d, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, Frame=
dIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}&#=
39;, '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '=
%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{N=
AS-Port-Type}', '%S', '0', '0', '%{Acct-Aut=
hentic}', '%{Connect-Info}', '', '0', '0&#3=
9;, '%{Called-Station-Id}', '%{Calling-Station-Id}', '&=
#39;, '%{Service-Type}', '%{Framed-Protocol}', '%{Frame=
d-IP-Address}', '%{Acct-Delay-Time}', '0')"
  sql: accounting_start_query_alt =3D "UPDATE radacct SET Acct=
StartTime =3D '%S', AcctStartDelay =3D '%{Acct-Delay-Time}'=
, ConnectInfo_start =3D '%{Connect-Info}' WHERE AcctSessionId =3D &=
#39;%{Acct-Session-Id}' AND UserName =3D '%{SQL-User-Name}' AND=
NASIPAddress =3D '%{NAS-IP-Address}'"
  sql: accounting_stop_query =3D "UPDATE radacct SET AcctStopT=
ime =3D '%S', AcctSessionTime =3D '%{Acct-Session-Time}', A=
cctInputOctets =3D '%{Acct-Input-Octets}', AcctOutputOctets =3D &#3=
9;%{Acct-Output-Octets}', AcctTerminateCause =3D '%{Acct-Terminate-=
Cause}', AcctStopDelay =3D '%{Acct-Delay-Time}', ConnectInfo_st=
op =3D '%{Connect-Info}' WHERE AcctSessionId =3D '%{Acct-Sessio=
n-Id}' AND UserName =3D '%{SQL-User-Name}' AND NASIPAddress =3D=
'%{NAS-IP-Address}'"
  sql: accounting_stop_query_alt =3D "INSERT into radacct (Acc=
tSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPort=
Type, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectI=
nfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStati=
onId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, Fr=
amedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id=
}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', &#=
39;%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '=
%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time=
:-0} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Ti=
me}', '%{Acct-Authentic}', '', '%{Connect-Info}&#39=
;, '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{=
Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Termi=
nate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', =
'%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')&=
quot;
  sql: group_membership_query =3D "SELECT GroupName FROM userg=
roup WHERE UserName=3D'%{SQL-User-Name}'"  sql: connec=
t_failure_retry_delay =3D 60  sql: simul_count_query =3D "&quo=
t;  sql: simul_verify_query =3D "SELECT RadAcctId, AcctSession=
Id, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, F=
ramedProtocol FROM radacct WHERE UserName=3D'%{SQL-User-Name}' AND =
AcctStopTime =3D 0"
  sql: postauth_table =3D "radpostauth"  sql: pos=
tauth_query =3D "INSERT into radpostauth (id, user, pass, reply, date)=
values ('', '%{User-Name}', '%{User-Password:-Chap-Pas=
sword}', '%{reply:Packet-Type}', NOW())"
  sql: safe-characters =3D "@abcdefghijklmnopqrstuvwxyzABCDEFG=
HIJKLMNOPQRSTUVWXYZ0123456789.-_: /" rlm_sql (sql): Driver rlm_sql_=
mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting=
to connect to=20
root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attem=
pting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MyS=
QL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL ser=
ver=20
root@localhost:radius rlm_sql_mysql: Mysql error 'Can't connect =
to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2=
)' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): s=
tarting 1
 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql)=
: starting 4 rlm_sql (sql): Failed to connect to any SQL server. Modu=
le: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id 
 acct_unique: key =3D "User-Name, Acct-Session-Id, NAS-IP-Address=
, Client-IP-Address, NAS-Port" Module: Instantiated acct_unique (ac=
ct_unique) Module: Loaded detail  detail: detailfile =3D "/=
usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"
  detail: detailperm =3D 384  detail: dirperm =3D 493 &n=
bsp;detail: locking =3D no Module: Instantiated detail (detail) Modul=
e: Loaded System  unix: cache =3D no  unix: passwd =3D &quo=
t;(null)"  unix: shadow =3D "(null)"
  unix: group =3D "(null)"  unix: radwtmp =3D &qu=
ot;/usr/local/var/log/radius/radwtmp"  unix: usegroup =3D no<b=
r> unix: cache_reload =3D 600 Module: Instantiated unix (unix) M=
odule: Loaded radutmp 
 radutmp: filename =3D "/usr/local/var/log/radius/radutmp"<b=
r> radutmp: username =3D "%{User-Name}"  radutmp: ca=
se_sensitive =3D yes  radutmp: check_with_nas =3D yes  radu=
tmp: perm =3D 384  radutmp: callerid =3D yes
 Module: Instantiated radutmp (radutmp) Module: Loaded eap  e=
ap: default_eap_type =3D "md5"  eap: timer_expire =3D 60<=
br> eap: ignore_unknown_eap_types =3D no  eap: cisco_accountin=
g_username_bug =3D no 
rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized=
type leap  gtc: challenge =3D "Password: "  gtc:=
auth_type =3D "PAP" rlm_eap: Loaded and initialized type gtc<=
br> mschapv2: with_ntdomain_hack =3D no
 rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated e=
ap (eap) Listening on authentication *:1812 Listening on accounting *=
:1813 Ready to process requests. Is anything wrong?   =
 
<div>2007/1/29, <a href=3D"mailto:A.L.M.Buxey@l=
boro.ac.uk">A.L.M.Buxey@lboro.ac.uk</a> <<a href=3D"mailto:A.L.M.Buxey@l=
boro.ac.uk">A.L.M.Buxey@lboro.ac.uk</a>>:<blockquote class=3D"gma=
il_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0=
pt 0pt 0.8ex; padding-left: 1ex;">
Hi, >   3.Edit radiusd.conf and sql.conf; > =
  Debug Result: >   Nothing to do.  Sleeping=
until we see a request. no. thats not the debug result. you&#39=
;ve edited all the lines before that output.
 alan - List info/subscribe/unsubscribe? See <a href=3D"http:/=
/www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.h=
tml</a> </blockquote></div> 

------=_Part_67755_4523449.1170033787632--

--===============0898726146==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode