找回密码
 注册
查看: 1949|回复: 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.conf8 Z$ F% B# u3 U. i" ^2 A% j
  7580:20210917:145626.903 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
2 \; C8 ]* J' ^& z% U  7580:20210917:145626.903 database is down: reconnecting in 10 seconds
6 F; b; _: E  z& W1 x  7580:20210917:145636.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
: ?" v% W* W' H. J# b: {  7580:20210917:145636.904 database is down: reconnecting in 10 seconds# H9 e/ q6 U0 @' ^2 `+ i7 [
  7580:20210917:145646.904 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)! o! h; _3 s9 N4 _! o; d
  7580:20210917:145646.905 database is down: reconnecting in 10 seconds
$ T! l7 X. I! u  7580:20210917:145656.905 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)9 J0 w7 X2 f' H. ~6 O. Y/ j# s. ^
  7580:20210917:145656.905 database is down: reconnecting in 10 seconds
% I4 F: N1 U4 `( w# P  7580:20210917:145706.906 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
$ {5 ]9 P0 w6 f/ u/ G4 e  7580:20210917:145706.907 database is down: reconnecting in 10 seconds7 ~! [& E4 K( T1 f( F+ s
  7580:20210917:145716.907 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)% o/ \" ]2 s8 g+ F" \
  7580:20210917:145716.907 database is down: reconnecting in 10 seconds
. A$ e, G+ s, c+ a) U4 F0 w. X  7580:20210917:145726.908 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
% j. o7 m) I2 Q( D$ C+ m. q. N( P% G  7580:20210917:145726.908 database is down: reconnecting in 10 seconds
& E( v3 J- k0 a) \  7580:20210917:145736.910 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'zabbix-monitor.novalocal' (using password: YES)
* h) J( A7 ~8 u" ]/ o  7580:20210917:145736.910 database is down: reconnecting in 10 seconds. a2 k, f3 K5 ~) o4 i9 {
  9 m# j/ r7 x' j, q7 A$ `

  p& J6 h* e8 T  Y8 c4 e* ~: K日志一直报错,解决办法:
& C3 \: p# e5 j2 Y( v" ~3 M8 u9 g* e( p- ?
; C) p$ Y+ Q% ?9 f
数据库添加权限:
/ T) }0 ]1 W3 x5 A, N1 }! `grant ALL PRIVILEGES on zabbix.* to "zabbix"@"zabbix-monitor.novalocal" Identified by "zabbix";
8 u% _' [: W7 A4 P' t$ G" }" J3 O2 s9 q
% Z# L5 `# l7 N+ r, a2 O

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2021-9-17 15:09:54 | 显示全部楼层
问题解决:
" o" N( V+ i9 w如日志所示:
; m% K4 F' b3 N: s0 C+ @# b- a5 c 7580:20210917:150726.962 database connection re-established
5 b. L3 }6 P0 Z. |+ Y- N  7580:20210917:150726.963 current database version (mandatory/optional): 03040000/03040007) W% h" S) P8 |
  7580:20210917:150726.963 required mandatory version: 03040000
* S- K' g! D9 c$ C  7580:20210917:150726.979 server #0 started [main process]$ ]) O$ C/ ]* p
  7738:20210917:150726.980 server #1 started [configuration syncer #1]- [5 V0 d+ r) c# G/ G! k
  7739:20210917:150726.980 server #2 started [alerter #1]9 a- A1 A( X' D3 `5 a: t. M
  7740:20210917:150726.981 server #3 started [alerter #2]
1 p$ ^1 {( D4 F) R) b* d. z$ y4 @  7741:20210917:150726.981 server #4 started [alerter #3]
% V* \+ k" I1 f  7742:20210917:150726.981 server #5 started [housekeeper #1]% A/ n8 Q0 g9 h8 G
  7743:20210917:150726.982 server #6 started [timer #1]
