I use mysql on google app engine all the time. I use mysqldb with latest
web2py and dal without any issue.
That is not the right connection string. It should be more something like
this:
google:MySQLdb://username:password@/dbname?unix_socket=/cloudsql/projectname
:us-central1:dbinstanceid
On Friday, 13 October 2017 00:01:12 UTC-5, Bernardo Leon wrote:
>
> Hello, me again. I am testing Google Cloud Platform along with pycharm (I
> added a new run configuration for gae inside pycharm) and I have the
> following model:
>
> # -*- coding: utf-8 -*-
> from gluon.tools import Auth
>
> db = DAL('google:sql://trahello:trahello-db/trahello')
>
> I have installed the google app engine local server and did their hello
> world tutorial so I think my installation is fine.
>
> When I hit the run button my console gives no errors:
>
> INFO 2017-10-13 04:40:50,304 sdk_update_checker.py:231] Checking for
> updates to the SDK.
> INFO 2017-10-13 04:40:51,108 sdk_update_checker.py:259] The SDK is up
> to date.
> INFO 2017-10-13 04:41:03,088 api_server.py:300] Starting API server
> at: http://localhost:36575
> INFO 2017-10-13 04:41:03,146 dispatcher.py:251] Starting module
> "default" running at: http://127.0.0.1:8080
> INFO 2017-10-13 04:41:03,147 admin_server.py:116] Starting admin
> server at: http://localhost:8000
>
> but when I try to open my app url: http://localhost:8080/trahello I get
> the following error.
>
> Traceback (most recent call last):
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/restricted.py",
> line 219, in restricted
> exec(ccode, environment)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/applications/trahello/models/modelo.py",
>
> line 4, in <module>
> db = DAL('google:sql://trahello:trahello-db/trahello')
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/base.py",
>
> line 170, in __call__
> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/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
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/base.py",
>
> line 455, in __init__
> self._adapter = adapter(**kwargs)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
>
> line 40, in __call__
> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/adapters/base.py",
>
> line 368, in __init__
> super(SQLAdapter, self).__init__(*args, **kwargs)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/adapters/base.py",
>
> line 50, in __init__
> self._initialize_(do_connect)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/adapters/google.py",
>
> line 32, in _initialize_
> super(GoogleSQL, self)._initialize_(do_connect)
> File
> "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/packages/dal/pydal/adapters/mysql.py",
>
> line 24, in _initialize_
> user = self.credential_decoder(m.group('user'))
> IndexError: no such group
>
> Since the google adapter inherits from MySQL adapter it tries to run the
> _initialize_ method of the MySQL adapter which in turn tries to get the
> user and the password from the Google SQL URI. Is this an expected
> behaviour?
>
> How good is the Google Cloud Platform support on web2py? I am using the
> most recent stable version: Version
> 2.15.4-stable+timestamp.2017.09.02.04.02.22
>
> Thank you for any insight!
>
--
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.
