Hi
I had setup the cartodb locally in my machine following this tutorial https://github.com/danseely/cartodb-install/blob/master/DEV-INSTALLATION.md
Everything is installed perfectly i can visualize a data in my local account,but when i try to import a dataset it's showing error

so i created dataset with point data.when i try to visulaize it using createviz function in cartodb.js i can only see the basemap my point data is not visible

This is error in my windshaft log file

[2015-10-13 04:09:22.025] [ERROR] console - [millstone] processing style 'style0'
[2015-10-13 04:09:22.028] [ERROR] console - [millstone] finished processing '/tmp/cdb-tiler-dev/millstone-dev/base'
[2015-10-13 04:09:22.038] [ERROR] console - [millstone] processing style 'style0'
[2015-10-13 04:09:22.039] [ERROR] console - [millstone] finished processing '/tmp/cdb-tiler-dev/millstone-dev/base'
[2015-10-13 04:09:22.785] [INFO] [default] - undefined GET development.localhost.lan:8181/api/v1/map?stat_tag=a4d98018-719a-11e5-a681-000c29c3fbc5&config=%7B%22version%22%3A%221.0.1%22%2C%22stat_tag%22%3A%22a4d98018-719a-11e5-a681-000c29c3fbc5%22%2C%22layers%22%3A%5B%7B%22type%22%3A%22cartodb%22%2C%22options%22%3A%7B%22sql%22%3A%22select%20_%20from%20untitled_table%22%2C%22cartocss%22%3A%22%2F__%20simple%20visualization%20_%2F%5Cn%5Cn%23untitled_table%7B%5Cn%20%20marker-fill-opacity%3A%200.9%3B%5Cn%20%20marker-line-color%3A%20%23FFF%3B%5Cn%20%20marker-line-width%3A%201%3B%5Cn%20%20marker-line-opacity%3A%201%3B%5Cn%20%20marker-placement%3A%20point%3B%5Cn%20%20marker-type%3A%20ellipse%3B%5Cn%20%20marker-width%3A%2010%3B%5Cn%20%20marker-fill%3A%20%23FF6600%3B%5Cn%20%20marker-allow-overlap%3A%20true%3B%5Cn%7D%22%2C%22cartocss_version%22%3A%222.1.1%22%2C%22interactivity%22%3A%5B%22cartodb_id%22%5D%7D%7D%5D%7D&callback=_cdbc_2261541726_1 200 776 ms -> text/javascript; charset=utf-8 ({"req2params":1,"incMapviewCount":100,"queryTablesAndLastUpdated":669,"total":770})

When i go diagnosis page development.localhost.lan:3000/diagnosis

I'm getting this error

CartoDB extension: error

    Installed version: 0.11.1
    Current supported version: 0.9.Latest version: 0.9.3

Windshaft: error

    Service url: http://localhost.lan:8181
    Full config: {"filter"=>"mapnik", "internal"=>{"protocol"=>"http", "domain"=>"localhost.lan", "port"=>"8181", "host"=>"127.0.0.1", "verifycert"=>false}, "private"=>{"protocol"=>"http", "domain"=>"localhost.lan", "port"=>"8181", "verifycert"=>false}, "public"=>{"protocol"=>"http", "domain"=>"localhost.lan", "port"=>"8181", "verifycert"=>false}}
    error fetching info: A JSON text must at least contain two octets!

SQL API: error

    Service url: http://localhost.lan:8080
    Full config: {"private"=>{"protocol"=>"http", "domain"=>"localhost.lan", "endpoint"=>"/api/v1/sql", "port"=>8080}, "public"=>{"protocol"=>"http", "domain"=>"localhost.lan", "endpoint"=>"/api/v2/sql", "port"=>8080}}
    error fetching info: A JSON text must at least contain two octets!

Thanks in advance
Any help would be appreciated

Hi I am following your documentation for setting CartoDB locally in Ubuntu 12.04. While installing cartodb sql api by

npm config set strict-ssl false
npm install

i am getting the following error.
26848 info postuninstall [email protected]
26849 error [email protected] install: node-gyp rebuild
26849 error Exit status 1
26850 error Failed at the [email protected] install script.
26850 error This is most likely a problem with the libxmljs package,
26850 error not with npm itself.
26850 error Tell the author that this fails on your system:
26850 error node-gyp rebuild
26850 error You can get their info via:
26850 error npm owner ls libxmljs
26850 error There is likely additional logging output above.
26851 error System Linux 3.13.0-32-generic
26852 error command "/usr/bin/node" "/usr/bin/npm" "install"
26853 error cwd /home/user/CartoDB-SQL-API
26854 error node -v v0.10.26
26855 error npm -v 1.4.3
26856 error code ELIFECYCLE
26857 verbose exit [ 1, true ]

Any help of which is causing the error and how to resolve it could be appreciated.

I have followed your steps and have also made sure that I do the following:

I have also done the following
$ sudo vim /etc/postgresql/9.3/main/postgresql.conf
...
shared_preload_libraries = 'schema_triggers.so'

