pyspider安装

 操作系统

CentOS Linux release 7.0.1406 (Core)

 

Python环境

Python安装　　

安装依赖：
　　yum install gcc # 安装python必须
　　yum install zlib # 以下四个安装setuptools必须，如果安装在python后，则需要重新make python
　　yum install zlib-devel
　　yum install openssl
　　yum install openssl-devel

　　cd Python-2.7.13
　　./configure --prefix=/python2.7
　　make
　　make install

配置环境变量
# vi ~/.bash_profile
　　export PATH=/python2.7/bin:$PATH

 

安装pip

　　　依赖：setuptools

　　　　依赖：six-1.10.0.tar.gz packaging-16.8.tar.gz pyparsing-2.2.0.tar.gz appdirs-1.4.3.tar.gz 

　　　cd pip-9.0.1

　　　# python setup.py install

 

安装pyspider

从github下载最新版pyspider

依赖系统包：

　　tcl  protobuf libcurl-devel libxslt-devel  libxml2

使用yum install 安装他们。。。

cd pyspider
# 安装依赖包并安装
pip install -r requirements.txt
python setup.py install

　　由于requirements.txt中的mysql-connector无法下载，所以选择安装其它版本的mysql-connector

　　pip install mysql-connector==2.1.4

 

安装mysql数据库

用yum安装完后,参考http://www.itnose.net/detail/6310643.html，完成数据库的安装。

# 重启mysql
service mysqld restart

# mysql -u root
# 修改root密码
mysql> use msyql
mysql> update user set password=password('123456') where user='root';


# 创建数据库并授权
mysql> create database taskdb;
mysql> create database projectdb;
mysql> create database resultdb;
mysql> create user 'pyspider'@'%';
mysql> create user pyspider@'localhost' identified by 'pyspider-pass';
mysql> grant select,insert,update,references,delete,create,drop,alter,index,trigger,create view,show view,execute,alter routine,create routine,create temporary tables,lock tables,event on taskdb.* to 'pyspider'@'%';
mysql> grant select,insert,update,references,delete,create,drop,alter,index,trigger,create view,show view,execute,alter routine,create routine,create temporary tables,lock tables,event on projectdb.* to 'pyspider'@'%';
mysql> grant select,insert,update,references,delete,create,drop,alter,index,trigger,create view,show view,execute,alter routine,create routine,create temporary tables,lock tables,event on resultdb.* to 'pyspider'@'%';
mysql> flush privileges;

修改配置文件(为集群做准备)
vi /etc/my.cnf
bind-address = 0.0.0.0

# 重启数据库 
service mysqld restart

　　 

安装redis

下载redis，并解压到/root/training目录下

安装redis

cd /root/training/redis-2.8.12
make
make test
make install

# 为集群做准备
cd /root/training/redis-3.2.8
cp redis.conf /etc/

vi /etc/redis.conf
bind 0.0.0.0 

# 启动 redis 
redis-server /etc/redis.conf &

　　

启动成功标志：The server is now ready to accept connections on port 6379

防火墙

查看防火墙状态：

firewall-cmd --state

自己两条配置：

iptables -A INPUT -s 127.0.0.1 -p tcp --dport 6379 -j ACCEPT
iptables -A INPUT -p tcp --dport 6379 -j DROP

 

关闭firewall：
systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动

 

如果不会配置，最好停止防火墙。

 

安装phantomjs

下载：wget https://bbuseruploads.s3.amazonaws.com/fd96ed93-2b32-46a7-9d2b-ecbc0988516a/downloads/396e7977-71fd-4592-8723-495ca4cfa7cc/phantomjs-2.1.1-linux-x86_64.tar.bz2?Signature=guF7TAUW11qr9nZXcTBHu7dg1ds%3D&Expires=1488510600&AWSAccessKeyId=AKIAIVFPT2YJYYZY3H4A&versionId=null&response-content-disposition=attachment%3B%20filename%3D%22phantomjs-2.1.1-linux-x86_64.tar.bz2%22

下载phantomjs-2.1.1-linux-x86_64.tar.bz2到/root目录下，解压

 

