Ok, I see, its not really clear from the online book that there should be something after google:sqlstore though
http://web2py.com/books/default/chapter/29/6 Thanks! On Thursday, May 24, 2012 11:59:23 PM UTC-4, Massimo Di Pierro wrote: > > 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 >> >>
