访问mongodb BI,提示 Unknown database 'zdanalysis'

2024-07-16T09:05:05.788+0800 I NETWORK [conn3] connection accepted from 43.153.30.*:39706 #3 (1 connection now open)
2024-07-16T09:05:05.788+0800 I NETWORK [conn3] writing initial handshake
2024-07-16T09:05:05.788+0800 I NETWORK [conn3] reading handshake response
2024-07-16T09:05:05.790+0800 I NETWORK [conn3] negotiating ssl
2024-07-16T09:05:05.790+0800 I CONTROL Enabling OpenSSL’s FIPS mode false
2024-07-16T09:05:05.796+0800 I NETWORK [conn3] ssl connection established
2024-07-16T09:05:05.796+0800 I NETWORK [conn3] client provided connection attributes _runtime_version:21.0.3, _client_version:8.0.31, _client_license:GPL, _runtime_vendor:Alpine, _client_name:MySQL Connector/J
2024-07-16T09:05:05.796+0800 I NETWORK [conn3] configuring client authentication for principal dbuser
2024-07-16T09:05:05.796+0800 I NETWORK [conn3] sending auth switch request for mysql_clear_password
2024-07-16T09:05:05.796+0800 I NETWORK [conn3] reading auth switch response
2024-07-16T09:05:05.797+0800 I NETWORK [conn3] authenticating client response with mysql_clear_password
2024-07-16T09:05:05.807+0800 I NETWORK [conn3] successfully authenticated as principal dbuser on zdanalysis
2024-07-16T09:05:05.810+0800 I NETWORK [conn3] loading privilege information for current user
2024-07-16T09:05:05.812+0800 I NETWORK [conn3] connected to MongoDB 6.0.14, git version: 25225db95574916fecab3af75b184409f8713aef
2024-07-16T09:05:05.813+0800 E NETWORK [conn3] handshake error: ERROR 1043 (08S01): error using database zdanalysis: ERROR 1049 (42000): Unknown database ‘zdanalysis’
2024-07-16T09:05:05.813+0800 I NETWORK [conn3] end connection 43.153.30.150:39706 (0 connections now open)

这个报错信息很清晰:没有找到名为 zdanalysis 的数据库。

2024-07-16T09:05:05.807+0800 I NETWORK [conn3] successfully authenticated as principal dbuser on zdanalysis 这段日志表示已经查到zdanalysis了,并且zdanalysis是真实存在的。用Metabase是能够直接访问的

这段日志显示用户 dbuser 成功认证并尝试连接数据库 zdanalysis ,但由于数据库 zdanalysis 未找到,导致连接失败并关闭。

可以再确认下相关链接信息等,如无问题可以到 GitHub 提个 Issue:Issues · dataease/dataease · GitHub