将 phantomjs/bin目录下的phantomjs文件拷贝到/python2.7/bin目录下

 

配置文件

====================================================================

pyspider配置文件如下：

{
  "taskdb": "mysql+taskdb://pyspider:pyspider-pass@localhost:3306/taskdb",
  "projectdb": "mysql+projectdb://pyspider:pyspider-pass@localhost:3306/projectdb",
  "resultdb": "mysql+resultdb://pyspider:pyspider-pass@localhost:3306/resultdb",
  "message_queue": "redis://localhost:6379/db",
  "webui": {
    "port":5555,
    "username": "pyspider",
    "password": "pyspider-pass",
    "need-auth": true
  }
}

　　

 =========================================

# 为安全起见，我们新建一个普通用户来存储配置文件
useradd -md /pyspider pyspider
# 保存配置文件
/pyspider/config.json
# 权限设置
chown -R pyspider:pyspider /pyspider
chmod 400 config.json

 

启动pyspider

启动pyspider

/anaconda2/bin/pyspider -c /pyspider/config.json

结果如下：

# pyspider -c /pyspider/config.json 
[W 170516 17:45:05 __init__:54] redis DB must zero-based numeric index, using 0 instead
[I 170516 17:45:05 result_worker:49] result_worker starting...
[W 170516 17:45:06 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:06 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:06 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:06 __init__:54] redis DB must zero-based numeric index, using 0 instead
[I 170516 17:45:06 processor:211] processor starting...
[W 170516 17:45:07 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:07 __init__:54] redis DB must zero-based numeric index, using 0 instead
[I 170516 17:45:07 tornado_fetcher:638] fetcher starting...
[W 170516 17:45:07 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:07 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:07 __init__:54] redis DB must zero-based numeric index, using 0 instead
[I 170516 17:45:09 scheduler:782] scheduler.xmlrpc listening on 127.0.0.1:23333
[I 170516 17:45:09 scheduler:647] scheduler starting...
phantomjs fetcher running on port 25555
[I 170516 17:45:09 scheduler:586] in 5m: new:0,success:0,retry:0,failed:0
[W 170516 17:45:10 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:10 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:10 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:10 __init__:54] redis DB must zero-based numeric index, using 0 instead
[W 170516 17:45:10 __init__:54] redis DB must zero-based numeric index, using 0 instead
[I 170516 17:45:10 app:76] webui running on 0.0.0.0:5555

　　

 ///目前这块还有问题

安装supervisor，监控所有进程

supervisor用来监控pyspider进程，如果停止则立即启动，下载supervisor-3.3.1到/root目录下，并解压。

cd /root/supervisor-3.3.1
python setup.py install
或
pip install supervisor

创建默认的配置文件并设置

# /python2.7/bin/echo_supervisord_conf > /python2.7/conf/supervisor.conf

; Sample supervisor config file.
;
; For more information on the config file, please see:
; http://supervisord.org/configuration.html
;
; Notes:
;  - Shell expansion ("~" or "$HOME") is not supported.  Environment
;    variables can be expanded using this syntax: "%(ENV_HOME)s".
;  - Comments must have a leading space: "a=b ;comment" not "a=b;comment".

[unix_http_server]
file=/tmp/supervisor.sock   ; (the path to the socket file)
chmod=0700                 ; socket file mode (default 0700)
chown=root:root       ; socket file uid:gid owner
;username=user              ; (default is no username (open server))
;password=123               ; (default is no password (open server))

[inet_http_server]         ; inet (TCP) server disabled by default
port=127.0.0.1:9001        ; (ip_address:port specifier, *:port for all iface)
username=supervisor             ; (default is no username (open server))
password=123               ; (default is no password (open server))

