Install and configure caravel in centos 7
Install Basic Package: yum groupinstall "Development tools"
1. pip installation 1. Install python
Python of version 2.7 is required. If centOS comes with version 2.7, it does not need to be installed (centOS7 comes with version 2.7.5)
① Download python
Https://www.python.org/ftp/python/2.7.9/Python-2.7.9.tar.xz
# Tar xf Python-2.7.9.tar.xz
# Cd Python-2.7.9
# Make & make altinstall
# Ln-s/usr/local/bin/python2.7/usr/local/bin/python
④ Test
# Python-V
② Decompress
③ Compile and install
#./Configure -- prefix =/usr/local
2. Install pip
First
# Yum install epel-release
Then
# Yum install python-pip
3. Install caravel
① Obtain the caravel source code
# Wget https://github.com/airbnb/caravel/archive/master.zip
② Decompress
# Unzip caravel-master.zip
③ Installation
Go to the root directory and run the pip command to install it. (The Source of Tsinghua University is used here, considering that overseas servers are too slow)
# Pip install.-I https://pypi.tuna.tsinghua.edu.cn/simple/
4. Error (if there is an error, execute the following)
① Cffi
Yum install libffi-devel
② Sasl
Yum install libgsasl-devel
Yum install libmemcached-devel
③ Python
Yum install python-devel
④ Openssl
Yum install openssl-devel
⑤ Pytz
Pip install -- upgrade pytz
⑥ Npy_math.py
Yum install numpy
Yum install openssl
Ii. nmp installation 1. Install nodejsto download node-v4.5.0.tar.gz (official website)
Extract
#./Configure -- prefix =/usr/local
# Make
# Make install
# Ln-s/usr/local/bin/node/usr/bin/node
2. Install npm
Download install. sh (https://npmjs.org/install.sh) from URL)
# Sh install. sh
3. Install express
# Npm install express-g
4. Install caravel (source code installation)
# Assuming $ CARAVEL_HOME as the root of the repo
# Cd $ CARAVEL_HOME/caravel/assets
# Npm install
# Npm run prod
# Cd $ CARAVEL_HOME
# Python setup. py install
3. Create an admin user during initialization
# Fabmanager create-admin -- app caravel
Initialize caravel metadata
# Caravel db upgrade
Initialize caravel's default user roles and permissions
# Caravel init
Load sample data
# Caravel load_examples
Define the running Port
# Caravel runserver-p 8088
Access through http: // localhost: 8088
4. Connect to the data source 1. postgresql
Yum install build-dep python-psycopg2
Pip install psycopg2
2. mysql
Yum install MySQL-pythonDatabasePypi packageSQLAlchemy URI prefixMySQL
pipinstallmysqlclient
mysql://
Postgres
pipinstallpsycopg2
postgresql+psycopg2://
Presto
pipinstallpyhive
presto://
Oracle
pipinstallcx_Oracle
oracle://
Sqlite
sqlite://
Redshift
pipinstallsqlalchemy-redshift
redshift+psycopg2://
MSSQL
pipinstallpymssql
mssql://
Impala
pipinstallimpyla
impala://
SparkSQL
pipinstallpyhive
jdbc+hive://
Note: if an error occurs when you connect to the data source, for example, importError no moduel MySQLdb, the solution is as follows:
Install MySQL-python in linux
The first method is simple: yum installMySQL-python
The second type is complex: You need to compile your own source code, and there are many dependent packages.
A. gcc
B. setuptools
C. python-dev
The detailed steps in Chapter 2 are as follows:
A. Download: wgethttp: // sourceforge.net/projects/mysql-python/files/latest/download
B.
$ Tar xfz MySQL-python-1.2.3.tar.gz
$ MySQL-python-1.2.3 cd
$ Whereismysql_config
Mysql_config:/usr/bin/mysql_config
$ Vim site. cfg
Modify mysql_config to the mysql configuration file path/usr/bin/mysql_config
Also modify
Threadsafe = False
$ Python setup. py build
$ Sudo python setup. py install in the python environment >>> import MySQLdb
/Usr/local/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_ mysql. py: 3: UserWarning: Module _ mysql was already imported from/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_ mysql. pyc, but/app/MySQL-python-1.2.5 is being added to sys. if the path is successfully installed, warn is reported during the installation process. error: command 'gcc 'failed with exit status 1. Use yum install gcc to check whether the latest version is installed and the mysql-devel package is not installed. solution: yum install mysql-devel reference: http://blog.csdn.net/wklken/article/details/7271019http://blog.csdn.net/agoago_2009/article/details/9492765
Reference File
Http://www.aboutyun.com/thread-19402-1-1.html
Http://blog.csdn.net/csulfy/article/details/51833407
Http://lxw1234.com/archives/2016/06/681.htm
Http://km-moon11.iteye.com/blog/2213527
Http://airbnb.io/caravel/installation.html