<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2>Use the socket method. If you don't know where the
socket file is try:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2>find / -name mysql.sock</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2>It will probably be in /tmp if it isn't in
/var/lib/mysql</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2>regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=212432105-29012007><FONT face=Arial
color=#0000ff size=2>Frank Ranner</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org
[mailto:freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org]
<B>On Behalf Of </B>yao guoxian<BR><B>Sent:</B> Monday, 29 January 2007
15:14<BR><B>To:</B> edvin.seferovic@kolp.at; FreeRadius users mailing
list<BR><B>Subject:</B> Re: Why Freeradius and Mysql dont
work?<BR></FONT><BR></DIV>
<DIV></DIV><FONT face="Times New Roman" size=3><SPAN lang=EN-GB
style="FONT-SIZE: 12pt"><SPAN class=q>Thanks again.<BR>
<FONT size=4>The file "/var/lib/mysql/mysql.sock" does not exist.When I use an
IP in sql.conf instead of the "localhost", I get the following
result:</FONT><BR><BR></SPAN></SPAN></FONT>rlm_sql (sql): Driver rlm_sql_mysql
(module rlm_sql_mysql) loaded and linked<BR>rlm_sql (sql): <FONT
size=4>Attempting to connect to root@202.117.X.X:/radius</FONT><BR>rlm_sql
(sql): starting 0<BR>rlm_sql (sql): Attempting to connect rlm_sql_mysql
#0<BR>rlm_sql_mysql: Starting connect to MySQL server for #0<BR>rlm_sql_mysql:
Couldn't connect socket to MySQL server
root@202.117.7.243:radius<BR>rlm_sql_mysql: Mysql error 'Host '<A
href="http://202.117.7.243">202.117.7.243</A>' is not allowed to connect to
this MySQL server'<BR>rlm_sql (sql): Failed to connect DB handle #0
<BR>rlm_sql (sql): starting 1<BR>rlm_sql (sql): starting 2<BR>rlm_sql (sql):
starting 3<BR>rlm_sql (sql): starting 4<BR>rlm_sql (sql): Failed to connect to
any SQL server.<BR>Module: Instantiated sql (sql)<BR><BR><BR><BR>
<DIV><SPAN class=gmail_quote>2007/1/29, Edvin Seferovic <<A
href="mailto:edvin.seferovic@kolp.at">edvin.seferovic@kolp.at</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV lang=DE vlink="blue" link="blue">
<DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN lang=EN-GB
style="FONT-SIZE: 12pt"><SPAN class=q>rlm_sql_mysql: Mysql error 'Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2)'<BR>rlm_sql (sql): <B><SPAN style="FONT-WEIGHT: bold">Failed to connect
DB handle #0 </SPAN></B><BR></SPAN></SPAN></FONT><SPAN class=q><FONT
size=4><SPAN lang=EN-GB style="FONT-SIZE: 13.5pt">rlm_sql (sql): Failed to
connect to any SQL server.</SPAN></FONT></SPAN><SPAN
lang=EN-GB><BR><BR><FONT color=navy><SPAN style="COLOR: navy">your socket
file is not in the place.. maybe you should use an IP in your sql.conf
instead of the "localhost" !</SPAN></FONT></SPAN></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">E:S</SPAN></FONT></P></DIV>
<P><FONT face="Times New Roman" size=3><SPAN lang=EN-GB
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></DIV><BR>-<BR>List
info/subscribe/unsubscribe? See <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://www.freeradius.org/list/users.html"
target=_blank>http://www.freeradius.org/list/users.html</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>