<div dir="auto">Hi,<div dir="auto"><br></div><div dir="auto">the the server is just telling you:</div><div dir="auto"><br></div><div dir="auto">Hey, the user octavia connecting FROM xxx is not allowed.</div><div dir="auto"><br></div><div dir="auto">So check your privilege config on the db server (esp the host-field)</div><div dir="auto"><br></div><div dir="auto"> Fabian</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Bujack, Stefan <<a href="mailto:stefan.bujack@desy.de">stefan.bujack@desy.de</a>> schrieb am Di., 6. Okt. 2020, 15:23:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:#000000"><div>Hello,</div><div><br></div><div>thank you for your answer. The access for user octavia on host octavia04 is denied because my database host is <a href="http://maria-intern.desy.de" target="_blank" rel="noreferrer">maria-intern.desy.de</a> and there is no DB service on octavia04. But why is the script trying to populate the DB on localhost and not my DB host as I configured in the <span style="color:#000000;font-family:arial,helvetica,sans-serif;font-size:16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#ffffff;text-decoration-style:initial;text-decoration-color:initial;display:inline!important;float:none">/etc/octavia/octavia.conf?</span></div><div><br></div><div><span style="color:#000000;font-family:'Segoe UI','Lucida Sans',sans-serif;font-size:14.16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#fdfdfd;text-decoration-style:initial;text-decoration-color:initial;display:inline!important;float:none">"Access denied for user 'octavia'@'</span><span id="m_-3073065524891245737OBJ_PREFIX_DWT156_com_zimbra_url" style="color:darkblue;text-decoration:none;font-family:'Segoe UI','Lucida Sans',sans-serif;font-size:14.16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#fdfdfd"><span id="m_-3073065524891245737OBJ_PREFIX_DWT309_com_zimbra_url" style="color:darkblue;text-decoration:none"><span id="m_-3073065524891245737OBJ_PREFIX_DWT462_com_zimbra_url" style="color:darkblue;text-decoration:none"><span id="m_-3073065524891245737OBJ_PREFIX_DWT615_com_zimbra_url" style="color:darkgreen;text-decoration:underline"><a href="http://octavia04.desy.de/" rel="noreferrer nofollow noopener noreferrer noreferrer" style="color:darkgreen;text-decoration:underline" target="_blank">octavia04.desy.de</a></span></span></span></span><span style="color:#000000;font-family:'Segoe UI','Lucida Sans',sans-serif;font-size:14.16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#fdfdfd;text-decoration-style:initial;text-decoration-color:initial;display:inline!important;float:none">' </span></div><div><br></div><div> <span style="color:#000000;font-family:arial,helvetica,sans-serif;font-size:16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#ffffff;text-decoration-style:initial;text-decoration-color:initial;display:inline!important;float:none">persistence_connection = mysql+pymysql://</span><a href="http://octavia:woxSGH45cdZL1Sa4@maria-intern.desy.de/octavia_persistence" rel="noreferrer nofollow noopener noreferrer noreferrer" style="font-family:arial,helvetica,sans-serif;font-size:16px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:#ffffff" target="_blank">octavia:woxSGH45cdZL1Sa4@maria-intern.desy.de/octavia_persistence</a><div style="clear:both"><br></div>Greets Stefan Bujack<br><div style="clear:both"><br></div></div><div><br></div><hr id="m_-3073065524891245737zwchr"><div><b>From: </b>"Anna Taraday" <<a href="mailto:akamyshnikova@mirantis.com" target="_blank" rel="noreferrer">akamyshnikova@mirantis.com</a>><br><b>To: </b>"Stefan Bujack" <<a href="mailto:stefan.bujack@desy.de" target="_blank" rel="noreferrer">stefan.bujack@desy.de</a>><br><b>Cc: </b>"openstack-discuss" <<a href="mailto:openstack-discuss@lists.openstack.org" target="_blank" rel="noreferrer">openstack-discuss@lists.openstack.org</a>><br><b>Sent: </b>Monday, 5 October, 2020 08:58:43<br><b>Subject: </b>Re: [Octavia] Please help with amphorav2 provider populate db command<br></div><div><br></div><div><div dir="ltr">Hello,<br>Error in your trace shows "Access denied for user '<span>octavia</span>'<br>Please check that you followed all steps from setup guide and grant access for user.<br>[1] - <a href="https://docs.openstack.org/octavia/latest/install/install-amphorav2.html#prerequisites" rel="nofollow noopener noreferrer noreferrer" target="_blank">https://docs.openstack.org/octavia/latest/install/install-amphorav2.html#prerequisites</a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Sep 29, 2020 at 8:12 PM Bujack, Stefan <<a href="mailto:stefan.bujack@desy.de" rel="nofollow noopener noreferrer noreferrer" target="_blank">stefan.bujack@desy.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I think I need a little help again with the configuration of the amphora v2 provider. I get an error when I try to populate the database. It seems that the name of the localhost is used for the DB host and not what I configured in octavia.conf as DB host<br>
<br>
<br>
root@octavia04:~# octavia-db-manage --config-file /etc/octavia/octavia.conf upgrade_persistence<br>
2020-09-29 11:45:01.911 818313 WARNING taskflow.persistence.backends.impl_sqlalchemy [-] Engine connection (validate) failed due to '(pymysql.err.OperationalError) (1045, "Access denied for user 'octavia'@'<a href="http://octavia04.desy.de" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia04.desy.de</a>' (using password: YES)")<br>
(Background on this error at: <a href="http://sqlalche.me/e/e3q8" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">http://sqlalche.me/e/e3q8</a>)'<br>
2020-09-29 11:45:01.912 818313 CRITICAL octavia-db-manage [-] Unhandled error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'octavia'@'<a href="http://octavia04.desy.de" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia04.desy.de</a>' (using password: YES)")<br>
(Background on this error at: <a href="http://sqlalche.me/e/e3q8" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">http://sqlalche.me/e/e3q8</a>)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage Traceback (most recent call last):<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return fn()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 303, in unique_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return _ConnectionFairy._checkout(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 760, in _checkout<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage fairy = _ConnectionRecord.checkout(pool)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage rec = pool._do_get()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self._dec_overflow()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage compat.reraise(exc_type, exc_value, exc_tb)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise value<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self._create_connection()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return _ConnectionRecord(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self.__connect(first_connect_check=True)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 639, in __connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage connection = pool._invoke_creator(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return dialect.connect(*cargs, **cparams)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 482, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self.dbapi.connect(*cargs, **cparams)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/__init__.py", line 94, in Connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return Connection(*args, **kwargs)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 325, in __init__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self.connect()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 599, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self._request_authentication()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 861, in _request_authentication<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage auth_packet = self._read_packet()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage packet.check_error()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage err.raise_mysql_exception(self._data)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise errorclass(errno, errval)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage pymysql.err.OperationalError: (1045, "Access denied for user 'octavia'@'<a href="http://octavia04.desy.de" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia04.desy.de</a>' (using password: YES)")<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage The above exception was the direct cause of the following exception:<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage Traceback (most recent call last):<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/local/bin/octavia-db-manage", line 8, in <module><br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage sys.exit(main())<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/local/lib/python3.8/dist-packages/octavia/db/migration/cli.py", line 156, in main<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage CONF.command.func(config, <a href="http://CONF.command.name" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">CONF.command.name</a>)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/local/lib/python3.8/dist-packages/octavia/db/migration/cli.py", line 98, in do_persistence_upgrade<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage persistence.initialize()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/local/lib/python3.8/dist-packages/octavia/controller/worker/v2/taskflow_jobboard_driver.py", line 50, in initialize<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage with contextlib.closing(backend.get_connection()) as connection:<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/taskflow/persistence/backends/impl_sqlalchemy.py", line 335, in get_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage conn.validate(max_retries=self._max_retries)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/taskflow/persistence/backends/impl_sqlalchemy.py", line 394, in validate<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage _try_connect(self._engine)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/tenacity/__init__.py", line 311, in wrapped_f<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self.call(f, *args, **kw)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/tenacity/__init__.py", line 391, in call<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage do = self.iter(retry_state=retry_state)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/tenacity/__init__.py", line 338, in iter<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return fut.result()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3.8/concurrent/futures/_base.py", line 432, in result<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self.__get_result()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3.8/concurrent/futures/_base.py", line 388, in __get_result<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise self._exception<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/tenacity/__init__.py", line 394, in call<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage result = fn(*args, **kwargs)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/taskflow/persistence/backends/impl_sqlalchemy.py", line 391, in _try_connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage with contextlib.closing(engine.connect()):<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2209, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self._connection_cls(self, **kwargs)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 103, in __init__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage else engine.raw_connection()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2306, in raw_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self._wrap_pool_connect(<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2279, in _wrap_pool_connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage Connection._handle_dbapi_exception_noconnection(<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage util.raise_from_cause(sqlalchemy_exception, exc_info)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage reraise(type(exception), exception, tb=exc_tb, cause=cause)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise value.with_traceback(tb)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return fn()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 303, in unique_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return _ConnectionFairy._checkout(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 760, in _checkout<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage fairy = _ConnectionRecord.checkout(pool)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 492, in checkout<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage rec = pool._do_get()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/impl.py", line 139, in _do_get<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self._dec_overflow()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage compat.reraise(exc_type, exc_value, exc_tb)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise value<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/impl.py", line 136, in _do_get<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self._create_connection()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 308, in _create_connection<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return _ConnectionRecord(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 437, in __init__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self.__connect(first_connect_check=True)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/pool/base.py", line 639, in __connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage connection = pool._invoke_creator(self)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return dialect.connect(*cargs, **cparams)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 482, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return self.dbapi.connect(*cargs, **cparams)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/__init__.py", line 94, in Connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage return Connection(*args, **kwargs)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 325, in __init__<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self.connect()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 599, in connect<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage self._request_authentication()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 861, in _request_authentication<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage auth_packet = self._read_packet()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage packet.check_error()<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage err.raise_mysql_exception(self._data)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage raise errorclass(errno, errval)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'octavia'@'<a href="http://octavia04.desy.de" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia04.desy.de</a>' (using password: YES)")<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage (Background on this error at: <a href="http://sqlalche.me/e/e3q8" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">http://sqlalche.me/e/e3q8</a>)<br>
2020-09-29 11:45:01.912 818313 ERROR octavia-db-manage<br>
<br>
<br>
<br>
root@octavia04:~# cat /etc/octavia/octavia.conf<br>
[DEFAULT]<br>
transport_url = rabbit://<a href="mailto:openstack%3Apassword@rabbit-intern.desy.de" rel="nofollow noopener noreferrer noreferrer" target="_blank">openstack:password@rabbit-intern.desy.de</a><br>
use_journal = True<br>
[api_settings]<br>
bind_host = 0.0.0.0<br>
bind_port = 9876<br>
[certificates]<br>
cert_generator = local_cert_generator<br>
ca_certificate = /etc/octavia/certs/server_ca.cert.pem<br>
ca_private_key = /etc/octavia/certs/server_ca.key.pem<br>
ca_private_key_passphrase = passphrase<br>
[controller_worker]<br>
amp_image_owner_id = f89517ee676f4618bd55849477442aca<br>
amp_image_tag = amphora<br>
amp_ssh_key_name = octaviakey<br>
amp_secgroup_list = 2236e82c-13fe-42e3-9fcf-bea43917f231<br>
amp_boot_network_list = 9f7fefc4-f262-4d8d-9465-240f94a7e87b<br>
amp_flavor_id = 200<br>
network_driver = allowed_address_pairs_driver<br>
compute_driver = compute_nova_driver<br>
amphora_driver = amphora_haproxy_rest_driver<br>
client_ca = /etc/octavia/certs/client_ca.cert.pem<br>
[database]<br>
connection = mysql+pymysql://<a href="http://octavia:password@maria-intern.desy.de/octavia" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia:password@maria-intern.desy.de/octavia</a><br>
[haproxy_amphora]<br>
client_cert = /etc/octavia/certs/client.cert-and-key.pem<br>
server_ca = /etc/octavia/certs/server_ca.cert.pem<br>
[health_manager]<br>
bind_port = 5555<br>
bind_ip = 172.16.0.2<br>
controller_ip_port_list = <a href="http://172.16.0.2:5555" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">172.16.0.2:5555</a><br>
[keystone_authtoken]<br>
www_authenticate_uri = <a href="https://keystone-intern.desy.de:5000/v3" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">https://keystone-intern.desy.de:5000/v3</a><br>
auth_url = <a href="https://keystone-intern.desy.de:5000/v3" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">https://keystone-intern.desy.de:5000/v3</a><br>
memcached_servers = <a href="http://nova-intern.desy.de:11211" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">nova-intern.desy.de:11211</a><br>
auth_type = password<br>
project_domain_name = default<br>
user_domain_name = default<br>
project_name = service<br>
username = octavia<br>
password = password<br>
service_token_roles_required = True<br>
[oslo_messaging]<br>
topic = octavia_prov<br>
[service_auth]<br>
auth_url = <a href="https://keystone-intern.desy.de:5000/v3" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">https://keystone-intern.desy.de:5000/v3</a><br>
memcached_servers = <a href="http://nova-intern.desy.de:11211" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">nova-intern.desy.de:11211</a><br>
auth_type = password<br>
project_domain_name = Default<br>
user_domain_name = Default<br>
project_name = service<br>
username = octavia<br>
password = password<br>
[task_flow]<br>
persistence_connection = mysql+pymysql://<a href="http://octavia:woxSGH45cdZL1Sa4@maria-intern.desy.de/octavia_persistence" rel="noreferrer nofollow noopener noreferrer noreferrer" target="_blank">octavia:woxSGH45cdZL1Sa4@maria-intern.desy.de/octavia_persistence</a><br>
jobboard_backend_driver = 'redis_taskflow_driver'<br>
jobboard_backend_hosts = 10.254.28.113<br>
jobboard_backend_port = 6379<br>
jobboard_backend_password = password<br>
jobboard_backend_namespace = 'octavia_jobboard'<br>
<br>
<br>
<br>
root@octavia04:~# octavia-db-manage current<br>
2020-09-29 12:02:23.159 819432 INFO alembic.runtime.migration [-] Context impl MySQLImpl.<br>
2020-09-29 12:02:23.160 819432 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.<br>
fbd705961c3a (head)<br>
<br>
<br>
<br>
We have an Openstack Ussuri deployment on Ubuntu 20.04.<br>
<br>
<br>
Thanks in advance,<br>
<br>
Stefan Bujack<br>
<br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr">Regards,<div>Ann Taraday</div><div>Mirantis, Inc</div></div></div></div></div><br></div></div></div></blockquote></div>