I'm struggling to get a basic test app deployed to Google App Engine using
Cloud SQL.
1. I cloned web2py of github two days ago.
2. I created a Google Cloud SQL instance.
3. I created a new sample app called "SQL" using the web2py admin interface.
4. On the new app, I changed the following line in db.py
db = DAL('google:datastore+ndb')
to
db = DAL('google:sql://web2py-test-165504:my-sql-instance/mysql')
5. I deployed web2py to GAE:
gcloud app deploy --project web2py-test-165504
After deployment, I can view the Welcome app no problem, since it is using
Datastore. But when I go to my app called "SQL", I get an error.
Here is the traceback:
ERROR 2017-04-24 22:51:17,829 restricted.py:171] Traceback (most recent
call last):
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\restricted.py",
line 216, in restricted
exec(ccode, environment)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\applications\SQL\models\db.py",
line 39, in <module>
db1 = DAL('google:sql://root:web2py-test-165504/mydatabase')
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\base.py",
line 170, in __call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\base.py",
line 475, in __init__
"Failure to connect, tried %d times:\n%s" % (attempts, tb)
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\base.py",
line 455, in __init__
self._adapter = adapter(**kwargs)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\__init__.py",
line 40, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\google.py",
line 40, in __init__
super(GoogleSQL, self).__init__(*args, **kwargs)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\base.py",
line 367, in __init__
super(SQLAdapter, self).__init__(*args, **kwargs)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\base.py",
line 50, in __init__
self._initialize_(do_connect)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\google.py",
line 49, in _initialize_
super(MySQL, self)._initialize_(do_connect)
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\base.py",
line 63, in _initialize_
self._find_work_folder()
File
"C:\Users\Jonathan\Documents\Python\GoogleAppEngine\web2py\gluon\packages\dal\pydal\adapters\google.py",
line 44, in _find_work_folder
super(GoogleSQL)._find_work_folder()
AttributeError: 'super' object has no attribute '_find_work_folder'
I've also tried connecting to a local MySQL server following Massimo's
directions here: https://groups.google.com/forum/#!topic/web2py/SJJBp1dq7VU
When I do, I get exactly the same error.
Any help would be appreciated!
--
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.
