<div dir="ltr">Ok, I made that adjustment (thank you a lot, that makes more sense actually to put in post-proxy), but for some reason, I'm still not seeing any write entries to the database. Am I missing something? I see cache working, correctly I think...but no updates to the database (timestamps are the same on radcheck).<div>
<br></div><div><div>rlm_sql (sql): Released sql socket id: 4</div><div>[sql] User tester not found</div><div>++[sql] = notfound</div><div>++? if (notfound)</div><div>? Evaluating (notfound) -> TRUE</div><div>++? if (notfound) -> TRUE</div>
<div>++if (notfound) {</div><div>+++update control {</div><div>+++} # update control = noop</div><div>[cache] <span class="" style="white-space:pre"> </span>expand: %{User-Name} -> tester</div><div>+++[cache] = notfound</div>
<div>+++update control {</div><div>+++} # update control = noop</div><div>+++? if (!notfound)</div><div>? Evaluating !(notfound) -> TRUE</div><div>+++? if (!notfound) -> TRUE</div><div>+++if (!notfound) {</div><div>
++++update control {</div><div>++++} # update control = noop</div><div>+++} # if (!notfound) = noop</div><div>+++ ... skipping else for request 0: Preceding "if" was taken</div><div>++} # if (notfound) = noop</div>
<div>+} # group authorize = ok</div><div> WARNING: Empty pre-proxy section. Using default return values.</div><div>Sending Access-Request of id 95 to 192.168.1.35 port 1812</div><div><span class="" style="white-space:pre"> </span>User-Name = "tester"</div>
<div><span class="" style="white-space:pre"> </span>User-Password = "suckit"</div><div><span class="" style="white-space:pre"> </span>NAS-IP-Address = 192.168.1.136</div><div><span class="" style="white-space:pre"> </span>NAS-Port = 0</div>
<div><span class="" style="white-space:pre"> </span>Message-Authenticator = 0x00000000000000000000000000000000</div><div><span class="" style="white-space:pre"> </span>Proxy-State = 0x313331</div><div>Proxying request 0 to home server 192.168.1.35 port 1812</div>
<div>Sending Access-Request of id 95 to 192.168.1.35 port 1812</div><div><span class="" style="white-space:pre"> </span>User-Name = "tester"</div><div><span class="" style="white-space:pre"> </span>User-Password = "suckit"</div>
<div><span class="" style="white-space:pre"> </span>NAS-IP-Address = 192.168.1.136</div><div><span class="" style="white-space:pre"> </span>NAS-Port = 0</div><div><span class="" style="white-space:pre"> </span>Message-Authenticator = 0x00000000000000000000000000000000</div>
<div><span class="" style="white-space:pre"> </span>Proxy-State = 0x313331</div><div>Going to the next request</div><div>Waking up in 0.9 seconds.</div><div>rad_recv: Access-Accept packet from host 192.168.1.35 port 1812, id=95, length=25</div>
<div><span class="" style="white-space:pre"> </span>Proxy-State = 0x313331</div><div># Executing section post-proxy from file /etc/raddb/sites-enabled/default</div><div>+group post-proxy {</div><div>[eap] No pre-existing handler found</div>
<div>++[eap] = noop</div><div>[cache] <span class="" style="white-space:pre"> </span>expand: %{User-Name} -> tester</div><div>[cache] <span class="" style="white-space:pre"> </span>expand: reply:Reply-Message -> reply:Reply-Message</div>
<div>[cache] <span class="" style="white-space:pre"> </span>expand: Cache last updated at %t -> Cache last updated at Fri Jun 13 18:58:10 2014</div><div>[cache] <span class="" style="white-space:pre"> </span>expand: ssssssssssssssssssssssssssssssss -> ssssssssssssssssssssssssssssssss</div>
<div>[cache] <span class="" style="white-space:pre"> </span>expand: %{randstr:ssssssssssssssssssssssssssssssss} -> IwEpAi6ylyNZ8zQoYOtW2xjHN.h52sgi</div><div>rlm_cache: Adding entry for "tester", with TTL of 10</div>
<div>++[cache] = updated</div><div>+} # group post-proxy = updated</div><div>Found Auth-Type = Accept</div><div>Auth-Type = Accept, accepting the user</div><div># Executing section post-auth from file /etc/raddb/sites-enabled/default</div>
<div>+group post-auth {</div><div>++[exec] = noop</div><div>+} # group post-auth = noop</div><div>Sending Access-Accept of id 131 to 127.0.0.1 port 48539</div><div><span class="" style="white-space:pre"> </span>Reply-Message += "reply:Reply-Message"</div>
<div><span class="" style="white-space:pre"> </span>Reply-Message += "Cache last updated at Fri Jun 13 18:58:10 2014"</div><div><span class="" style="white-space:pre"> </span>Class := 0x49774570416936796c794e5a387a516f594f745732786a484e2e683532736769</div>
<div>Finished request 0.</div><div>Going to the next request</div><div>Waking up in 4.9 seconds.</div><div>Cleaning up request 0 ID 131 with timestamp +40</div><div>Ready to process requests.</div></div><div><br></div></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Jun 14, 2014 at 3:23 PM, Arran Cudbard-Bell <span dir="ltr"><<a href="mailto:a.cudbardb@freeradius.org" target="_blank">a.cudbardb@freeradius.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
On 14 Jun 2014, at 20:13, Arran Cudbard-Bell <<a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a>> wrote:<br>
<div class=""><br>
><br>
> On 14 Jun 2014, at 19:53, Brandon Jozsa <<a href="mailto:bjozsa@gmail.com">bjozsa@gmail.com</a>> wrote:<br>
><br>
>> Ok, so now that I have this working...rlm_cache is loading just fine, but I think I may be making an error (based on what I want to achieve anyway). I've taken information from the article <a href="http://wiki.freeradius.org/modules/Rlm_cache#Two-call-caching" target="_blank">http://wiki.freeradius.org/modules/Rlm_cache#Two-call-caching</a>, and i see the cache working, but is it in the wrong place?<br>
><br>
> Yes. The second call should go in Post-Proxy.<br>
<br>
</div>authorize {<br>
sql<br>
if (notfound) {<br>
<div class=""> update control {<br>
Cache-Status-Only = 'yes'<br>
}<br>
cache<br>
</div><div class=""> update control {<br>
Cache-Status-Only !* ANY<br>
}<br>
<br>
# Not found - Proxy request<br>
</div> if (!notfound) {<br>
update control {<br>
<div class=""> Proxy-To-Realm := <realm><br>
}<br>
}<br>
# Found - Merge proxy response<br>
else {<br>
cache<br>
}<br>
}<br>
}<br>
<br>
post-proxy {<br>
cache<br>
}<br>
<br>
Or 3rd call... v3.0.4 is simpler.<br>
<br>
</div>Arran Cudbard-Bell <<a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a>><br>
<div class="HOEnZb"><div class="h5">FreeRADIUS Development Team<br>
<br>
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2<br>
<br>
</div></div><br>-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Brandon<br>
</div>