[MSNoise] Problem creating database.

Oscar Alberto Castro Artola oscar.cas.art at gmail.com
Thu Jun 22 18:56:43 UTC 2017


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


More information about the MSNoise mailing list