浏览此站
联系我们相册切换到窄版 Language

 找回密码
 注册
易陆发现论坛»论坛 › 操作系统区 › 非桌面系统 › Redhat/Centos Linux系统 › connection to database 'zabbix' failed: [2059] Authe ...
返回列表 发新帖
查看: 37|回复: 2

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

[复制链接]
admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2024-11-22 23:50:58 | 显示全部楼层 |阅读模式
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 directory6 b+ o; ]. P* @, s! f0 [1 D
  2009:20241023:074318.691 Cannot connect to the database. Exiting...
! N, p- T, A1 U' J: y% B4 j
8 c7 D& J3 @" l' J
' b  N: n5 U& o/ y. I/ A, |应该是在配置的时候没有执行数据库zabbix用户的配置：
" S  O3 j9 w$ Q0 h# i& ?; smysql> alter user 'zabbix'@'localhost' identified with mysql_native_password BY 'Zabbix23@';' |0 I  u2 A. {* j: `9 R
Query OK, 0 rows affected (0.01 sec)' P( E! j  J9 U9 r2 \5 Q) ^$ q
( _+ A+ L( Q  U
mysql> flush privilges;
6 l. S5 `. @/ T- u8 _+ ~4 r; ]" vERROR 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
/ G5 ]  q9 `' Fmysql> flush privileges;
2 v: F5 o9 g7 d; WQuery OK, 0 rows affected (0.00 sec)
2 A# G9 z% u. Z5 v! E$ M' b& S: S. z
mysql> % Z. }) M1 V9 T  a) V9 T
  J9 G7 R3 g5 p3 K6 u
  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, ]: N* v6 X2 Y$ J
  2009:20241023:074318.691 Cannot connect to the database. Exiting...
