I have been unable to connect to a 2nd generation Google SQL instance for quite a time now. This is painful as 1st generation instances are less capable and declared "legacy" by Google.
I suspect it may have to do with web2py using a deprecated driver "rdbms", e.g. in google_adapters.py. According to Google, this has been long deprecated and "future versions of Cloud SQL will not be supported by the legacy drivers" - a quote from 2015. Read here: https://groups.google.com/forum/#!topic/google-cloud-sql-announce/4m3_GPhm444 In fact, I have tried to hack google_adapters.py to use the Google recommended MySQLdb driver instead of the old rdbms. I also had to change some of the args to it. Suddenly, I was able to connect to the 2nd generation SQL instance, only to fail a little later with ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-prod' at line 1") This is where my current knowledge stops, I am hoping some insider could help. Thank you. -- 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.
