问题现象

修改pg_hba.conf配置文件后,重启数据库启动失败.

--change
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all    omm      tpcc            *         trust   --add 新增行
host    all    all    xxx/32    sha256
host    all    all    xxx/32    sha256

重启数据库

gs_om -t restart
[root@mogdb01 ptk]# ./ptk cluster -n mogdb_cluster1 status
[   Cluster State   ]
cluster_name				: mogdb_cluster1
cluster_state   			: Unavailable
database_version			: MogDB 3.0.4 (build cc068866)

[  Datanode State   ]
   cluster_name  |  id  |     ip      | port  | user | nodename |      db_role      |           state           | upstream  
-----------------+------+-------------+-------+------+----------+-------------------+---------------------------+-----------
  mogdb_cluster1 | 6001 | 10.xx.26 | 26000 | omm  | dn_6001  | primary(previous) | Stopped                   | -         
                 | 6002 | 10.xx.27 | 26000 | omm  | dn_6002  | standby           | Need repair(Disconnected) | -    

问题分析

检查数据库日志

[root@mogdb01 dn_6001]# pwd
/opt/mogdb/log/pg_log/dn_6001

[root@mogdb01 dn_6001]# cat  postgresql-2023-06-13_172512.log
2023-06-13 17:25:12.350 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] LOG:  invalid authentication method "*"
2023-06-13 17:25:12.350 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] CONTEXT:  line 94 of configuration file "/opt/mogdb/data/pg_hba.conf"
2023-06-13 17:25:12.550 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] LOG:  invalid authentication method "*"
2023-06-13 17:25:12.550 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] CONTEXT:  line 94 of configuration file "/opt/mogdb/data/pg_hba.conf"
2023-06-13 17:25:12.751 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] LOG:  invalid authentication method "*"
2023-06-13 17:25:12.751 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] CONTEXT:  line 94 of configuration file "/opt/mogdb/data/pg_hba.conf"
2023-06-13 17:25:12.751 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] FATAL:  could not load pg_hba.conf
2023-06-13 17:25:12.772 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] LOG:  FiniNuma allocIndex: 0.
2023-06-13 17:25:12.773 [unknown] [unknown] localhost 70383494561808 0[0:0#0] 0 [BACKEND] LOG:  Gaussdb exit(1)

启动mogdb数据库,观察最新的数据库日志,可以发现明确指向hba配置文件中的第94行配置

修改Hba配置文件

--报错的配置信息如下
94 host    all    omm      tpcc            *         trust
--修改后
host    all    tpcc            *         trust

--重启库
[root@mogdb01 ptk]# ./ptk cluster restart --all

小结

1.数据库启动失败,可以通过安装路径,看数据库告警日志,mogdb与opengauss,pg是一个系列的，告警日志每次启动会创建一个最新的;
2.hba配置文件可以控制外部的连接访问的加密格式,如配置不当远程连接将无法访问mogdb数据库;