See www.zabbix.com for the official Zabbix site.

Docs/DB schema/3.4/media type

From Zabbix.org
Jump to: navigation, search

This table contains the configured media types. Most of the columns are only meaningful for certain types and contain an empty string in unused fields.

Columns

Column Detail Default NULL? Type Ref from Ref to
mediatypeid Media type ID. Managed by Zabbix via the ids table. NONE NOT NULL id alerts.mediatypeid C
media.mediatypeid C
opmessage.mediatypeid
type Type of the mediatype.
  • 0 - MEDIA_TYPE_EMAIL
  • 1 - MEDIA_TYPE_EXEC
  • 2 - MEDIA_TYPE_SMS
  • 3 - MEDIA_TYPE_JABBER
  • 100 - MEDIA_TYPE_EZ_TEXTING
0 NOT NULL integer
description Name of the media type entry. EMPTY NOT NULL varchar(100)
smtp_server SMTP server host - only meaningful for MEDIA_TYPE_EMAIL. EMPTY NOT NULL varchar(255)
smtp_helo SMTP HELO string - only meaningful for MEDIA_TYPE_EMAIL. EMPTY NOT NULL varchar(255)
smtp_email From email address - only meaningful for MEDIA_TYPE_EMAIL. EMPTY NOT NULL varchar(255)
exec_path Path to the script - only meaningful for MEDIA_TYPE_EXEC. Relative to AlertScripts directory from the server configuration file. EMPTY NOT NULL varchar(255)
gsm_modem Path to the modem device - only meaningful for MEDIA_TYPE_SMS. EMPTY NOT NULL varchar(255)
username Username - only meaningful for MEDIA_TYPE_JABBER or MEDIA_TYPE_EZ_TEXTING, or MEDIA_TYPE_EMAIL with SMTP_AUTHENTICATION_NORMAL. EMPTY NOT NULL varchar(255)
passwd Password - only meaningful for MEDIA_TYPE_JABBER or MEDIA_TYPE_EZ_TEXTING, or MEDIA_TYPE_EMAIL with SMTP_AUTHENTICATION_NORMAL. EMPTY NOT NULL varchar(255)
status Status of the media type entry.
  • 0 - MEDIA_TYPE_STATUS_ACTIVE
  • 1 - MEDIA_TYPE_STATUS_DISABLED
0 NOT NULL integer
smtp_port SMTP port. 25 NOT NULL integer
smtp_security SMTP security.
  • 0 - SMTP_CONNECTION_SECURITY_NONE
  • 1 - SMTP_CONNECTION_SECURITY_STARTTLS
  • 2 - SMTP_CONNECTION_SECURITY_SSL_TLS
0 NOT NULL integer
smtp_verify_peer Whether the SMTP TLS certificate should be verified; used when type='MEDIA_TYPE_EMAIL and smtp_security=SMTP_CONNECTION_SECURITY_STARTTLS or SMTP_CONNECTION_SECURITY_SSL_TLS.
  • 0 - do not verify
  • 1 - verify
0 NOT NULL integer
smtp_verify_host Whether the SMTP TLS host name should be verified; used when type=MEDIA_TYPE_EMAIL and smtp_security=SMTP_CONNECTION_SECURITY_STARTTLS or SMTP_CONNECTION_SECURITY_SSL_TLS.
  • 0 - do not verify
  • 1 - verify
0 NOT NULL integer
smtp_authentication SMTP authentication status - only meaningful for MEDIA_TYPE_EMAIL.
  • 0 - SMTP_AUTHENTICATION_NONE
  • 1 - SMTP_AUTHENTICATION_NORMAL
0 NOT NULL integer
exec_params Newline separated parameters for the script; used when type=MEDIA_TYPE_EXEC EMPTY NOT NULL varchar(255)
maxsessions Maximum number of concurrent sessions for this media type. 1 NOT NULL integer
maxattempts Maximum number of attempts for this media type. 3 NOT NULL integer
attempt_interval Interval between sequential attempts.

Seconds if an integer or a time period.

10s NOT NULL varchar(32)

Indexes

Name UNIQ Columns
PRIMARY KEY YES mediatypeid
media_type_1 YES description