Pyrit networking SQLAlchemy 0.6 Depreciation

[GoogleCodeExporter]

Pyrit SVN r212
Cuda module SVN r212
SQLAlchemy 0.6beta1

Problem: 12 lines of depreciation warnings every time pyrit is used.

Output:

/usr/lib/python2.5/site-packages/cpyrit/storage.py:709:
SADeprecationWarning: The Binary type has been renamed to LargeBinary.
  sql.Column('essid', sql.Binary(32), nullable=False),
/usr/lib/python2.5/site-packages/cpyrit/storage.py:718:
SADeprecationWarning: The Binary type has been renamed to LargeBinary.
  sql.Column('collection_buffer', sql.Binary(2**24-1), \
/usr/lib/python2.5/site-packages/cpyrit/storage.py:730:
SADeprecationWarning: The Binary type has been renamed to LargeBinary.
  sql.Column('results_buffer', sql.Binary(2**24-1), \

Connecting to storage at 'postgres://pyrit:@127.0.0.1/pyrit'... 
/usr/lib/python2.5/site-packages/SQLAlchemy-0.6beta1-py2.5.egg/sqlalchemy/engine
/url.py:99:
SADeprecationWarning: The SQLAlchemy PostgreSQL dialect has been renamed
from 'postgres' to 'postgresql'. The new URL format is
postgresql[+driver]://<user>:<pass>@<host>/<dbname>
  module = __import__('sqlalchemy.dialects.%s' % (dialect, )).dialects
connected.

Fix:

diff -Na -U 0 storage.py /usr/lib/python2.5/site-packages/cpyrit/storage.py
--- storage.py  2010-02-13 21:46:23.000000000 -0700
+++ /usr/lib/python2.5/site-packages/cpyrit/storage.py  2010-02-13
22:39:44.000000000 -0700
@@ -54 +54 @@
-    elif protocol in ('sqlite', 'mysql', 'postgres', 'oracle', 'mssql', \
+    elif protocol in ('sqlite', 'mysql', 'postgres', 'postgresql',
'oracle', 'mssql', \
@@ -709 +709 @@
-                        sql.Column('essid', sql.Binary(32), nullable=False),
+                        sql.Column('essid', sql.LargeBinary(32),
nullable=False),
@@ -718 +718 @@
-                        sql.Column('collection_buffer', sql.Binary(2**24-1), \
+                        sql.Column('collection_buffer',
sql.LargeBinary(2**24-1), \
@@ -730 +730 @@
-                        sql.Column('results_buffer', sql.Binary(2**24-1), \
+                        sql.Column('results_buffer',
sql.LargeBinary(2**24-1), \

testing: 

checked essid creation and deletion.
ran a verification on a DB of 40 million pmk's generated before the patch.
*did not check for compatibility of LargeBinary with SQLAlchemy versions
other than 0.6

Original issue reported on code.google.com by inetd.c...@lostconf.com on 14 Feb 2010 at 5:45

[GoogleCodeExporter]

Thanks for noting that; will be integrated.

Original comment by lukas.l...@gmail.com on 16 Feb 2010 at 12:35

• Changed state: Accepted
• Added labels: Priority-Low
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Original comment by lukas.l...@gmail.com on 21 Feb 2010 at 1:26

• Changed state: Done