Pyrit - Mysql Cluster not working

GoogleCodeExporter commented 8 years ago

Hi, i'm having an issue with pyrit, my setup is listed below.

2 x mysql cluster nodes
1 x HAProxy server - 192.168.1.101

Pyrit 0.4.0 (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://192.168.1.101:3306/pyrit'...  connected.
Checking workunits...
Traceback (most recent call last):
  File "/usr/local/bin/pyrit", line 6, in <module>
    pyrit_cli.Pyrit_CLI().initFromArgv()
  File "/usr/local/lib/python2.6/dist-packages/pyrit_cli.py", line 115, in initFromArgv
    func(self, **options)
  File "/usr/local/lib/python2.6/dist-packages/pyrit_cli.py", line 1358, in checkdb
    wu = storage.passwords[key]
  File "/usr/local/lib/python2.6/dist-packages/cpyrit/storage.py", line 1173, in __getitem__
    return q.filter(PAW2_DBObject.key == key).one()
  File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1528, in one
    raise orm_exc.NoResultFound("No row was found for one()")

I can connect to the server and import passwords, the issue is only when i try 
to connect to run certain commands, pyrit batch, pyrit check_db etc, importing 
passwords, creating essids works fine, now i'm trying to get to the bottom of 
this, i've been searching google for over a week now, my heads hurting so bad.

Original issue reported on code.google.com by djones.i...@gmail.com on 21 Aug 2012 at 12:09

GoogleCodeExporter commented 8 years ago

did you install python-sqlalchemy , u need that AND python-sqldb

Original comment by Testicul...@gmail.com on 26 Aug 2012 at 9:31

GoogleCodeExporter commented 8 years ago

Yes, the two mentions are installed

Original comment by djones.i...@gmail.com on 29 Aug 2012 at 11:09

GoogleCodeExporter commented 8 years ago

there is a problem with older version of sqlalchemy, I had this issue before, I 
recommend downloading the latest version from sourceforge and installing it

download it
untar it

python setup.py build && python setup.py install

Original comment by MarkyPoo...@gmail.com on 3 Sep 2012 at 8:05

ronnieman / pyrit

Pyrit - Mysql Cluster not working #404