Ssha512 value

Arran Cudbard-Bell a.cudbardb at
Wed Jan 28 03:13:07 CET 2015

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


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 Cudbard-Bell <a.cudbardb at>
FreeRADIUS development team

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

More information about the Freeradius-Users mailing list