pyspider配置mysql_pyspider安装

最新推荐文章于 2021-03-25 07:28:15 发布

图院长

最新推荐文章于 2021-03-25 07:28:15 发布

阅读量322

点赞数

文章标签： pyspider配置mysql

本文链接：https://blog.csdn.net/weixin_42360285/article/details/113299584

版权

本文详细介绍了在CentOS 7系统中，如何安装Python环境，配置并安装pyspider，包括依赖库的安装、MySQL数据库的配置、pyspider的安装步骤，以及启动和监控pyspider进程的设置。此外，还解决了可能出现的错误和排错方法。

摘要由CSDN通过智能技术生成

操作系统

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> 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

/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

[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

[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

[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

[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)