Thanks, that solved it (Well that and my other thread on heroku DB)
On Thu, Dec 27, 2012 at 4:40 AM, Massimo Di Pierro <[email protected]> wrote: > Did you look at all into: > > https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-heroku.sh > https://github.com/web2py/web2py/blob/master/gluon/contrib/heroku.py > > You must use db = get_db() not db=DAL() on heroku. > > > On Wednesday, 26 December 2012 07:05:55 UTC-6, Alec Taylor wrote: >> >> Been using Red Hat OpenShift for 6-months now, but have been annoyed >> with their lack of DNS. A or CNAMEs simply aren't the same. >> >> So today I thought to try with Heroku. >> >> Here's a step-by-step setup guide: >> >> 1. Follow these steps: https://devcenter.heroku.com/articles/quickstart >> 2. Grab the version of web2py you want to use (I used trunk off of >> github), cd into this directory >> 3. echo web: python anyserver.py -s gunicorn -i 0.0.0.0 -p $PORT > >> Procfile >> 4. In this directory create a 'requirements.txt' file for pip, with >> these contents: >> web2py >> gunicorn >> psycopg2 # PostgreSQL >> 5. Modify the db.py for your app(s) to: >> if not request.env.web2py_runtime_gae: >> ## if NOT running on Google App Engine use SQLite or other DB >> db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) >> try: db = DAL(os.environ.get('DATABASE_URL')) >> except: db = DAL('sqlite://storage.sqlite') >> 6. git init && git add . && git commit -am "init" >> 7. heroku create >> Take not of your URL here >> 8. git push heroku master >> >> For further information see: >> https://devcenter.heroku.com/articles/python >> https://devcenter.heroku.com/articles/procfile >> http://blog.doersguild.com/post/35049380409/running-web2py-on-heroku # >> Where I got most of this from :P >> >> My thoughts thus far: >> - Good to see a newer version of python (2.7.2 vs OpenShifts': 2.6) >> - Has a default AES256 bit protected DigiCert verified which is nice >> to see; and stops me from doing any hacky workarounds to get admin >> working on HTTP (like required with OpenShift) >> - Don't need to enter my password everytime I push my changes (not >> sure if I like this!) >> - It uses an old version of pip (1.1) >> >> Problems: >> Unable to get a database connection. The doersguild blog guide which I >> followed (see link above) didn't work, because 'DATABASE_URL' isn't in >> my environ. >> >> My environ contains: >> {'LANG': 'en_US.UTF-8', 'LIBRARY_PATH': '/app/.heroku/vendor/lib', >> 'SHLVL': '1', 'PYTHONPATH': '/app/', 'SERVER_SOFTWARE': >> 'gunicorn/0.17.0', 'PYTHONHOME': '/app/.heroku/venv/', 'PORT': '[not >> saying publicly]', 'PWD': '/app', 'PYTHONHASHSEED': '[not saying >> publicly]', 'HOME': '/app', 'PATH': >> >> '/app/.heroku/venv/bin:/app/.heroku/venv/bin:/bin:/usr/local/bin:/usr/bin', >> 'PYTHONUNBUFFERED': 'true', 'PS1': >> '\\[\\033[01;34m\\]\\w\\[\\033[00m\\] \\[\\033[01;32m\\]$ >> \\[\\033[00m\\]', 'LD_LIBRARY_PATH': '/app/.heroku/vendor/lib', '_': >> '/app/.heroku/venv/bin/python'} >> >> Hope you enjoy my guide and can help me edit it to make it work >> properly; i.e.: with DB connection. >> >> All the best, >> >> Alec Taylor > > -- > > > --
