Issue ODBC 5.1 permission problem: Specified driver could not be loaded due to system error 5: Access deni

[Lorenzo84]

Every about 20 days I receive this error in one of my website installed in Plesk:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver, C:\Program Files (x86)\MySQL\Connector ODBC 5.1\myodbc5.dll).

I resolve temporarly whith this workaroud:
Connection to MySQL database fails: Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver)

After about 20 days the problem occurs again.
I think when Plesk run permission repair tool

I have italian Plesk Onyx Version 17.5.3 Update #41

Thank's
Lorenzo

 

[MarkM]

Have you tried upgrading or even just reinstalling the ODBC driver?

 

[Lorenzo84]

No,
I don't update ODBC driver, I have this error from first installation

Do you think I need to update? I think it's a problem of Plesk permission repair tool

Thank's
Lorenzo

 

[MarkM]

Wait - are you running the repair utility that frequently?

 

[Lorenzo84]

No. Never.
Sometimes (about every 20 day) I get this error and the cause is the changed permission of pca users. I think that is Plesk that revoke permission to this user in odbc directory.

Thanks

 

[MarkM]

Did you customize DiskSecurity?

What do you have in this folder;

%plesk_dir%\etc\DiskSecurity

 

[Lorenzo84]

No, I don't customize.

I have a XML file with this lines:

<!-- [MYSQL_ODBC5] -->
<Entry AccounType="1" Account="Psaadm" Path="[MYSQL_ODBC5]" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="ReadAndExecute" EntryFlags="0" />
<Entry AccounType="1" Account="Psacln" Path="[MYSQL_ODBC5]" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="ReadAndExecute" EntryFlags="0" />
<Entry AccounType="1" Account="Psaserv" Path="[MYSQL_ODBC5]" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="ReadAndExecute" EntryFlags="0" />
<Entry AccounType="0" Account="NetworkService" Path="[MYSQL_ODBC5]" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="ReadAndExecute" EntryFlags="0" />
<Entry AccounType="1" Account="IIS_IUSRS" Path="[MYSQL_ODBC5]" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="ReadAndExecute" EntryFlags="0" />

I need to change it?

 

[Lorenzo84]

I read info about DiskSecurety... I need to create a new file xml with this lines, right?

<?xml version="1.0" encoding="utf-8" ?>
<Entries>
<Entry AccounType="1" Account="Psacln" Path="{ProgramFilesX86}" SubPath="MySQL\Connector ODBC 5.1" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0" />
<Entry AccounType="1" Account="Psaadm" Path="{ProgramFilesX86}" SubPath="MySQL\Connector ODBC 5.1" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0" />
</Entries>

It's correct?

How I can test if this is the error?

Thank's
Lorenzo