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