<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article How to enable batch processing for ODBC based plugins in PAM Self-Hosted Articles</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-articles/how-to-enable-batch-processing-for-odbc-based-plugins/ta-p/1430016</link>
    <description>In some situations, multiple commands need to be executed during with the ODBC CPM plugin.&lt;BR /&gt;&lt;BR /&gt;IE: for MySQL when issuing the following:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%';&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;The command works but the password cannot be used because flush privileges is required.&lt;BR /&gt;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;IE:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%'; FLUSH PRIVILEGES;&lt;/SPAN&gt;
&lt;H3&gt;Steps&lt;/H3&gt;
In the Platform add the batch processing option to the connection string.&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;Note:&lt;/B&gt; This will only be successful if the ODBC driver in use supports batch processing.&amp;nbsp; You should refer to the driver's documentation for confirmation.&lt;BR /&gt;&lt;BR /&gt;([Edit Plaform] -&amp;gt; Automatic Password Management -&amp;gt; Additional Policy Settings)&lt;BR /&gt;Property:&amp;nbsp;ConnectionCommand&lt;BR /&gt;&lt;BR /&gt;Update Command to include option 67108864 (batch processing)&lt;BR /&gt;IE:&lt;BR /&gt;OOB (SSL_Enforce and FOUND_ROWS enabled):&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=3;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;Batch processing enabled:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver};server=%ADDRESS%;user=%USER%;option=67108864;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;SSL_Enforce, FOUND_ROWS, and Batch processing enabled:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver};server=%ADDRESS%;user=%USER%;option=67108867;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;</description>
    <pubDate>Tue, 04 Aug 2020 17:01:20 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-08-04T17:01:20Z</dc:date>
    <item>
      <title>How to enable batch processing for ODBC based plugins</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-articles/how-to-enable-batch-processing-for-odbc-based-plugins/ta-p/1430016</link>
      <description>In some situations, multiple commands need to be executed during with the ODBC CPM plugin.&lt;BR /&gt;&lt;BR /&gt;IE: for MySQL when issuing the following:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%';&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;The command works but the password cannot be used because flush privileges is required.&lt;BR /&gt;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;IE:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%'; FLUSH PRIVILEGES;&lt;/SPAN&gt;
&lt;H3&gt;Steps&lt;/H3&gt;
In the Platform add the batch processing option to the connection string.&lt;BR /&gt;&lt;BR /&gt;&lt;B&gt;Note:&lt;/B&gt; This will only be successful if the ODBC driver in use supports batch processing.&amp;nbsp; You should refer to the driver's documentation for confirmation.&lt;BR /&gt;&lt;BR /&gt;([Edit Plaform] -&amp;gt; Automatic Password Management -&amp;gt; Additional Policy Settings)&lt;BR /&gt;Property:&amp;nbsp;ConnectionCommand&lt;BR /&gt;&lt;BR /&gt;Update Command to include option 67108864 (batch processing)&lt;BR /&gt;IE:&lt;BR /&gt;OOB (SSL_Enforce and FOUND_ROWS enabled):&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=3;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;Batch processing enabled:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver};server=%ADDRESS%;user=%USER%;option=67108864;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;SSL_Enforce, FOUND_ROWS, and Batch processing enabled:&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver={MySQL ODBC 3.51&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;Driver};server=%ADDRESS%;user=%USER%;option=67108867;port=%PORT%;Password=%LOGONPASSWORD%&lt;/SPAN&gt;</description>
      <pubDate>Tue, 04 Aug 2020 17:01:20 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-articles/how-to-enable-batch-processing-for-odbc-based-plugins/ta-p/1430016</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-08-04T17:01:20Z</dc:date>
    </item>
  </channel>
</rss>

