fortinet.fortimanager.fmgr_system_sql module – SQL settings.

Note

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

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 string	Deprecated, please rename it to background_rebuild. 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 integer	Deprecated, please rename it to compress_table_min_age. Minimum age in days for SQL tables to be compressed.
custom-index list / elements=dictionary	Deprecated, please rename it to custom_index. Custom index.
case-sensitive string	Deprecated, please rename it to case_sensitive. Disable/Enable case sensitive index. disable - Build a case insensitive index. enable - Build a case sensitive index. Choices: "disable" "enable"
device-type string	Deprecated, please rename it to device_type. 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 string	Deprecated, please rename it to index_field. Log field name to be indexed.
log-type string	Deprecated, please rename it to log_type. 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 list / elements=dictionary	Deprecated, please rename it to custom_skipidx. Custom skipidx.
device-type string	Deprecated, please rename it to device_type. 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 string	Deprecated, please rename it to index_field. Field to be added to skip index.
log-type string	Deprecated, please rename it to log_type. 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 string	Deprecated, please rename it to database_name. Database name.
database-type string	Deprecated, please rename it to database_type. Database type. mysql - MySQL database. postgres - PostgreSQL local database. Choices: "mysql" "postgres"
device-count-high string	Deprecated, please rename it to device_count_high. 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 integer	Deprecated, please rename it to event_table_partition_time. Maximum SQL database table partitioning time range in minute
fct-table-partition-time integer	Deprecated, please rename it to fct_table_partition_time. 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 string	Deprecated, please rename it to prompt_sql_upgrade. 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 string	Deprecated, please rename it to rebuild_event. 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 any	(list) Deprecated, please rename it to rebuild_event_start_time. Rebuild event starting date and time
server string	Database IP or hostname.
start-time any	(list) Deprecated, please rename it to start_time. Start date and time
status string	SQL database status. disable - Disable SQL database. local - Enable local database. Choices: "disable" "local"
text-search-index string	Deprecated, please rename it to text_search_index. Disable/Enable text search index. disable - Do not create text search index. enable - Create text search index. Choices: "disable" "enable"
traffic-table-partition-time integer	Deprecated, please rename it to traffic_table_partition_time. Maximum SQL database table partitioning time range in minute
ts-index-field list / elements=dictionary	Deprecated, please rename it to ts_index_field. 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 integer	Deprecated, please rename it to utm_table_partition_time. 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)