connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sh

admin

2009:20241023:074318.691 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
  2009:20241023:074318.691 Cannot connect to the database. Exiting...
0 X+ M+ S9 [1 M+ s; O
+ V$ f# Y1 H( e: N, A+ K2 c
1 i6 h4 J) r% j& |, ?. k应该是在配置的时候没有执行数据库zabbix用户的配置：
  a: t( B" ~) l$ Xmysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';
Query OK, 0 rows affected (0.01 sec)
" Z  ?  D9 @5 d* Y* v4 B
- a" Q/ Z, m( U0 F; ^; b; pmysql> flush privilges;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilges' at line 1
5 a, n' n/ F8 q. G1 V$ Nmysql> flush privileges;
1 j( O* A; {# v: x1 [% m, pQuery OK, 0 rows affected (0.00 sec)

mysql>

  2009:20241023:074318.691 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
  2009:20241023:074318.691 Cannot connect to the database. Exiting...


5 T' [1 |2 j0 W* F

  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
  2063:20241023:074952.931 ****** Enabled features ******
  2063:20241023:074952.931 SNMP monitoring:           YES
$ M5 n$ D* r: u4 W8 o- Q+ ~' e  2063:20241023:074952.931 IPMI monitoring:            NO
  2063:20241023:074952.931 Web monitoring:             NO
$ V. d  Y5 p9 L/ e+ ^  2063:20241023:074952.932 VMware monitoring:          NO
0 W, h( `) F. i4 K5 }/ i  2063:20241023:074952.932 SMTP authentication:        NO
  2063:20241023:074952.932 ODBC:                       NO
) g, D/ V1 R* k0 ?2 |, [  2063:20241023:074952.932 SSH support:                NO
  2063:20241023:074952.932 IPv6 support:               NO
2 k8 ?# _5 ^. o8 `  2063:20241023:074952.932 TLS support:                NO
  2063:20241023:074952.933 ******************************
5 P% v% P1 F% E) `, d8 M  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
/ ]! C) I' [7 A: w% J4 ^  2063:20241023:074952.938 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
" @2 ]/ {7 \& Q4 s  x- [  2063:20241023:074952.938 database is down: reconnecting in 10 seconds
  2063:20241023:075002.940 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
3 T$ B* t& C* {  _  2063:20241023:075002.941 database is down: reconnecting in 10 seconds
  2063:20241023:075012.942 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075012.943 database is down: reconnecting in 10 seconds
  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8 a; v( }+ d, P+ o" x5 ]% s  2063:20241023:075022.944 database is down: reconnecting in 10 seconds
, d9 M# M* n" J$ |) f* _  2063:20241023:075032.946 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075032.946 database is down: reconnecting in 10 seconds
  2063:20241023:075042.948 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  2063:20241023:075042.949 database is down: reconnecting in 10 seconds
5 h" d' h' [; a  s
) S( w* p$ D% B# k; T

admin

cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so:


mysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
Query OK, 0 rows affected (0.02 sec)
- Y! [& x( X- W1 q$ A
mysql> flush privileges;
+ f3 Y4 H$ S$ e  y; q6 j9 M% J5 pQuery OK, 0 rows affected (0.00 sec)
0 i! ?3 Z3 o9 f6 c9 i4 ^3 f4 N# m
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';
3 j: E, d" v+ s$ o: X. AQuery OK, 0 rows affected (0.00 sec)
; h0 \6 ]2 E% R
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
$ }8 F% Y* c  L
mysql>

admin

2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
  2164:20241023:081631.025 ****** Enabled features ******
  2164:20241023:081631.025 SNMP monitoring:           YES
  2164:20241023:081631.025 IPMI monitoring:            NO
  2164:20241023:081631.025 Web monitoring:             NO
  2164:20241023:081631.025 VMware monitoring:          NO
  2164:20241023:081631.025 SMTP authentication:        NO
  2164:20241023:081631.026 ODBC:                       NO
  2164:20241023:081631.026 SSH support:                NO
5 A8 M, S2 G/ R* L4 }8 h& p  2164:20241023:081631.026 IPv6 support:               NO
  2164:20241023:081631.026 TLS support:                NO
  2164:20241023:081631.026 ******************************
" E& q, V* K  q! O$ A  2164:20241023:081631.026 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
  2164:20241023:081631.067 current database version (mandatory/optional): 06040000/06040036
  2164:20241023:081631.068 required mandatory version: 06040000
+ t* U9 W; ~- W! x& Y  2165:20241023:081631.118 starting HA manager
' p# ?8 Y; E$ v3 F& Y" j  2165:20241023:081631.141 HA manager started in active mode
  2164:20241023:081631.143 server #0 started [main process]
3 [1 `& U9 Z  ^4 z9 J, Q  2166:20241023:081631.144 server #1 started [service manager #1]
  2167:20241023:081631.145 server #2 started [configuration syncer #1]
  2168:20241023:081631.947 server #3 started [alert manager #1]
) a2 _, t2 T, Q  2169:20241023:081631.948 server #4 started [alerter #1]
  2170:20241023:081631.948 server #5 started [alerter #2]
  2171:20241023:081631.950 server #6 started [alerter #3]
' s, w0 e2 z8 F" ~- H  2173:20241023:081631.950 server #8 started [lld manager #1]
" I5 l, H. I" @  2172:20241023:081631.951 server #7 started [preprocessing manager #1]
  X, x5 t3 x7 \% u' z8 P; p$ B  2174:20241023:081631.951 server #9 started [lld worker #1]
; o) j' U: S/ r/ e. I  2175:20241023:081631.952 server #10 started [lld worker #2]
  2177:20241023:081631.954 server #12 started [timer #1]
  2178:20241023:081631.956 server #13 started [http poller #1]
  2179:20241023:081631.957 server #14 started [discoverer #1]
! U$ l! g1 B, s3 f  2185:20241023:081631.961 server #17 started [history syncer #3]
  2186:20241023:081631.963 server #18 started [history syncer #4]
  2187:20241023:081631.964 server #19 started [escalator #1]
; J' ^5 \3 s2 k7 o2 M# \  2188:20241023:081631.966 server #20 started [proxy poller #1]
9 `! R1 q6 E( i7 b2 f+ x  2183:20241023:081631.967 server #16 started [history syncer #2]
  2192:20241023:081631.967 server #23 started [poller #1]
  2176:20241023:081631.968 server #11 started [housekeeper #1]
  2194:20241023:081631.970 server #24 started [poller #2]
) q6 l7 d& c1 @+ M: [  2195:20241023:081631.972 server #25 started [poller #3]
6 @0 t0 @/ j6 z  2198:20241023:081631.975 server #27 started [poller #5]
8 G9 T& ^7 Y: r  2189:20241023:081631.975 server #21 started [self-monitoring #1]
  2202:20241023:081631.977 server #29 started [trapper #1]
  2204:20241023:081631.978 server #31 started [trapper #3]
  2207:20241023:081631.980 server #34 started [icmp pinger #1]
7 C$ D4 }& @+ I, h6 X$ `. y/ b* S  2182:20241023:081631.981 server #15 started [history syncer #1]
  2191:20241023:081631.982 server #22 started [task manager #1]
/ |- v! y/ G$ A% A# v& t' z  2208:20241023:081631.982 server #35 started [alert syncer #1]
: l# X* W+ l) d( Y! O, r/ U  2201:20241023:081631.983 server #28 started [unreachable poller #1]
5 T& {& T3 c7 H0 A' J9 f( @# ]7 S  2209:20241023:081631.984 server #36 started [history poller #1]
1 H& g0 u+ T0 l4 M9 }  2203:20241023:081631.987 server #30 started [trapper #2]
3 r3 o# N; Q  ?  2215:20241023:081631.987 server #38 started [history poller #3]
$ [: x' n; [! i" N7 \0 h  2206:20241023:081631.988 server #33 started [trapper #5]
) z$ V+ \) ^2 R9 l  2219:20241023:081631.989 server #40 started [history poller #5]
  2218:20241023:081631.990 server #39 started [history poller #4]
