Unknown Problem, need solution, SQL Issues

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Pyrit Batch
2. Pyrit Eval

I have two separate errors that seem to be sql based

root@katmai:/var/www# pyrit eval
Pyrit 0.4.1-dev (svn r308) (C) 2008-2011 Lukas Lueg http://pyrit.googlecode.com
This code is distributed under the GNU General Public License v3+

Connecting to storage at 'mysql://localhost/pyrit'...  connected.
Querying... Traceback (most recent call last):
  File "/usr/bin/pyrit", line 6, in <module>
    pyrit_cli.Pyrit_CLI().initFromArgv()
  File "/usr/lib/python2.5/site-packages/pyrit_cli.py", line 117, in initFromArgv
    func(self, **options)
  File "/usr/lib/python2.5/site-packages/pyrit_cli.py", line 325, in eval_results
    pwcount, essid_results = storage.getStats()
  File "/usr/lib/python2.5/site-packages/cpyrit/storage.py", line 960, in getStats
    q = session.query(sql.func.sum(PAW2_DBObject.numElems))
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line 763, in query
    q = self._query_cls(mapper_or_class, self, **kwargs)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 68, in __init__
    self.__init_mapper(_class_to_mapper(class_or_mapper, entity_name=entity_name))
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 74, in __init_mapper
    self.table = self._from_obj = self.mapper.mapped_table
AttributeError: 'DefaultCompiler' object has no attribute 'mapped_table'

========================================
And then
========================================

root@katmai:/var/www# pyrit batch
Pyrit 0.4.1-dev (svn r308) (C) 2008-2011 Lukas Lueg http://pyrit.googlecode.com
This code is distributed under the GNU General Public License v3+

Connecting to storage at 'mysql://localhost/pyrit'...  connected.
Traceback (most recent call last):
  File "/usr/bin/pyrit", line 6, in <module>
    pyrit_cli.Pyrit_CLI().initFromArgv()
  File "/usr/lib/python2.5/site-packages/pyrit_cli.py", line 117, in initFromArgv
    func(self, **options)
  File "/usr/lib/python2.5/site-packages/pyrit_cli.py", line 801, in batchprocess
    for cur_essid in essids:
  File "/usr/lib/python2.5/site-packages/cpyrit/storage.py", line 353, in unfinishedESSIDs
    for e in self.essids:
  File "/usr/lib/python2.5/site-packages/cpyrit/storage.py", line 991, in __iter__
    essids = session.query(ESSID_DBObject.essid)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line 763, in query
    q = self._query_cls(mapper_or_class, self, **kwargs)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 68, in __init__
    self.__init_mapper(_class_to_mapper(class_or_mapper, entity_name=entity_name))
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/util.py", line 399, in _class_to_mapper
    return class_or_mapper.compile()
AttributeError: 'InstrumentedAttribute' object has no attribute 'compile'

What version of the product are you using? On what operating system?

Linux katmai 2.6.24-19-server #1 SMP Wed Jun 18 15:18:00 UTC 2008 i686 GNU/Linux
Pyrit 0.4.1-dev (svn r308) 

Original issue reported on code.google.com by MrNicho...@gmail.com on 7 Jun 2011 at 1:01

[GoogleCodeExporter]

Installed Latest Python-SQLalchemy, Problems solved - Close Ticket, thanks!

http://sourceforge.net/projects/sqlalchemy/files/sqlalchemy/0.7.1/SQLAlchemy-0.7
.1.tar.gz

Original comment by MrNicho...@gmail.com on 7 Jun 2011 at 1:05

[GoogleCodeExporter]

Original comment by lukas.l...@gmail.com on 8 Jun 2011 at 4:09

• Changed state: WontFix