<div dir="ltr">Greetings -<div><br></div><div>I recently installed Opensips v3.3 on a CentOS Linux physical server via yum. When I attempt to create the Opensips databases using opensips-cli, I am constantly getting errors and the databases are not created. I have provided the screen output from running "opensips-cli -f /etc/opensips/opensips-cli.cfg -x database create" below:</div><div><br></div><div># opensips-cli -f /etc/opensips/opensips-cli.cfg -x database create<br>DEBUG: Loaded module 'database'<br>DEBUG: running in non-interactive mode database create []<br>DEBUG: running command 'create' '[]'<br>DEBUG: db_name: 'opensips'<br>Password for admin MySQL user (root): <br>DEBUG: read password: '<password>'<br>DEBUG: admin DB URL: 'mysql://root:<password>@localhost'<br>DEBUG: DB URL: 'mysql://opensips:opensipsrw@localhost'<br>DEBUG: connecting to mysql://root:<password>@localhost<br>Traceback (most recent call last):<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 1122, in _do_get<br>    return self._pool.get(wait, self._timeout)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/queue.py", line 145, in get<br>    raise Empty<br>sqlalchemy.util.queue.Empty<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2141, in _wrap_pool_connect<br>    return fn()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 328, in unique_connection<br>    return _ConnectionFairy._checkout(self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout<br>    fairy = _ConnectionRecord.checkout(pool)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout<br>    rec = pool._do_get()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get<br>    self._dec_overflow()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__<br>    compat.reraise(exc_type, exc_value, exc_tb)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise<br>    raise value<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get<br>    return self._create_connection()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection<br>    return _ConnectionRecord(self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 461, in __init__<br>    self.__connect(first_connect_check=True)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 661, in __connect<br>    exec_once(self.connection, self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/event/attr.py", line 246, in exec_once<br>    self(*args, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/event/attr.py", line 256, in __call__<br>    fn(*args, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 1321, in go<br>    return once_fn(*arg, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 181, in first_connect<br>    dialect.initialize(c)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", line 1632, in initialize<br>    default.DefaultDialect.initialize(self, connection)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 249, in initialize<br>    self.get_isolation_level(connection.connection)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", line 1496, in get_isolation_level<br>    cursor.execute('SELECT @@tx_isolation')<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 255, in execute<br>    self.errorhandler(self, exc, value)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler<br>    raise errorvalue<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 252, in execute<br>    res = self._query(query)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 378, in _query<br>    db.query(q)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/connections.py", line 280, in query<br>    _mysql.connection.query(self, query)<br>_mysql_exceptions.OperationalError: (1193, "Unknown system variable 'tx_isolation'")<br><br>The above exception was the direct cause of the following exception:<br><br>Traceback (most recent call last):<br>  File "/usr/lib/python3.6/site-packages/opensipscli/db.py", line 208, in __init__<br>    self.__conn = self.__engine.connect().\<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2085, in connect<br>    return self._connection_cls(self, **kwargs)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 90, in __init__<br>    if connection is not None else engine.raw_connection()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2171, in raw_connection<br>    self.pool.unique_connection, _connection)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2145, in _wrap_pool_connect<br>    e, dialect, self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception_noconnection<br>    exc_info<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause<br>    reraise(type(exception), exception, tb=exc_tb, cause=cause)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 185, in reraise<br>    raise value.with_traceback(tb)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2141, in _wrap_pool_connect<br>    return fn()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 328, in unique_connection<br>    return _ConnectionFairy._checkout(self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 766, in _checkout<br>    fairy = _ConnectionRecord.checkout(pool)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 516, in checkout<br>    rec = pool._do_get()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 1138, in _do_get<br>    self._dec_overflow()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__<br>    compat.reraise(exc_type, exc_value, exc_tb)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise<br>    raise value<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 1135, in _do_get<br>    return self._create_connection()<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 333, in _create_connection<br>    return _ConnectionRecord(self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 461, in __init__<br>    self.__connect(first_connect_check=True)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/pool.py", line 661, in __connect<br>    exec_once(self.connection, self)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/event/attr.py", line 246, in exec_once<br>    self(*args, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/event/attr.py", line 256, in __call__<br>    fn(*args, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 1321, in go<br>    return once_fn(*arg, **kw)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 181, in first_connect<br>    dialect.initialize(c)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", line 1632, in initialize<br>    default.DefaultDialect.initialize(self, connection)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 249, in initialize<br>    self.get_isolation_level(connection.connection)<br>  File "/usr/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", line 1496, in get_isolation_level<br>    cursor.execute('SELECT @@tx_isolation')<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 255, in execute<br>    self.errorhandler(self, exc, value)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler<br>    raise errorvalue<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 252, in execute<br>    res = self._query(query)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 378, in _query<br>    db.query(q)<br>  File "/usr/lib64/python3.6/site-packages/MySQLdb/connections.py", line 280, in query<br>    _mysql.connection.query(self, query)<br>sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1193, "Unknown system variable 'tx_isolation'")<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br>  File "/bin/opensips-cli", line 9, in <module><br>    run_console()<br>  File "/bin/opensips-cli", line 6, in run_console<br>    main.main()<br>  File "/usr/lib/python3.6/site-packages/opensipscli/main.py", line 78, in main<br>    sys.exit(shell.cmdloop())<br>  File "/usr/lib/python3.6/site-packages/opensipscli/cli.py", line 247, in cmdloop<br>    ret = self.run_command(module, command, modifiers, params)<br>  File "/usr/lib/python3.6/site-packages/opensipscli/cli.py", line 409, in run_command<br>    return mod[0].__invoke__(cmd, params, modifiers)<br>  File "/usr/lib/python3.6/site-packages/opensipscli/module.py", line 36, in __invoke__<br>    return f(params, modifiers)<br>  File "/usr/lib/python3.6/site-packages/opensipscli/modules/database.py", line 598, in do_create<br>    db = self.get_db(admin_url if engine != 'sqlite' else db_url, db_name)<br>  File "/usr/lib/python3.6/site-packages/opensipscli/modules/database.py", line 871, in get_db<br>    return osdb(db_url, db_name)<br>  File "/usr/lib/python3.6/site-packages/opensipscli/db.py", line 233, in __init__<br>    raise osdbError("unable to connect to the database")<br>opensipscli.db.osdbError: unable to connect to the database<br></div><div><br></div><div>The contents of the opensips-cli.cfg file are as follows:</div><div><br></div><div>[default]<br>database_modules: ALL<br><br>log_level: DEBUG<br><br>database_admin_url: mysql://root@localhost<br><br>database_name: opensips<br>database_url: mysql://opensips:opensipsrw@localhost<br>database_path: /usr/share/opensips/<br>communication_type: fifo<br>fifo_file: /var/run/opensips/opensips_fifo<br></div><div><br></div><div>The OS is CentOS 7 x86, and the version of MySql installed on the server is MySQL Community Server v8.0.34.</div><div><br></div><div>Any advice or assistance would be greatly appreciated!</div><div><br></div><div>Regards,</div><div>Brian</div><div><br></div><div><br></div></div>