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