找回密码
 注册
查看: 1948|回复: 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.conf# \( X* M4 |' \) p* W; A
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
4 Z0 u# j- G4 D3 H" @8 z  7580:20210917:145626.903 database is down: reconnecting in 10 seconds% O+ ~5 W  X' t; `) M: T
  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
2 V+ Z( C. W3 G  V! p" T1 b/ _  7580:20210917:145636.904 database is down: reconnecting in 10 seconds; q4 G# T3 B* T/ s6 ?- G$ e& L
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)" V- `1 R  H: Q; o
  7580:20210917:145646.905 database is down: reconnecting in 10 seconds6 z; }# |$ W6 t' h! [
  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)& v% `+ a9 C9 |7 ?- e& c0 E
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
) T: V/ O1 u/ ^3 B' w  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
/ U0 U0 w& n' Z& u* E+ v1 V3 K( x  7580:20210917:145706.907 database is down: reconnecting in 10 seconds
9 n& G6 ~; Y- h9 q9 ^. x  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)  \  F  [9 q9 Q! ]$ `
  7580:20210917:145716.907 database is down: reconnecting in 10 seconds% }7 j. g  H7 A' j5 f, c- D
  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)) [/ g7 f& t; T" @
  7580:20210917:145726.908 database is down: reconnecting in 10 seconds
8 I1 d  b# n% e! v) M4 z" ~7 b  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
* v6 V9 H" W& f' e; d  7580:20210917:145736.910 database is down: reconnecting in 10 seconds* |3 p1 F" k& |* D
  1 G( ]+ h, [! @5 k$ \4 X. p6 h
4 w4 P6 c3 r1 B- |0 K- @" Z
日志一直报错,解决办法:' a2 j7 [# ?6 m& O, H
2 \5 P! d' N& O$ v. a, D0 X* z
5 s8 j( x& ]9 F5 m+ C2 G6 a
数据库添加权限:% F3 a$ V% H! q  d0 b0 f; [
grant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";
# n/ _8 L1 t7 d. O! Z+ G* J0 g( ?5 i. j. R! i

. Q$ O# x" r+ a, A

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:% C/ ?% N& ?9 L4 u! l
如日志所示:+ P6 u: ~- O2 a6 M9 e
7580:20210917:150726.962 database connection re-established
+ T9 Y% O) w# b" l( ~6 I  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007
, A( k- \8 u* S1 i; Y  7580:20210917:150726.963 required mandatory version: 03040000
8 o( o5 Z, l2 C# s5 J' P2 a: C; y! D  7580:20210917:150726.979 server #0 started [main process]( O9 m) c0 e, l/ F* v
  7738:20210917:150726.980 server #1 started [configuration syncer #1]: N0 d+ |* v) g' P& H: {
  7739:20210917:150726.980 server #2 started [alerter #1], m9 q3 }& c% ~* H. b
  7740:20210917:150726.981 server #3 started [alerter #2]
5 _; s5 q( P5 S' x  7741:20210917:150726.981 server #4 started [alerter #3]
+ C; \. E( O- s) J( [0 {  7742:20210917:150726.981 server #5 started [housekeeper #1]( l( A0 r& w# b0 G/ c: k
  7743:20210917:150726.982 server #6 started [timer #1]
( Z" x( m$ K' F8 G0 |, Y( y) ^  7744:20210917:150726.982 server #7 started [http poller #1]+ z/ L  c- ~7 J8 p& J4 p
  7747:20210917:150726.983 server #8 started [discoverer #1]9 |8 o% h0 r9 ^
  7748:20210917:150726.984 server #9 started [history syncer #1]& W5 q& R2 d) x* h1 D! J
  7750:20210917:150726.985 server #10 started [history syncer #2]* ~: s4 Y$ O0 W9 _! B+ D9 ]6 [5 C
  7751:20210917:150726.985 server #11 started [history syncer #3]
& P7 e+ |- m! {( {9 `  7755:20210917:150726.986 server #13 started [escalator #1]
* w: R" L  V) i- x  7753:20210917:150726.986 server #12 started [history syncer #4]
8 d1 T* R. d/ R; O( D  7756:20210917:150726.986 server #14 started [proxy poller #1]
: \- [& _- X& M/ i  7759:20210917:150726.987 server #16 started [task manager #1]
  K8 o9 W9 X$ U9 f2 k6 v- k$ E  7760:20210917:150726.988 server #17 started [poller #1]
. L! Z" ^# p9 g# f: N  7765:20210917:150726.990 server #21 started [poller #5]; H* ^* D: _. X0 G
  7762:20210917:150726.990 server #18 started [poller #2]- u  J: u' [6 D( @4 H6 X
  7764:20210917:150726.990 server #20 started [poller #4]
7 w! j$ t7 I; U  7768:20210917:150726.993 server #23 started [trapper #1]
  N" v+ X; D" A  7770:20210917:150726.993 server #25 started [trapper #3]
$ P0 J6 o" m1 ^. m: r0 y8 p6 w  7771:20210917:150726.994 server #26 started [trapper #4]& M. u# P) O7 y" g; d( n
  7774:20210917:150726.995 server #29 started [alert manager #1]: W- ^& i5 |5 @5 M& ]2 m
  7769:20210917:150726.996 server #24 started [trapper #2]
0 w* `0 h8 ?$ e% P6 ]  7766:20210917:150726.997 server #22 started [unreachable poller #1]! m  @. i, `1 |- K+ _6 v0 o5 t
  7773:20210917:150726.997 server #28 started [icmp pinger #1]
! s5 _. j% |  ?$ K5 p2 @7 g  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
1 \4 c3 Q! L+ q6 j: Q6 W7 r  7763:20210917:150726.998 server #19 started [poller #3]4 v. @# {  V1 @3 b+ H* a
  7757:20210917:150726.999 server #15 started [self-monitoring #1]7 w9 m2 O7 P" a# E* q5 h7 e) c9 Z" J
  7772:20210917:150726.999 server #27 started [trapper #5]
2 Z/ m, Y7 c. J2 V, @5 L  7777:20210917:150727.093 server #31 started [preprocessing worker #1]
% b1 u6 \; T2 Q( v0 Q  7778:20210917:150727.094 server #32 started [preprocessing worker #2]' A: F; ~8 M( S: I1 h: H
  7779:20210917:150727.094 server #33 started [preprocessing worker #3]
" ~7 `4 V$ J6 ]6 \; m1 D2 {6 {& ~  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" l* g3 y3 w$ O7 ~+ Q3 L1 i% n$ j
  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds
9 D' P! ~7 n- }( `2 Y4 l* ?  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable
1 E! a- i. B/ Y  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
. u# K$ ~; u2 m" ^( h) R4 [. @  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable9 t" x' e  [/ {  f% D+ f1 ~
' {) |) ~& ^7 v/ g3 i
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 01:55 , Processed in 0.019558 second(s), 23 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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