koop install log

gistfile1.txt

koop install terminal 6/29/2014

failed to npm install because i had somehow laid down a 'pre' version of node

with Andrew Wang 7/15/2014
overcame an error starting up the node server by calling npm update on koop's dependencies

with Mike Juniper 7/16/2014
pointed out that my koop adaptors weren't installed properly
afterward, i could run the gist and github previews once, but thats it

with Matt Ziebarth 7/17/2014
actually installed PostGIS, instead of trying to activate the extension on PostGres database all by itself
even tried creating a database from a template, but still no joy
doesn't seem to matter whether default port is specified in default.yml or not

7/23
chelm let me know a template shouldn't be required and that he'd pushed an update to support SQLite for development.
haven't been able to get that configured successfully either

basic SQL queries work repeatedly, but not bounding box queries
  works: http://localhost:17008/gist/6178185/FeatureServer/0/query?outFields=*&outSR=4326&inSR=4326&where=1=1
  doesn't: http://localhost:17008/gist/6178185/FeatureServer/0/query?geometryType=esriGeometryEnvelope&geometry={"xmin":-122.67175197601318,"ymin":-36.09571873655533,"xmax":-32.671751976013184,"ymax":45.527516684421265,"spatialReference":{"wkid":4326}}&outFields=*&outSR=4326&inSR=4326&where=1=1&f=json

7/24
uninstalled the Postgres.app and realized that i had postgres and postgis installed via homebrew as well.
blew everything away and started over from scratch, but still no joy

psql (9.3.4)
Type "help" for help.

john6251=# CREATE DATABASE koopdev;
CREATE DATABASE
john6251-# \q
frink:Application Support john6251$ psql koopdev
psql (9.3.4)
Type "help" for help.

koopdev=# CREATE EXTENSION postgis;
CREATE EXTENSION
koopdev=# 

i don't see any evidence in pgadmin that any features are gettings written into my databases.

tried using shp2pgsql to load the same PostGIS database with a generic shapefile, which seemed successful, but didn't leave any evidence in pgadmin either...

shp2pgsql -s 2898 parking public.parking | psql -h localhost -d koopdev -U john6251

with nixta and chelm 7/25/2014
figured out many things
using the preview button seems to be sending something corrupt into the database which breaks it forever.  when i made sure to fire a standard query first, koop stopped breaking!

nixta figured out that the tables that are written can be found below 'schema' in pgadmin (rather than Catalog).  my shapefile was there too!




unresolved questions:

1. do you need 'test:' in the default.yml configuration for spatialite or not?  (looks like you don't)
  default.yml.example in koop repo doesn't have it
  same file in koop-server repo does have it
  SQLite.js doesn't mention it

2. do you need to npm install spatialite seperately or does npm install for koop-server take care of it for you (i think you don't)
  koop readme is ambiguous, should explicitly state if its taken care of automatically