Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 6006B28C7C for ; Sat, 19 May 2012 17:42:34 -0300 (ADT) Received: from mail-ob0-f174.google.com ([209.85.214.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SVqTu-0001EW-S3 for pgsql-www@postgresql.org; Sat, 19 May 2012 20:42:33 +0000 Received: by obbtb18 with SMTP id tb18so5798118obb.19 for ; Sat, 19 May 2012 13:42:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=/N+YlE7ES4L9LePeD6v0YN+XkooZqulrLkHN5ZAer0Q=; b=Z1qSOh0U69qp6y7MAQOMsG1wuBzNYxHW4Kz6is+MpxjZJTZOHLUJWqAjrMjFw34HGh ZY2H9Xx8mQHdUDP+p+emoCNZRi+4HJ/Fgsuqi2F5gX6c580YDFzhFA1Of0diJTiQYM/k RFAna9DUK7ELVytqhhi2MB3X0akfT3d2m8jQeBntU9zzWkR9PENzYzqQiVFbg7dcUKpU 5XqqK1dq0QSU0EB/GAF2TA6S/zQayuoBIbZou/+xE0QOQxJitaF6/l/twoUfQCqetpea xFUVEawE0oR4xQoqZUsr1maD3LQI2kEIWSdSQOalpsrGNVx6T5+wnDzpta9sRbMBeF6Q HWsQ== MIME-Version: 1.0 Received: by 10.60.14.193 with SMTP id r1mr14502667oec.16.1337460136223; Sat, 19 May 2012 13:42:16 -0700 (PDT) Received: by 10.60.146.180 with HTTP; Sat, 19 May 2012 13:42:16 -0700 (PDT) Date: Sat, 19 May 2012 13:42:16 -0700 Message-ID: Subject: pgweb dev install hurdles From: Josh Kupershmidt To: "w^3" Content-Type: multipart/mixed; boundary=e89a8ff252ee52254e04c069b45b X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201205/51 X-Sequence-Number: 20675 --e89a8ff252ee52254e04c069b45b Content-Type: text/plain; charset=ISO-8859-1 Hi all, I finally got around to trying out pgweb locally, following the instructions in dev_install.rst. The first hurdle I hit was due to DATABASE_NAME not being set in settings_local.py, which results in the manage.py exception: "You need to specify NAME in your Django settings file." Since step 3 of dev_install.rst recommends creating the "pgweb" database for this application, the suggested overrides for settings_local.py in step 4 should include a DATABASE_NAME pointing there. Next, while trying to load in community_login.sql per step 6 of the dev_install instructions, I encountered this: josh@vboxdeb:~/src/pgweb/sql$ psql pgweb -f community_login.sql BEGIN CREATE FUNCTION CREATE FUNCTION psql:community_login.sql:87: ERROR: relation "users_old" does not exist LINE 4: ...lower(username)=lower($1) UNION ALL SELECT 1 from users_old ... I didn't see anywhere the "users_old" relation was defined, other than a mention in ./tools/migrate/1_crunch_in_sql.sql. I was able to work around this problem by making a dummy users_old table with the appropriate columns, but perhaps this table should be included in the schema? Then, when I ran load_initial_data.sh, I ran into this: Problem installing fixture './core/fixtures/data.yaml': Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/django/core/management/commands/loaddata.py", line 172, in handle obj.save(using=using) ... snip ... File "/usr/lib/pymodules/python2.6/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute return self.cursor.execute(query, args) IntegrityError: null value in column "firstreldate" violates not-null constraint DETAIL: Failing row contains (1, 8.4, 0, 2009-07-01, release-8-4.html, f, t, null, null, null). which corresponded to this error in my server log: ERROR: null value in column "firstreldate" violates not-null constraint DETAIL: Failing row contains (1, 8.4, 0, 2009-07-01, release-8-4.html, f, t, null, null, null). STATEMENT: INSERT INTO "core_version" ("id", "tree", "latestminor", "reldate", "relnotes", "current", "supported", "docsloaded", "firstreldate", "eoldate") VALUES (1, '8.4', 0, '2009-07-01', 'release-8-4.html', false, true, NULL, NULL, NULL) I hacked up ./pgweb/core/fixtures/data.yaml to include a "firstreldate" (copied from "reldate", no idea if that was right) and "eoldate" until load_initial_data.sh worked OK. Attached is a patch containing the few fixes/kludges I used to get pgweb running locally. Josh --e89a8ff252ee52254e04c069b45b Content-Type: text/x-patch; charset=US-ASCII; name="dev_install_fixes.diff" Content-Disposition: attachment; filename="dev_install_fixes.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: file0 ZGlmZiAtLWdpdCBhL2RvY3MvZGV2X2luc3RhbGwucnN0IGIvZG9jcy9kZXZfaW5zdGFsbC5yc3QK bmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggYzQ1NTgyYy4uODk1MmZjOQoqKiogYS9kb2NzL2Rl dl9pbnN0YWxsLnJzdAotLS0gYi9kb2NzL2Rldl9pbnN0YWxsLnJzdAoqKioqKioqKioqKioqKiog U28sIHlvdSdyZSByZWFkeSB0byBjb250cmlidXRlIHRvIHBnd2ViLAoqKiogNSwxMSAqKioqCiAg bG9jYWwgd29ya2luZyBjb3B5IG9mIHRoZSB3ZWJzaXRlIGNvZGUsIHNvIHlvdSBoYXZlIHNvbWV0 aGluZyB0byB3b3JrCiAgd2l0aC4gSGVyZSdzIGEgcXVpY2sgc3RlcC1ieS1zdGVwIG9uIGhvdyB0 byBkbyB0aGF0OgogIAohIDEuIE1ha2Ugc3VyZSB5b3UgaGF2ZSBkb3dubG9hZGVkIGFuZCBpbnN0 YWxsZWQgZGphbmdvICp2ZXJzaW9uIDEuMioKICAgICAob3IgbGF0ZXIpLiBZb3Ugd2lsbCBhbHNv IG5lZWQgdGhlIGRlcGVuZGVuY2llcyAqcHN5Y29wZzIqLCAqeWFtbCoKICAgICBhbmQgKm1hcmtk b3duKiAodGhlc2UgYXJlIHB5dGhvbiBsaWJyYXJpZXMsIHNvIHByZWZpeCBweXRob24tIGZvciBE ZWJpYW4KICAgICBwYWNrYWdlcywgZm9yIGV4YW1wbGUpLgotLS0gNSwxMSAtLS0tCiAgbG9jYWwg d29ya2luZyBjb3B5IG9mIHRoZSB3ZWJzaXRlIGNvZGUsIHNvIHlvdSBoYXZlIHNvbWV0aGluZyB0 byB3b3JrCiAgd2l0aC4gSGVyZSdzIGEgcXVpY2sgc3RlcC1ieS1zdGVwIG9uIGhvdyB0byBkbyB0 aGF0OgogIAohICMuIE1ha2Ugc3VyZSB5b3UgaGF2ZSBkb3dubG9hZGVkIGFuZCBpbnN0YWxsZWQg ZGphbmdvICp2ZXJzaW9uIDEuMioKICAgICAob3IgbGF0ZXIpLiBZb3Ugd2lsbCBhbHNvIG5lZWQg dGhlIGRlcGVuZGVuY2llcyAqcHN5Y29wZzIqLCAqeWFtbCoKICAgICBhbmQgKm1hcmtkb3duKiAo dGhlc2UgYXJlIHB5dGhvbiBsaWJyYXJpZXMsIHNvIHByZWZpeCBweXRob24tIGZvciBEZWJpYW4K ICAgICBwYWNrYWdlcywgZm9yIGV4YW1wbGUpLgoqKioqKioqKioqKioqKiogd2l0aC4gSGVyZSdz IGEgcXVpY2sgc3RlcC1ieS1zdGVwIG9uIGhvdwoqKiogMjgsMzMgKioqKgotLS0gMjgsMzQgLS0t LQogIAlOT19IVFRQU19SRURJUkVDVD1UcnVlCiAgCVNFU1NJT05fQ09PS0lFX1NFQ1VSRT1GYWxz ZQogIAlTRVNTSU9OX0NPT0tJRV9ET01BSU49Tm9uZQorICAgICAgICAgREFUQUJBU0VfTkFNRT0i cGd3ZWIiCiAgIy4gSW4gdGhlIHBnd2ViIGRpcmVjdG9yeSBydW4gdGhlIGZvbGxvd2luZyBjb21t YW5kIHRvIGNyZWF0ZSBhbGwKICAgICB0YWJsZXMgYW5kIGluZGV4ZXMsIGFzIHdlbGwgYXMgY3Jl YXRlIGEgc3VwZXJ1c2VyIGZvciB5b3VyIGxvY2FsCiAgICAgaW5zdGFsbGF0aW9uOjoKZGlmZiAt LWdpdCBhL3Bnd2ViL2NvcmUvZml4dHVyZXMvZGF0YS55YW1sIGIvcGd3ZWIvY29yZS9maXh0dXJl cy9kYXRhLnlhbWwKbmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggYmM4ZGM1Yi4uMzY2NjJmMAoq KiogYS9wZ3dlYi9jb3JlL2ZpeHR1cmVzL2RhdGEueWFtbAotLS0gYi9wZ3dlYi9jb3JlL2ZpeHR1 cmVzL2RhdGEueWFtbAoqKioqKioqKioqKioqKioKKioqIDYsMTEgKioqKgotLS0gNiwxMyAtLS0t CiAgICAgInJlbG5vdGVzIjogInJlbGVhc2UtOC00Lmh0bWwiLCAKICAgICAidHJlZSI6ICI4LjQi LCAKICAgICAicmVsZGF0ZSI6ICIyMDA5LTA3LTAxIiwgCisgICAgImVvbGRhdGUiOiAiMjAxNC0w Ny0wMSIsCisgICAgImZpcnN0cmVsZGF0ZSI6ICIyMDA5LTA3LTAxIiwgCiAgICAgImxhdGVzdG1p bm9yIjogMAogICAgfQogICB9LCAKKioqKioqKioqKioqKioqCioqKiAxNiwyMSAqKioqCi0tLSAx OCwyNSAtLS0tCiAgICAgInJlbG5vdGVzIjogInJlbGVhc2UtOC0zLTcuaHRtbCIsIAogICAgICJ0 cmVlIjogIjguMyIsIAogICAgICJyZWxkYXRlIjogIjIwMDktMDMtMTciLCAKKyAgICAiZW9sZGF0 ZSI6ICIyMDEzLTAyLTAxIiwKKyAgICAiZmlyc3RyZWxkYXRlIjogIjIwMDktMDMtMTciLCAKICAg ICAibGF0ZXN0bWlub3IiOiA3CiAgICB9CiAgIH0sIAoqKioqKioqKioqKioqKioKKioqIDI1LDMx ICoqKioKICAgICJmaWVsZHMiOiB7CiAgICAgInJlbG5vdGVzIjogInJlbGVhc2UtOC0yLTEzLmh0 bWwiLCAKICAgICAidHJlZSI6ICI4LjIiLCAKISAgICAicmVsZGF0ZSI6ICIyMDA5LTAzLTE3Iiwg CiAgICAgImxhdGVzdG1pbm9yIjogMTMKICAgIH0KICAgfSwgCi0tLSAyOSwzNyAtLS0tCiAgICAi ZmllbGRzIjogewogICAgICJyZWxub3RlcyI6ICJyZWxlYXNlLTgtMi0xMy5odG1sIiwgCiAgICAg InRyZWUiOiAiOC4yIiwgCiEgICAgInJlbGRhdGUiOiAiMjAwOS0wMy0xNyIsCiEgICAgImVvbGRh dGUiOiAiMjAxMS0xMi0wMSIsIAohICAgICJmaXJzdHJlbGRhdGUiOiAiMjAwOS0wMy0xNyIsIAog ICAgICJsYXRlc3RtaW5vciI6IDEzCiAgICB9CiAgIH0sIAoqKioqKioqKioqKioqKioKKioqIDM2 LDQxICoqKioKLS0tIDQyLDQ5IC0tLS0KICAgICAicmVsbm90ZXMiOiAicmVsZWFzZS5odG1sI1JF TEVBU0UtOC0xLTE3IiwgCiAgICAgInRyZWUiOiAiOC4xIiwgCiAgICAgInJlbGRhdGUiOiAiMjAw OS0wMy0xNyIsIAorICAgICJlb2xkYXRlIiA6ICIyMDEwLTExLTAxIiwKKyAgICAiZmlyc3RyZWxk YXRlIjogIjIwMDktMDMtMTciLCAKICAgICAibGF0ZXN0bWlub3IiOiAxNwogICAgfQogICB9LCAK KioqKioqKioqKioqKioqCioqKiA0Niw1MSAqKioqCi0tLSA1NCw2MSAtLS0tCiAgICAgInJlbG5v dGVzIjogInJlbGVhc2UuaHRtbCNSRUxFQVNFLTgtMC0yMSIsIAogICAgICJ0cmVlIjogIjguMCIs IAogICAgICJyZWxkYXRlIjogIjIwMDktMDMtMTciLCAKKyAgICAiZW9sZGF0ZSI6ICIyMDEwLTEw LTAxIiwKKyAgICAiZmlyc3RyZWxkYXRlIjogIjIwMDktMDMtMTciLCAKICAgICAibGF0ZXN0bWlu b3IiOiAyMQogICAgfQogICB9LCAKZGlmZiAtLWdpdCBhL3NxbC92YXJuaXNoLnNxbCBiL3NxbC92 YXJuaXNoLnNxbApuZXcgZmlsZSBtb2RlIDEwMDY0NAppbmRleCAzZGU5MTk2Li4xYjVmOGQ3Cioq KiBhL3NxbC92YXJuaXNoLnNxbAotLS0gYi9zcWwvdmFybmlzaC5zcWwKKioqKioqKioqKioqKioq IEJFR0lOOwoqKiogMiw4ICoqKioKICAKICAtLQogIC0tIENyZWF0ZSBhIGZ1bmN0aW9uIHRvIHB1 cmdlIGZyb20gdmFybmlzaCBjYWNoZQohIC0tIEJ5IGRlZmFsdXQgdGhpcyBhZGRzIHRoZSBvYmpl Y3QgdG8gYSBwZ3EgcXVldWUsCiAgLS0gYnV0IHRoaXMgZnVuY3Rpb24gY2FuIGJlIHJlcGxhY2Vk IHdpdGggYSB2b2lkIG9uZQogIC0tIHdoZW4gcnVubmluZyBhIGRldmVsb3BtZW50IHZlcnNpb24u CiAgLS0KLS0tIDIsOCAtLS0tCiAgCiAgLS0KICAtLSBDcmVhdGUgYSBmdW5jdGlvbiB0byBwdXJn ZSBmcm9tIHZhcm5pc2ggY2FjaGUKISAtLSBCeSBkZWZhdWx0IHRoaXMgYWRkcyB0aGUgb2JqZWN0 IHRvIGEgcGdxIHF1ZXVlLAogIC0tIGJ1dCB0aGlzIGZ1bmN0aW9uIGNhbiBiZSByZXBsYWNlZCB3 aXRoIGEgdm9pZCBvbmUKICAtLSB3aGVuIHJ1bm5pbmcgYSBkZXZlbG9wbWVudCB2ZXJzaW9uLgog IC0tCg== --e89a8ff252ee52254e04c069b45b--