<font size="4">Thanks a lot!<br> I dont know why Freeradius and MySQL suddenly works after I did the following step.</font><br><span style="font-weight: bold;">1 </span> insert into radgroupreply (groupname,attribute,op,values) values ('user'£¬'Auth-Type',':=','Local');
<br>¡¡¡¡insert into radgroupreply (groupname,attribute,op,values) values ('user'£¬'Service-Type',':=','Framed-User'); <br>¡¡¡¡insert into radgroupreply (groupname,attribute,op,values) values ('user'£¬'Framed-IP-Address',':=','
<a href="http://255.255.255.254">255.255.255.254</a>'); <br>¡¡¡¡insert into radgroupreply (groupname,attribute,op,values) values ('user'£¬'Framed-IP-Netmask',':=','<a href="http://255.255.255.0">
255.255.255.0</a>'); <br>insert into radcheck (username,attribute,op,value) values ('test','User-Password',':=','test') £»<br>insert into usergroup (username,groupname) values ('test','user');
<br><br><span style="font-weight: bold;">2 </span>change the setting of sql.conf<br> server = "localhost" => server = "202.117.X.X"<br><span style="font-weight: bold;">3</span> # cp /home/ygx/mysql-
standard-5.0.20-linux-i686/support-files/my-medium.cnf /etc/my.cnf <br><span style="font-weight: bold;">4</span> # /home/ygx/mysql-standard-5.0.20-linux-i686/bin/safe_mysqld --user = root<br><span style="font-weight: bold;">
5</span> # radiusd -X<br><span style="font-weight: bold;">6 </span>#radtest test teset localhost 0 testing123 <br><br>It seems Freeradius and MySQL<font size="4"> works</font> as follow:<br>[root@nic219 freeradius-1.0.5]# radtest test test localhost 0 testing123
<br>Sending Access-Request of id 211 to <a href="http://127.0.0.1:1812">127.0.0.1:1812</a><br> User-Name = "test"<br> User-Password = "test"<br> NAS-IP-Address = nic219<br> NAS-Port = 0
<br>rad_recv: <span style="font-weight: bold;">Access-Accept</span> packet from host <a href="http://127.0.0.1:1812">127.0.0.1:1812</a>, id=211, length=38<br> Service-Type = Framed-User<br> Framed-IP-Address =
<a href="http://255.255.255.254">255.255.255.254</a><br> Framed-IP-Netmask = <a href="http://255.255.255.0">255.255.255.0</a><br>And I use NTRadping on a XP machine , it returns correctly.<br> <br>But i <span style="font-weight: bold;">
couldn't</span> use " mysql -u root -p rootpass" to enter the command line enviroment any longer. The output is :ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Seems strange,isnt? Anyway, I might better re-install Mysql.
<br><br> Thanks again!<br><br><br><br><br><br><div><span class="gmail_quote">2007/1/29, satish patel <<a href="mailto:linuxtrap@yahoo.co.in">linuxtrap@yahoo.co.in</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
this is problem of mysql configuration check /etc/my.cnf file for socket path and check your mysql working ??? or some mysql put mysql.sock file in /tmp/mysql.sock so plz check where your sock file in your env ? <br><br>install mysql again and try it
<div><span class="e" id="q_1106c740b422482a_1"><br><br><b><i>Edvin Seferovic <<a href="mailto:edvin.seferovic@kolp.at" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">edvin.seferovic@kolp.at</a>>
</i></b> wrote:</span></div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <div><div><span class="e" id="q_1106c740b422482a_3"> <div> <div><font face="Times New Roman" size="3">
<span style="font-size: 12pt;" lang="EN-GB">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></font><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 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></div> <div><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB"> </span></font></div> <div><font color="navy" face="Arial" size="2">
<span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB">Regards,</span></font></div> <div><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB">
</span></font></div> <div><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB">E:S</span></font></div> </div> <div><font face="Times New Roman" size="3">
<span style="font-size: 12pt;" lang="EN-GB"> </span></font></div></span></div> </div> - <span class="q"><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></span></blockquote>
<span class="ad"><br><p>
</p><hr size="1">
Here's a new way to find what you're looking for - <a href="http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Yahoo! Answers
</a>
<p></p></span><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>