jslhs / pyrit

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

fail to import dictionary to MySql on CentOS 5.5 #308

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Using Centos 5.5 and type the following command to import password but no 
success
pyrit -u mysql://root:root@127.0.0.1/pyrit -i pass.txt import_passwords
Does it only work on Ubuntu? Any1 can import in CentOS 5.5 mysql?

What is the expected output? What do you see instead?
Connecting to storage at 'mysql://127.0.0.1/pyrit'...  Traceback (most recent 
call last):
  File "/usr/local/bin/pyrit", line 6, in <module>
    pyrit_cli.Pyrit_CLI().initFromArgv()
  File "/usr/local/lib/python2.7/site-packages/pyrit_cli.py", line 114, in initFromArgv
    options['storage'] = self._getStorage(storage_url)
  File "/usr/local/lib/python2.7/site-packages/pyrit_cli.py", line 229, in _getStorage
    storage = cpyrit.storage.getStorage(url)
  File "/usr/local/lib/python2.7/site-packages/cpyrit/storage.py", line 132, in getStorage
    return SQLStorage(url)
  File "/usr/local/lib/python2.7/site-packages/cpyrit/storage.py", line 996, in __init__
    self.engine = sql.create_engine(url, echo=False)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py", line 263, in create_engine
    return strategy.create(*args, **kwargs)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 64, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/usr/local/lib/python2.7/site-packages/sqlalchemy/connectors/mysqldb.py", line 52, in dbapi
    return __import__('MySQLdb')
ImportError: No module named MySQLdb

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

Please provide any additional information below.

Only work on ubuntu for using MySQLdb to import dictionary to db?

Original issue reported on code.google.com by StephenY...@gmail.com on 8 May 2011 at 5:28

GoogleCodeExporter commented 8 years ago
Is there a performance benefit to use MySQL or sqlite over just the standard 
file:///?

Original comment by GrantWSa...@gmail.com on 8 May 2011 at 12:39

GoogleCodeExporter commented 8 years ago
Using a SQL-database instead of the filesystem will give you some benefits:
    Real ACID-compliance, backup- and load-balancing-features.
    Multiple Pyrit-clients can operate on the same database at the same time over the network.
    Meta- and binary-data are (possibly) stored independent of each other, making the database easier to query and operate on. 

Original comment by StephenY...@gmail.com on 8 May 2011 at 1:42

GoogleCodeExporter commented 8 years ago
How about size? I think pyrit compress the data when your using the file:/// 
option or default storage in the blobspace.

Original comment by GrantWSa...@gmail.com on 8 May 2011 at 3:41

GoogleCodeExporter commented 8 years ago
As the error message says: you need the bindings for mysql<->python installed. 
see CentOS' package-repository. 

Original comment by lukas.l...@gmail.com on 12 May 2011 at 6:51