search

spring / uberserver

uberserver, a matchmaking/chat lobby server for the spring rts project
https://springrts.com/wiki/Uberserver
Other
33 stars 38 forks source link

sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'lobbydev'@'localhost' to database 'lobbydev'") #304

Closed silentwings closed 5 years ago

silentwings commented 5 years ago

2019-02-07 07:46:19 INFO server.:36 Starting uberserver... 2019-02-07 07:46:19 INFO server.:48 Using 25 client handling thread(s). 2019-02-07 07:47:41 INFO DataHandler.detectIp:466 Detecting local IP: 2019-02-07 07:47:41 INFO DataHandler.detectIp:468 78.46.100.157 2019-02-07 07:47:41 INFO DataHandler.detectIp:470 Detecting online IP: 2019-02-07 07:47:41 INFO DataHandler.detectIp:478 78.46.100.157 2019-02-07 07:47:41 INFO server.:36 Starting uberserver... 2019-02-07 07:47:41 INFO server.:48 Using 25 client handling thread(s). duplicate line in bad_sites.txt: bagslap.com Awaiting UDP messages on port 7001 Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1044, in _do_get return self._pool.get(wait, self._timeout) File "/usr/lib/python3/dist-packages/sqlalchemy/util/queue.py", line 145, in get raise Empty sqlalchemy.util.queue.Empty

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect return fn() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 376, in connect return _ConnectionFairy._checkout(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 713, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 480, in checkout rec = pool._do_get() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get self._dec_overflow() File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get return self._create_connection() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection return _ConnectionRecord(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 449, in init self.connection = self.connect() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 607, in connect connection = self.pool._invoke_creator(self) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect return dialect.connect(*cargs, *cparams) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 385, in connect return self.dbapi.connect(cargs, **cparams) File "/usr/lib/python3/dist-packages/MySQLdb/init.py", line 81, in Connect return Connection(*args, **kwargs) File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204, in init super(Connection, self).init__(*args, **kwargs2) _mysql_exceptions.OperationalError: (1044, "Access denied for user 'lobbydev'@'localhost' to database 'lobbydev'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "server.py", line 50, in _root.init() File "/home/lobbydev/uberserver/DataHandler.py", line 113, in init self.userdb = SQLUsers.UsersHandler(self, self.engine) File "/home/lobbydev/uberserver/SQLUsers.py", line 338, in init metadata.create_all(engine) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 3748, in create_all tables=tables) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1855, in _run_visitor with self._optional_conn_ctx_manager(connection) as conn: File "/usr/lib/python3.5/contextlib.py", line 59, in enter return next(self.gen) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1848, in _optional_conn_ctx_manager with self.contextual_connect() as conn: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2039, in contextual_connect self._wrap_pool_connect(self.pool.connect, None), File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect e, dialect, self) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1405, in _handle_dbapi_exception_noconnection exc_info File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 185, in reraise raise value.with_traceback(tb) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect return fn() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 376, in connect return _ConnectionFairy._checkout(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 713, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 480, in checkout rec = pool._do_get() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get self._dec_overflow() File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get return self._create_connection() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection return _ConnectionRecord(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 449, in init self.connection = self.connect() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 607, in connect connection = self.pool._invoke_creator(self) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect return dialect.connect(*cargs, *cparams) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 385, in connect return self.dbapi.connect(cargs, **cparams) File "/usr/lib/python3/dist-packages/MySQLdb/init.py", line 81, in Connect return Connection(*args, **kwargs) File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204, in init super(Connection, self).init__(*args, **kwargs2) sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'lobbydev'@'localhost' to database 'lobbydev'")

abma commented 5 years ago

fixed