create/schema shell> cat sqlite.sql | sqlite3 /var/lib/sqlite/zabbix.db shell> cd ../data shell> cat data.sql | sqlite3 /var/lib/sqlite/zabbix.db shell> cat images_sqlite3.sql | sqlite3 /var/lib/sqlite/zabbix.db shell> ./configure --enable-server --with-sqlite3 --with-net-snmp --with-jabber --with-libcurl # for SQLite3 + Jabber + WEB monitoring Note: Use flag --with-ibm-db2 to specify location of the CLI API. Use postgresql.sql | psql -U zabbix For SQLite: shell> cd create/schema shell> cat sqlite.sql | sqlite3 /var/lib/sqlite/zabbix.db Note: The database will be automatically created if it does not exist

side due to licensing issues. While it was not recommended to use Zabbix server and frontend with SQLite3 database before, this change makes it even less recommended, because simultaneous database access with Zabbix server and frontend may now corrupt the database. Note that using Zabbix proxy with SQLite3 database is still a perfectly valid solution. ** Housekeeper changes ** On zabbix_server and zabbix_proxy Attention: IBM DB2 support is experimental! Attention: While SQLite3 can be used with Zabbix proxies without any problems, using SQLite3 with Zabbix server is not recom- mended. Since Zabbix 2.4.0, simultaneous

side due to licensing issues. While it was not recommended to use Zabbix server and frontend with SQLite3 database before, this change makes it even less recommended, because simultaneous database access with Zabbix server and frontend may now corrupt the database. Note that using Zabbix proxy with SQLite3 database is still a perfectly valid solution. 11 What’s new in Zabbix 2.2.6 11.1 Frontend improvements Attention: IBM DB2 support is experimental! Attention: While SQLite3 can be used with Zabbix proxies without any problems, using SQLite3 with Zabbix server is not recom- mended. Since Zabbix 2.2.5, simultaneous

Attention: IBM DB2 support is experimental! 34 Attention: While SQLite3 can be used with Zabbix proxies without any problems, using SQLite3 with Zabbix server is not recom- mended. Since Zabbix 2.4.0, simultaneous as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. sqlite3 Required if SQLite is used as Zabbix backend database. Note: Zabbix may work on previous versions PostgreSQL, SQLite One of the following modules must be installed: ibm_db2, mysql, oci8, pgsql, sqlite3 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled In

Attention: IBM DB2 support is experimental! Attention: While SQLite3 can be used with Zabbix proxies without any problems, using SQLite3 with Zabbix server is not recom- mended. Since Zabbix 2.4.0, simultaneous as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. sqlite3 Required if SQLite is used as Zabbix backend database. Note: Zabbix may work on previous versions PostgreSQL, SQLite One of the following modules must be installed: ibm_db2, mysql, oci8, pgsql, sqlite3 bcmath php-bcmath mbstring php-mbstring PHP mbstring.func_overload option must be disabled In

is used as Zabbix backend database. Attention: IBM DB2 support is experimental! Attention: SQLite3 support for use with Zabbix server is experimental! Frontend The following software is required as Zabbix backend database. pgsql Required if PostgreSQL is used as Zabbix backend database. sqlite3 Required if SQLite is used as Zabbix backend database. 46 Note: Zabbix may work on previous versions PostgreSQL, SQLite One of the following modules must be installed: ibm_db2, mysql, oci8, pgsql, sqlite3 bcmath php-bcmath mbstring php-mbstring sockets php-net-socket. Required for user script support

zabbix-web-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database For Zabbix server and proxy daemons a database is required gz | sudo -u psql zabbix # zcat /usr/share/doc/zabbix-proxy-sqlite3*/schema.sql.gz | sqlite3 zabbix.db Configure database for Zabbix server/proxy Edit zabbix_server.conf or zabbix_proxy.conf zabbix-frontend-php Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database For Zabbix server and proxy daemons a database is required

database/sqlite3 shell> sqlite3 /var/lib/sqlite/zabbix.db < schema.sql # stop here if you are creating database for Zabbix proxy shell> sqlite3 /var/lib/sqlite/zabbix.db < images.sql shell> sqlite3 /var/lib/sqlite/zabbix 如 果 是 Post- greSQL 只 有 空 字 符 串 会 使 用 socket. 11 参数必 范围 默认值 描述 DBName yes 数 据 库 名 称. 对 于 SQLite3 必 须 提 供 数 据 库 文 件 路 径. 数 据 库 用 户 名 和 密 码 可 以 忽 略. DBPassword no 数 据 库 登 陆 密 码. SQLite 可 忽 略. 如 no 0-1000000 5000 一 个 house- keep- ing 周 期 内， 一 个 任 务 删 除 的 最 大 行 数 （相 应 的 表 名， 字 段 名， 值）。 SQLite3 不 使 用 该 参 数， 删 除 所 有 相 应 的 行。 如 果 设 置 为 0， 不 再 限 制 删 除 的 行 数， 这 种 情 况， 你 必 须 清 楚 自 己 在 做 什 么! Zabbix

zabbix-proxy-mysql Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). Creating database Create a separate database for Zabbix proxy. Zabbix server sql.gz | sudo -u zabbix psql zabbix # zcat /usr/share/doc/zabbix-proxy-sqlite3*/schema.sql.gz | sqlite3 zabbix.db Configure database for Zabbix proxy Edit zabbix_proxy.conf: 79 # vi /etc/zabbix/zabbix_proxy install zabbix-proxy-mysql Substitute ’mysql’ in the command with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3. Creating database Create a separate database for Zabbix proxy. Zabbix server

database upgrade on proxies with SQLite Upon the first launch after an upgrade, Zabbix proxy with SQLite3 now automatically dumps the existing older version of the database file and creates a new one for version Description github.com/godror/godror 0.20.1 Oracle DB driver. github.com/mattn/go- sqlite3 2.0.3 Sqlite3 driver. github.com/mediocregopher/radix/v33.5.0 Redis client. github.com/memcachier/mc/v3 zabbix-sql-scripts Substitute ’mysql’ in the commands with ’pgsql’ to use PostgreSQL, or with ’sqlite3’ to use SQLite3 (proxy only). The package ’zabbix-sql-scripts’ contains database schemas for all supported