Ok, first sorry for the delay in responding. I missed the updates on page 2!
The lights have been in and working for a few days now, but from the above and reading back through the comments, there still seems to be a potentially hazardous issue if connector 3 is separated while the circuit is live (in reality I'd always disable the circuit before disconnecting anyway, but guess others may not).
It seems:
Connector 1: All ok
Connector 2: All ok
Connector 3: Connectors are the wrong way round, mains cables the wrong way round (black connected to L1, red connected to N). Also the lighting side was previously wired incorrectly too, but since my recent work, that side is now correctly wired to the indicators on the terminal (but now doesn't match the mains side).
So to finish this job, I need to re-wire Connector 3 the other way round (and at the same time might as well replace it and secure the correct wires to the correct terminals!). Correct?
With regards to screwing the (mains) ends of the connectors to cabinets, there doesn't seem to be a hole in the connector to do this (or do I need to drill through the two recessed holes in front of the terminal connectors, and attach that way? I don't want end up with a screw made live, and going into the cupboard!
Ironically it's been a long time since I've used any other than removing some in a local village hall where the cables were simply chopped.
In that case just add some clips fairly close to the connectors.