$ ~: p/ v7 l* ?/ q  7744:20210917:150726.982 server #7 started [http poller #1]
% u& k) `1 Y1 t* |' x7 O4 E* g  7747:20210917:150726.983 server #8 started [discoverer #1]$ f: \! T$ C. l8 d. F
  7748:20210917:150726.984 server #9 started [history syncer #1]
$ V( \2 [& ]. a6 ]  7750:20210917:150726.985 server #10 started [history syncer #2]0 z/ H! A% i5 Q3 I4 d
  7751:20210917:150726.985 server #11 started [history syncer #3]  B2 {  M0 Z! I; F, u$ J
  7755:20210917:150726.986 server #13 started [escalator #1]
5 C! B  g! v+ o/ z  7753:20210917:150726.986 server #12 started [history syncer #4]
$ s! y! F# [2 \: ^6 T5 q0 [  7756:20210917:150726.986 server #14 started [proxy poller #1]5 J2 o3 V1 k6 Y2 ?5 c2 g
  7759:20210917:150726.987 server #16 started [task manager #1]6 ]% r" Q* w, Q$ K2 j/ A6 U
  7760:20210917:150726.988 server #17 started [poller #1]
! {: s  F9 Z+ m, f# H7 R. G6 k) L  7765:20210917:150726.990 server #21 started [poller #5]# u& N# z7 D2 a  }) X" \; _# F
  7762:20210917:150726.990 server #18 started [poller #2]
) {0 E' B% N9 o& {; D  7764:20210917:150726.990 server #20 started [poller #4]
' l. I5 L9 K0 y' y5 Z  7768:20210917:150726.993 server #23 started [trapper #1]6 j" g; _0 B4 Z# x3 p* q; j# B! I; o
  7770:20210917:150726.993 server #25 started [trapper #3]
" l3 I: q0 t8 R: p& X  7771:20210917:150726.994 server #26 started [trapper #4]
" u) N3 ?; P0 s# f. {  7774:20210917:150726.995 server #29 started [alert manager #1]
# o; b$ m5 k( |. d# X  7769:20210917:150726.996 server #24 started [trapper #2]
9 \' O1 @, U% j  X& s* `5 k  7766:20210917:150726.997 server #22 started [unreachable poller #1]
) q  A# Q2 r- B9 f: P/ N# a6 n  7773:20210917:150726.997 server #28 started [icmp pinger #1]
# w/ @+ y' v' `3 W% L7 B  7776:20210917:150726.997 server #30 started [preprocessing manager #1]
+ I" o4 ?# \2 f. e/ b% G/ ^9 P# r. C  ~  7763:20210917:150726.998 server #19 started [poller #3]
$ M& k5 \$ F* \, M: z; l  7757:20210917:150726.999 server #15 started [self-monitoring #1]3 }- [8 `7 ]/ Q6 X1 ^
  7772:20210917:150726.999 server #27 started [trapper #5]% ~7 {* `5 D/ ~- A4 T
  7777:20210917:150727.093 server #31 started [preprocessing worker #1]
# [; B! J0 l! ?1 q% i  7778:20210917:150727.094 server #32 started [preprocessing worker #2]
; J# U( u( z1 ]1 E# N  7779:20210917:150727.094 server #33 started [preprocessing worker #3]
5 q% W, z$ C3 Z2 g  7760:20210917:150730.194 Zabbix agent item "system.users.num" on host "10.144.106.6" failed: first network error, wait for 15 seconds% d5 p# M) U  u1 H% g8 d- {
  7762:20210917:150744.196 Zabbix agent item "agent.ping" on host "10.144.108.9" failed: first network error, wait for 15 seconds2 V( n& b0 B% U1 y) i
  7766:20210917:150830.258 temporarily disabling Zabbix agent checks on host "10.144.106.6": host unavailable
" {' l* C* c! d# X  7770:20210917:150835.682 cannot send list of active checks to "10.144.108.9": host [zbbix-agent] not found
1 L; Z, Q4 |  T5 U% E# j  7766:20210917:150844.264 temporarily disabling Zabbix agent checks on host "10.144.108.9": host unavailable
" u( g. M$ L4 `' S# B1 T$ F" S
' O& M( d. s; d0 ~" \
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

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

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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