No db access allowed in nova-compute:

[men]

[root@controller ~]# cat /etc/redhat-release
CentOS Linux release 8.4.2105

version:
      openstack-v

Nova log does not continue to output now. I wonder if it is normal?
nova-compute.log:
2021-09-16 10:03:47.613 8421 INFO nova.virt.vmwareapi.driver [req-c92bd574-1257-4c64-bd1f-a28a09a6c337 - - - - -] VMware vCenter version: 7.0.2
2021-09-16 10:03:51.152 8421 INFO nova.compute.provider_config [req-c92bd574-1257-4c64-bd1f-a28a09a6c337 - - - - -] No provider configs found in /etc/nova/provider_config/. If files are present, ensure the Nova process has access.
2021-09-16 10:03:51.183 8421 ERROR nova.cmd.common [req-ea168173-cff4-478b-b172-e9a80b2b9fb7 - - - - -] No db access allowed in nova-compute: File "/usr/bin/nova-compute", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python3.6/site-packages/nova/cmd/compute.py", line 59, in main
    topic=compute_rpcapi.RPC_TOPIC)
  File "/usr/lib/python3.6/site-packages/nova/service.py", line 265, in create
    utils.raise_if_old_compute()
  File "/usr/lib/python3.6/site-packages/nova/utils.py", line 1069, in raise_if_old_compute
    ctxt, ['nova-compute'])
  File "/usr/lib/python3.6/site-packages/nova/objects/service.py", line 554, in get_minimum_version_all_cells
    binaries)
  File "/usr/lib/python3.6/site-packages/nova/context.py", line 545, in scatter_gather_all_cells
    fn, *args, **kwargs)
  File "/usr/lib/python3.6/site-packages/nova/context.py", line 433, in scatter_gather_cells
    with target_cell(context, cell_mapping) as cctxt:
  File "/usr/lib64/python3.6/contextlib.py", line 81, in __enter__
    return next(self.gen)
  File "/usr/lib/python3.6/site-packages/nova/context.py", line 393, in target_cell
    set_target_cell(cctxt, cell_mapping)
  File "/usr/lib/python3.6/site-packages/nova/context.py", line 366, in set_target_cell
    get_or_set_cached_cell_and_set_connections()
  File "/usr/lib/python3.6/site-packages/oslo_concurrency/lockutils.py", line 360, in inner
    return f(*args, **kwargs)
  File "/usr/lib/python3.6/site-packages/nova/context.py", line 354, in get_or_set_cached_cell_and_set_connections
    db_connection_string)
  File "/usr/lib/python3.6/site-packages/nova/db/api.py", line 79, in create_context_manager
    return IMPL.create_context_manager(connection=connection)
  File "/usr/lib/python3.6/site-packages/nova/cmd/common.py", line 44, in __call__
    stacktrace = "".join(traceback.format_stack())

2021-09-16 10:03:51.184 8421 WARNING nova.utils [req-ea168173-cff4-478b-b172-e9a80b2b9fb7 - - - - -] This service is configured for access to the API database but is not allowed to directly access the database. You should run this service without the [api_database]/connection config option. The service version check will only query the local cell.: nova.exception.DBNotAllowed: nova-compute attempted direct database access which is not allowed by policy
2021-09-16 10:03:51.196 8421 WARNING oslo_config.cfg [req-ea168173-cff4-478b-b172-e9a80b2b9fb7 - - - - -] Deprecated: Option "auth_strategy" from group "api" is deprecated for removal (
The only non-default choice, ``noauth2``, is for internal development and
testing purposes only and should not be used in deployments. This option and
its middleware, NoAuthMiddleware[V2_18], will be removed in a future release.
). Its value may be silently ignored in the future.
2021-09-16 10:03:51.199 8421 WARNING oslo_config.cfg [req-ea168173-cff4-478b-b172-e9a80b2b9fb7 - - - - -] Deprecated: Option "api_servers" from group "glance" is deprecated for removal (
Support for image service configuration via standard keystoneauth1 Adapter
options was added in the 17.0.0 Queens release. The api_servers option was
retained temporarily to allow consumers time to cut over to a real load
balancing solution.
). Its value may be silently ignored in the future.
2021-09-16 10:03:51.214 8421 INFO nova.service [-] Starting compute node (version 22.2.2-1.el8)
2021-09-16 10:03:51.279 8421 INFO nova.compute.manager [req-873204ac-6c81-49e2-8bb0-90aae7c73c43 - - - - -] Looking for unclaimed instances stuck in BUILDING status for nodes managed by this host

[root@controller ~]# openstack compute service list
+----+----------------+------------+----------+---------+-------+----------------------------+
| ID | Binary | Host | Zone | Status | State | Updated At |
+----+----------------+------------+----------+---------+-------+----------------------------+
| 4 | nova-conductor | controller | internal | enabled | up | 2021-09-16T02:01:16.000000 |
| 6 | nova-scheduler | controller | internal | enabled | up | 2021-09-16T02:01:16.000000 |
| 8 | nova-compute | controller | nova | enabled | up | 2021-09-16T02:01:22.000000 |
+----+----------------+------------+----------+---------+-------+----------------------------+

[root@controller ~]# mysql -unova -pNOVA_DBPASS -b "nova_api" -h controller -e "show databases;"
+--------------------+
| Database |
+--------------------+
| information_schema |
| nova |
| nova_api |
| nova_cell0 |
+--------------------+

[Balazs Gibizer (balazs-gibizer)]

As the WARNING suggests in the log you should not have [api_database]/connection configuration for the nova-compute service. Remove that configuration then start the compute again.

[men (keyi)]

I am in all in one mode. How should I configure it? When I turn on debug = true, it can work normally