<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Sorry , i thought i had attached the radiusd -X report.........<p> <p> <p> <p> <p>rad_recv: Access-Request packet from host 192.168.1.150 port 56916, id=97, length=123<br> User-Name = "<a href="mailto:username@realm">username@realm</a>"<br> Acct-Session-Id = "1340979220W15beb"<br> NAS-Port = 0<br> Calling-Station-Id = "1115551212"<br> NAS-Identifier = "192.168.1.150"<br> User-Password = "1234567"<br> Message-Authenticator = 0x5b68c4b10cdd7a5dc3cf1d01361e6d24<br># Executing section authorize from file /etc/raddb/sites-enabled/default<br>+- entering group authorize {...}<br>++[preprocess] returns ok<br>++[chap] returns noop<br>++[mschap] returns noop<br>[suffix] Looking up realm "realm" for User-Name = "<a href="mailto:username@realm">username@realm</a>"<br>[suffix] No such realm "realm"<br>++[suffix] returns noop<br>[eap] No EAP-Message, not doing EAP<br>++[eap] returns noop<br>[sql] expand: %{User-Name} -> <a href="mailto:username@realm">username@realm</a><br>[sql] sql_set_user escaped user --> <a href="mailto:'username@realm'">'username@realm'</a><br>rlm_sql (sql): Reserving sql socket id: 1<br>[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = <a href="mailto:'username@realm'">'username@realm'</a> ORDER BY id<br>[sql] User found in radcheck table<br>[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = <a href="mailto:'username@realm'">'username@realm'</a> ORDER BY id<br>[sql] expand: SELECT groupname FROM usergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM usergroup WHERE username = <a href="mailto:'username@realm'">'username@realm'</a> ORDER BY priority<br>[sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'MyGroup' ORDER BY id<br>[sql] User found in group MyGroup<br>[sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'MyGroup' ORDER BY id<br>rlm_sql (sql): Released sql socket id: 1<br>++[sql] returns ok<br>++[expiration] returns noop<br>++[logintime] returns noop<br>++[pap] returns updated<br>Found Auth-Type = PAP<br># Executing group from file /etc/raddb/sites-enabled/default<br>+- entering group PAP {...}<br>[pap] login attempt with password "1234567"<br>[pap] Using clear text password "1234567"<br>[pap] User authenticated successfully<br>++[pap] returns ok<br># Executing section post-auth from file /etc/raddb/sites-enabled/default<br>+- entering group post-auth {...}<br>[sql] expand: %{User-Name} -> <a href="mailto:username@realm">username@realm</a><br>[sql] sql_set_user escaped user --> <a href="mailto:'username@realm'">'username@realm'</a><br>[sql] expand: %{User-Password} -> 1234567<br>[sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( <a href="mailto:'username@realm'">'username@realm'</a>, '1234567', 'Access-Accept', '2012-06-29 15:13:08')<br>rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( <a href="mailto:'username@realm'">'username@realm'</a>, '1234567', 'Access-Accept', '2012-06-29 15:13:08')<br>rlm_sql (sql): Reserving sql socket id: 0<br>rlm_sql (sql): Released sql socket id: 0<br>++[sql] returns ok<br>++[exec] returns noop<br>Sending Access-Accept of id 97 to 192.168.1.150 port 56916<br>Finished request 1.<br>Going to the next request<br>Waking up in 4.9 seconds.<p> <p> <p> <p> <p> <p> <p> <div><div id="SkyDrivePlaceholder"></div>> Date: Fri, 29 Jun 2012 20:57:50 +0700<br>> Subject: Re: FreeRADIUS SQl Ippool problem -<br>> From: list@fajar.net<br>> To: djtaz@iol.ie; freeradius-users@lists.freeradius.org<br>> <br>> On Fri, Jun 29, 2012 at 8:46 PM, Taz Manian <djtazie@hotmail.com> wrote:<br>> > But the username isnt the problem, that authenticates properly and if i put<br>> > in<br>> <br>> You should fix that. There might be a compatibility code that allows<br>> it to work today, but the next versions might not have it.<br>> <br>> > I get no info back for the pools at all when i do a radiusd -X<br>> <br>> And the debug log says ... what?<br>> <br>> If you think you can solve it by yourself so that you don't need to<br>> send the output to this list, then don't bother asking here. Seriusly.<br>> <br>> In any case, the debug log SHOULD tell you whether it runs<br>> sqlipool-related queries. If so, then try running those queries<br>> manually, see if the result is indeed what you expect them to be.<br>> <br>> If it DOESN'T run sqlipool-related queries, then your problem is<br>> elsewhere. Probably because your setup DOESN'T read radgroupcheck by<br>> default (yes, it can be that way, if you configure it to do so). In<br>> that case moving Pool-Name to radcheck should be an easy way to test.<br>> <br>> -- <br>> Fajar<br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></div> </div></body>
</html>