Hello List,
after installing Qlustar 10, I've tried to connect to the cluster via the GUI. However, I am unable to generate the necessary token:
# qluman-cli --gencert -o cert ERROR:client.cli.network:client.cli.network.Cluster.__init__(): could not connect to server Error: No such user: 'admin' ERROR:qlunet4.Node:Channel[('zmq_version_info', 1)].do_recv(): exception in request generator Traceback (most recent call last): File "/usr/lib/python3/dist-packages/qluman-10/qluman-cli.py", line 1274, in gencert db.users.lookup(field="name", val=user) File "/usr/lib/python3/dist-packages/qluman-10/common/types.py", line 1678, in lookup raise KeyError KeyError
Checking the logs, there seems to be something wrong with qlumand and/or its database (see below). Any ideas?
Thanks a lot,
A.
syslog excerpt:
May 9 15:03:52 cl-head systemd[1]: qluman-server.service: Service hold-off time over, scheduling restart. May 9 15:03:52 cl-head systemd[1]: Stopped Qlustar Management server. May 9 15:03:52 cl-head systemd[1]: Started Qlustar Management server. May 9 15:03:52 cl-head qlumand[4428]: 2018-05-09 15:03:52,718 [4429] INFO#011__main__ May 9 15:03:52 cl-head qlumand[4428]: - Starting Qluman main server: qlumand. May 9 15:03:52 cl-head qlumand[4428]: 2018-05-09 15:03:52,719 [4429] INFO#011server.admin May 9 15:03:52 cl-head qlumand[4428]: - Qlumand running with address beosrv-c / external cl-head May 9 15:03:52 cl-head qlumand[4428]: 2018-05-09 15:03:52,823 [4429] INFO#011server.db.DBData May 9 15:03:52 cl-head qlumand[4428]: - DbVersion = 10.0.0 [expected 10.0.1] May 9 15:03:52 cl-head qlumand[4428]: 2018-05-09 15:03:52,824 [4429] ERROR#011server.db.DBData#011 Probably already have column: May 9 15:03:52 cl-head qlumand[4428]: Traceback (most recent call last): May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context May 9 15:03:52 cl-head qlumand[4428]: context) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute May 9 15:03:52 cl-head qlumand[4428]: cursor.execute(statement, parameters) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute May 9 15:03:52 cl-head qlumand[4428]: self._handle_result(self._connection.cmd_query(stmt)) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query May 9 15:03:52 cl-head qlumand[4428]: result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result May 9 15:03:52 cl-head qlumand[4428]: raise errors.get_exception(packet) May 9 15:03:52 cl-head qlumand[4428]: mysql.connector.errors.ProgrammingError: 1060 (42S21): Duplicate column name 'net_config_name_id' May 9 15:03:52 cl-head qlumand[4428]: The above exception was the direct cause of the following exception: May 9 15:03:52 cl-head qlumand[4428]: Traceback (most recent call last): May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 190, in add_column May 9 15:03:52 cl-head qlumand[4428]: engine.execute("ALTER TABLE {0} ADD COLUMN {1} {2} NOT NULL DEFAULT '{3}'".format(table_name, column_name, column_type, default)) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1991, in execute May 9 15:03:52 cl-head qlumand[4428]: return connection.execute(statement, *multiparams, **params) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 906, in execute May 9 15:03:52 cl-head qlumand[4428]: return self._execute_text(object, multiparams, params) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text May 9 15:03:52 cl-head qlumand[4428]: statement, parameters May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context May 9 15:03:52 cl-head qlumand[4428]: context) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception May 9 15:03:52 cl-head qlumand[4428]: exc_info May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause May 9 15:03:52 cl-head qlumand[4428]: reraise(type(exception), exception, tb=exc_tb, cause=exc_value) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in reraise May 9 15:03:52 cl-head qlumand[4428]: raise value.with_traceback(tb) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context May 9 15:03:52 cl-head qlumand[4428]: context) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute May 9 15:03:52 cl-head qlumand[4428]: cursor.execute(statement, parameters) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute May 9 15:03:52 cl-head qlumand[4428]: self._handle_result(self._connection.cmd_query(stmt)) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query May 9 15:03:52 cl-head qlumand[4428]: result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result May 9 15:03:52 cl-head qlumand[4428]: raise errors.get_exception(packet) May 9 15:03:52 cl-head qlumand[4428]: sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1060 (42S21): Duplicate column name 'net_config_name_id' [SQL: "ALTER TABLE Nic2NicProps ADD COLUMN net_config_name_id INTEGER UNSIGNED NOT NULL DEFAULT '1'"] May 9 15:03:52 cl-head qlumand[4428]: 2018-05-09 15:03:52,835 [4429] ERROR#011server.db.DBData#011Don't know how to update database format 10.0.0 to 10.0.1 May 9 15:03:52 cl-head qlumand[4428]: Traceback (most recent call last): May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 369, in __init__ May 9 15:03:52 cl-head qlumand[4428]: self.sess = db_updates[db_version.params](self.DB, self.sess, global_props) May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 337, in db_update_10_0_0 May 9 15:03:52 cl-head qlumand[4428]: db_set_version(global_props, "10.0.1") May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 174, in db_set_version May 9 15:03:52 cl-head qlumand[4428]: entry = global_props.lookup(field="name", val="DbVersion") May 9 15:03:52 cl-head qlumand[4428]: File "/usr/lib/python3/dist-packages/qluman-10/common/types.py", line 1678, in lookup May 9 15:03:52 cl-head qlumand[4428]: raise KeyError May 9 15:03:52 cl-head qlumand[4428]: KeyError