list manipulation - Generating Tuples with restrictions

I am interested in a certain subset of all tuples. Generating all with Tuples and then filtering is wasteful, and will "blow up" very quickly.

For a concrete example, let's say I want to find all 8-tuples of {1,2,3,4,5} such that: the ordering does not matter, i.e. {1,2,3,4,5} is the same as {5,4,3,2,1}; the sum of all elements is constrained, say 24; the sum of squares is constrained, say 86. I can do it like this.

candidates = Tuples[Range[5], 8];


candidates = Sort /@ candidates;

candidates = DeleteDuplicates@candidates;

f[x_] := If[Total[x] == 24, x, 0 ];

candidates = DeleteCases[f /@ candidates, 0];

g[x_] := If[Total[x^2] == 86, x, 0 ];


candidates = DeleteCases[g /@ candidates, 0];

Starting from 5^8 elements generated by Tuples, the final step leaves me with just 5 elements. Even if I could just directly generate the different combinations without reorderings that would already be a huge improvement (495 elements in this particular case). I should emphasize that repetition of the same number is allowed.

EDIT

Thanks for all who have answered so far. I was able to find a fast way for larger lists by modifying the answer by Kuba. The basic idea is to still use IntegerPartitions but enforce the sum of squares rather than the sum of elements and then filtering with Select. The code that can do this is below.

rN = 8;
rD = 24;
rA = 86;
dmin = 1;
dmax = 5;


candidates = 
Round@Sqrt[
 Select[
  Developer`ToPackedArray[
   IntegerPartitions[rA,{rN},Range[dmin,dmax]^2],
  Complex],
 Total[Sqrt[#]] == rD&]
];

In the code above, packed array coercion is used to speed up the Sqrt and Round is used on the result to get rid of the auxiliary imaginary part. While this appears to be the fastest approach at least for now, the answer by qwr is more memory efficient, based on values given by MaxMemoryUsed[].

For a power test, I used rN=40, rD=188, rA=1020, dmin=1 and dmax=9, with the code above doing the job in 3 seconds while the answer by qwr took 4.3 seconds. On the other hand, MaxMemoryUsed[] gave a result almost 5 times bigger with the fast code than with the answer by qwr.

Answer

Select[
 IntegerPartitions[24, {8}, Range[5]],
 #.# == 86 &
]

{{5, 5, 4, 2, 2, 2, 2, 2}, {5, 5, 3, 3, 3, 2, 2, 1}, 

{5, 4, 4, 4, 2, 2, 2, 1}, {5, 4, 4, 3, 3, 3, 1, 1}, {4, 4, 4, 4, 4, 2, 1, 1}}

---

Slightly more general approach (in case where IntegerPartitions is not what we need):

ClearAll[ar, a];
ar = Array[a, 8]

ar /. Solve[Flatten@{
     Tr[ar] == 24,
     ar.ar == 86,

     Thread[1 <= ar <= 5],
     LessEqual @@ ar (* this part takes care about
                        droping equivalent permutations*)
     },
     ar,
     Integers
] 

{{1, 1, 2, 4, 4, 4, 4, 4}, {1, 1, 3, 3, 3, 4, 4, 5}, 

 {1, 2, 2, 2, 4, 4, 4, 5}, {1, 2, 2, 3, 3, 3, 5, 5}, {2, 2, 2, 2, 2, 4, 5, 5}}