5 z2 H( I* B. _/ S1 _
6 p- o* H" [, G5 X
9 N4 o: N# O" Q4 t9 {
& z% d/ U: `7 T- V" u; g7 w1 D- K! k8 x
  2063:20241023:074952.930 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).$ C" p; A, }$ |
  2063:20241023:074952.931 ****** Enabled features ******8 Y7 p1 V1 j! y# H* C- t
  2063:20241023:074952.931 SNMP monitoring:           YES: W; O$ n. Q; S, Y" j
  2063:20241023:074952.931 IPMI monitoring:            NO
" O% Y7 I4 }  P8 {, T+ h  2063:20241023:074952.931 Web monitoring:             NO" L$ ?8 V3 [# a+ Q# S1 E! S; T
  2063:20241023:074952.932 VMware monitoring:          NO5 j$ v0 S1 }) ?
  2063:20241023:074952.932 SMTP authentication:        NO3 P# a- D. M  l$ i
  2063:20241023:074952.932 ODBC:                       NO; W0 z. V& v/ |3 g- C' }& y
  2063:20241023:074952.932 SSH support:                NO
: N0 w3 G# q3 h/ n+ R0 i3 _" h8 W& _5 Z  2063:20241023:074952.932 IPv6 support:               NO/ N( @  |* m" _# c! j
  2063:20241023:074952.932 TLS support:                NO+ h* ?1 e& G: A7 o* v& p2 X) F) S
  2063:20241023:074952.933 ******************************
+ ]% R: V% {, S  v! Z: t0 n$ h7 R0 \  2063:20241023:074952.933 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
+ ], m/ \1 Z# q. u# A  2063:20241023:074952.938 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
$ I* O' b4 a, h9 ]6 h  2063:20241023:074952.938 database is down: reconnecting in 10 seconds. P: I4 O5 U! c! t& o3 ~3 U
  2063:20241023:075002.940 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)" H  N8 n6 @" \8 f1 d* s: c: q$ Q
  2063:20241023:075002.941 database is down: reconnecting in 10 seconds* o" Q6 Q8 w, z5 T
  2063:20241023:075012.942 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
0 |2 i. S" \" I" a  2063:20241023:075012.943 database is down: reconnecting in 10 seconds: U, j$ n# f# j* R; ?
  2063:20241023:075022.944 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
  B4 _7 p! s  S( [  2063:20241023:075022.944 database is down: reconnecting in 10 seconds2 u, u/ H( q( V6 q4 z2 N  N2 I
  2063:20241023:075032.946 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
" K1 _# k7 `" M5 f. ?  V( w" h  2063:20241023:075032.946 database is down: reconnecting in 10 seconds% R  `6 B  ^! ~* i
  2063:20241023:075042.948 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
' Y( z% D0 P& W" J  o  2063:20241023:075042.949 database is down: reconnecting in 10 seconds
6 b% @( H. d6 z% i" j5 h
) U' Y& c. I8 J: E% c& K( z3 T# t
回复

举报

admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2024-11-23 00:16:12 | 显示全部楼层
cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so:5 h3 @) h8 F4 ]6 n8 m. b

  a' g- k- p7 `
5 l2 w' ^4 j+ z8 \& Jmysql> alter user 'zabbix'@'localhost' identified with caching_sha2_password  by 'Zabbix123@';
$ I; b; `9 Z7 c7 Q9 TQuery OK, 0 rows affected (0.02 sec)  K/ M: ^- _5 J. k

8 C0 b/ h" A6 G' S0 bmysql> flush privileges;4 \7 A/ G& p4 o# j4 U
Query OK, 0 rows affected (0.00 sec)+ x; X; I  t  O- l% A
! J" `. U6 y* K  N
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password  by 'Zabbix123@';: b3 {9 k. D& `- _( k# _: `5 r
Query OK, 0 rows affected (0.00 sec). S2 V8 w% l) S% u, M) S
" Z% W5 _( v& G% \7 m) y" W
mysql> flush privileges;
- u- H3 y, d4 q  ]. `Query OK, 0 rows affected (0.01 sec)
- B0 ?" L" E! V4 b5 I0 o( u3 `/ q9 |0 p
mysql>
$ E; k0 m1 ^6 [& ?5 Q5 z: L
回复

举报

admin

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2024-11-23 00:17:17 | 显示全部楼层
2164:20241023:081631.024 Starting Zabbix Server. Zabbix 6.4.20 (revision 114e4f42c15).
1 _/ [# K4 [/ K/ W; E  2164:20241023:081631.025 ****** Enabled features ******) C3 S) I2 Q# V; C! N9 K5 Q
  2164:20241023:081631.025 SNMP monitoring:           YES5 n3 }+ M. e" ?" ?+ w2 n  w; Z
  2164:20241023:081631.025 IPMI monitoring:            NO/ }* A# G% X/ R
  2164:20241023:081631.025 Web monitoring:             NO1 g  l( B9 H5 @! U* E  h
  2164:20241023:081631.025 VMware monitoring:          NO
+ ?0 C/ a4 Q; ?. A  2164:20241023:081631.025 SMTP authentication:        NO
9 D" U! m$ U- A: ~  2164:20241023:081631.026 ODBC:                       NO
! }8 ?$ R/ u% `. b$ o- ^5 V# y3 F: {6 m  2164:20241023:081631.026 SSH support:                NO; w" {2 S* J2 }+ S- B, ^# O) X
  2164:20241023:081631.026 IPv6 support:               NO! k; k* i6 R' f# V* b5 J
  2164:20241023:081631.026 TLS support:                NO6 \' v4 |8 J% E  q0 U
  2164:20241023:081631.026 ******************************( B7 {+ _* v0 L0 f2 }9 u
  2164:20241023:081631.026 using configuration file: /var/lib/zabbix-6-4-20/etc/zabbix_server.conf
& O2 O: L% J% Y/ g4 i2 T  2164:20241023:081631.067 current database version (mandatory/optional): 06040000/06040036
% n6 Z9 q# l4 ]; v; j8 J5 p  2164:20241023:081631.068 required mandatory version: 060400005 ?5 e0 Y1 {5 @
  2165:20241023:081631.118 starting HA manager6 _( a) S& P9 x: ?$ S8 Q
  2165:20241023:081631.141 HA manager started in active mode; B5 D+ ]6 V/ D
  2164:20241023:081631.143 server #0 started [main process]/ ]: ]# [$ |" y
  2166:20241023:081631.144 server #1 started [service manager #1]
" A6 a. g* K5 H! p* V# [  2167:20241023:081631.145 server #2 started [configuration syncer #1]+ q# t+ k" t* J# H
  2168:20241023:081631.947 server #3 started [alert manager #1]* h: J+ y  Y8 @3 t/ @
  2169:20241023:081631.948 server #4 started [alerter #1]4 \  X& {8 J  r( m. }. P+ q
  2170:20241023:081631.948 server #5 started [alerter #2]& \- `+ b/ n. F
  2171:20241023:081631.950 server #6 started [alerter #3]$ ~5 K$ `: M: W. K& a  E7 p. q
  2173:20241023:081631.950 server #8 started [lld manager #1]
