Hello,
I am migrating my projects to a new and faster Linux computer. Currently I
am working with MSNoise 1.5 and everything works fine except for one thing:
I have created a new database usgin phpmyadmin (browser interface) but when
I run *msnoise install *I get the following error:
Traceback (most recent call last):
File "/usr/local/anaconda/bin/msnoise", line 11, in <module>
sys.exit(run())
File
"/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/msnoise.py",
line 717, in run
cli(obj={})
File "/usr/local/anaconda/lib/python2.7/site-packages/click/core.py",
line 722, in __call__
return self.main(*args, **kwargs)
File "/usr/local/anaconda/lib/python2.7/site-packages/click/core.py",
line 697, in main
rv = self.invoke(ctx)
File "/usr/local/anaconda/lib/python2.7/site-packages/click/core.py",
line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/anaconda/lib/python2.7/site-packages/click/core.py",
line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/anaconda/lib/python2.7/site-packages/click/core.py",
line 535, in invoke
return callback(*args, **kwargs)
File
"/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/msnoise.py",
line 211, in install
main()
File
"/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s000installer.py",
line 93, in main
Base.metadata.create_all(engine)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/sql/schema.py",
line 3934, in create_all
tables=tables)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1928, in _run_visitor
with self._optional_conn_ctx_manager(connection) as conn:
File "/usr/local/anaconda/lib/python2.7/contextlib.py", line 17, in
__enter__
return self.gen.next()
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1921, in _optional_conn_ctx_manager
with self.contextual_connect() as conn:
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2112, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2151, in _wrap_pool_connect
e, dialect, self)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1465, in _handle_dbapi_exception_noconnection
exc_info
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 2147, in _wrap_pool_connect
return fn()
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
387, in connect
return _ConnectionFairy._checkout(self)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
766, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
516, in checkout
rec = pool._do_get()
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
1138, in _do_get
self._dec_overflow()
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py",
line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
1135, in _do_get
return self._create_connection()
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
333, in _create_connection
return _ConnectionRecord(self)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
461, in __init__
self.__connect(first_connect_check=True)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/pool.py", line
651, in __connect
connection = pool._invoke_creator(self)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py",
line 105, in connect
return dialect.connect(*cargs, **cparams)
File
"/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 393, in connect
return self.dbapi.connect(*cargs, **cparams)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/__init__.py", line
90, in Connect
return Connection(*args, **kwargs)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/connections.py",
line 706, in __init__
self.connect()
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/connections.py",
line 932, in connect
self._request_authentication()
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/connections.py",
line 1152, in _request_authentication
auth_packet = self._read_packet()
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/connections.py",
line 1014, in _read_packet
packet.check_error()
File
"/usr/local/anaconda/lib/python2.7/site-packages/pymysql/connections.py",
line 393, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/anaconda/lib/python2.7/site-packages/pymysql/err.py",
line 107, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045,
u"Access denied for user 'oscar'@'localhost' (using password:
YES)")
The database created has my username on it with all privileges. I hope you
can help me!
Thank you!
Oscar