this line is the problem
db= DAL('google:sqlstore')
should be
db = DAL('google:sql://realm:domain/database')
where realm:domain and database are parameters that depend on your google
sql configuration:
https://developers.google.com/cloud-sql/docs/before_you_begin#enroll
I have not used it recently but it was fully tested with the GAE-SQL
development instance. Unless something has changed on their side, it should
still work fine.
On Thursday, 24 May 2012 14:00:16 UTC-5, Umpei Kurokawa wrote:
>
> So far, I have been developing my app locally on my laptop (I am just
> using the built in rocket server with sqlite on my windows laptop and it is
> working great!!)
> However, I am now trying to get my app uploaded to the google app engine
> using SQL , instead of using noSQL. I have my db set up this way
>
> if not request.env.web2py_runtime_gae:
> ## if NOT running on Google App Engine use SQLite or other DB
> db = DAL('sqlite://storage.sqlite')
> else:
> ## connect to Google BigTable (optional 'google:datastore://namespace')
> #db = DAL('google:datastore') #for no SQL
> db= DAL('google:sqlstore') #for SQL
> ## store sessions and tickets there
> session.connect(request, response, db = db)
>
> When I use the db=DAL('google:sqlstore') option to use SQL, and when I try
> to access my app through google app engine, it sends me to a page that just
> says "Internal error, ticket issued unknown"(it is not the typical web2py
> error message, seems to be coming from google app engine). And when I click
> on the link "unknown" it sends me to the web2py administration site. The
> example , and welcome apps seems to be working fine on my google app engine
> instance so I figured I am doing something wrong in my app. I tried using
> the noSQL option, and if I do that, it at least sends me to a web2py error
> page because I am using join related commands to access my database (hence
> the reason I want to use SQL).
>
> I looked through the documentation and it seems like google's sql can do
> everything that sqlite can do. I also believe I'm not performing any writes
> or reads into the filesystem since google app engine prohibits it. Is there
> anything crucial I am missing?
>
> Is there somethign
>
>
