I think the black and white on the green connector are a bit of a red herring at the moment. If the camera worked at one time, they have nothing to do with your problem, nobody snuck up to your camera and pulled a pair out and stuck it on that connector.
Looks like you have Ethernet and power Siamese cable as other have pointed out.
As Pounce pointed out it kind of looks like all your pairs are in the connector, although hard to say for sure from the picture.
Your test is indicating possible issues on 3 of the conductors. That’s your issue.
Need to inspect the connectors closely. If this is a direct cable to the rack, then inspect both ends, of it hits a patch panel or anything along the way, need to inspect connections there.
Could also be a damaged cable somewhere along the way, behind the wall or in the attic. Contrary to popular belief, if a cable tests fine when it’s installed, doesn’t mean it can’t fail later if it’s poorly installed... catches on a nail, catching on a truss plate, pulled with too much force, installer nicking conductors when stripping insulation. Wire expands and contracts over time.