将设为首页浏览此站
开启辅助访问 天气与日历 收藏本站联系我们切换到窄版

易陆发现论坛

 找回密码
 开始注册
查看: 228|回复: 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) t: O, r/ E$ |6 o5 G7 T4 r
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES); {" H, e% @: e! a* k( ?
  7580:20210917:145626.903 database is down: reconnecting in 10 seconds
7 b2 S3 O( C- i3 q  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
" a5 Z4 N0 k# `9 {  7580:20210917:145636.904 database is down: reconnecting in 10 seconds8 X0 J9 X) P( L( ^% B' H! D
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)) y* X5 K+ ?& _/ _
  7580:20210917:145646.905 database is down: reconnecting in 10 seconds- g3 k9 {. |; z2 G
  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)' \3 a) k; R& A3 P! r
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
  f+ B- w' n5 L- I( @- C  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)3 G3 v' g! x% x: W! X
  7580:20210917:145706.907 database is down: reconnecting in 10 seconds% s7 b0 a* p4 ?8 G+ y
  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
- T' u4 a5 t. ?3 U. k/ |  7580:20210917:145716.907 database is down: reconnecting in 10 seconds
- i( w# M! a3 Q8 u8 F  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)+ ^, s$ V1 l9 k. P; c
  7580:20210917:145726.908 database is down: reconnecting in 10 seconds" E" _) {4 O" z& S$ y. h
  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
1 u) l' ]: C, E. a, O6 q/ U  7580:20210917:145736.910 database is down: reconnecting in 10 seconds
, ~5 |: U0 u0 N4 M& A% [( b3 Z$ q% N  
( e8 e) Z1 x( A8 k9 g3 H' o! o
1 }) j4 z8 z+ Z* G9 N$ C8 M- T4 ?日志一直报错,解决办法:" W8 w- d8 }6 I3 ?9 f& C

5 h' S7 X  \; c! _$ E
% G/ B) m. a; ]# D9 w, L, y数据库添加权限:
0 D# s7 A( l# t) p3 u: qgrant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";3 U5 _6 b" J& r

8 {4 X1 u  T* Y6 Q: S) J) x. u: ^8 F) G4 u4 @+ B" S* y
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:
& i$ ~. ]$ w/ r如日志所示:
& g- S' ^$ P: s5 y: E+ v1 M0 I 7580:20210917:150726.962 database connection re-established- J' P* P. }$ d2 m- E* s. ?
  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007; V, ]' i: K; E' P& U
  7580:20210917:150726.963 required mandatory version: 03040000
. a0 Q5 M# I0 `- s- P  7580:20210917:150726.979 server #0 started [main process]( z5 V8 l! D  f1 z8 Z, G/ ~
  7738:20210917:150726.980 server #1 started [configuration syncer #1]6 H+ E  K" {$ q& p5 v: d
  7739:20210917:150726.980 server #2 started [alerter #1]
. a5 n: x7 i) Q6 C9 ~- W3 Z  7740:20210917:150726.981 server #3 started [alerter #2]
# ~2 u4 f4 |7 {8 E  7741:20210917:150726.981 server #4 started [alerter #3]" S1 m& }6 o. D" V- m/ w6 o) j
  7742:20210917:150726.981 server #5 started [housekeeper #1]
  w1 q0 y  i. _! X; z  7743:20210917:150726.982 server #6 started [timer #1]
) R+ w9 x8 p  H( X  7744:20210917:150726.982 server #7 started [http poller #1]( T3 ~" |3 t: x- G
  7747:20210917:150726.983 server #8 started [discoverer #1]
; P/ x4 s0 O- T8 {# }+ k  7748:20210917:150726.984 server #9 started [history syncer #1]
" c- E3 G/ z+ B  7750:20210917:150726.985 server #10 started [history syncer #2]
1 }: Y2 Q' q3 ~9 O  7751:20210917:150726.985 server #11 started [history syncer #3]3 Z5 l( s! z' A1 C( x
  7755:20210917:150726.986 server #13 started [escalator #1]
- T; o& [  b) q) l! b7 [  7753:20210917:150726.986 server #12 started [history syncer #4]$ J! V0 J* l4 L  V' \
  7756:20210917:150726.986 server #14 started [proxy poller #1]. b/ s8 t; O0 ?7 u5 o; h7 [* m1 W. I
  7759:20210917:150726.987 server #16 started [task manager #1]
/ R) Z6 b  P* o( K) T' G6 h8 r8 }  7760:20210917:150726.988 server #17 started [poller #1]
4 B& F2 `; i- ]6 g7 l  7765:20210917:150726.990 server #21 started [poller #5]9 b/ s/ j) O3 |$ Z
  7762:20210917:150726.990 server #18 started [poller #2]& a8 Z; I) p! g$ z( w$ u
  7764:20210917:150726.990 server #20 started [poller #4]
; c$ V/ A! l9 ?4 F/ |  7768:20210917:150726.993 server #23 started [trapper #1]- m+ `6 f; Q! n- p' V& m  F7 J
  7770:20210917:150726.993 server #25 started [trapper #3]
2 U5 D7 c" t6 p! @/ ~  7771:20210917:150726.994 server #26 started [trapper #4]6 i; j# U- D; @  _: C2 j: D% |
  7774:20210917:150726.995 server #29 started [alert manager #1]
# c3 J4 Y5 B8 V. B  7769:20210917:150726.996 server #24 started [trapper #2]6 I6 Z) P' n' ^( B
  7766:20210917:150726.997 server #22 started [unreachable poller #1]; N  e1 P+ h0 a* |' `: m
  7773:20210917:150726.997 server #28 started [icmp pinger #1]
8 u6 r0 {8 ~) i7 H  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
* f7 C* `* }5 C' y9 v  e0 p. r! F) f6 t  7763:20210917:150726.998 server #19 started [poller #3]
9 W8 R& C5 d" N) l  r/ x+ d0 ]$ C  7757:20210917:150726.999 server #15 started [self-monitoring #1]
" ~' d. t$ Y2 T. Z4 n) V  7772:20210917:150726.999 server #27 started [trapper #5]
4 [/ I) p" h4 s  7777:20210917:150727.093 server #31 started [preprocessing worker #1]
5 r2 k6 ]  G( |  7778:20210917:150727.094 server #32 started [preprocessing worker #2]7 r% T0 ]9 c+ d& V. r
  7779:20210917:150727.094 server #33 started [preprocessing worker #3]
1 t8 u) r% |& f7 e1 t: O  7760:20210917:150730.194 Zabbix agent item "system.users.num" on host "10.144.106.6" failed: first network error, wait for 15 seconds
  |/ S7 ^2 o9 f7 Y2 i: p  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds5 |1 i! J: S/ q
  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable# l# ]! C7 C1 h
  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
! L; \! r3 n8 j: `  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable5 L0 w/ E6 t4 w
3 _3 @+ t) a# |( Y4 f
您需要登录后才可以回帖 登录 | 开始注册

本版积分规则

关闭

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

如有购买积分卡请联系497906712

QQ|返回首页|Archiver|手机版|小黑屋|易陆发现 点击这里给我发消息

GMT+8, 2021-10-28 16:23 , Processed in 0.044471 second(s), 22 queries .

Powered by LR.LINUX.cloud bbs168x X3.2 Licensed

© 2012-2022 Comsenz Inc.

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