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 [email protected].
For more options, visit https://groups.google.com/d/optout.
