<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<span class="Apple-style-span" style="font-family: Tahoma, Verdana, Arial, sans-serif; color: rgb(68, 68, 68); ">hi<br>i installed mysql.<br><br>and i modify <span class="ecxsystem">in /etc/freeradius/sql.conf</span>:<br>readclients=yes<br><br>also, i decommented in <span class="ecxsystem">/etc/freeradius/radiusd.conf:<br>accounting<br>{....<br>sql}<br>authorize<br>{...<br>sql}<br><br>i run again freeradius -X:<br>but it seems failed because of sql: this is the output<br>[...]<br> sql: postauth_query = "INSERT into radpostauth (user, pass, reply, date) values ('%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())"<br> sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked<br>rlm_sql (sql): Attempting to connect to root@localhost:/radius<br>rlm_sql (sql): starting 0<br>rlm_sql (sql): Attempting to connect rlm_s!
ql_mysql #0<br>rlm_sql_mysql: Starting connect to MySQL server for #0<br>rlm_sql_mysql: Couldn't connect socket to MySQL server r! oot@localhost:radius<br>rlm_sql_mysql: Mysql error 'Access denied for user 'root'@'localhost' (using password: YES)'<br># but i check it and it's ok i have in sql.conf: sql{server = "localhost"<br> login = "root"<br> password = "rootpass"}<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>#but i begin with installing </span>mysql-server and i add a user in the database<br><span class="ecxsystem">rlm_sql (sql): - generate_sql_clients<br>rlm_sql (sql): Query: SELECT * FROM nas<br>rlm_sql (sql): Ignoring unconnected handle 4..<br>rlm_sql (sql): Ignoring unconnected handle 3..<br>rlm_sql (sql): Ignoring unconnected handle 2..<br>rlm_sql (s!
ql): Ignoring unconnected handle 1..<br>rlm_sql (sql): Ignoring unconn
ected handle 0..<br>rlm_sql (sql): There are no DB handles to use! sk! ipped 5, tried to connect 0<br>rlm_sql (sql): generate_sql_clients() r eturned error<br>rlm_sql (sql): Closing sqlsocket 4<br>rlm_sql (sql): Closing sqlsocket 3<br>rlm_sql (sql): Closing sqlsocket 2<br>rlm_sql (sql): Closing sqlsocket 1<br>rlm_sql (sql): Closing sqlsocket 0<br>radiusd.conf[14]: sql: Module instantiation failed. <br>radiusd.conf[1860] Unknown module "sql".<br>radiusd.conf[1789] Failed to parse authorize section. </span></span> <br /><hr />Hotmail: Trusted email with Microsoft’s powerful SPAM protection. <a href='https://signup.live.com/signup.aspx?id=60969' target='_new'>Sign up now.</a></body>
</html>