<div dir="ltr">Answer my own question, it's in the dialup.conf<div><br></div><div>root@chronos:~# vim /etc/freeradius/sql/mysql/dialup.conf<br></div><div><br></div><div style>Uncomment this line;</div><div><div>sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"<br>
</div><div><br></div><div><br></div><div><br></div><div> #######################################################################</div><div> # Query config: Username</div><div> #######################################################################</div>
<div> # This is the username that will get substituted, escaped, and added</div><div> # as attribute 'SQL-User-Name'. '%{SQL-User-Name}' should be used below</div><div> # everywhere a username substitution is needed so you you can be sure</div>
<div> # the username passed from the client is escaped properly.</div><div> #</div><div> # Uncomment the next line, if you want the sql_user_name to mean:</div><div> #</div><div> # Use Stripped-User-Name, if it's there.</div>
<div> # Else use User-Name, if it's there,</div><div> # Else use hard-coded string "DEFAULT" as the user name.</div><div> sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"</div>
<div> #</div><div> sql_user_name = "%{User-Name}"</div><div><br></div></div><div><br></div><div style>Thanks me :)</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jun 10, 2013 at 9:20 AM, Ross <span dir="ltr"><<a href="mailto:ross@rosslisa.net" target="_blank">ross@rosslisa.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5"><p dir="ltr"><br>
On 09/06/2013 11:01 PM, "Alan DeKok" <<a href="mailto:aland@deployingradius.com" target="_blank">aland@deployingradius.com</a>> wrote:<br>
><br>
> geebs wrote:<br>
> > I don't recall having to setup a realm in previous installs.<br>
><br>
> You always had to set up a realm in previous installs.<br>
><br>
> Alan DeKok.<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></p>
</div></div><p dir="ltr">Ok, so where do I setup the realm and then strip the realm? I'm using mysql.<br>
Some assistance would be greatly appreciated :)</p>
</blockquote></div><br></div>