CODEWITHSUNDEEP
mysqlweb2py
Mert Nuhoglu
Mert Nuhoglu

Reputation: 10133

web2py doesn't connect to mysql

I installed web2py as source and wanted to use DAL without the rest of the framework.

But DAL does not connect to mysql:

>>> DAL('mysql://user1:user1@localhost/test_rma')
...
RuntimeError: Failure to connect, tried 5 times:
'NoneType' object has no attribute 'connect'

Whereas MySQLdb can connect to the database with the same credentials:

>>> import MySQLdb
>>> db = MySQLdb.connect(host='localhost', user='user1', passwd='user1', db='test_rma')

A similar problem with MsSQL was solved by explicitly setting the driver object. I tried the same solution:

>>> from gluon.dal import MySQLAdapter
>>> print MySQLAdapter.driver
None
>>> driver = globals().get('MySQLdb',None)
>>> print MySQLAdapter.driver
None

But still the driver is None.

Upvotes: 1

Views: 2864

Answers (1)

Mert Nuhoglu
Mert Nuhoglu

Reputation: 10133

Ok, I found the solution of the problem. I had to write:

MySQLAdapter.driver = globals().get('MySQLdb',None)

instead of 

driver = globals().get('MySQLdb',None)

I misread that line in the original question.

Upvotes: 2

Related Questions