酸酸R后端报错

达达大人

1. [root@xqs shadowsocksr]# python server.py
   
2. IPv6 support
   
3. 2018-05-13 14:58:54 INFO     util.py:85 loading libcrypto from libcrypto.so.10
   
4. 2018-05-13 14:58:54 INFO     asyncdns.py:324 dns server: [('8.8.8.8', 53), ('8.8.4.4', 53)]
   
5. 2018-05-13 14:58:54 INFO     shell.py:72 ShadowsocksR 3.4.0 2017-07-27
   
6. 2018-05-13 14:58:54 INFO     db_transfer.py:238 current process RLIMIT_NOFILE resource: soft 1024 hard 4096
   
7. 2018-05-13 14:58:55 ERROR    db_transfer.py:266 Traceback (most recent call last):
   
8.   File "/root/shadowsocksr/db_transfer.py", line 248, in thread_db
   
9.     rows = db_instance.pull_db_all_user()
   
10.   File "/root/shadowsocksr/db_transfer.py", line 383, in pull_db_all_user
    
11.     db=self.cfg["db"], charset='utf8')
    
12.   File "/usr/lib/python2.6/site-packages/cymysql/__init__.py", line 81, in Connect
    
13.     return Connection(*args, **kwargs)
    
14.   File "/usr/lib/python2.6/site-packages/cymysql/connections.py", line 237, in __init__
    
15.     self._connect()
    
16.   File "/usr/lib/python2.6/site-packages/cymysql/connections.py", line 403, in _connect
    
17.     self._request_authentication()
    
18.   File "/usr/lib/python2.6/site-packages/cymysql/connections.py", line 477, in _request_authentication
    
19.     auth_packet = MysqlPacket(self)
    
20.   File "/usr/lib/python2.6/site-packages/cymysql/packet.py", line 67, in __init__
    
21.     raise_mysql_exception(self.__data)
    
22.   File "/usr/lib/python2.6/site-packages/cymysql/err.py", line 142, in raise_mysql_exception
    
23.     _check_mysql_exception(errinfo)
    
24.   File "/usr/lib/python2.6/site-packages/cymysql/err.py", line 138, in _check_mysql_exception
    
25.     raise InternalError(errno, errorvalue)
    
26. InternalError: (1043, u'Bad handshake')

复制代码

1. [root@xqs ~]# pip --version
   
2. pip 1.3.1 from /usr/lib/python2.6/site-packages/pip-1.3.1-py2.6.egg (python 2.6)
   

复制代码

解决：
wget https://pypi.python.org/packages/source/p/pip/pip-9.0.1.tar.gz --no-check-certificate
tar -xzvf pip-9.0.1.tar.gz
cd pip-9.0.1
python setup.py install
pip install cymysql==0.9.4

因pip版本太高 无法指定安装低版本cymysql，降低pip版本指定安装低版本cymysql就行了
错误就是pip和 cymysql版本都太高

杰克王

达达大人 发表于 2018-5-14 13:20
应该是cmmysql版本的问题 换成了901后安装cymysql都是097版本 报错还是一样的

换成9.0.1 后再指定0.9.4也不行吗？
你这个问题基本可以确定是cymysql版本过高，问题就是如何降版本了。

ylovex75

cymysql模块

ylovex75

yum install -y python-setuptools  && easy_install pip && pip install cymysql  安装试试，看着好像是缺少cymysql

达达大人

ylovex75 发表于 2018-5-14 10:57
cymysql模块

安装过

1. [root@xqs ~]# pip install cymysql
   
2. Downloading/unpacking cymysql
   
3.   Downloading cymysql-0.9.7.tar.gz (42kB): 42kB downloaded
   
4.   Running setup.py egg_info for package cymysql
   
5. Installing collected packages: cymysql
   
6.   Running setup.py install for cymysql
   
7. Successfully installed cymysql
   
8. Cleaning up...

复制代码

ylovex75

达达大人 发表于 2018-5-14 10:59
安装过

那我就不知道了 后端除了阿里云遇到过缺少cymysql模块，别的没遇到过

chankin

pip uninstall cymysql
pip install cymysql==0.9.4

toyst

我遇到过，是cymysql版本问题，进后端目录，运行：pip install -r requirements.txt

achen0207

你是不是安装完了SSR以后又运行APT UPDATE GRADE了？

达达大人

toyst 发表于 2018-5-14 11:29
我遇到过，是cymysql版本问题，进后端目录，运行：pip install -r requirements.txt

Could not open requirements file: [Errno 2] No such file or directory: 'requirements.txt'
Storing complete log in /root/.pip/pip.log