Ssha512 value

[Arran Cudbard-Bell]

> On 28 Jan 2015, at 08:06, Robert Graham <robert_graham at 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 at freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2