找回密码
 注册
查看: 1950|回复: 1

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

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2021-9-17 15:06:04 | 显示全部楼层 |阅读模式
7580:20210917:145626.898 using configuration file: /etc/zabbix/zabbix_server.conf9 H& g$ T& s* f$ d, J' q
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)3 n' n6 v0 N/ S7 s: ~4 M( E# A7 M
  7580:20210917:145626.903 database is down: reconnecting in 10 seconds0 |9 [3 v9 r# [- |; R
  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
0 I! Y) `/ X8 e4 {  7580:20210917:145636.904 database is down: reconnecting in 10 seconds+ [7 c( C7 d+ z* e
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
2 L: Q' f) f/ K  7580:20210917:145646.905 database is down: reconnecting in 10 seconds! x/ z5 q5 \9 f+ X5 }- F. `
  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES). _& z7 q: h0 C4 |& k+ @
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds9 f' h  X, s) U- X
  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)1 G3 ]8 h. t+ l* J
  7580:20210917:145706.907 database is down: reconnecting in 10 seconds
* [) m" j* S3 V" U( z/ b  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
% c8 q" I, ]6 S3 K  7580:20210917:145716.907 database is down: reconnecting in 10 seconds
" R0 l+ J# Q2 Y) U  v- `  F  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
, d" |- S, F8 f  7580:20210917:145726.908 database is down: reconnecting in 10 seconds
5 O- J2 i- d* Q4 o; o  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)8 e4 ]2 Q3 m( Y$ w( F! {
  7580:20210917:145736.910 database is down: reconnecting in 10 seconds
! u" ~% Z! o# K+ F/ T: m  ( `; Y! i! f& ?- q2 w; P% A$ [
# P5 y1 ?4 J! L
日志一直报错,解决办法:+ Q+ w5 f) j  q2 U& S+ n- J

5 J5 X/ _8 m) h4 F% f* P  T% j5 ~, ?
+ e3 \' r5 l! t# F数据库添加权限:
* F% C; L3 h6 h, b7 Mgrant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";
2 W& m* s' j7 P  P6 l- H% O' a% N9 b0 y! G; I9 m8 @, Y
; F2 }/ F: f$ ]& `1 d9 }

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:
: M& P+ e0 u7 l: X如日志所示:+ j5 j7 O- f; I% s+ @) c7 g! I  h
7580:20210917:150726.962 database connection re-established2 a; B9 y( x3 z  S, A
  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007
6 t$ N; j& B7 Q$ R; m5 J! r  7580:20210917:150726.963 required mandatory version: 030400007 ]3 x: l) m9 p2 P6 N
  7580:20210917:150726.979 server #0 started [main process]
3 ~$ T' W* l' }( a( O  7738:20210917:150726.980 server #1 started [configuration syncer #1]
: H& q. r; ?% ~2 {. C' F$ t  7739:20210917:150726.980 server #2 started [alerter #1]: D" [, I* i8 }" H. D) z# T
  7740:20210917:150726.981 server #3 started [alerter #2]
) u) `! s* W! F! i5 D0 P  7741:20210917:150726.981 server #4 started [alerter #3]9 r/ R4 x! o6 U# r3 N5 J" K4 A
  7742:20210917:150726.981 server #5 started [housekeeper #1]2 ?6 Y. r; s7 O. a
  7743:20210917:150726.982 server #6 started [timer #1]+ j/ E6 D3 {% m2 @+ _
  7744:20210917:150726.982 server #7 started [http poller #1]
' L0 Q5 x% `1 ]; W5 H) o" V  7747:20210917:150726.983 server #8 started [discoverer #1]
2 C+ `0 _& o2 ^5 Q6 q/ [+ I+ H  7748:20210917:150726.984 server #9 started [history syncer #1]
! ?! c) ?" `3 W6 Z1 c  7750:20210917:150726.985 server #10 started [history syncer #2]
" Z* z' h$ Q  ^; m" v1 H1 K8 P+ @" d  7751:20210917:150726.985 server #11 started [history syncer #3]& y. y+ F2 d/ b' Z* S
  7755:20210917:150726.986 server #13 started [escalator #1]
1 r& j* c% t8 [8 a% b6 w  F1 k  7753:20210917:150726.986 server #12 started [history syncer #4]& o, Y4 P$ H! m$ s0 {
  7756:20210917:150726.986 server #14 started [proxy poller #1]: {& a; Z% y/ W/ H- b
  7759:20210917:150726.987 server #16 started [task manager #1]
# m9 h1 d; M. v, A! k. P$ t0 J; \  7760:20210917:150726.988 server #17 started [poller #1]
8 g' ~" D" e7 H8 L1 R6 H  7765:20210917:150726.990 server #21 started [poller #5]
, t& g  E' U- ]) ^7 U  \6 s. @  7762:20210917:150726.990 server #18 started [poller #2]
5 b/ T" i4 }8 n  7764:20210917:150726.990 server #20 started [poller #4]
* y2 P) C- [# y' m" o: Y5 K  7768:20210917:150726.993 server #23 started [trapper #1]: \/ X5 t( w& ~6 q/ d
  7770:20210917:150726.993 server #25 started [trapper #3]
9 ~2 r, V" d. K# U) R8 z6 c; R  7771:20210917:150726.994 server #26 started [trapper #4]
! f/ v4 I) }+ |2 |( T; ~% r/ Y  Y0 ~4 U  7774:20210917:150726.995 server #29 started [alert manager #1]
4 O% M" {* J% E  7769:20210917:150726.996 server #24 started [trapper #2]
% y' ]" `3 r& v5 J. _0 a( ~  7766:20210917:150726.997 server #22 started [unreachable poller #1]
' W, L: x( Y5 o3 {. @* O  7773:20210917:150726.997 server #28 started [icmp pinger #1]
# D4 @* ~$ ?6 g  7776:20210917:150726.997 server #30 started [preprocessing manager #1]3 ]5 U- e5 l/ S
  7763:20210917:150726.998 server #19 started [poller #3], l7 U+ x# k% I% ]
  7757:20210917:150726.999 server #15 started [self-monitoring #1]
+ I# L  v3 C0 Y3 [# e  7772:20210917:150726.999 server #27 started [trapper #5]$ s! I; k$ j9 Z' b, l
  7777:20210917:150727.093 server #31 started [preprocessing worker #1]0 S2 D; W+ F/ N% W
  7778:20210917:150727.094 server #32 started [preprocessing worker #2]
. d8 c8 `$ u" M! M( C( ~; V+ {  7779:20210917:150727.094 server #33 started [preprocessing worker #3]
1 P$ x8 Z: o! d; ^+ y7 w; 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
* z- u8 o: t3 y2 Y7 W6 v" }  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds
( ^! l0 O' f7 }, D, M8 X& ^  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable3 f, ]& R3 N: B8 [8 \- C4 u
  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
+ e+ s" Q$ ?; C  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable
! Y$ N2 ]& z' E' a; X6 e* b: Z7 j" ^* d
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 04:06 , Processed in 0.015927 second(s), 23 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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