fortinet.fortimanager.fmgr_system_sql module – SQL settings.

Note

This module is part of the fortinet.fortimanager collection (version 2.3.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

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

Minimum age in days for SQL tables to be compressed.

custom-index

list / elements=dictionary

Custom-Index.

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

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

string

Log field name to be indexed.

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

list / elements=dictionary

Custom-Skipidx.

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

string

Field to be added to skip index.

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

string

Database name.

database-type

string

Database type.

mysql - MySQL database.

postgres - PostgreSQL local database.

Choices:

  • "mysql"

  • "postgres"

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

integer

Maximum SQL database table partitioning time range in minute

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

file-filter

asset

protocol

siem

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

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

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) Rebuild event starting date and time

server

string

Database IP or hostname.

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

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

integer

Maximum SQL database table partitioning time range in minute

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

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

  • 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.

  • To create or update an object, use state present directive.

  • To delete an object, use state absent directive.

  • 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

- hosts: fortimanager-inventory
  collections:
    - fortinet.fortimanager
  connection: httpapi
  vars:
    ansible_httpapi_use_ssl: True
    ansible_httpapi_validate_certs: False
    ansible_httpapi_port: 443
  tasks:
    - name: SQL settings.
      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)