search

samwize / python-email-crawler

Search on Google, and crawls for emails related to the result
292 stars 127 forks source link

sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None #2

Closed Jameslarkin closed 11 years ago

Jameslarkin commented 11 years ago

i can;t get the scrip to work, what does this mean ? :

"sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None "

the code i get

python email_crawler.py "south london photographers" james-larkins-MacBook-Pro:~ jameslarkin$ python email_crawler.py "south london photographers" /Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python: can't open file 'email_crawler.py': [Errno 2] No such file or directory james-larkins-MacBook-Pro:~ jameslarkin$ cd /users/python james-larkins-MacBook-Pro:python jameslarkin$ python email_crawler.py "south london photographers" Traceback (most recent call last): File "email_crawler.py", line 31, in db.connect() File "/Users/python/database.py", line 15, in connect self.connection = self.engine.connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1649, in connect return self._connection_cls(self, kwargs) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 59, in init self.connection = connection or engine.raw_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1707, in raw_connection return self.pool.unique_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 220, in unique_connection return _ConnectionFairy(self).checkout() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 425, in __init* rec = self._connection_record = pool._do_get() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 855, in _do_get return self._create_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 225, in _create_connection return _ConnectionRecord(self) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 318, in init self.connection = self.connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 368, in connect connection = self.__pool._creator() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect return dialect.connect(_cargs, _cparams) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 279, in connect return self.dbapi.connect(_cargs, *_cparams) sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None None james-larkins-MacBook-Pro:python jameslarkin$

samwize commented 11 years ago

You need to install sqlalchemy first.

On 20 Mar, 2013, at 10:44 PM, Jameslarkin notifications@github.com wrote:

i can;t get the scrip to work, what does this mean ? :

"sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None "

the code i get

python email_crawler.py "south london photographers" james-larkins-MacBook-Pro:~ jameslarkin$ python email_crawler.py "south london photographers" /Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python: can't open file 'email_crawler.py': [Errno 2] No such file or directory james-larkins-MacBook-Pro:~ jameslarkin$ cd /users/python james-larkins-MacBook-Pro:python jameslarkin$ python email_crawler.py "south london photographers" Traceback (most recent call last): File "email_crawler.py", line 31, in db.connect() File "/Users/python/database.py", line 15, in connect self.connection = self.engine.connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1649, in connect return self._connection_cls(self, *kwargs) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 59, in init self.connection = connection or engine.raw_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1707, in raw_connection return self.pool.unique_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 220, in unique_connection return ConnectionFairy(self).checkout() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 425, in init_ rec = self._connection_record = pool._do_get() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 855, in do_get return self._create_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 225, in _create_connection return _ConnectionRecord(self) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 318, in _init self.connection = self.__connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 368, in connect connection = self.pool._creator() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect return dialect.connect(_cargs, _cparams) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 279, in connect return self.dbapi.connect(_cargs, *_cparams) sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None None james-larkins-MacBook-Pro:python jameslarkin$

— Reply to this email directly or view it on GitHub.

Jameslarkin commented 11 years ago

i recently installed python 2.7.3 today i tried to install SQLAlchemy again to make sure its installed but i get the same problem ?

Last login: Thu Mar 21 08:29:14 on console james-larkins-MacBook-Pro:~ jameslarkin$ sqlalchemy -bash: sqlalchemy: command not found james-larkins-MacBook-Pro:~ jameslarkin$ easy_install SQLAlchemy Searching for SQLAlchemy Best match: SQLAlchemy 0.8.0 Adding SQLAlchemy 0.8.0 to easy-install.pth file

Using /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages Processing dependencies for SQLAlchemy Finished processing dependencies for SQLAlchemy james-larkins-MacBook-Pro:~ jameslarkin$ cd /users/python james-larkins-MacBook-Pro:python jameslarkin$ python email_crawler.py "south london photographers" Traceback (most recent call last): File "email_crawler.py", line 30, in db.connect() File "/Users/python/database.py", line 15, in connect self.connection = self.engine.connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1649, in connect return self._connection_cls(self, kwargs) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 59, in init self.connection = connection or engine.raw_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1707, in raw_connection return self.pool.unique_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 220, in unique_connection return _ConnectionFairy(self).checkout() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 425, in __init* rec = self._connection_record = pool._do_get() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 855, in _do_get return self._create_connection() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 225, in _create_connection return _ConnectionRecord(self) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 318, in init self.connection = self.connect() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 368, in connect connection = self.__pool._creator() File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect return dialect.connect(_cargs, _cparams) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 279, in connect return self.dbapi.connect(_cargs, *_cparams) sqlalchemy.exc.OperationalError: (OperationalError) unable to open database file None None james-larkins-MacBook-Pro:python jameslarkin$

samwize commented 11 years ago

My mistake. The sqlite file is not found because the file (and the directory) is not found.

I have fixed.