易陆发现互联网技术论坛

 找回密码
 开始注册
查看: 1946|回复: 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+ H$ j2 u  n; |
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)9 B/ `6 B6 k& b2 ]8 I8 Z* N
  7580:20210917:145626.903 database is down: reconnecting in 10 seconds, u2 o% R$ x0 C# r7 _  |' C! K3 F
  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES); Y3 f$ E( y& F# M" T
  7580:20210917:145636.904 database is down: reconnecting in 10 seconds4 [8 l5 F" d+ A7 T
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)* g9 m3 `3 @9 ~1 E& m
  7580:20210917:145646.905 database is down: reconnecting in 10 seconds8 [5 T7 z) y7 J; s2 [6 {; G" Z4 W
  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)+ `8 A, v, \; K" Z- V& q. n, P# A
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
! X: f2 I. E+ H" ]' |  O  k5 _  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
- |! C# q( m. B7 q+ n4 }+ T1 g' m  7580:20210917:145706.907 database is down: reconnecting in 10 seconds+ }  ^: Y0 ]1 I' l! V; t0 _& W
  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
9 o( O4 r; F) g- Q  7580:20210917:145716.907 database is down: reconnecting in 10 seconds/ V; c1 S4 E; O
  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES): f4 _+ V, u, q. W: N
  7580:20210917:145726.908 database is down: reconnecting in 10 seconds
  }0 r4 U4 A' C( {% ~- U. w  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)2 d& Y! b" U! P% k
  7580:20210917:145736.910 database is down: reconnecting in 10 seconds
; P* r- o/ u  C( n/ O  ; D% |$ f5 B- j5 }# x  g

3 f0 [7 O7 t0 @: ?" U5 g日志一直报错,解决办法:
! |4 D2 y) m" x  S2 n) s5 w! W& R: _- f) v% g# u/ X( x" C! p/ f1 @" E. O

/ T4 S1 ~5 Z1 |9 R" k% i8 p& U数据库添加权限:
6 ?, N; O# V- R# `6 ?& _- B5 [grant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";* a- H  D  D! m) M
2 j# p; P, u$ k5 S/ b% w

/ |9 P) g2 |6 B
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:
/ R2 D4 G8 J) l) w如日志所示:5 G) E  {7 j" F1 S: q8 [- y& c
7580:20210917:150726.962 database connection re-established
) X& x) Z7 ~: N, J  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007
; _  C# Q2 E6 }- [- R  7580:20210917:150726.963 required mandatory version: 03040000
; q( B2 d5 S! ?2 S( A) x8 Z" y  7580:20210917:150726.979 server #0 started [main process]6 u& d+ o; |4 o" p7 Z1 r2 e4 _9 G
  7738:20210917:150726.980 server #1 started [configuration syncer #1]
% M7 _4 @' ?# q: a  7739:20210917:150726.980 server #2 started [alerter #1]
( V8 t0 M) K9 ~- Z8 l  M  7740:20210917:150726.981 server #3 started [alerter #2]
6 Y: Q9 {; q9 T- S1 |  7741:20210917:150726.981 server #4 started [alerter #3]. w7 L: u# \) S: ~& G4 I- ?
  7742:20210917:150726.981 server #5 started [housekeeper #1]$ F+ l. z1 X6 ]. }
  7743:20210917:150726.982 server #6 started [timer #1]
2 B1 P3 k, s! O- o, A  7744:20210917:150726.982 server #7 started [http poller #1]5 T! @: R$ w# A) p  ]7 b
  7747:20210917:150726.983 server #8 started [discoverer #1]
# q* y4 }: y* o, I2 e  7748:20210917:150726.984 server #9 started [history syncer #1]. f4 a6 M; \  W, C6 F
  7750:20210917:150726.985 server #10 started [history syncer #2]& L" l/ N9 `# \7 y
  7751:20210917:150726.985 server #11 started [history syncer #3]4 G  f, a) A' G$ n
  7755:20210917:150726.986 server #13 started [escalator #1]) H5 N. B6 q& y; O4 ^
  7753:20210917:150726.986 server #12 started [history syncer #4]
% ^5 S9 J- p: P/ u$ O  I/ K  7756:20210917:150726.986 server #14 started [proxy poller #1]
/ p5 Q# t* j8 S2 _# U  7759:20210917:150726.987 server #16 started [task manager #1]2 F  d* z: L3 Q
  7760:20210917:150726.988 server #17 started [poller #1]7 f. j- ]' u% G/ L
  7765:20210917:150726.990 server #21 started [poller #5]
5 I- d  S# G/ N& q* Q  7762:20210917:150726.990 server #18 started [poller #2]; e- n7 E6 V8 P$ O0 E6 g1 B. H
  7764:20210917:150726.990 server #20 started [poller #4]8 {/ \% t. q- Z
  7768:20210917:150726.993 server #23 started [trapper #1]
& D" Z6 g, A0 s% u  7770:20210917:150726.993 server #25 started [trapper #3]( h3 Z2 q- g1 O$ ~% ^( E0 l& Z' e
  7771:20210917:150726.994 server #26 started [trapper #4]4 b4 n2 I6 X' `1 V0 I
  7774:20210917:150726.995 server #29 started [alert manager #1]
8 C3 G. z- M4 B7 B2 @2 v- ]  7769:20210917:150726.996 server #24 started [trapper #2]# W) b  M& S* ~3 B  ^
  7766:20210917:150726.997 server #22 started [unreachable poller #1]
/ ^  K! L8 r; X' W  7773:20210917:150726.997 server #28 started [icmp pinger #1]
0 h0 p! H" ^+ d$ y: |  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
% v5 |: t# r5 u+ K0 C! ?7 M; G6 U- w  7763:20210917:150726.998 server #19 started [poller #3]- E' z/ @5 P; H
  7757:20210917:150726.999 server #15 started [self-monitoring #1]- m/ g- [/ N! h
  7772:20210917:150726.999 server #27 started [trapper #5]
  S& C8 ?: V: H: i; w7 i  7777:20210917:150727.093 server #31 started [preprocessing worker #1]
1 {0 z( N9 l# x: L3 M% c  ]$ {9 D! A9 x  7778:20210917:150727.094 server #32 started [preprocessing worker #2]% i# x& x; R( j: h3 A% S* ]$ W( v
  7779:20210917:150727.094 server #33 started [preprocessing worker #3]( J. \( U3 L3 g* J! Q/ t' @
  7760:20210917:150730.194 Zabbix agent item "system.users.num" on host "10.144.106.6" failed: first network error, wait for 15 seconds) o- I. c% J7 N$ T
  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds4 K. G1 v) P' q4 {5 B( A3 R+ |
  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable* F! N4 u$ k) R- ~
  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found0 ^/ q) d/ i8 N% m8 D
  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable0 V8 h* l) j1 H. u) `. B

5 e' ?7 I1 p5 m3 p5 g. x
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

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

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

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

GMT+8, 2026-4-9 00:04 , Processed in 0.054428 second(s), 23 queries .

Powered by Discuz! X3.4 Licensed

© 2012-2025 Discuz! Team.

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