Hi rAm, Yes, it's installed. As I mentioned, it works fine if I run the service using
#python web2py.py but it doesn't work if the service is running on ngnix+fcgi +fcgihandler.py Thank you! Regards, Zhe On Aug 5, 1:52 pm, Ramjee Ganti <[email protected]> wrote: > Hi Zhe, > > When you start web2py do you see a message like this: (I use python > web2py.py at command line) > Database Drivers Available: SQLite3, MySQL > > if you don't see MySQL, it means the python driver to connect to MySQL is > not available. You need to download it for the version of python you are > running:http://sourceforge.net/projects/mysql-python. Check the DAL > documentation:http://web2py.com/book/default/chapter/06#The-Database-Abstraction-Layer > > Thanks, > rAm > > i Think, i Wait, i Fast -- Siddharthahttp://sodidi.ramjeeganti.com > > > > On Thu, Aug 5, 2010 at 5:08 PM, Zhe Li <[email protected]> wrote: > > Hi, > > > I am using ngnix+fcgi with web2py. Just today I switched the database > > from SQLite to MySQL. But it seems web2py failed to connect to mysql > > if using fcgi+ngnix. Launch it by "python web2py.py" works fine. > > > The error looks like this: > > > Error traceback > > Traceback (most recent call last): > > File "/home/zhe/web2py/gluon/restricted.py", line 178, in restricted > > exec ccode in environment > > File "/home/zhe/web2py/applications/init/models/db.py", line 16, in > > <module> > > db = DAL('mysql://web2py:lindge1...@localhost/lab') > > File "/home/zhe/web2py/gluon/sql.py", line 3887, in DAL > > raise RuntimeError, "Failure to connect to DB. Tried 5 times" > > RuntimeError: Failure to connect to DB. Tried 5 times > > > Could anyone tell me what to do? Thanks! > > > Cheers, > > Zhe
