ZABBIX Forums  
  #1  
Old 07-12-2017, 07:55
konstantin.p konstantin.p is offline
Junior Member
 
Join Date: Sep 2017
Posts: 18
Default установка на posgresql

Добрый день!

Установил zabbix с поддержкой posgresql, установка прошла успешно но на веб интерфейсе в начальной странице ввода логина и пароля выходит ошибка

Error in query [ERROR: error executing query: OCIStmtExecute failed to execute remote query DETAIL: ORA-01400: cannot insert NULL into ("ZABBIX"."AUDITLOG"."RESOURCEID")]

подскажите в чем ошибка?

спасибо.
Reply With Quote
  #2  
Old 07-12-2017, 08:12
konstantin.p konstantin.p is offline
Junior Member
 
Join Date: Sep 2017
Posts: 18
Default скрин

вот скрин ошибки
Name:  zabbix-error.jpg
Views: 33
Size:  55.2 KB
Reply With Quote
  #3  
Old 07-12-2017, 13:21
konstantin.p konstantin.p is offline
Junior Member
 
Join Date: Sep 2017
Posts: 18
Default zabbix сервер не запускается

systemctl status zabbix-server.service
Б≈▐ zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: resources) since Thu 2017-12-07 17:19:58 +06; 5s ago
Process: 7535 ExecStop=/bin/kill -SIGTERM $MAINPID (code=exited, status=1/FAILURE)
Process: 7887 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 7533 (code=exited, status=1/FAILURE)

Dec 07 17:19:58 server-X-X-X systemd[1]: Failed to start Zabbix Server.
Dec 07 17:19:58 server-X-X-X systemd[1]: Unit zabbix-server.service entered failed state.
Dec 07 17:19:58 server-X-X-X systemd[1]: zabbix-server.service failed.
Reply With Quote
  #4  
Old 07-12-2017, 16:15
Kos Kos is offline
Senior Member
 
Join Date: Aug 2015
Location: Riga, Latvia
Posts: 605
Default

...а существует ли сама база данных?
Что пишет сервер при попытке запуститься в свой лог-файл (zabbix_server.log)?
Reply With Quote
  #5  
Old 08-12-2017, 05:17
konstantin.p konstantin.p is offline
Junior Member
 
Join Date: Sep 2017
Posts: 18
Default

Quote:
Originally Posted by Kos View Post
...а существует ли сама база данных?
Что пишет сервер при попытке запуститься в свой лог-файл (zabbix_server.log)?
2284:20171207:174022.098 cannot use database "zabbix": database is not a Zabbix database
2290:20171207:174032.312 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
2290:20171207:174032.312 ****** Enabled features ******
2290:20171207:174032.312 SNMP monitoring: YES
2290:20171207:174032.312 IPMI monitoring: YES
2290:20171207:174032.312 Web monitoring: YES
2290:20171207:174032.312 VMware monitoring: YES
2290:20171207:174032.312 SMTP authentication: YES
2290:20171207:174032.312 Jabber notifications: YES
2290:20171207:174032.313 Ez Texting notifications: YES
2290:20171207:174032.313 ODBC: YES
2290:20171207:174032.313 SSH2 support: YES
2290:20171207:174032.313 IPv6 support: YES
2290:20171207:174032.313 TLS support: YES
2290:20171207:174032.313 ******************************
2290:20171207:174032.313 using configuration file: /etc/zabbix/zabbix_server.conf
2290:20171207:174032.359 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: connection for foreign table "users" cannot be established
DETAIL: ORA-12541: TNS:no listener
[select userid from users limit 1]
2290:20171207:174032.359 cannot use database "zabbix": database is not a Zabbix database
[root@zbx-x-x-xt ~]#
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 02:42.