On 28 Jan 2015, at 08:06, Robert Graham <robert_graham@uhaul.com> wrote:
We were able to get the output of the salt in hex form, but getting it to concatenate is a whole other problem. When I do research on the web and tried all possible examples of the query, still would not give me the information that I need.
If I have a column that has the hashed password and a column that has a salt that is in hexfomat... how would the
update control { SSHA2-512-Password =: "0x%{sql:SELECT what is the proper context to concatenate the hashed pw in hex and the salt in hex
If it's easier you can do it in two queries, but it's less efficient. i.e. update control { Tmp-String-0 := "%{sql:SELECT hash FROM <table> WHERE <clause>}" Tmp-String-1 := "%{sql:SELECT salt FROM <table> WHERE <clause>}" } update control { SSHA2-512-Password := "0x%{control:Tmp-String-0}%{control:Tmp-String-1}" } -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2