<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Fixedsys;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:"Times New Roman";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>Why is it that when I run a radiusd –X, I always come back with
errors on saying that it cannot connect to the mysql server:</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): Attempting to connect to radius@localhost:/radius</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): starting 0</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql_mysql: Starting connect to MySQL server for #0</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql_mysql: Couldn't connect socket to MySQL server radius@localhost:radius</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql_mysql: Mysql error 'Access denied for user 'radius'@'localhost'
(using password: YES)'</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): Failed to connect DB handle #0</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): starting 1</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): starting 2</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): starting 3</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): starting 4</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>rlm_sql (sql): Failed to connect to any SQL server.</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>I have put this in my sql.conf like so:</span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'># Connect info</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> server =
"localhost"</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> login =
"radius"</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> password =
"xxxxxxxxx"</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> # Database
table configuration</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Fixedsys><span
style='font-size:10.0pt;font-family:Fixedsys;color:navy'> radius_db =
"radius"<a href="mailto:atkinsd@uthscsa.edu"></a></span></font> </p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>What am I doing wrong? I have followed a number of whitepapers to
install this and most of them say the same thing. </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I downloaded freeradius and mysql-server using the ‘yum install’
option. Now, when I do a ./configure on freeradius, do I need to do it with a –with—mysql
option?</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Should I try this on something other than FC4? I am opened to options.</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
Thanks</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
Dwane</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>