, v( j( X" m0 l! g, S: W  2172:20241023:081631.951 server #7 started [preprocessing manager #1]
2 H& J! v0 M) S( T6 T5 a; F& \  2174:20241023:081631.951 server #9 started [lld worker #1]
" r8 I* Y& i7 Q% A: K9 I  2175:20241023:081631.952 server #10 started [lld worker #2]
6 O6 i" f  T1 t  2177:20241023:081631.954 server #12 started [timer #1]
3 M$ V' w8 Q9 V  n; `  2178:20241023:081631.956 server #13 started [http poller #1]
( c! g$ l! ^0 l" h9 S- m  2179:20241023:081631.957 server #14 started [discoverer #1]5 W% B2 ~- ^* t0 Z! P
  2185:20241023:081631.961 server #17 started [history syncer #3]$ `. Y0 ]8 }' m! |8 r
  2186:20241023:081631.963 server #18 started [history syncer #4]
  _9 b- A( c) M. n, H0 w% l. S  2187:20241023:081631.964 server #19 started [escalator #1]
" r5 P3 }) T9 f8 |. R! M  2188:20241023:081631.966 server #20 started [proxy poller #1]( J- `: O# ?$ D( B' |
  2183:20241023:081631.967 server #16 started [history syncer #2]- H2 _1 _: D7 R6 P  i9 n
  2192:20241023:081631.967 server #23 started [poller #1]
  {- @. y1 a" U# K# A  2176:20241023:081631.968 server #11 started [housekeeper #1]' y6 e3 l1 |3 X/ W" H
  2194:20241023:081631.970 server #24 started [poller #2]
9 L2 x1 ?' o+ O% ^) `- B1 v  2195:20241023:081631.972 server #25 started [poller #3]7 e  `) t0 [9 F- J
  2198:20241023:081631.975 server #27 started [poller #5]
0 _/ Y4 Y" c7 w3 _% V3 T  2189:20241023:081631.975 server #21 started [self-monitoring #1]
0 @4 a& ?! q1 F9 h" _3 g7 p  2202:20241023:081631.977 server #29 started [trapper #1]! v/ T  x( b0 o3 V
  2204:20241023:081631.978 server #31 started [trapper #3]
' v. |+ ]) E+ b9 U, ~7 y1 W  2207:20241023:081631.980 server #34 started [icmp pinger #1]/ i, z; Y* n7 I$ A
  2182:20241023:081631.981 server #15 started [history syncer #1]
" j) e5 Z" T4 l: V/ t  2191:20241023:081631.982 server #22 started [task manager #1]+ H" y$ A1 i$ G
  2208:20241023:081631.982 server #35 started [alert syncer #1]
" r8 g0 X9 a# ~# M7 H  2201:20241023:081631.983 server #28 started [unreachable poller #1]
; r8 A- `2 f2 T* }9 {  2209:20241023:081631.984 server #36 started [history poller #1]+ O2 h' O6 g& P* S# b4 ^6 K2 @
  2203:20241023:081631.987 server #30 started [trapper #2]4 _, {, D4 _. J9 {1 V  U8 C
  2215:20241023:081631.987 server #38 started [history poller #3]+ D6 f( q6 G* w( E& z% `, @7 T
  2206:20241023:081631.988 server #33 started [trapper #5]
: O; Q/ x3 T0 @  2219:20241023:081631.989 server #40 started [history poller #5]
/ a9 v  z% }6 j& g  2218:20241023:081631.990 server #39 started [history poller #4]* C; c# s# f) ?7 z3 Q* o
  2205:20241023:081631.990 server #32 started [trapper #4]0 m+ |* s2 u! U
  2221:20241023:081631.992 server #42 started [trigger housekeeper #1]
4 |6 w  w" o' S8 e  J4 J2 L' }  2197:20241023:081631.993 server #26 started [poller #4]
+ d5 v2 X- k) @& U  2210:20241023:081631.994 server #37 started [history poller #2]1 G7 w! M& Z1 x+ ^
  2222:20241023:081631.999 server #43 started [odbc poller #1]
. M# L4 W/ K" ]( R8 Y1 P  2220:20241023:081632.002 server #41 started [availability manager #1]+ I, j/ d) l- U  |& m
  2172:20241023:081632.006 [1] thread started [preprocessing worker #1]& O2 W/ W8 I- A
  2172:20241023:081632.008 [2] thread started [preprocessing worker #2]
. B$ M9 o: D0 e' |  2172:20241023:081632.009 [3] thread started [preprocessing worker #3]
7 _8 l  i. ?! Y0 }+ ^2 s6 D! q& g+ o  2194:20241023:081638.016 enabling Zabbix agent checks on host "Zabbix server": interface became available+ K. S3 t1 \/ n, d# k; I, P6 {# |
  2185:20241023:081641.010 item "Zabbix server:zabbix[process,ipmi poller,avg,busy]" became not supported: No "ipmi poller" processes started.
8 r% Y! k7 F, `  2186:20241023:081642.015 item "Zabbix server:zabbix[process,java poller,avg,busy]" became not supported: No "java poller" processes started.
; _& [/ G) v' E+ i8 v/ T, x  x  2186:20241023:081647.034 item "Zabbix server:zabbix[process,snmp trapper,avg,busy]" became not supported: No "snmp trapper" processes started." C" t* K  M8 B! J
  2186:20241023:081647.034 item "Zabbix server:zabbix[process,ipmi manager,avg,busy]" became not supported: No "ipmi manager" processes started.
, F2 K" z# ^  c+ X$ b  2186:20241023:081647.035 item "Zabbix server:zabbix[connector_queue]" became not supported: connector is not initialized: please check "StartConnectors" configuration parameter
3 u& N9 }9 C* b, q" }; Y) w  2185:20241023:081648.035 item "Zabbix server:zabbix[process,vmware collector,avg,busy]" became not supported: No "vmware collector" processes started.* H! u6 }2 J8 C9 }9 r
  2185:20241023:081648.035 item "Zabbix server:zabbix[process,connector manager,avg,busy]" became not supported: No "connector manager" processes started.
7 v8 C) w4 |: y: W7 L+ G' ^: b, t  2185:20241023:081649.049 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.  X; ^: t+ c1 T8 d: R" ^- i: z" T  ]
  2182:20241023:081655.013 item "Zabbix server:zabbix[vmware,buffer,pused]" became not supported: No "vmware collector" processes started.; K$ G0 @) w  G
  2182:20241023:081658.033 item "Zabbix server:zabbix[process,report writer,avg,busy]" became not supported: No "report writer" processes started.( D! J4 ?# c; |& V. e- ~2 C& G
  2183:20241023:081659.038 item "Zabbix server:zabbix[process,report manager,avg,busy]" became not supported: No "report manager" processes started.
回复

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 03:21 , Processed in 0.022765 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表