I had a problem where when I was trying to pair my wireless PS3 controller, and it said to plug it in to usb, it wouldn’t detect it. Finally tried other usb adapters and found 1 of the 4 I had finally showed up.
So, maybe you’re having a problem with the cable. Does the command lsusb show the ps3 controller when plugged in?
