santolp / pyrit

Automatically exported from code.google.com/p/pyrit
0 stars 0 forks source link

MySQL packet exceeds max_allowed_packet size #375

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Remote MySQL Database 
2. Some ESSID's and a large amount(3+million) of Passwords stored in DB
3. Running "pyrit batch" on that DB

What is the expected output?
Normal calculation of PMKs.

What do you see instead?
Start of calculation of PMKs.

Then>>
sqlalchemy.exc.OperationalError (1153, "Got a packet bigger than 
'max_allowed_packet' bytes")

file: cpyrit/storage.py
line: 1068
in: __setitem__
   session.commit()

What version of the product are you using? On what operating system?
pyrit:0.4.0
cpyrit-opencl: 0.4.0    
OS: Ubuntu 11.10
Catalyst : 11.11
AMD SDK: 2.5
MySQL: 5.0.33
Python: 2.7
GPU: HD6950

--Please provide any additional information below.--

http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

QUICK FIX __ DIRTY FIX
Drastically increase the max_allowed_packet variable in the remote MySQL Server.
(~16Mbyte in my case from initially 1Mbyte)

Suggestion
Handling the exception to inform the user what max packet size is sent by pyrit.
Suggesting the user to alter the MySQL server config or allow the user to 
change packet size sent by pyrit via its config.

Question
Is the size of the workunit in any way related to the packet size?

Request
Keep up the good work! ;)

Original issue reported on code.google.com by mtf...@gmx.net on 10 Dec 2011 at 11:35