I am assuming you are using trunk from github. Please download web2py stable from the web site. We are working on fixing that problem in the development version.
Massimo On Monday, 7 December 2015 06:41:31 UTC-6, yytry...@gmail.com wrote: > > 1.when i use the shell and submint db._uri ,db or anyother ,it display > none,the connect to db is problem? but i can add new record to the > table,why? 2.when i use > mysql to replace sqlite ,i grant all privieges on root in localhost and use > root to connect,it can't connect ,i always install pymysql and the > example.py is regular work That's Error ticket: > Traceback (most recent call last): > File "C:\Python27\web2py\gluon\restricted.py", line 227, in restricted > exec ccode in environment > File "C:/Python27/web2py/applications/images/models/db.py", line 1, in > <module> > db = DAL("mysql://root:mypassword@localhost/test") > File "C:\Python27\web2py\gluon\packages\dal\pydal\base.py", line 174, in > __call__ > obj = super(MetaDAL, cls).__call__(*args, **kwargs) > File "C:\Python27\web2py\gluon\packages\dal\pydal\base.py", line 459, in > __init__ > raise RuntimeError("Failure to connect, tried %d times:\n%s" % > (attempts, tb)) > RuntimeError: Failure to connect, tried 5 times: > Traceback (most recent call last): > File "C:\Python27\web2py\gluon\packages\dal\pydal\base.py", line 437, in > __init__ > self._adapter = ADAPTERS[self._dbname](**kwargs) > File "C:\Python27\web2py\gluon\packages\dal\pydal\adapters\base.py", > line 57, in __call__ > obj = super(AdapterMeta, cls).__call__(*args, **kwargs) > File "C:\Python27\web2py\gluon\packages\dal\pydal\adapters\mysql.py", > line 132, in __init__ > if do_connect: self.reconnect() > File "C:\Python27\web2py\gluon\packages\dal\pydal\connection.py", line > 104, in reconnect > self.connection = f() > File "C:\Python27\web2py\gluon\packages\dal\pydal\adapters\mysql.py", > line 130, in connector > return self.driver.connect(**driver_args) > File "MySQLdb/__init__.py", line 81, in Connect > File "MySQLdb/connections.py", line 193, in __init__ > OperationalError: (2003, "Can't connect to MySQL server on 'localhost' > (10061)") > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.