Hey,
I am also getting the same error.
I am not able to telnet to localhost 3306. I've checked my.cnf and there is
a line "bind-address:127.0.0.1". I tried commenting it out, but error still
persisted. Can you help me here?
On Wednesday, March 16, 2011 1:51:31 AM UTC+5:30, Kevin Ivarsen wrote:
>
> Miguel,
>
> MySQL can communicate over either TCP or a named pipe. It's possible
> that your MySQL server is only listening on the named pipe. I could
> imagine that the mysql command line client would connect successfully
> over this channel, but Python would try to connect to the TCP socket
> and fail.
>
> Try telnetting to the local mysql port and see what happens:
>
> telnet localhost 3306
>
> If you get an error like "connection refused", then this is almost
> certainly the problem. Take a look at your mysql config file (/etc/
> mysql/my.cnf or similar) and look for the bind-address or skip-
> networking settings.
>
> Kevin
>
> On Mar 15, 11:08 am, Miguel <miguel.miran...@gmail.com> 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
--
