pymysqlTypeError:objectsupportingthebufferAPIrequired

使用python语言&＃xff0c;通过pymysql库访问mysql数据库(别问我为什么不用orm框架&＃xff0c;有些时候orm框架真的不如原生态的sql好用)&＃xff0c;在我本机运行是ok的&＃xff0c;但在另一同事机器运行失败&＃xff0c;报错如下&＃xff1a;

Traceback (most recent call last):File "D:/work//scripts/main.py", line 25, in biz_service.initialize("./config/config.yaml")File "D:\work\\scripts\biz\sync_security_service.py", line 57, in initializepassword&＃61;self._config.mysql.password,db&＃61;self._config.mysql.database)File "D:\work\scripts\env\lib\site-packages\pymysql\__init__.py", line 94, in Connectreturn Connection(*args, **kwargs)File "D:\work\scripts\env\lib\site-packages\pymysql\connections.py", line 325, in __init__self.connect()File "D:\work\scripts\env\lib\site-packages\pymysql\connections.py", line 599, in connectself._request_authentication()File "D:\work\scripts\env\lib\site-packages\pymysql\connections.py", line 817, in _request_authenticationauthresp &＃61; _auth.scramble_native_password(self.password, self.salt)File "D:\work\scripts\env\lib\site-packages\pymysql\_auth.py", line 39, in scramble_native_passwordstage1 &＃61; sha1_new(password).digest()File "D:\work\scripts\env\lib\hashlib.py", line 149, in __hash_newreturn _hashlib.new(name, data)
TypeError: object supporting the buffer API required

   开始以为是python版本和pymysql版本的问题&＃xff0c;后来换成一样的版本&＃xff0c;还是报错&＃xff01;&＃xff01;&＃xff01;&＃xff01;从上面的日志其实可以很清楚的看到错误的函数&＃xff1a;sync_security_service.py的第57行&＃xff08;不得不说&＃xff0c;详细的错误日志及堆栈是个好东东&＃xff09;&＃xff0c;而57行就是:

self._connect&＃61;pymysql.connect(host&＃61;self.mysql.ip,port&＃61;self.mysql.port,user&＃61;self.mysql.user&＃xff0c;password&＃61;self.mysql.password,db&＃61;self.mysql.database)

于是决定跟踪pymysql.connect函数到底干了什么~~~

在跟踪的过程中&＃xff0c;偶然发现&＃xff1a;self.mysql.password是一个整型&＃xff0c;竟然是一个整型&＃xff0c;密码应该是字符串类型&＃xff0c;怎么会是整型呢&＃xff1f;原来同事的密码是一串数字123456&＃xff0c;python在读配置文件过程中默认把123456转成了整型&＃xff0c;修改如下&＃xff1a;

self._connect&＃61;pymysql.connect(host&＃61;self.mysql.ip,port&＃61;self.mysql.port,user&＃61;self.mysql.user&＃xff0c;password&＃61;str(self.mysql.password),db&＃61;self.mysql.database)

再次运行&＃xff0c;发现问题解决。