DB9
---
   
       plug                 DB9
    MISO (1)   ------------- 8 (Green)
       V   (2) ------------- no connection (Blue)
 --  SCK (3)   --- cable --- 4 (Purple)
 -- MOSI   (4) - direction - 3 (Grey)
   RESET (5)   ------------- 7 (White)
     GND   (6) ------------- 5 (Black)

   plug         5 4 1 3   6        
         DCD  Rx  Tx DTR GND
           DSR RTS CTS  RI
   DB9    1   2   3   4   5
   DB9      6   7   8   9

----------------
   
RS232
   serial header plug <-> DB9F cable (wire side view):
   
      plug                 DB9
    GND (1)   ------------- 5
 -- DTR   (2) --- cable --- 4
 --  Tx (3)   - direction - 3
     Rx   (4) ------------- 2

   plug      4   3   2   1
        DCD  Rx  Tx DTR GND
          DSR RTS CTS  RI
   DB9   1   2   3   4   5
   DB9     6   7   8   9