易陆发现互联网技术论坛

 找回密码
 开始注册
查看: 1945|回复: 1
收起左侧

zabbix界面上无数据日志报错connection to database 'zabbix' failed:

[复制链接]
发表于 2021-9-17 15:06:04 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?开始注册

x
7580:20210917:145626.898 using configuration file: /etc/zabbix/zabbix_server.conf/ K- g% \( P8 [7 W( W
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)  @8 e( O' o& G
  7580:20210917:145626.903 database is down: reconnecting in 10 seconds
( t" M4 F7 ?$ d$ M0 S$ E  ~/ J. [  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)# o- z. x/ m5 {/ \
  7580:20210917:145636.904 database is down: reconnecting in 10 seconds. ?, o) V4 A9 U# Y6 V# p6 w
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
5 c$ z  T$ K  g, J' B6 m( ^: n  7580:20210917:145646.905 database is down: reconnecting in 10 seconds
8 @! @# A: ~+ I3 I* E0 M  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES): G; k0 R) o% I3 l
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
# {2 ]$ u" k8 r( t. i  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
( A( T* H. ]9 `7 X9 ?  7580:20210917:145706.907 database is down: reconnecting in 10 seconds+ c: }/ ?1 ~; C9 P& F, |
  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)% B6 |: @" N# k, D  U  D. e
  7580:20210917:145716.907 database is down: reconnecting in 10 seconds
! {# ?. \+ p9 Y9 R; W9 l  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)0 ~' @5 v( T7 D" F) z! a9 S. D
  7580:20210917:145726.908 database is down: reconnecting in 10 seconds4 r) |+ F3 s. \
  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)5 S, \5 |* x" n
  7580:20210917:145736.910 database is down: reconnecting in 10 seconds& t4 Y1 H) z" X7 }, d  c8 E3 Q
  
( j: s& E7 @/ W: q5 [: E' X0 P, A8 y; A1 x% y) Y$ W
日志一直报错,解决办法:  d9 C. c; U; E

  X, v6 d2 n6 |- X0 _4 Z2 }) W7 y/ }! C' U; Q( h; H8 |# D' g
数据库添加权限:2 S; h) q" L0 O5 m$ v( O8 e
grant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";5 |% p! Q5 ^4 p% r2 V  Z, K
% i$ |- I! r8 B3 V0 m! u

/ f4 P1 k! {& K7 d
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:
, z9 ]( q) L1 q" k8 C; V如日志所示:
6 T0 t; F% u, N 7580:20210917:150726.962 database connection re-established
8 y/ L8 @% Q% r3 f7 ~) l0 f  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007* ~; I' Z+ L. {0 Z( q( e( I; y
  7580:20210917:150726.963 required mandatory version: 03040000
1 X: W( S% P4 G7 M  7580:20210917:150726.979 server #0 started [main process]
# V0 \6 h% n; k1 J1 G/ _& j  7738:20210917:150726.980 server #1 started [configuration syncer #1]* ^# g2 T" _1 s0 t, d3 K  w
  7739:20210917:150726.980 server #2 started [alerter #1], `4 v- k' f& f/ `0 J2 W+ q$ X& L
  7740:20210917:150726.981 server #3 started [alerter #2]
0 n0 v7 |4 o& D" }: B. e  7741:20210917:150726.981 server #4 started [alerter #3]/ ]- T8 C- d8 v* c: m9 J
  7742:20210917:150726.981 server #5 started [housekeeper #1]
3 N% X9 b' _+ f( ?$ q  7743:20210917:150726.982 server #6 started [timer #1]
8 ^4 Y2 }! @0 n3 b# {& j  7744:20210917:150726.982 server #7 started [http poller #1]2 l! D0 |/ L) {; U5 m
  7747:20210917:150726.983 server #8 started [discoverer #1]' W* L5 Q+ O8 _# }
  7748:20210917:150726.984 server #9 started [history syncer #1]
- e! B, e+ N( Q/ A3 e8 n9 }  7750:20210917:150726.985 server #10 started [history syncer #2]0 R0 {# Z! _  b) R/ R# p3 @
  7751:20210917:150726.985 server #11 started [history syncer #3]
5 W2 f+ w$ v: @# T- F/ N$ h: |  7755:20210917:150726.986 server #13 started [escalator #1]
) d; `7 q6 x1 W; p8 Q# p  7753:20210917:150726.986 server #12 started [history syncer #4]! Z2 |0 F* w# s$ L  l! h$ H  n
  7756:20210917:150726.986 server #14 started [proxy poller #1]
- {! p6 q/ {  f/ `6 x; p1 }  7759:20210917:150726.987 server #16 started [task manager #1]
. F0 P1 H4 j" f9 N- c/ Y  7760:20210917:150726.988 server #17 started [poller #1]
5 d. e) j- z) o6 r9 e  7765:20210917:150726.990 server #21 started [poller #5]
6 f' h4 N, G) g  h5 j  7762:20210917:150726.990 server #18 started [poller #2]7 k- x" k5 g; S2 C9 `$ m
  7764:20210917:150726.990 server #20 started [poller #4]  Q9 L! b$ d+ a, I* R
  7768:20210917:150726.993 server #23 started [trapper #1]+ \5 g6 D2 {& d
  7770:20210917:150726.993 server #25 started [trapper #3]
/ E+ ^: _- o' Y5 x/ @  7771:20210917:150726.994 server #26 started [trapper #4]; `( Z' Y, H4 T; m/ ]' `* v
  7774:20210917:150726.995 server #29 started [alert manager #1]
! r* s. ?& L% ^, `  B5 m0 N2 z  7769:20210917:150726.996 server #24 started [trapper #2]' K! W/ `7 O3 C. k
  7766:20210917:150726.997 server #22 started [unreachable poller #1]9 _$ V  M  X' N5 j4 J/ H) L7 M( z
  7773:20210917:150726.997 server #28 started [icmp pinger #1]- @& m1 l, ]$ A/ z
  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
) r8 P9 `$ g" X  7763:20210917:150726.998 server #19 started [poller #3]4 j' T+ }( D( H/ f* ?
  7757:20210917:150726.999 server #15 started [self-monitoring #1]
6 {6 I# A: D: z# W& e2 h  7772:20210917:150726.999 server #27 started [trapper #5]
! E3 k9 y- G( _3 @6 C; }  7777:20210917:150727.093 server #31 started [preprocessing worker #1]# S. h) T- e: W+ G7 v
  7778:20210917:150727.094 server #32 started [preprocessing worker #2]
. d, w4 L9 i& H$ O6 x' @  7779:20210917:150727.094 server #33 started [preprocessing worker #3]! P# J& M( I7 {9 D" y- _
  7760:20210917:150730.194 Zabbix agent item "system.users.num" on host "10.144.106.6" failed: first network error, wait for 15 seconds
! p7 g6 B1 D% o1 S  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds1 P) o' r8 L. }: j7 Y# u' S6 H9 Z9 q
  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable0 }, U0 x+ U# D. X
  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
8 m: i! C0 M* A% [4 P. c  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable
+ I. _. ]; |4 h6 c2 T. P, l* z- W0 z. i8 t( b0 K- _5 P6 ]
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

站长推荐上一条 /4 下一条

北京云银创陇科技有限公司以云计算运维,代码开发

QQ|返回首页|Archiver|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )点击这里给我发消息

GMT+8, 2026-4-8 23:52 , Processed in 0.050333 second(s), 23 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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