I finally got my serial port setup correctly.

to all.
Here's my setup:
1. RJ45 to DB9 modular adapter
2. 3-wire power cable cut and connected the RJ45 to other end using the tree wires only (slot 2,3 and 5) according to the serial port pinout listed in this thread (1->2, 3->3,2->5)
The RJ45 modular adapter was setup as a standard DB9 (minus the 9th pin). According to the included pinout:
1 Blue
2 Orange
3 Black
4 Red
5 Green
6 Yellow
7 Brown
8 White
This setup was cheaper for me to build because the serial cable was $6.99 then this cost 2.99 for the adapter and 1.99 for the power cable (save $2 LOL). Also, I did not have a way to figure out which wire was attached to which pin in the serial cable. The modular adapter you set it up according to your needs. The hardest thing I had to do was shave the power cable wires down to fit the RJ45 slots.