freeradius & mysql

Hello!

I have problem with connecting to MysSQL server from radius. Versions are: freeradius-1.0.4-1.FC4.1 mysql-server-4.1.11-2

service radiusd restart gets this:

Fri Feb 10 17:06:17 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Fri Feb 10 17:06:17 2006 : Info: rlmexec: Wait=yes but no output defined. Did you mean output=none? Fri Feb 10 17:06:17 2006 : Info: rlmsql (sql): Driver rlmsqlmysql (module rlmsqlmysql) loaded and linked Fri Feb 10 17:06:17 2006 : Info: rlmsql (sql): Attempting to connect Fri Feb 10 17:06:17 2006 : Info: rlmsqlmysql: Starting connect to MySQL server for #0 Fri Feb 10 17:06:17 2006 : Error: rlmsqlmysql: Couldn't connect Fri Feb 10 17:06:17 2006 : Error: rlmsqlmysql: Mysql error 'Can't connect to local MySQL server through socket '-var-lib-my sql-mysql.sock' (13)' Fri Feb 10 17:06:17 2006 : Error: rlmsql (sql): Failed to connect DB handle #0 Fri Feb 10 17:06:17 2006 : Info: Ready to process requests.

But i connect from console mysql -u netams -p normally.

radiusd -x connect to mysql too:

