How does a guy who has not had a real relationship since 2004 and who has bipolar disorder, no job, few friends, is rather shy and socially awkward and who has little outlook on life find a girlfriend?

I've tried several dating sites and had a few "dates" with nice women but I never heard from them again after the first meeting. I'm tired of looking online for women. I'd rather meet them in person at a bar or cafe but being socially anxious and awkward I find that difficult.

I have a lot to learn, I guess.