[supervisord]
logfile=/tmp/supervisord.log ; (main log file;default $CWD/supervisord.log)
logfile_maxbytes=50MB        ; (max main logfile bytes b4 rotation;default 50MB)
logfile_backups=10           ; (num of main logfile rotation backups;default 10)
loglevel=info                ; (log level;default info; others: debug,warn,trace)
pidfile=/tmp/supervisord.pid ; (supervisord pidfile;default supervisord.pid)
nodaemon=false               ; (start in foreground if true;default false)
minfds=1024                  ; (min. avail startup file descriptors;default 1024)
minprocs=200                 ; (min. avail process descriptors;default 200)
;umask=022                   ; (process file creation umask;default 022)
;user=chrism                 ; (default is current user, required if root)
;identifier=supervisor       ; (supervisord identifier, default is 'supervisor')
;directory=/tmp              ; (default is not to cd during start)
;nocleanup=true              ; (don't clean up tempfiles at start;default false)
;childlogdir=/tmp            ; ('AUTO' child log dir, default $TEMP)
;environment=KEY="value"     ; (key value pairs to add to environment)
;strip_ansi=false            ; (strip ansi escape codes in logs; def. false)

; the below section must remain in the config file for RPC
; (supervisorctl/web interface) to work, additional interfaces may be
; added by defining them in separate rpcinterface: sections
[rpcinterface:supervisor]
supervisor.rpcinterface_factory = supervisor.rpcinterface:make_main_rpcinterface

[supervisorctl]
serverurl=unix:///tmp/supervisor.sock ; use a unix:// URL  for a unix socket
;serverurl=http://127.0.0.1:9001 ; use an http:// url to specify an inet socket
username=suppervisor             ; should be same as http_username if set
password=123                ; should be same as http_password if set
prompt=mysupervisor         ; cmd line prompt (default "supervisor")
history_file=~/.sc_history  ; use readline history if available

; The below sample program section shows all possible program subsection values,
; create one or more 'real' program: sections to be able to control them under
; supervisor.

;[program:theprogramname]
;command=/bin/cat              ; the program (relative uses PATH, can take args)
;process_name=%(program_name)s ; process_name expr (default %(program_name)s)
;numprocs=1                    ; number of processes copies to start (def 1)
;directory=/tmp                ; directory to cwd to before exec (def no cwd)
;umask=022                     ; umask for process (default None)
;priority=999                  ; the relative start priority (default 999)
;autostart=true                ; start at supervisord start (default: true)
;startsecs=1                   ; # of secs prog must stay up to be running (def. 1)
;startretries=3                ; max # of serial start failures when starting (default 3)
;autorestart=unexpected        ; when to restart if exited after running (def: unexpected)
;exitcodes=0,2                 ; 'expected' exit codes used with autorestart (default 0,2)
;stopsignal=QUIT               ; signal used to kill process (default TERM)
;stopwaitsecs=10               ; max num secs to wait b4 SIGKILL (default 10)
;stopasgroup=false             ; send stop signal to the UNIX process group (default false)
;killasgroup=false             ; SIGKILL the UNIX process group (def false)
;user=chrism                   ; setuid to this UNIX account to run the program
;redirect_stderr=true          ; redirect proc stderr to stdout (default false)
;stdout_logfile=/a/path        ; stdout log path, NONE for none; default AUTO
;stdout_logfile_maxbytes=1MB   ; max # logfile bytes b4 rotation (default 50MB)
;stdout_logfile_backups=10     ; # of stdout logfile backups (default 10)
;stdout_capture_maxbytes=1MB   ; number of bytes in 'capturemode' (default 0)
;stdout_events_enabled=false   ; emit events on stdout writes (default false)
;stderr_logfile=/a/path        ; stderr log path, NONE for none; default AUTO
;stderr_logfile_maxbytes=1MB   ; max # logfile bytes b4 rotation (default 50MB)
;stderr_logfile_backups=10     ; # of stderr logfile backups (default 10)
;stderr_capture_maxbytes=1MB   ; number of bytes in 'capturemode' (default 0)
;stderr_events_enabled=false   ; emit events on stderr writes (default false)
;environment=A="1",B="2"       ; process environment additions (def no adds)
;serverurl=AUTO                ; override serverurl computation (childutils)

; The below sample eventlistener section shows all possible
; eventlistener subsection values, create one or more 'real'
; eventlistener: sections to be able to handle event notifications
; sent by supervisor.

;[eventlistener:theeventlistenername]
;command=/bin/eventlistener    ; the program (relative uses PATH, can take args)
;process_name=%(program_name)s ; process_name expr (default %(program_name)s)
;numprocs=1                    ; number of processes copies to start (def 1)
;events=EVENT                  ; event notif. types to subscribe to (req'd)
;buffer_size=10                ; event buffer queue size (default 10)
;directory=/tmp                ; directory to cwd to before exec (def no cwd)
;umask=022                     ; umask for process (default None)
;priority=-1                   ; the relative start priority (default -1)
;autostart=true                ; start at supervisord start (default: true)
;startsecs=1                   ; # of secs prog must stay up to be running (def. 1)
;startretries=3                ; max # of serial start failures when starting (default 3)
;autorestart=unexpected        ; autorestart if exited after running (def: unexpected)
;exitcodes=0,2                 ; 'expected' exit codes used with autorestart (default 0,2)
;stopsignal=QUIT               ; signal used to kill process (default TERM)
;stopwaitsecs=10               ; max num secs to wait b4 SIGKILL (default 10)
;stopasgroup=false             ; send stop signal to the UNIX process group (default false)
;killasgroup=false             ; SIGKILL the UNIX process group (def false)
;user=chrism                   ; setuid to this UNIX account to run the program
;redirect_stderr=false         ; redirect_stderr=true is not allowed for eventlisteners
;stdout_logfile=/a/path        ; stdout log path, NONE for none; default AUTO
;stdout_logfile_maxbytes=1MB   ; max # logfile bytes b4 rotation (default 50MB)
;stdout_logfile_backups=10     ; # of stdout logfile backups (default 10)
;stdout_events_enabled=false   ; emit events on stdout writes (default false)
;stderr_logfile=/a/path        ; stderr log path, NONE for none; default AUTO
;stderr_logfile_maxbytes=1MB   ; max # logfile bytes b4 rotation (default 50MB)
;stderr_logfile_backups=10     ; # of stderr logfile backups (default 10)
;stderr_events_enabled=false   ; emit events on stderr writes (default false)
;environment=A="1",B="2"       ; process environment additions
;serverurl=AUTO                ; override serverurl computation (childutils)

; The below sample group section shows all possible group values,
; create one or more 'real' group: sections to create "heterogeneous"
; process groups.

;[group:thegroupname]
;programs=progname1,progname2  ; each refers to 'x' in [program:x] definitions
;priority=999                  ; the relative start priority (default 999)

; The [include] section can just contain the "files" setting.  This
; setting can list multiple files (separated by whitespace or
; newlines).  It can also contain wildcards.  The filenames are
; interpreted as relative to this file.  Included files *cannot*
; include files themselves.

;[include]
;files = relative/directory/*.ini
[group:pyspider]
programs=pyspider-fetcher,pyspider-processor

[program:pyspider-fetcher]
command=/python2.7/bin/pyspider -c /pyspider/config.json fetcher
autorestart=true
autostart=true
user=root
group=pyspider
stopasgroup=true

[program:pyspider-processor]
command=/python2.7/bin/pyspider -c /pyspider/config.json processor
autorestart=true
autostart=true
user=root
group=pyspider
stopasgroup=true
stderr_logfile=/var/Spider/Log/Process/spider_process_err.log
stdout_logfile=/var/Spider/Log/Process/spider_process_out.log

　　

 启动supervisor

 # supervisord -c /etc/supervisor.conf

 

注：config.json配置修改后需要重载

# supervisorctl reload

目前为止pyspider已安装完成

 

登陆pyspider

http://ip:5555/

  

 

 

排错：

ImportError: pycurl: libcurl link-time ssl backend (nss) is different from compile-time ssl backend (none/other)

# pip uninstall pycurl
# export PYCURL_SSL_LIBRARY=nss
# pip install pycurl

 

ImportError: No module named _sqlite3

# find / -name _sqlite*.so
/usr/lib64/python2.7/lib-dynload/_sqlite3.so
/usr/lib64/python2.7/site-packages/_sqlitecache.so

# cp /usr/lib64/python2.7/lib-dynload/_sqlite3.so /python2.7/lib/python2.7/lib-dynload/