fortinet.fortimanager.fmgr_system_sql module – SQL settings.

Note

This module is part of the fortinet.fortimanager collection (version 2.8.2).

You might already have this collection installed if you are using the ansible package. It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it, use: ansible-galaxy collection install fortinet.fortimanager.

To use it in a playbook, specify: fortinet.fortimanager.fmgr_system_sql.

New in fortinet.fortimanager 2.0.0

Synopsis

• This module is able to configure a FortiManager device.

• Examples include all parameters and values which need to be adjusted to data sources before usage.

Parameters

Parameter	Comments
access_token string	The token to access FortiManager without using username and password.
bypass_validation boolean	Only set to True when module schema diffs with FortiManager API structure, module continues to execute without validating parameters. Choices: false ← (default) true
enable_log boolean	Enable/Disable logging for task. Choices: false ← (default) true
forticloud_access_token string	Authenticate Ansible client with forticloud API access token.
proposed_method string	The overridden method for the underlying Json RPC request. Choices: "update" "set" "add"
rc_failed list / elements=integer	The rc codes list with which the conditions to fail will be overriden.
rc_succeeded list / elements=integer	The rc codes list with which the conditions to succeed will be overriden.
system_sql dictionary	The top level parameters set.
background_rebuild aliases: background-rebuild string	Disable/Enable rebuild SQL database in the background. disable - Rebuild SQL database not in the background. enable - Rebuild SQL database in the background. Choices: "disable" "enable"
compress_table_min_age aliases: compress-table-min-age integer	Minimum age in days for SQL tables to be compressed.
custom_index aliases: custom-index list / elements=dictionary	Custom index.
case_sensitive aliases: case-sensitive string	Disable/Enable case sensitive index. disable - Build a case insensitive index. enable - Build a case sensitive index. Choices: "disable" "enable"
device_type aliases: device-type string	Device type. FortiGate - Device type to FortiGate. FortiManager - Set device type to FortiManager FortiClient - Set device type to FortiClient FortiMail - Device type to FortiMail. FortiWeb - Device type to FortiWeb. FortiCache - Set device type to FortiCache FortiSandbox - Set device type to FortiSandbox FortiDDoS - Set device type to FortiDDoS FortiAuthenticator - Set device type to FortiAuthenticator FortiProxy - Set device type to FortiProxy Choices: "FortiGate" "FortiManager" "FortiClient" "FortiMail" "FortiWeb" "FortiCache" "FortiSandbox" "FortiDDoS" "FortiAuthenticator" "FortiProxy"
id integer	Add or Edit log index fields.
index_field aliases: index-field string	Log field name to be indexed.
log_type aliases: log-type string	Log type. none - none app-ctrl attack content dlp emailfilter event generic history traffic virus voip webfilter netscan fct-event fct-traffic fct-netscan waf gtp dns ssh ssl Choices: "none" "app-ctrl" "attack" "content" "dlp" "emailfilter" "event" "generic" "history" "traffic" "virus" "voip" "webfilter" "netscan" "fct-event" "fct-traffic" "fct-netscan" "waf" "gtp" "dns" "ssh" "ssl" "file-filter" "asset" "protocol" "siem" "ztna" "security"
custom_skipidx aliases: custom-skipidx list / elements=dictionary	Custom skipidx.
device_type aliases: device-type string	Device type. FortiGate - Set device type to FortiGate. FortiManager - Set device type to FortiManager FortiClient - Set device type to FortiClient. FortiMail - Set device type to FortiMail. FortiWeb - Set device type to FortiWeb. FortiSandbox - Set device type to FortiSandbox FortiProxy - Set device type to FortiProxy Choices: "FortiGate" "FortiManager" "FortiClient" "FortiMail" "FortiWeb" "FortiSandbox" "FortiProxy"
id integer	Add or Edit log index fields.
index_field aliases: index-field string	Field to be added to skip index.
log_type aliases: log-type string	Log type. app-ctrl attack content dlp emailfilter event generic history traffic virus voip webfilter netscan fct-event fct-traffic fct-netscan waf gtp dns ssh ssl file-filter asset Choices: "app-ctrl" "attack" "content" "dlp" "emailfilter" "event" "generic" "history" "traffic" "virus" "voip" "webfilter" "netscan" "fct-event" "fct-traffic" "fct-netscan" "waf" "gtp" "dns" "ssh" "ssl" "file-filter" "asset" "protocol" "siem" "ztna" "security"
database_name aliases: database-name string	Database name.
database_type aliases: database-type string	Database type. mysql - MySQL database. postgres - PostgreSQL local database. Choices: "mysql" "postgres"
device_count_high aliases: device-count-high string	Must set to enable if the count of registered devices is greater than 8000. disable - Set to disable if device count is less than 8000. enable - Set to enable if device count is equal to or greater than 8000. Choices: "disable" "enable"
event_table_partition_time aliases: event-table-partition-time integer	Maximum SQL database table partitioning time range in minute
fct_table_partition_time aliases: fct-table-partition-time integer	Maximum SQL database table partitioning time range in minute
logtype list / elements=string	Log type. none - None. app-ctrl attack content dlp emailfilter event generic history traffic virus voip webfilter netscan fct-event fct-traffic fct-netscan waf gtp dns ssh ssl Choices: "none" "app-ctrl" "attack" "content" "dlp" "emailfilter" "event" "generic" "history" "traffic" "virus" "voip" "webfilter" "netscan" "fct-event" "fct-traffic" "fct-netscan" "waf" "gtp" "dns" "ssh" "ssl" "file-filter" "asset" "protocol" "siem" "ztna" "security"
password any	(list) Password for login remote database.
prompt_sql_upgrade aliases: prompt-sql-upgrade string	Prompt to convert log database into SQL database at start time on GUI. disable - Do not prompt to upgrade log database to SQL database at start time on GUI. enable - Prompt to upgrade log database to SQL database at start time on GUI. Choices: "disable" "enable"
rebuild_event aliases: rebuild-event string	Disable/Enable rebuild event during SQL database rebuilding. disable - Do not rebuild event during SQL database rebuilding. enable - Rebuild event during SQL database rebuilding. Choices: "disable" "enable"
rebuild_event_start_time aliases: rebuild-event-start-time any	(list) Rebuild event starting date and time
server string	Database IP or hostname.
start_time aliases: start-time any	(list) Start date and time
status string	SQL database status. disable - Disable SQL database. local - Enable local database. Choices: "disable" "local"
text_search_index aliases: text-search-index string	Disable/Enable text search index. disable - Do not create text search index. enable - Create text search index. Choices: "disable" "enable"
traffic_table_partition_time aliases: traffic-table-partition-time integer	Maximum SQL database table partitioning time range in minute
ts_index_field aliases: ts-index-field list / elements=dictionary	Ts index field.
category string	Category of text search index fields.
value string	Fields of text search index.
username string	User name for login remote database.
utm_table_partition_time aliases: utm-table-partition-time integer	Maximum SQL database table partitioning time range in minute
workspace_locking_adom string	The adom to lock for FortiManager running in workspace mode, the value can be global and others including root.
workspace_locking_timeout integer	The maximum time in seconds to wait for other user to release the workspace lock. Default: 300

