Are you running web2py from source or the mac binary (the latter comes
with its own python and it would not see the mysqldb driver)
On May 18, 8:42 pm, Avik Basu <avikb...@gmail.com> wrote:
> Hello,
>
> I am having some trouble connecting to a MySQL server running on my
> local machine (Macbook Pro running Snow Leopard with My SQL 5.1.46).
> I use the following connection string:
>
> db = DAL('mysql://root:passw...@localhost/test', pool_size=10)
>
> and I get the following error:
>
> Traceback (most recent call last):
> File "gluon/restricted.py", line 178, in restricted
> File "/Applications/web2py.app/Contents/Resources/applications/
> FWv7_12/models/db.py", line 9, in <module>
> File "gluon/sql.py", line 3840, in DAL
> RuntimeError: Failure to connect to DB. Tried 5 times
>
> I do have the python-mysql driver properly installed. Also, I am able
> to connect to the database named 'test' both from the shell and using
> a third party MySQL app (Sequel Pro). There are no existing tables in
> the 'test' database to begin with. Any ideas why the connection may be
> failing?
>
> Avik
