We are facing same problem. What's the solution for this?
On Tuesday, March 15, 2011 8:38:19 PM UTC+5:30, Miguel wrote:
>
> Hello to all, I have created a new project using the web wizard, for
> some unknown reason the mysql connection is not working, this is the
> uri im using:
>
> mysql://cmts_monitor:cmtsTigoHome@localhost/cmts_monitor
>
> and this is the error i got:
>
> Traceback (most recent call last):
> File "/home/www-data/web2py/gluon/restricted.py", line 188, in
> restricted
> exec ccode in environment
> File "/home/www-data/web2py/applications/CMTS_Monitor/models/db.py",
> line 17, in <module>
> db = DAL('mysql://cmts_monitor:cmtsTigoHome@localhost/
> cmts_monitor') # if not, use SQLite or other DB
> File "/home/www-data/web2py/gluon/dal.py", line 3423, in __init__
> raise RuntimeError, "Failure to connect, tried 5 times:\n%s" %
> error
> RuntimeError: Failure to connect, tried 5 times:
> (2003, "Can't connect to MySQL server on 'localhost' (111)")
>
> i have tested the username/password combination in the command line,
> it works fine:
>
> mmiranda@appsrv01:/var/log/check_cmts$ mysql --user cmts_monitor --
> database cmts_monitor --host=localhost -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 20510
> Server version: 5.1.37-1ubuntu5.5 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql>
>
>
> What should i check?
> regards
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
