OCP部署META数据库失败

arlter · 2023 年7 月 2 日 07:50

【使用环境】测试环境
【 OB or 其他组件】社区版OCP
【使用版本】OB3.1.2 OCP3.1.1
【问题描述】最后一步，部署OCP过程中提示错误，安装失败。
【复现路径】执行 ./ocp_installer.sh install -c ocp.yaml
【问题现象及影响】
mysql -v -h192.168.100.154 -P2881 -uocp@ocp_meta -pAAbb__1122 -f -Docp < …/…/sqls/real_ocp2_template_variable_meta.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: mc_ocp_cluster_config.sql
sed ‘s/$VAR_TABLEGROUP_NAME/ocp_meta/g’ …/…/sqls/mc_ocp_cluster_config.sql > …/…/sqls/real_mc_ocp_cluster_config.sql
executing real sql script: real_mc_ocp_cluster_config.sql
mysql -v -h192.168.100.154 -P2881 -uocp@ocp_meta -pAAbb__1122 -f -Docp < …/…/sqls/real_mc_ocp_cluster_config.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: dynamic_config_properties.sql
sed ‘s/$VAR_TABLEGROUP_NAME/ocp_meta/g’ …/…/sqls/dynamic_config_properties.sql > …/…/sqls/real_dynamic_config_properties.sql
executing real sql script: real_dynamic_config_properties.sql
mysql -v -h192.168.100.154 -P2881 -uocp@ocp_meta -pAAbb__1122 -f -Docp < …/…/sqls/real_dynamic_config_properties.sql >>ocp-init.log 2>>ocp-init.err
finish to load sqls. see ocp-init.log for details
create database if not exists, database:ocp_monitor, host:192.168.100.154, user:ocp@ocp_monitor, port:2881
mysql -h192.168.100.154 -P2881 -uocp@ocp_monitor -pAAbb__11122 -e ‘create database if not exists ocp_monitor;’
catched exception running sql: create table test_db_writable_sdfkwhyeufbjss (c1 int primary key) with db_config: {‘database’: ‘ocp_monitor’, ‘backup_dbname_prefix’: ‘backup’, ‘host’: ‘192.168.100.154’, ‘user’: ‘ocp@ocp_monitor’, ‘password’: ‘AAbb__11122’, ‘port’: 2881}, Traceback (most recent call last):
File “create_metadb.py”, line 56, in run_sql_no_result
port=db_config[‘port’], database=db_config[‘database’], use_pure=True, autocommit=True)
File “/usr/lib64/python2.7/site-packages/mysql/connector/init.py”, line 177, in connect
return MySQLConnection(*args, **kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 104, in init
self.connect(**kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/abstracts.py”, line 781, in connect
self._open_connection()
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 288, in _open_connection
self._ssl, self._conn_attrs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 208, in _do_auth
self._auth_switch_request(username, password)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 252, in _auth_switch_request
raise errors.get_exception(packet)
ProgrammingError: 1045 (42000): Access denied for user ‘ocp’@‘xxx.xxx.xxx.xxx’ (using password: YES)

catched exception running sql: drop table if exists test_db_writable_sdfkwhyeufbjss with db_config: {‘database’: ‘ocp_monitor’, ‘backup_dbname_prefix’: ‘backup’, ‘host’: ‘192.168.100.154’, ‘user’: ‘ocp@ocp_monitor’, ‘password’: ‘AAbb__11122’, ‘port’: 2881}, Traceback (most recent call last):
File “create_metadb.py”, line 56, in run_sql_no_result
port=db_config[‘port’], database=db_config[‘database’], use_pure=True, autocommit=True)
File “/usr/lib64/python2.7/site-packages/mysql/connector/init.py”, line 177, in connect
return MySQLConnection(*args, **kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 104, in init
self.connect(**kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/abstracts.py”, line 781, in connect
self._open_connection()
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 288, in _open_connection
self._ssl, self._conn_attrs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 208, in _do_auth
self._auth_switch_request(username, password)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 252, in _auth_switch_request
raise errors.get_exception(packet)
ProgrammingError: 1045 (42000): Access denied for user ‘ocp’@‘xxx.xxx.xxx.xxx’ (using password: YES)

Traceback (most recent call last):
File “create_metadb.py”, line 721, in
init_ocp(filename)
File “create_metadb.py”, line 549, in init_ocp
if not test_db_writable(monitor_db_connect_info):
File “create_metadb.py”, line 525, in test_db_writable
run_sql_no_result(‘drop table if exists test_db_writable_sdfkwhyeufbjss’, db_config)
File “create_metadb.py”, line 56, in run_sql_no_result
port=db_config[‘port’], database=db_config[‘database’], use_pure=True, autocommit=True)
File “/usr/lib64/python2.7/site-packages/mysql/connector/init.py”, line 177, in connect
return MySQLConnection(*args, **kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 104, in init
self.connect(**kwargs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/abstracts.py”, line 781, in connect
self._open_connection()
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 288, in _open_connection
self._ssl, self._conn_attrs)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 208, in _do_auth
self._auth_switch_request(username, password)
File “/usr/lib64/python2.7/site-packages/mysql/connector/connection.py”, line 252, in _auth_switch_request
raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1045 (42000): Access denied for user ‘ocp’@‘xxx.xxx.xxx.xxx’ (using password: YES)
init ocp databse failed on 192.168.100.154

【附件】 ocp.ymal

arlter · 2023 年7 月 2 日 07:51

OCP_IP_ARRAY=(192.168.100.154) # （IP1 IP2 IP3）

SSH_USER=root # if not root, make sure remote user can use sudo without password admin ALL=(ALL) NOPASSWD:ALL
SSH_PORT=22
SSH_AUTH=password # can be password or pubkey
SSH_PASSWORD=‘AAbb__1122’ # password for passowrd auth, when use pubkey auth, is passphrase
#SSH_KEY_FILE=’/root/.ssh/id_rsa.pub’ # pubkey auth

OCP_METADB_HOST=192.168.100.154
OCP_METADB_PORT=2881
OCP_METADB_USER=ocp@ocp_meta
OCP_METADB_PASSWORD=‘AAbb__1122’ # password may contains special char, make sure correctly quote
OCP_METADB_DBNAME=ocp
OCP_MONITORDB_USER=ocp@ocp_monitor
OCP_MONITORDB_PASSWORD=‘AAbb__1122’ # password may contains special char, make sure correctly quote
OCP_MONITORDB_DBNAME=ocp_monitor
OCP_WEB_PORT=8080

OCP_LB_VIP= # HA OCP VIP
OCP_LB_VPORT= # HA OCP VPORT

OCP_IMAGE=/home/admin/data/files/ocp-3.1.1-ce/ocp.tar.gz # absoulute path of ocp image file
OCP_CPU=4
OCP_MEMORY=8G
OCP_LOG_DIR=/home/admin/data/logs/ocp

宁封 · 2023 年7 月 3 日 10:09

使用指定用户名和密码手动连接是否可以成功？
配置文件中 SSH_PASSWORD=‘AAbb__1122’ # password ，看起来单引号使用的并不正确，是展示问题，还是楼主的配置文件中也不正确？

菜鸟收割机 · 2023 年7 月 3 日 10:20

请下次记得上传附件，提供更多有效信息，比如各类日志。看你这报错，密码格式有误，请检查。

arlter · 2023 年7 月 3 日 17:45

这个文件是我粘过来的，很有可能就是引号错了。谢谢提醒

宁封 · 2023 年7 月 3 日 19:26

是引号的问题吗？

贺子 · 2024 年8 月 23 日 23:21

大佬解决了没？我是没有新建集群，直接复用了业务库ocenbase集群中新建一个租户，再学obcp3.*的考试

贺子 · 2024 年8 月 24 日 00:32

发现报错了，貌似只能填写系统sys租户下的账号和密码，改用Exception: The incoming user must belong to the sys tenant.后不报错了，
太恶心了官方文档一点提醒都没有，

  # OCP metadb 的配置信息，如果在上面配置了创建一个单独的 metadb 集群，会使用创建的集群的信息
  metadb:
    host: xxx.xxx.xxx.xxx
    port: 2883
    meta_user: meta_user@meta_tenant#obcluster
    meta_password: ******
    meta_database: meta_database
    monitor_user: monitor_user@monitor_tenant#obcluster
    monitor_password: ******
    monitor_database: monitor_database