How to enable batch processing for ODBC based plugins

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

PAM Self-Hosted Articles
1 min read
L3 Networker
No ratings
In some situations, multiple commands need to be executed during with the ODBC CPM plugin.

IE: for MySQL when issuing the following:
UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%'; 

The command works but the password cannot be used because flush privileges is required.

Flush Privileges is a separate command so in order to run this Batch processing is needed so multiple command can be issued on the same command line.

IE:
UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%'; FLUSH PRIVILEGES;

Steps

In the Platform add the batch processing option to the connection string.

Note: This will only be successful if the ODBC driver in use supports batch processing.  You should refer to the driver's documentation for confirmation.

([Edit Plaform] -> Automatic Password Management -> Additional Policy Settings)
Property: ConnectionCommand

Update Command to include option 67108864 (batch processing)
IE:
OOB (SSL_Enforce and FOUND_ROWS enabled):
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=3;port=%PORT%;Password=%LOGONPASSWORD%

Batch processing enabled:
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=67108864;port=%PORT%;Password=%LOGONPASSWORD%

SSL_Enforce, FOUND_ROWS, and Batch processing enabled:
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=67108867;port=%PORT%;Password=%LOGONPASSWORD%
Rate this article:
  • 1392 Views
  • 0 comments
  • 0 Likes
Article Dashboard
Version history
Last Updated:
‎08-04-2020 10:01 AM
Updated by: