The trick to doing it in tank is a combo approach. A combo of cyanoacrylate and a 2 part epoxy putty typically does the trick. The super glue does the initial hold and once the epoxy sets, that frag is going nowhere.
Combo I use is the BSI glue and the oceans wonder purple epoxy. But any brand/combo should do