Zabbix Documentation 4.4

3.04.04.4 (current)| In development:5.0 (devel)| Unsupported:1.82.02.22.43.23.44.2Guidelines

User Tools

Site Tools


manual:appendix:install:db_scripts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:appendix:install:db_scripts [2020/02/20 13:20]
martins-v instructions for mysql 8
manual:appendix:install:db_scripts [2020/03/06 08:05] (current)
martins-v fixing link target
Line 15: Line 15:
  
 Character set utf8 and utf8_bin collation is required for Zabbix server to work properly with MySQL database. Character set utf8 and utf8_bin collation is required for Zabbix server to work properly with MySQL database.
- 
-Instructions for creating a Zabbix database for MySQL versions prior to 8.0: 
- 
-  shell> mysql -uroot -p<​password>​ 
-  mysql> create database zabbix character set utf8 collate utf8_bin; 
-  mysql> grant all privileges on zabbix.* to [email protected] identified by '<​password>';​ 
-  mysql> quit; 
- 
-Instructions for creating a Zabbix database with MySQL 8.0 and later: 
  
   shell> mysql -uroot -p<​password>​   shell> mysql -uroot -p<​password>​
Line 68: Line 59:
 <note warning>​Currently TimescaleDB is not supported by Zabbix proxy.</​note>​ <note warning>​Currently TimescaleDB is not supported by Zabbix proxy.</​note>​
  
-We assume that TimescaleDB extension has been already installed ​in the database (see [[https://​docs.timescale.com/​v1.1/​getting-started/​installation|installation instructions]]).+We assume that TimescaleDB extension has been already installed ​on the database ​server ​(see [[https://​docs.timescale.com/​latest/​getting-started/​installation|installation instructions]]).
  
 TimescaleDB extension must also be enabled for the specific DB by executing: TimescaleDB extension must also be enabled for the specific DB by executing:
Line 74: Line 65:
   echo "​CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;"​ | sudo -u postgres psql zabbix   echo "​CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;"​ | sudo -u postgres psql zabbix
  
-Running this command requires database administrator privileges. ​+Running this command requires database administrator privileges. 
 + 
 +<​note>​If you use a database schema other than '​public'​ you need to add a SCHEMA clause to the command above. E.g.:\\ ''​echo %%"​%%CREATE EXTENSION IF NOT EXISTS timescaledb SCHEMA yourschema CASCADE;​%%"​%% | sudo -u postgres psql zabbix''</​note>​
  
 The ''​timescaledb.sql''​ script is located in database/​postgresql. The script must be run after the regular PostgreSQL database has been created with initial schema/data (see section above): The ''​timescaledb.sql''​ script is located in database/​postgresql. The script must be run after the regular PostgreSQL database has been created with initial schema/data (see section above):