sql2 = “insert into posts(key_int,title_desc,videos,ok) values (%s,%s,%s,%s)” try: cursor.execute(sql2, (kid,tdjson,ytbjson,1)) conn.commit() sql1 = “update mainkeys set ok=1 where id = ‘%s'” % (kid) cursor.execute(sql2) conn.commit() except: conn.rollback()
if “xc3” in firstname: firstnames = firstname.encode().decode(‘unicode_escape’)
pip install Pillow #coding=utf-8 from PIL import Image im = Image.open(‘3.jpeg’).convert(“RGB”) im.save(“3.webp”, “WEBP”)
Traceback (most recent call last): File “/root/doms/dnsall2.py”, line 24, in s.connect((domain, 443)) File “/usr/lib/python3.9/ssl.py”, line 1342, in connect self._real_connect(addr, False) File “/usr/lib/python3.9/ssl.py”, line 1333, in _real_connect self.do_handshake() File “/usr/lib/python3.9/ssl.py”, line 1309, in do_handshake self._sslobj.do_handshake() ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1123) ““““““““““““““` 指定cafile地址 ctx = ssl.create_default_context(cafile = “/etc/ssl/certs/ca-certificates.crt”)
这个其实跟选用的python版本的关系不大，主要原因是因为每次使用 pip install 命令下载插件的时候，下载的都是最新的版本，比如下载requests插件，它会自动的将依赖的urllib3这个插件也安装，然后依赖的插件版本太高，就导致了这个报错的问题。 所以说，一般遇到这种莫名其妙的问题的时候，可以先去看一下是不是插件的问题导致的，解决措施就是 将urllib3插件的版本降低就可以，当然，直接在安装requests插件的时候，选择用低版本也可以解决这个问题。比如用下面的命令指定版本进行安装： pip install requests==2.20
import requests session = requests.session() login_html = session.post(login_url, headers = login_headers, data = login_data, timeout = 30, allow_redirects=False) sub_html = session.post(sub_url, headers = sub_headers, data = sub_data, timeout = 30)
import socket def get_host_ip(): try: s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM) s.connect((“8.8.8.8”, 80)) ip = s.getsockname()[0] finally: s.close() return ip if __name__ == “__main__”: ip=get_host_ip()