Problems faced during CartoDB install & solutions if known

Lets document the issues faced while installing CartoDB. These may not necessarily be the issues with cartoDB itself. CartoDB depends on many other packages (mostly bleeding edge & latest stuff).

1) SSL Error installing rvm 1.9.2 in Ubuntu 11.10

Error Message :

 ossl_ssl.c:110:1: error: ‘SSLv2_method’ undeclared here (not in a function)
 ossl_ssl.c:111:1: error: ‘SSLv2_server_method’ undeclared here (not in a function)
 ossl_ssl.c:112:1: error: ‘SSLv2_client_method’ undeclared here (not in a function)
 make[1]: *** [ossl_ssl.o] Error 1 
 make[1]: Leaving directory `/var/cache/ruby-rvm/src/ruby-1.9.2-p180/ext/openssl'
 make: *** [mkmain.sh] Error 1

OS: Ubuntu 11.10 32 bit

Solution :

 sudo apt-get install ruby-rvm
 # make sure we have $rvm_path
 source /etc/profile
 # don't use ubuntus openssl
 rvm package install openssl
 rvm install 1.9.2 --with-openssl-dir=$rvm_path/usr

thanks to Jonas Wagner (http://29a.ch/2011/10/28/rvm-on-ubuntu-11-10)

2) Can only import one file, have to restart resque to import another

No Error Message, the import job just doesn't start

OS: Ubuntu 11.10 32 bit

Solution :

Install and run pgbouncer and modify config/database.yml to connect using pgbouncer's port.

https://github.com/CartoDB/cartodb20/issues/51

3) After login in a local development environment, CartoDB dashboard doesn't finishes loading and throws 404s on files like mixpanel.js or user_stats.js

Solution:

Try recreating cdb Javascript module:

 /cartodb/lib/assets/javascripts/cdb$ npm install
 /cartodb$ make update_cdb

Also, disable AdBlock or similar javascript-blocking browser extensions as they might not like unbundled file names.

4) Mapnik installation fails on Ubuntu 12.04

Solution:

 # remove the cartodb ppa
 sudo apt-add-repository --remove ppa:cartodb/mapnik
 # install mapnik ppa
 sudo add-apt-repository ppa:mapnik/nightly-2.1 
 apt-get update
 # install boost
 sudo apt-get install libboost1.49-dev
 # install mapnik
 sudo apt-get install libmapnik-dev python-mapnik mapnik-utils

thanks to tomay (https://gist.github.com/tomay/7779546/raw/5479e0be07e80b1cc5b4341c180d675afff5b427/cartodb+install+notes+12.04.md)

5) How do I install Varnish 2.1 under Ubuntu Precise?

Solution:

 sudo apt-cache policy varnish
 # specify 2.1.x version available for your system
 sudo apt-get install varnish=2.1.0-2cdb~precise1
 # disable auto-updating of varnish
 sudo apt-mark hold varnish

Note: Remove the secrets file authentication from /etc/default/varnish (DAEMON_OPTS variable will contain it). try telnet 127.0.0.1 8062 and it shouldn't say anything about authentication required.

6) I want to install Ruby without RVM, how do I do it?

Solution:

First, install yaml

cd /usr/local/src
wget http://pyyaml.org/download/libyaml/yaml-0.1.4.tar.gz
tar xzvf yaml-0.1.4.tar.gz
cd yaml-0.1.4
./configure --prefix=/usr/local
make
make install

Install some required libraries:

sudo apt-get install zlib1g zlib1g-dev build-essential openssl libssl-dev libmysqlclient18 libmysqlclient-dev libyaml-dev curl git-core python-software-properties

Then, download Ruby source code (https://www.ruby-lang.org/en/downloads/) and build it:

cd /usr/local/src/...
./configure
make
sudo make install

Install Bundler:

gem install bundler

And prepare the environment by installing all required gems

bundle install

If while trying to run a Rails console you get an error mentioning not finding readline, install the following gem:

gem install rb-readline
bundle update debugger

7. • After running gruntI get this error:

Errno::ENOENT on line ["33"] of /Users/username/.rvm/gems/ruby-1.9.3-p194/gems/compass-0.12.3/lib/compass/exec/global_options_parser.rb: No such file or directory - /Users/username/code/cartoDB/app/assets/stylesheets/tmp/common (

Solution: update your CartoDB git submodules running: git submodule update --init