: E' o5 Y6 s2 \  2205:20241023:081631.990 server #32 started [trapper #4]
: J9 k1 [9 c. T& G, [- E7 }  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
5 f$ b+ \3 m$ ^6 Y- v! q. F1 q  2197:20241023:081631.993 server #26 started [poller #4]
  2210:20241023:081631.994 server #37 started [history poller #2]
: b( B( |: Y- k* W  2222:20241023:081631.999 server #43 started [odbc poller #1]
( Y" r, d, B; |' Z7 h& a  2220:20241023:081632.002 server #41 started [availability manager #1]
, G2 U% J0 B* c; D" Q9 t  2172:20241023:081632.006 [1] thread started [preprocessing worker #1]
  2172:20241023:081632.008 [2] thread started [preprocessing worker #2]
/ f7 a2 ~% K! f( h1 Q6 O7 E: p( Z4 a  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
  2194:20241023:081638.016 enabling Zabbix agent checks on host "Zabbix server": interface became available
# d5 x0 J% S; P- N1 l" k  Q7 F* q  2185:20241023:081641.010 item "Zabbix server:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
3 Q3 ~, ^" }: M2 U  E; S$ W  2186:20241023:081642.015 item "Zabbix server:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
  2186:20241023:081647.034 item "Zabbix server:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started.
6 C& h' P% B1 D5 E  2186:20241023:081647.034 item "Zabbix server:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
  c" \3 V9 p/ t0 d/ ~$ x+ Z  2186:20241023:081647.035 item "Zabbix server:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
  2185:20241023:081648.035 item "Zabbix server:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.
) F8 G! o1 @0 U, Y& A4 @2 {  2185:20241023:081648.035 item "Zabbix server:zabbix[process,connector manager,avg,busy]" became not supported: No "connector manager" processes started.
' e' l8 E- D  ?' i* Q( c9 X/ a  2185:20241023:081649.049 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
  2182:20241023:081655.013 item "Zabbix server:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.
  2182:20241023:081658.033 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.
4 R; w7 X3 T8 V3 \1 A* E  2183:20241023:081659.038 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.