Help please: my web2py application on gae no longer connect mysql
google cloud database. (it was working until a few days ago. no change in
configuration mysql instance neither console gae application.)
another application python on gae (not web2py) keek working with no problem.
log en console google app engine for my web2py application is:
DEBUG: connect attempt 4, connection error:
Traceback (most recent call last):
File
"/base/data/home/apps/s~mimetic-plate-536/63.382845407756969333/gluon/dal/base.py",
line 410, in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
File
"/base/data/home/apps/s~mimetic-plate-536/63.382845407756969333/gluon/dal/adapters/base.py",
line 47, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
File
"/base/data/home/apps/s~mimetic-plate-536/63.382845407756969333/gluon/dal/adapters/google.py",
line 51, in __init__
if do_connect: self.reconnect()
File
"/base/data/home/apps/s~mimetic-plate-536/63.382845407756969333/gluon/dal/connection.py",
line 92, in reconnect
self.connection = f()
File
"/base/data/home/apps/s~mimetic-plate-536/63.382845407756969333/gluon/dal/adapters/google.py",
line 49, in connector
return rdbms.connect(**driver_args)
File
"/base/data/home/runtimes/python27/python27_lib/versions/1/google/appengine/api/rdbms.py",
line 70, in connect
password=password)
File
"/base/data/home/runtimes/python27/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
line 813, in __init__
self.OpenConnection()
File
"/base/data/home/runtimes/python27/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
line 836, in OpenConnection
response = self.MakeRequest('OpenConnection', request)
File
"/base/data/home/runtimes/python27/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
line 947, in MakeRequest
raise _ToDbApiException(response.sql_exception)
OperationalError: (1045, u"Access denied for user 'root'@'localhost' (using
password: NO)")
MY db.py is:
if not request.env.web2py_runtime_gae:
db =
DAL('mysql://root:[email protected]/mydata',pool_size=1,check_reserved=['all'],migrate=False)
else:
db2 = DAL('google:datastore')
session.connect(request, response, db=db2)
db = DAL('google:sql://apiproyect:instance/mydb',migrate_enabled=False)
Help please. my web sites is shutdown.
my another python application on gae no web2py is working with no problem for
using:
_INSTANCE_NAME = 'apiproyect:instance'
db = MySQLdb.connect(unix_socket='/cloudsql/' + _INSTANCE_NAME, db='mydb',
user='root', passwd='xxxxxx')
--
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.