Notes

Note

• Starting in version 2.4.0, all input arguments are named using the underscore naming convention (snake_case). Please change the arguments such as “var-name” to “var_name”. Old argument names are still available yet you will receive deprecation warnings. You can ignore this warning by setting deprecation_warnings=False in ansible.cfg.

• Running in workspace locking mode is supported in this FortiManager module, the top level parameters workspace_locking_adom and workspace_locking_timeout help do the work.

• Normally, running one module can fail when a non-zero rc is returned. you can also override the conditions to fail or succeed with parameters rc_failed and rc_succeeded

Examples

- name: Example playbook (generated based on argument schema)
  hosts: fortimanagers
  connection: httpapi
  vars:
    ansible_httpapi_use_ssl: true
    ansible_httpapi_validate_certs: false
    ansible_httpapi_port: 443
  tasks:
    - name: SQL settings.
      fortinet.fortimanager.fmgr_system_sql:
        # bypass_validation: false
        workspace_locking_adom: <value in [global, custom adom including root]>
        workspace_locking_timeout: 300
        # rc_succeeded: [0, -2, -3, ...]
        # rc_failed: [-2, -3, ...]
        system_sql:
          background_rebuild: <value in [disable, enable]>
          custom_index:
            -
              case_sensitive: <value in [disable, enable]>
              device_type: <value in [FortiGate, FortiManager, FortiClient, ...]>
              id: <integer>
              index_field: <string>
              log_type: <value in [none, app-ctrl, attack, ...]>
          database_name: <string>
          database_type: <value in [mysql, postgres]>
          device_count_high: <value in [disable, enable]>
          event_table_partition_time: <integer>
          fct_table_partition_time: <integer>
          logtype:
            - "none"
            - "app-ctrl"
            - "attack"
            - "content"
            - "dlp"
            - "emailfilter"
            - "event"
            - "generic"
            - "history"
            - "traffic"
            - "virus"
            - "voip"
            - "webfilter"
            - "netscan"
            - "fct-event"
            - "fct-traffic"
            - "fct-netscan"
            - "waf"
            - "gtp"
            - "dns"
            - "ssh"
            - "ssl"
            - "file-filter"
            - "asset"
            - "protocol"
            - "siem"
            - "ztna"
            - "security"
          password: <list or string>
          prompt_sql_upgrade: <value in [disable, enable]>
          rebuild_event: <value in [disable, enable]>
          rebuild_event_start_time: <list or string>
          server: <string>
          start_time: <list or string>
          status: <value in [disable, local]>
          text_search_index: <value in [disable, enable]>
          traffic_table_partition_time: <integer>
          ts_index_field:
            -
              category: <string>
              value: <string>
          username: <string>
          utm_table_partition_time: <integer>
          custom_skipidx:
            -
              device_type: <value in [FortiGate, FortiManager, FortiClient, ...]>
              id: <integer>
              index_field: <string>
              log_type: <value in [app-ctrl, attack, content, ...]>
          compress_table_min_age: <integer>

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key	Description
meta dictionary	The result of the request. Returned: always
request_url string	The full url requested. Returned: always Sample: "/sys/login/user"
response_code integer	The status of api request. Returned: always Sample: 0
response_data list / elements=string	The api response. Returned: always
response_message string	The descriptive message of the api response. Returned: always Sample: "OK."
system_information dictionary	The information of the target system. Returned: always
rc integer	The status the request. Returned: always Sample: 0
version_check_warning list / elements=string	Warning if the parameters used in the playbook are not supported by the current FortiManager version. Returned: complex

Authors

• Xinwei Du (@dux-fortinet)

• Xing Li (@lix-fortinet)

• Jie Xue (@JieX19)

• Link Zheng (@chillancezen)

• Frank Shen (@fshen01)

• Hongbin Lu (@fgtdev-hblu)

Collection links

• Issue Tracker
• Homepage
• Repository (Sources)