dbdbprofile¶

Configuration for DB profile resource.

Properties¶

(click to see Operations )

Name	Data Type	Permissions	Description
name	<String>	Read-write	Name for the database profile. Must begin with an ASCII alphanumeric or underscore (_) character, and must contain only ASCII alphanumeric, underscore, hash (#), period (.), space, colon (:), at sign (@), equal sign (=), and hyphen (-) characters. Cannot be changed after the profile is created. CLI Users: If the name includes one or more spaces, enclose the name in double or single quotation marks (for example, "my profile" or 'my profile'). . Minimum length = 1 Maximum length = 127
interpretquery	<String>	Read-write	If ENABLED, inspect the query and update the connection information, if required. If DISABLED, forward the query to the server. Default value: YES Possible values = YES, NO
stickiness	<String>	Read-write	If the queries are related to each other, forward to the same backend server. Default value: NO Possible values = YES, NO
kcdaccount	<String>	Read-write	Name of the KCD account that is used for Windows authentication. Minimum length = 1 Maximum length = 127
conmultiplex	<String>	Read-write	Use the same server-side connection for multiple client-side requests. Default is enabled. Default value: ENABLED Possible values = ENABLED, DISABLED
enablecachingconmuxoff	<String>	Read-write	Enable caching when connection multiplexing is OFF. Default value: DISABLED Possible values = ENABLED, DISABLED
refcnt	<Double>	Read-only	Profile Reference Count.
__count	<Double>	Read-only	count parameter

Operations¶

(click to see Properties )

ADD
DELETE
UPDATE
UNSET
GET (ALL)
GET
COUNT

Some options that you can use for each operations:

Getting warnings in response: NITRO allows you to get warnings in an operation by specifying the 'warning' query parameter as 'yes'. For example, to get warnings while connecting to the NetScaler appliance, the URL is as follows:
http:// <netscaler-ip-address> /nitro/v1/config/login?warning=yes
If any, the warnings are displayed in the response payload with the HTTP code '209 X-NITRO-WARNING'.
Authenticated access for individual NITRO operations: NITRO allows you to logon to the NetScaler appliance to perform individual operations. You can use this option instead of creating a NITRO session (using the login object) and then using that session to perform all operations,
To do this, you must specify the username and password in the request header of the NITRO request as follows:
X-NITRO-USER: <username>
X-NITRO-PASS: <password>
Note: In such cases, make sure that the request header DOES not include the following:
Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Note:

Mandatory parameters are marked in red and placeholder content is marked in green

add¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile

HTTP Method: POST

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Content-Type:application/json

Request Payload:

{"dbdbprofile":{
<b>      "name":<String_value>,
</b>      "interpretquery":<String_value>,
      "stickiness":<String_value>,
      "kcdaccount":<String_value>,
      "conmultiplex":<String_value>,
      "enablecachingconmuxoff":<String_value>
}}

Response:

HTTP Status Code on Success: 201 Created

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

delete¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile/ name_value<String>

HTTP Method: DELETE

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

update¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile

HTTP Method: PUT

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Content-Type:application/json

Request Payload:

{"dbdbprofile":{
<b>      "name":<String_value>,
</b>      "interpretquery":<String_value>,
      "stickiness":<String_value>,
      "kcdaccount":<String_value>,
      "conmultiplex":<String_value>,
      "enablecachingconmuxoff":<String_value>
}}

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

unset¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? action=unset

HTTP Method: POST

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Content-Type:application/json

Request Payload:

{"dbdbprofile":{
<b>      "name":<String_value>,
</b>      "interpretquery":true,
      "stickiness":true,
      "kcdaccount":true,
      "conmultiplex":true,
      "enablecachingconmuxoff":true
}}

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

get (all)¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile

Query-parameters:

attrs

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? attrs=property-name1,property-name2

Use this query parameter to specify the resource details that you want to retrieve.

filter

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? filter=property-name1:property-val1,property-name2:property-val2

Use this query-parameter to get the filtered set of dbdbprofile resources configured on NetScaler.Filtering can be done on any of the properties of the resource.

view

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? view=summary

Use this query-parameter to get the summary output of dbdbprofile resources configured on NetScaler.

Note: By default, the retrieved results are displayed in detail view (?view=detail).

pagination

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? pagesize=#no;pageno=#no

Use this query-parameter to get the dbdbprofile resources in chunks.

HTTP Method: GET

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Accept:application/json

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

Response Header:

Content-Type:application/json

Response Payload:

{ "dbdbprofile": [ {
      "name":<String_value>,
      "interpretquery":<String_value>,
      "stickiness":<String_value>,
      "kcdaccount":<String_value>,
      "conmultiplex":<String_value>,
      "refcnt":<Double_value>,
      "enablecachingconmuxoff":<String_value>
}]}

get¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile/ name_value<String>

Query-parameters:

attrs

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile/ name_value<String> ? attrs=property-name1,property-name2

Use this query parameter to specify the resource details that you want to retrieve.

view

http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile/ name_value<String> ? view=summary

Use this query-parameter to get the summary output of dbdbprofile resources configured on NetScaler.

Note: By default, the retrieved results are displayed in detail view (?view=detail).

HTTP Method: GET

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Accept:application/json

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

Response Header:

Content-Type:application/json

Response Payload:

{  "dbdbprofile": [ {
      "name":<String_value>,
      "interpretquery":<String_value>,
      "stickiness":<String_value>,
      "kcdaccount":<String_value>,
      "conmultiplex":<String_value>,
      "refcnt":<Double_value>,
      "enablecachingconmuxoff":<String_value>
}]}

count¶

URL: http:// <netscaler-ip-address> /nitro/v1/config/dbdbprofile? count=yes

HTTP Method: GET

Request Headers:

Cookie:NITRO_AUTH_TOKEN= <tokenvalue>

Accept:application/json

Response:

HTTP Status Code on Success: 200 OK

HTTP Status Code on Failure: 4xx <string> (for general HTTP errors) or 5xx <string> (for NetScaler-specific errors). The response payload provides details of the error

Response Header:

Content-Type:application/json

Response Payload:

{ "dbdbprofile": [ { "__count": "#no"} ] }