$ sudo service postgresql restart # restart postgres
NOTICE: database "contrib_regression" does not exist, skipping
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test test_setup ... ok
test test_ddl_triggers ... FAILED
test test/CDB_CartodbfyTableTest ... ok
test test/CDB_DigitSeparatorTest ... ok
test test/CDB_DistinctMeasureTest ... ok
test test/CDB_DistTypeTest ... ok
test test/CDB_EqualIntervalBinsTest ... ok
test test/CDB_HeadsTailsBinsTest ... ok
test test/CDB_HexagonTest ... ok
test test/CDB_JenksBinsTest ... ok
test test/CDB_MathTest ... ok
test test/CDB_QuantileBinsTest ... ok
test test/CDB_QueryStatementsTest ... ok
test test/CDB_QueryTablesTest ... FAILED
test test/CDB_QuotaTest ... ok
test test/CDB_StatsTest ... ok
test test/CDB_TransformToWebmercatorTest ... ok
test test/CDB_UserTablesTest ... ok
test test/CDB_XYZ_ExtentTest ... ok

2 of 19 tests failed.

Any help will be appreciated as I have redone the steps a number of times, but still get the same error

Hi,

I am setting cartoDB locally in ubuntu 12.04 by following https://github.com/danseely/cartodb-install/blob/master/DEV-INSTALLATION.md. And while installing Windshaft-cartodb there are some errors logged in npm-debug.log file. And below is the error in the log file

42454 info postuninstall [email protected]
42455 error [email protected] install: node-pre-gyp install --fallback-to-build
42455 error Exit status 1
42456 error Failed at the [email protected] install script.
42456 error This is most likely a problem with the mapnik package,
42456 error not with npm itself.
42456 error Tell the author that this fails on your system:
42456 error node-pre-gyp install --fallback-to-build
42456 error You can get their info via:
42456 error npm owner ls mapnik
42456 error There is likely additional logging output above.
42457 error System Linux 3.2.0-23-generic-pae
42458 error command "/usr/bin/node" "/usr/bin/npm" "install"
42459 error cwd /home/user/Windshaft-cartodb
42460 error node -v v0.10.26
42461 error npm -v 1.4.3
42462 error code ELIFECYCLE
42463 verbose exit [ 1, true ]

Any help regarding what makes this error and how to solve would be appreciated.

I have followed your document and completed the setup
when i run Windshaft-cartodb It's showing the following error

Error: Cannot find module '/home/shiva/Windshaft-cartodb/node_modules/windshaft/node_modules/grainstore/node_modules/millstone/node_modules/srs/lib/binding/node-v0.11.16-linux-ia32/srs_settings.js'
at Function.Module._resolveFilename (module.js:336:15)
at Function.Module._load (module.js:278:25)
at Module.require (module.js:365:17)
at require (module.js:384:17)
at Object. (/home/shiva/Windshaft-cartodb/node_modules/windshaft/node_modules/grainstore/node_modules/millstone/node_modules/srs/lib/srs.js:6:16)
at Module._compile (module.js:460:26)
at Object.Module._extensions..js (module.js:478:10)
at Module.load (module.js:355:32)
at Function.Module._load (module.js:310:12)
at Module.require (module.js:365:17)
shiva@ubuntu:~/Windshaft-cartodb$

I think I'm missing some dependencies of windshaft but i have no idea any help would be appreciated

I am trying to set CartoDB in Ubuntu 12.04. I am trying to install Python dependencies as a part of my installation. I am installing with below commands

export CPLUS_INCLUDE_PATH=/usr/include/gdal
export C_INCLUDE_PATH=/usr/include/gdal
sudo pip install --no-install GDAL

If i execute with the third command, it is saying an error "no such option: --no-install".

If i tried proceeding with "sudo pip install GDAL, it is raising the below error

The directory '/home/user/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
The directory '/home/user/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
Collecting GDAL
/usr/local/lib/python2.7/dist-packages/pip-7.1.2-py2.7.egg/pip/vendor/requests/packages/urllib3/util/ssl.py:90: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning
Downloading GDAL-2.0.1.tar.gz (519kB)
100% |████████████████████████████████| 520kB 38kB/s
Installing collected packages: GDAL
Running setup.py install for GDAL
Complete output from command /usr/bin/python -c "import setuptools, tokenize;file='/tmp/pip-build-PMhlKD/GDAL/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-0u9jBS-record/install-record.txt --single-version-externally-managed --compile:
running install
running build
running build_py
creating build
creating build/lib.linux-x86_64-2.7
copying gdal.py -> build/lib.linux-x86_64-2.7
copying ogr.py -> build/lib.linux-x86_64-2.7
copying osr.py -> build/lib.linux-x86_64-2.7
copying gdalconst.py -> build/lib.linux-x86_64-2.7
creating build/lib.linux-x86_64-2.7/osgeo
copying osgeo/init.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/gdal.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/gdalconst.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/osr.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/gdal_array.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/gdalnumeric.py -> build/lib.linux-x86_64-2.7/osgeo
copying osgeo/ogr.py -> build/lib.linux-x86_64-2.7/osgeo
running build_ext
building 'osgeo._gdal' extension
creating build/temp.linux-x86_64-2.7
creating build/temp.linux-x86_64-2.7/extensions
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -I../../port -I../../gcore -I../../alg -I../../ogr/ -I/usr/include/python2.7 -I. -I/usr/include -c extensions/gdal_wrap.cpp -o build/temp.linux-x86_64-2.7/extensions/gdal_wrap.o
cc1plus: warning: command line option ‘-Wstrict-prototypes’ is valid for Ada/C/ObjC but not for C++ [enabled by default]
extensions/gdal_wrap.cpp:2859:22: fatal error: cpl_port.h: No such file or directory
compilation terminated.
error: command 'gcc' failed with exit status 1

----------------------------------------

Command "/usr/bin/python -c "import setuptools, tokenize;file='/tmp/pip-build-PMhlKD/GDAL/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-0u9jBS-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-build-PMhlKD/GDAL

Help would be appreciated.