问题： win 系统下，python3+环境，写一个购物车程序，退出时打印商品价格，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-14/Shopping Cart.py", line 6, in <module>
print("您选择的商品价格为："+prices[buy+1])
TypeError: must be str, not int
答案：字符串不能跟整型合并，把需要合并的整型用str转换成字符串即可。
问题： win 系统下，python3+环境，在创建一个嵌套的字典时，执行后报错信息如下
"C:\Program Files\Python\Python36\python.exe" H:/Python培训/2017-09-18/level3.py
File "H:/Python培训/2017-09-18/level3.py", line 2
"福建省"{"福州"{"仓山区","晋安区","台江区"},
^
SyntaxError: invalid syntax
答案：键跟值之间必须要使用：隔开，加上：即可。
问题： win 系统下，python3+环境，在读取一个嵌套的字典时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-18/level3.py", line 14, in <module>
for i2 in level(choice1):
TypeError: 'dict' object is not callable
答案：字典取键的值时应该使用［］而不是（），（）改成［］即可。
问题： win 系统下，python3+环境，在引用一个变量时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-19/shopping car.py", line 22, in <module>
print(seller_username)
NameError: name 'seller_username' is not defined
答案：引用了一个不存在的变量，引用前需要先定义变量。
问题： win 系统下，python3+环境，在调用一个列表的值时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-19/shopping car.py", line 26, in <module>
if user_password == user_password_list(user_list.index(user_name)):
TypeError: 'list' object is not callable
答案：取列表的值时应该使用［］而不是（），把（）换成［］即可。
问题： win 系统下，python3+环境，在执行一个ｉｆ．．ｅｌｓｅ语句时，执行后报错信息如下
"C:\Program Files\Python\Python36\python.exe" "H:/Python培训/2017-09-19/shopping car.py"
File "H:/Python培训/2017-09-19/shopping car.py", line 40
elif choice == "q":
^
IndentationError: expected an indented block
答案：ｉｆ语句下面的代码块没写就运行，代码块没写时可使用ｐａｓｓ语句
问题： win 系统下，python3+环境，choice接收input的输入，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-19/shopping car.py", line 40, in <module>
if choice >=0 and choice<len(goods_list):
TypeError: '>=' not supported between instances of 'str' and 'int'
答案：数据类型错误，input输入的为字符串，字符串无法跟整型比较，使用int将字符串转换成整型即可。
问题： win 系统下，python3+环境，进行文件操作时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/2017-09-19/shopping car.py", line 56, in <module>
ba.write(bala)
TypeError: write() argument must be str, not int
答案：write写入必须为字符串，不能为整型，使用str将整型转换为字符串即可。
问题： win 系统下，python3+环境，使用split函数时，执行后报错信息如下
File "H:/Python培训/1.第一模块/作业/模拟登陆/login.py", line 6
x = line1.strip().split(,)
^
SyntaxError: invalid syntax
答案：split中的参数为字符串类型，必须加引号。
问题： win 系统下，python3+环境，写一个程序进行文件操作，读取文件时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/1.第一模块/作业/三级菜单/level3.py", line 2, in <module>
for line in f:
io.UnsupportedOperation: not readable
答案：打开文件时使用的是“a”追加模式，无法读取文件，将打开模式改为“r”即可。
问题： win 系统下，python3+环境，for循环一个字典时，执行后报错信息如下
File "H:/Python培训/1.第一模块/作业/三级菜单/level3.py", line 18
for y in level[choice]
^
SyntaxError: invalid syntax
答案：for循环语句末尾忘记加：，加上：即可。
问题： win 系统下，python3+环境，写一个程序对文件进行操作，返回文件大小时，执行后报错信息如下
Traceback (most recent call last):
File "H:/Python培训/1.第一模块/作业/购物车/shopping.py", line 22, in <module>
if os.path.getsize() == 0:
TypeError: getsize() missing 1 required positional argument: 'filename'
答案：os.path.getsize()的参数必须为具体的文件，指定具体的文件即可。
问题： win 系统下，python3+环境下，对使用列表下标读取列表中的值时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/员工信息系统/staff_info_test.py", line 93, in <module>
if update[-1].replace('"', "") == update_list[4]:
IndexError: list index out of range
答案：在取值时读取了错误的列表，下标超过了该列表的长度，读取正确的列表即可
问题： win 系统下，python3+环境下，使用isinstance()函数判断列表是否是可迭代对象时，执行后报错信息如下：
>>> isinstance([],Iterable)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 'Iterable' is not defined
答案：需要导入Iterable模块，执行from collections import Iterable即可
问题： win 系统下，python3+环境下，定义函数时使用非固定参数，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/2017-10-13/test1.py", line 22, in <module>
user()
File "H:/Python培训/2.第二模块/2017-10-13/test1.py", line 3, in deco
func(args, kwargs)
TypeError: user() takes 0 positional arguments but 2 were given
答案：函数中调用非固定参数时也必须使用*args,**kwargs的写法，错误中的func(args,kwargs)改成func(*args,**kwargs)即可
问题： win 系统下，python3+环境下，调用自定义模块时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/atm/bin/atm.py", line 6, in <module>
from core import main
ModuleNotFoundError: No module named 'core'
答案：忘记将模块所在路径加入path，使用sys.path.append将路径加入path即可
问题： win 系统下，python3+环境下，调用自定义模块时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/atm/bin/manage.py", line 10, in <module>
main.manage_run()
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\login.py", line 21, in login
logger.managelog(admin_name, "login", "success")
AttributeError: module 'core.logger' has no attribute 'managelog'
答案：调用时写错了函数名，改成正确的即可
问题： win 系统下，python3+环境下，打开一个文件进行操作时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/atm/bin/manage.py", line 7, in <module>
from core import main
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\main.py", line 25, in <module>
from core import manage_function
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\manage_function.py", line 8, in <module>
with open("%s/log/manage.log", "r") as f1:
FileNotFoundError: [Errno 2] No such file or directory: '%s/log/manage.log'
答案：忘记定义对%s进行定义，定义%s即可
问题： win 系统下，python3+环境下，写一个还款后计算剩余未还款金额的程序时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/atm/bin/atm.py", line 10, in <module>
main.user_run()
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\login.py", line 40, in login
func(*args, **kwargs)
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\main.py", line 49, in user_run
user_choice_list[user_choice]() # 根据选择的功能执行相应的函数
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\main.py", line 23, in repayment
user_function.repayment_function()
File "H:\Python培训\2.第二模块\作业\ATM\atm\core\user_function.py", line 59, in repayment_function
print("本月已还款%s，还需还款%s" % (repayment_sum, repayment_must - repayment_sum))
TypeError: unsupported operand type(s) for -: 'float' and 'str'
答案：两个变量相减时忘记转换数据类型，将一个变量的类型从字符串转成浮点型即可
问题： win 系统下，python3+环境下，调用一个装饰器时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/shopping_mall/bin/shopping_mall.py", line 7, in <module>
from core import main
File "H:\Python培训\2.第二模块\作业\ATM\shopping_mall\core\main.py", line 9, in <module>
@auth()
TypeError: auth() missing 1 required positional argument: 'func'
答案：调用装饰器时写成@auth()，调用时应该指向的是该装饰器的内存地址，把@auth后面的括号去掉即可
问题： win 系统下，python3+环境下，在读取一个json文件时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/2.第二模块/作业/ATM/shopping_mall/core/mall_function.py", line 7, in <module>
good_list = json.load(f)
File "C:\Program Files\Python\Python36\lib\json\__init__.py", line 299, in load
parse_constant=parse_constant, object_pairs_hook=object_pairs_hook, **kw)
File "C:\Program Files\Python\Python36\lib\json\__init__.py", line 354, in loads
return _default_decoder.decode(s)
File "C:\Program Files\Python\Python36\lib\json\decoder.py", line 339, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "C:\Program Files\Python\Python36\lib\json\decoder.py", line 355, in raw_decode
obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Expecting ',' delimiter: line 1 column 66 (char 65)
答案：json文件中的列表少了一个逗号，修改json文件即可
问题： win 系统下，python3+环境下，在使用正则模块进行匹配时，执行后报错信息如下：
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 're' is not defined
答案：忘记导入re模块，import re即可
问题： win 系统下，python3+环境下，写一个子类继承一个基类时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/2017-10-31/class_test3.py", line 27, in <module>
d = Husky("二哈", "2")
File "H:/Python培训/3.第三模块/2017-10-31/class_test3.py", line 20, in __init__
super(Dog, self).__init__(name, age)
TypeError: object.__init__() takes no parameters
答案：super()中的类写成基类，改为子类即可
问题： win 系统下，python3+环境下，写一个子类继承一个基类时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/2017-10-31/class_test3.py", line 27, in <module>
d = Husky("二哈", "2")
File "H:/Python培训/3.第三模块/2017-10-31/class_test3.py", line 22, in __init__
Dog.add_dog()
TypeError: add_dog() missing 1 required positional argument: 'self'
答案：调用基类的方法时少了self，加上self即可
问题： win 系统下，python3+环境下，写一个程序读取文件时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/作业/选课系统/bin/course_system.py", line 10, in <module>
main.run()
File "H:\Python培训\3.第三模块\作业\选课系统\core\main.py", line 47, in run
choice_list[choice]()
File "H:\Python培训\3.第三模块\作业\选课系统\core\main.py", line 10, in admin
with open("%s/db/admin.json", "r") as f:
FileNotFoundError: [Errno 2] No such file or directory: '%s/db/admin.json'
答案：路径中的%s忘记赋值，给%s赋值即可
问题： win 系统下，python3+环境下，写一个程序读取文件时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/作业/选课系统/bin/course_system.py", line 10, in <module>
main.Main.run()
File "H:\Python培训\3.第三模块\作业\选课系统\core\main.py", line 28, in run
choice_list[choice]()
File "H:\Python培训\3.第三模块\作业\选课系统\core\main.py", line 88, in student_login
student_func.StudentFunc.student_func()
File "H:\Python培训\3.第三模块\作业\选课系统\core\student_func.py", line 23, in student_func
choice_list[choice]()
File "H:\Python培训\3.第三模块\作业\选课系统\core\student_func.py", line 48, in choice_classes
with open("%s/db/student.text" % base_dir) as f:
FileNotFoundError: [Errno 2] No such file or directory: 'H:\\Python培训\\3.第三模块\\作业\\选课系统/db/student.text'
答案：忘记指定文件打开模式，指定打开模式即可
问题： win 系统下，python3+环境下，使用setattr设置一个方法，执行后报错信息如下：
Traceback (most recent call last):
2
File "F:/python/反射.py", line 20, in <module>
print(d.dog_talk())
TypeError: talk() missing 2 required positional arguments: 'self' and 'talk'
答案：dog_talk方法需要传入两个值，其中的self也需要传值，为方法传入对象本身和另外一个值即可。
问题： win 系统下，python3+环境下，写一个服务端程序，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/2017-11-08/socket_test_server.py", line 12, in <module>
print("%s连接服务端成功..." % address)
TypeError: not all arguments converted during string formatting
答案：conn, address = server.accept()中的address返回的是一个元组，故无法赋值给%s，只要将address中的一个项赋值给%s即可。
问题： win 系统下，python3+环境下，调用一个类的静态方法时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/作业/简单FTP_test/FTP_client.py", line 58, in <module>
ClientFunc.client_func()
File "H:/Python培训/3.第三模块/作业/简单FTP_test/FTP_client.py", line 18, in client_func
getattr(ClientFunc, choice_list[choice])()
TypeError: upload_file() missing 1 required positional argument: 'self'
答案：静态方法中的self没有去掉，所以需要传值，去掉self即可。
问题： win 系统下，python3+环境下，从服务端下载一个文件时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/3.第三模块/作业/简单FTP_test/FTP_client.py", line 184, in <module>
ClientFunc.client_func()
File "H:/Python培训/3.第三模块/作业/简单FTP_test/FTP_client.py", line 58, in client_func
getattr(ClientFunc, choice_list[choice])()
File "H:/Python培训/3.第三模块/作业/简单FTP_test/FTP_client.py", line 106, in download_file
file_list = pickle.loads(msg) # 打印FTP Server上的文件列表
_pickle.UnpicklingError: invalid load key, '\xe4'.
答案：下载的文件已经存在，所以报错。
问题： win 系统下，python3+环境下，写一个程序计算字符串的hash值，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/4.第四模块/作业/高级FTP/FTP_Server/bin/FTP_server.py", line 12, in <module>
main.ServerFunc.run()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\main.py", line 34, in run
getattr(ServerFunc, choice_list[choice])()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\main.py", line 18, in run_admin
admin_func.AdminFunc.admin_func()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\admin_func.py", line 90, in admin_func
go_back = getattr(AdminFunc, choice_list[choice])()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\admin_func.py", line 22, in add_user
user_info["pw"] = hashlib.sha256(password).hexdigest() # 密码加密并存入字典
TypeError: Unicode-objects must be encoded before hashing
答案：计算hash时传入的必须是byte类型，把字符串encode下即可解决
问题： win 系统下，python3+环境下，写一个程序使用socket发送字典时，执行后报错信息如下：
Exception happened during processing of request from ('127.0.0.1', 56173)
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 639, in process_request_thread
self.finish_request(request, client_address)
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 361, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 696, in __init__
self.handle()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\server_func.py", line 36, in handle
if self.data["REQ"] == "check_user":
TypeError: byte indices must be integers or slices, not str
答案：socket只能发送byte类型，把字典使用pickle进行序列化后即可发送
问题： win 系统下，python3+环境下，写一个程序使用socket发送字符串时，执行后报错信息如下：
Exception happened during processing of request from ('127.0.0.1', 53055)
Traceback (most recent call last):
用户ccc正在尝试上传文件...
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\socketserver.py", line 639, in process_request_thread
self.finish_request(request, client_address)
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\socketserver.py", line 361, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\socketserver.py", line 696, in __init__
self.handle()
File "F:\python\高级FTP\FTP_Server\core\server_func.py", line 166, in handle
getattr(self, data["REQ"])(data)
File "F:\python\高级FTP\FTP_Server\core\server_func.py", line 84, in put
self.request.sendall("ERROR：磁盘已满！无法上传文件！")
TypeError: a bytes-like object is required, not 'str'
答案：socket只能发送byte类型，把字符串encode下即可解决
问题： win 系统下，python3+环境下，写一个程序使用socket发送数字时，执行后报错信息如下：
Exception happened during processing of request from ('127.0.0.1', 54763)
正在接收文件....
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 639, in process_request_thread
self.finish_request(request, client_address)
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 361, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "C:\Program Files\Python\Python36\lib\socketserver.py", line 696, in __init__
self.handle()
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\server_func.py", line 196, in handle
getattr(self, data["REQ"])(data)
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\server_func.py", line 82, in put
self.receive_file(f, no_extension_name, file_name, file_size, file_md5)
File "H:\Python培训\4.第四模块\作业\高级FTP\FTP_Server\core\server_func.py", line 156, in receive_file
self.request.sendall(size)
TypeError: a bytes-like object is required, not 'int'
答案：socket也无法发送int类型的数字，使用pickle将数字序列化后即可发送
问题： win 系统下，python3+环境下，写一个程序使用paramiko模块通过SSH连接远程主机执行命令时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/4.第四模块/2017-11-25/paramiko_test.py", line 10, in <module>
stdout, stderr = ssh.exec_commond("df")
AttributeError: 'SSHClient' object has no attribute 'exec_commond'
答案：调用的方法写错了，ssh.exec_commond改为ssh.exec_command即可
问题： win 系统下，python3+环境下，写一个程序使用paramiko模块通过SSH连接远程主机执行命令时，执行后报错信息如下：
Traceback (most recent call last):
File "F:/python/2017-11-25/paramiko_sshclient_key.py", line 9, in <module>
ssh.connect(hostname="192.168.3.25", port=22, username="fangyu", pkey=rsa_key)
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\site-packages\paramiko\client.py", line 402, in connect
self, server_hostkey_name, server_key
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\site-packages\paramiko\client.py", line 768, in missing_host_key
'Server {!r} not found in known_hosts'.format(hostname)
paramiko.ssh_exception.SSHException: Server '192.168.3.25' not found in known_hosts
答案：没有将本机加入远程主机的know_hosts，使用ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())自动将本机加入远程主机的know_hosts即可
问题： win 系统下，python3+环境下，写一个程序启动一个进程时，执行后报错信息如下：
Traceback (most recent call last):
File "F:/python/2017-12-02/进程Manager.py", line 23, in <module>
p.join()
File "C:\Users\MAIMAI\AppData\Local\Programs\Python\Python36\lib\multiprocessing\process.py", line 120, in join
assert self._popen is not None, 'can only join a started process'
AssertionError: can only join a started process
答案：设置好进程之后忘记启动了，使用start()启动进程即可解决
问题： win 系统下，python3+环境下，写一个服务端接受客户端的连接程序，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/4.第四模块/2017-12-04/select_server.py", line 23, in <module>
print("来自%s的新连接..." % address)
TypeError: not all arguments converted during string formatting
答案：conn, address = server.accept()返回的address为一个元组，取元组的第一项即为IP地址
问题： win 系统下，python3+环境下，写一个正则表达式，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/作业/主机管理系统(RabbitMQ实现)/HostManage_Client/bin/client.py", line 12, in <module>
main.run()
File "H:\Python培训\5.第五模块\作业\主机管理系统(RabbitMQ实现)\HostManage_Client\core\main.py", line 29, in run
manage.manage_cmd()
File "H:\Python培训\5.第五模块\作业\主机管理系统(RabbitMQ实现)\HostManage_Client\core\manage_func.py", line 61, in manage_cmd
getattr(self, func)(cmd)
File "H:\Python培训\5.第五模块\作业\主机管理系统(RabbitMQ实现)\HostManage_Client\core\manage_func.py", line 14, in run
ip_list = re.findall("\d+.\d+.\d+.\d+")
TypeError: findall() missing 1 required positional argument: 'string'
答案：正则匹配时少了匹配对象，添加上要进行匹配的字符串即可。
问题： win 系统下，python3+环境下，使用pika模块接收RabbitMQ队列中的消息，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2017-12-13/简单rabbitmq_receive.py", line 19, in <module>
channel.basic_consume(callback)
TypeError: basic_consume() missing 1 required positional argument: 'queue'
答案：缺少了queue名参数，添加queue=“队列名”即可。
问题： win 系统下，python3+环境下，使用pika模块接收RabbitMQ队列中的消息，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2017-12-13/简单rabbitmq_receive.py", line 19, in <module>
channel.basic_consume(callback, queue="1")
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 1551, in basic_consume
consumer_callback=consumer_callback)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 1614, in _basic_consume_impl
self._flush_output(ok_result.is_ready)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 1250, in _flush_output
*waiters)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 455, in _flush_output
self._impl.ioloop.poll()
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\select_connection.py", line 245, in poll
self._poller.poll()
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\select_connection.py", line 718, in poll
self._dispatch_fd_events(fd_event_map)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\select_connection.py", line 625, in _dispatch_fd_events
handler(fileno, events)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\base_connection.py", line 395, in _handle_events
self._handle_read()
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\base_connection.py", line 449, in _handle_read
self._on_data_available(data)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\connection.py", line 1938, in _on_data_available
self._process_frame(frame_value)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\connection.py", line 2059, in _process_frame
if self._process_callbacks(frame_value):
File "C:\Program Files\Python\Python36\lib\site-packages\pika\connection.py", line 2040, in _process_callbacks
frame_value) # Args
File "C:\Program Files\Python\Python36\lib\site-packages\pika\callback.py", line 60, in wrapper
return function(*tuple(args), **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\callback.py", line 92, in wrapper
return function(*args, **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\callback.py", line 236, in process
callback(*args, **keywords)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 1316, in _on_channel_closed
method.reply_text)
pika.exceptions.ChannelClosed: (404, "NOT_FOUND - no queue '1' in vhost '/'")
答案：使用了一个不存在的queue名，配置正确的queue名即可。
问题： win 系统下，python3+环境下，使用pika模块连接远程主机上的RabbitMQ时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2017-12-15/rabbitmq_test.py", line 6, in <module>
conn = pika.BlockingConnection(pika.ConnectionParameters("192.168.0.231", 5672, "/", user))
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 374, in __init__
self._process_io_for_connection_setup()
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 414, in _process_io_for_connection_setup
self._open_error_result.is_ready)
File "C:\Program Files\Python\Python36\lib\site-packages\pika\adapters\blocking_connection.py", line 466, in _flush_output
raise maybe_exception
pika.exceptions.ProbableAuthenticationError: (403, 'ACCESS_REFUSED - Login was refused using authentication mechanism PLAIN. For details see the broker logfile.')
答案：RabbitMQ默认的guest用户无法用于远程登录，在RabbitMQ中添加一个新用户即可。
问题： win 系统下，python3+环境下，连接远程主机上的Redis时，执行后报错信息如下：
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 484, in connect
sock = self._connect()
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 541, in _connect
raise err
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 529, in _connect
sock.connect(socket_address)
ConnectionRefusedError: [WinError 10061] 由于目标计算机积极拒绝，无法连接。
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\site-packages\redis\client.py", line 667, in execute_command
connection.send_command(*args)
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 610, in send_command
self.send_packed_command(self.pack_command(*args))
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 585, in send_packed_command
self.connect()
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 489, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 10061 connecting to 192.168.0.231:6379. 由于目标计算机积极拒绝，无法连接。.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 484, in connect
sock = self._connect()
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 541, in _connect
raise err
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 529, in _connect
sock.connect(socket_address)
ConnectionRefusedError: [WinError 10061] 由于目标计算机积极拒绝，无法连接。
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2017-12-14/连接redis.py", line 6, in <module>
r.set("a", "aa")
File "C:\Program Files\Python\Python36\lib\site-packages\redis\client.py", line 1171, in set
return self.execute_command('SET', *pieces)
File "C:\Program Files\Python\Python36\lib\site-packages\redis\client.py", line 673, in execute_command
connection.send_command(*args)
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 610, in send_command
self.send_packed_command(self.pack_command(*args))
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 585, in send_packed_command
self.connect()
File "C:\Program Files\Python\Python36\lib\site-packages\redis\connection.py", line 489, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 10061 connecting to 192.168.0.231:6379. 由于目标计算机积极拒绝，无法连接。.
答案：Redis默认无法支持远程登录，只能本地登录，修改Reids的配置文件redis.conf中的bind 127.0.0.1为bind 0.0.0.0或你的IP即可。
问题： win 系统下，python3+环境下，使用SQLAlchemy在MySQL中写入数据时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2018-01-02/orm查询数据.py", line 20, in <module>
data = Session.query(Student).filter_by(name="gougou").first()
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2778, in first
ret = list(self[0:1])
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2570, in __getitem__
return list(res)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2899, in _execute_and_instances
close_with_result=True)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2908, in _get_bind_args
**kw
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\query.py", line 2890, in _connection_from_session
conn = self.session.connection(**kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\session.py", line 1025, in connection
bind = self.get_bind(mapper, clause=clause, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\orm\session.py", line 1387, in get_bind
', '.join(context)))
sqlalchemy.exc.UnboundExecutionError: Could not locate a bind configured on mapper Mapper|Student|student, SQL expression or this Session
答案：在实例化sessionmaker时忘记bind=engine了。
问题： win 系统下，python3+环境下，使用SQLAlchemy在MySQL中写入数据时，执行后报错信息如下：
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/2018-01-03/orm插入多条记录.py", line 17, in <module>
Base.metadata.create_all()
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\schema.py", line 4000, in create_all
bind = _bind_or_error(self)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\base.py", line 636, in _bind_or_error
raise exc.UnboundExecutionError(msg)
sqlalchemy.exc.UnboundExecutionError: MetaData object is not bound to an Engine or Connection. Execution can not proceed without a database to execute against.
答案：Base.metadata.create_all()忘记加engine，改成Base.metadata.create_all(engine)即可。
问题： win 系统下，python3+环境下，使用SQLAlchemy在MySQL中创建表时，执行后报错信息如下：
Traceback (most recent call last):
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2444, in visit_create_table
and not first_pk)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 245, in process
return obj._compiler_dispatch(self, **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2475, in visit_create_column
first_pk=first_pk
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 1131, in get_column_specification
column.type, type_expression=column)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 293, in process
return type_._compiler_dispatch(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2914, in visit_string
return self.visit_VARCHAR(type_, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 1538, in visit_VARCHAR
self.dialect.name)
sqlalchemy.exc.CompileError: VARCHAR requires a length on dialect mysql
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "H:/Python培训/5.第五模块/作业/堡垒机/Fortress/bin/fortress.py", line 10, in <module>
from core import main
File "H:\Python培训\5.第五模块\作业\堡垒机\Fortress\core\main.py", line 4, in <module>
from core import tables
File "H:\Python培训\5.第五模块\作业\堡垒机\Fortress\core\tables.py", line 18, in <module>
Base.metadata.create_all(engine)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\schema.py", line 4004, in create_all
tables=tables)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\engine\base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\engine\base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\ddl.py", line 757, in visit_metadata
_is_metadata_operation=True)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\engine\base.py", line 948, in execute
return meth(self, multiparams, params)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in _execute_ddl
if not self.schema_for_object.is_default else None)
File "<string>", line 1, in <lambda>
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\elements.py", line 442, in compile
return self._compiler(dialect, bind=bind, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\ddl.py", line 26, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 219, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 245, in process
return obj._compiler_dispatch(self, **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2455, in visit_create_table
(table.description, column.name, ce.args[0])
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\util\compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\util\compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2444, in visit_create_table
and not first_pk)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 245, in process
return obj._compiler_dispatch(self, **kwargs)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2475, in visit_create_column
first_pk=first_pk
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 1131, in get_column_specification
column.type, type_expression=column)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 293, in process
return type_._compiler_dispatch(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\sql\compiler.py", line 2914, in visit_string
return self.visit_VARCHAR(type_, **kw)
File "C:\Program Files\Python\Python36\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 1538, in visit_VARCHAR
self.dialect.name)
sqlalchemy.exc.CompileError: (in table 'tesetable', column 'name'): VARCHAR requires a length on dialect mysql
答案：表的字符型字段创建时没有指定长度，为该字段指定长度即可。
