1.Openstack创建提供者网络时候报错

# openstack network create  --share --external   --provider-physical-network provider   --provider-network-type flat provider]

2020-08-12 15:55:11.859 7938 ERROR oslo.service.loopingcall ProgrammingError: (pymysql.err.ProgrammingError) (1146, u”Table ‘neutron.agents’ doesn’t exist”) [SQL: u’SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents.binary AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load, agents.resources_synced AS agents_resources_synced \nFROM agents \nWHERE agents.admin_state_up IN (%(admin_state_up_1)s)’] [parameters: {u’admin_state_up_1′: 1}] (Background on this error at: http://sqlalche.me/e/f405)

需要将数据库设置为utf8格式

[root@controller ~]# cat /etc/my.cnf.d/openstack.cnf 
[mysqld]
bind-address=192.168.10.11

default-storage-engine=innodb
innodb_file_per_table=on
max_connections=4096
collation-server=utf8_general_ci
character-set-server=utf8

配置完成后，重新执行此页面的sql语句：
https://docs.openstack.org/neutron/stein/install/controller-install-rdo.html

# su -s /bin/sh -c "neutron-db-manage --config-file /etc/neutron/neutron.conf \
  --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head" neutron