Rodney asks John to be the one to give his memorial, is the first person he runs to to tell about his proposal, gives out his passwords to him...I don't need a tin hat to know that in canon these are two guys that are best friends and love each other, the only thing that diverts from fanon is the lack of pants. :)