Starting - reading configuration files ... rereadconfig: reading radiusd.conf Config: including file:etc-raddb-proxy.conf Config: including file:etc-raddb-clients.conf Config: including file:etc-raddb-snmp.conf Config: including file:etc-raddb-eap.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: hostnamelookups = no main: maxrequesttime = 30 main: cleanupdelay = 5 main: maxrequests = 1024 main: deleteblockedrequests = 0 main: port = 0 main: allowcoredumps = no main: logstrippednames = no main: logfile = "-var-log-radius-radius.log" main: logauth = no main: logauthbadpbutt = no main: logauthgoodpbutt = no main: pidfile = "-var-run-radiusd-radiusd.pid" main: user = "radiusd" main: group = "radiusd" main: usercollide = no main: loweruser = "no" main: lowerpbutt = "no" main: nospaceuser = "no" main: nospacepbutt = "no" main: checkrad = "-usr-sbin-checkrad" main: proxyrequests = yes proxy: retrydelay = 5 proxy: retrycount = 3 proxy: synchronous = no proxy: defaultfallback = yes proxy: deadtime = 120 proxy: postproxyauthorize = yes proxy: wakeallifalldead = no security: maxattributes = 200 security: rejectdelay = 1 security: statusserver = no main: debuglevel = 0 readconfigfiles: reading dictionary readconfigfiles: reading naslist Using deprecated naslist file. Support for this will go away soon. readconfigfiles: reading clients readconfigfiles: reading realms radiusd: entering modules setup Module: Library search path isusr-lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: inputpairs = "request" exec: outputpairs = "(null)" exec: packettype = "(null)" rlmexec: 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: encryptionscheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: usemppe = yes mschap: requireencryption = no mschap: requirestrong = no mschap: withntdomainhack = no mschap: pbuttwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlmauth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: pbuttwd = "(null)" unix: shadow = "-etc-shadow" unix: group = "(null)" unix: radwtmp = "-var-log-radius-radwtmp" unix: usegroup = no unix: cachereload = 600 Module: Instantiated unix (unix) Module: Loaded preprocess preprocess: huntgroups = "-etc-raddb-huntgroups" preprocess: hints = "-etc-raddb-hints" preprocess: withascendhack = no preprocess: ascendchannelsperline = 23 preprocess: withntdomainhack = no preprocess: withspecialixjetstreamhack = no preprocess: withciscovsahack = 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 (authlog) Module: Loaded realm realm: format = "suffix" realm: ignoredefault = no realm: ignorenull = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "-etc-raddb-users" files: acctusersfile = "-etc-raddb-acctusers" files: preproxyusersfile = "-etc-raddb-preproxyusers" files: compat = "no" Module: Instantiated files (files) Module: Loaded SQL sql: driver = "rlmsqlmysql" sql: server = "localhost" sql: port = sql: login = "netams" sql: pbuttword = "lovexx" sql: radiusdb = "netams" sql: accttable = "radacct" sql: accttable2 = "radacct" sql: authchecktable = "radcheck" sql: authreplytable = "radreply" sql: groupchecktable = "radgroupcheck" sql: groupreplytable = "radgroupreply" sql: usergrouptable = "usergroup" sql: nastable = "nas" sql: dicttable = "dictionary" sql: sqltrace = yes sql: sqltracefile = "-var-log-radius-sqltrace.sql" sql: readclients = no sql: deletestalesessions = yes sql: numsqlsocks = 5 sql: sqlusername = "%{User-Name}" sql: defaultuserprofile = sql: queryonnotfound = no sql: authorizecheckquery = "SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER" sql: authorizereplyquery = "SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER" sql: authorizegroupcheckquery = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.V" sql: authorizegroupreplyquery = "SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.V" sql: accountingonoffquery = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unixtimestamp('%S') - unixtimestamp(" sql: accountingupdatequery = "UPDATE radacct ? SET FramedIPAddress = '%{Framed-IP-Address}', ? AcctSessionTime = '%{Acct-" sql: accountingupdatequeryalt = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPor" sql: accountingstartquery = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, " sql: accountingstartqueryalt = "UPDATE radacct SET AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectI" sql: accountingstopquery = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOc" sql: accountingstopqueryalt = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortI" sql: groupmembershipquery = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'" sql: connectfailureretrydelay = 60 sql: simulcountquery = sql: simulverifyquery = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStat" sql: postauthtable = "radpostauth" sql: postauthquery = "INSERT into radpostauth (id, user, pbutt, reply, date) values ('', '%{User-Name}', '%{User-Pbuttword:-" sql: safe-characters = rlmsql (sql): Driver rlmsqlmysql (module rlmsqlmysql) loaded and linked rlmsql (sql): starting 0 rlmsql (sql): Attempting to connect rlmsqlmysql #0 rlmsqlmysql: Starting connect to MySQL server for #0 rlmsql (sql): Connected new DB handle, #0 rlmsql (sql): starting 1 rlmsql (sql): Attempting to connect rlmsqlmysql #1 rlmsqlmysql: Starting connect to MySQL server for #1 rlmsql (sql): Connected new DB handle, #1 rlmsql (sql): starting 2 rlmsql (sql): Attempting to connect rlmsqlmysql #2 rlmsqlmysql: Starting connect to MySQL server for #2 rlmsql (sql): Connected new DB handle, #2 rlmsql (sql): starting 3 rlmsql (sql): Attempting to connect rlmsqlmysql #3 rlmsqlmysql: Starting connect to MySQL server for #3 rlmsql (sql): Connected new DB handle, #3 rlmsql (sql): starting 4 rlmsql (sql): Attempting to connect rlmsqlmysql #4 rlmsqlmysql: Starting connect to MySQL server for #4 rlmsql (sql): Connected new DB handle, #4 Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acctunique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" Module: Instantiated acctunique (acctunique) Module: Loaded radutmp radutmp: filename = "-var-log-radius-radutmp" radutmp: username = "%{User-Name}" radutmp: casesensitive = yes radutmp: checkwithnas = yes radutmp: perm = 384 radutmp: callerid = yes Module: Instantiated radutmp (radutmp) Module: Loaded eap eap: defaulteaptype = "md5" eap: timerexpire = 60 eap: ignoreunknowneaptypes = no eap: ciscoaccountingusernamebug = no rlmeap: Loaded and initialized type md5 rlmeap: Loaded and initialized type leap gtc: challenge = "Pbuttword: " gtc: authtype = "PAP" rlmeap: Loaded and initialized type gtc mschapv2: withntdomainhack = no rlmeap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) detail: detailfile = "-var-log-radius-radacct-%{Client-IP-Address}-reply-detail-%Y%m%d" detail: detailperm = 384 detail: dirperm = 493 detail: locking = no Module: Instantiated detail (replylog) Listening on authentication *:1812 Listening on accounting *:1813 Listening on proxy *:1814 Ready to process requests.

Problem only then service radiusd start. =

Can anybody help me in this trouble?