Thank you! Ross! The problem was mysql URL. It was different from application URL(= web2py-codingday.rhcloud.com).
Now connection to mysql is OK. But still there is HTTP 500 error with default welcome application... I should spend more to know why. 2012년 5월 15일 화요일 오후 8시 51분 26초 UTC+9, Ross Peoples 님의 말: > > I don't know anything about openshift, but I would think the normal MySQL > troubleshooting steps apply: > > > 1. Make sure MySQL is listening on all interfaces > 2. Make sure your MySQL account accepts connections from the '%' host. > > > On Tuesday, May 15, 2012 3:55:07 AM UTC-4, JungHyun Kim wrote: >> >> Hello. I'm now trying to use redhat openshift. >> >> I am struggling access database - mysql-5.1 - which is set via openshift >> cartridge. >> I got admin user(admin), password and database name(we2py). >> So I modified database setting in models/db.py >> >> as >> >> db = DAL('mysql://admin:passw...@web2py-codingday.rhcloud.com/web2py') >> >> But web2py application can't connect to mysql. >> >> OperationalError: (2003, "Can't connect to MySQL server on ' >> web2py-codingday.rhcloud.com' (111)") >> >> I think I couldn't understand enough. I am a noob for both web2py and >> openshift. >> >> How can I make web2py connect to database right? >> >> Thank you. >> >> >>