Thanks!<br>The file "mysql.sock" is actually in /tmp/.<br><br>regards<br>Guoxian<br><br><div><span class="gmail_quote">2007/1/29, Ranner, Frank MR <<a href="mailto:Frank.Ranner@defence.gov.au">Frank.Ranner@defence.gov.au
</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">find / -name mysql.sock</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" 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><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">regards</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Frank Ranner</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
freeradius-users-bounces+frank.ranner=<a href="mailto:defence.gov.au@lists.freeradius.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">defence.gov.au@lists.freeradius.org</a>
[mailto:<a href="mailto:freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">freeradius-users-bounces+frank.ranner=defence.gov.au@lists.freeradius.org
</a>]
<b>On Behalf Of </b>yao guoxian<br><b>Sent:</b> Monday, 29 January 2007
15:14<br><b>To:</b> <a href="mailto:edvin.seferovic@kolp.at" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">edvin.seferovic@kolp.at</a>; 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 style="font-size: 12pt;" lang="EN-GB"><span>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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">edvin.seferovic@kolp.at</a>>:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="blue" link="blue" lang="DE">
<div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"><span>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><font size="4"><span style="font-size: 13.5pt;" lang="EN-GB">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 color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Regards,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">E:S</span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"></span></font> </p></div></div><br>-<br>List
info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.freeradius.org/list/users.html</a><br><br></blockquote>
</div><br></blockquote></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>