[MDEV-4713] Access denied message accessing symlinked existing database in data dir Created: 2013-06-26 Updated: 2013-06-27 Resolved: 2013-06-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.31 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Scott Harman | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | symlink | ||
| Environment: |
Win 7 x64, MariaDB 5.5.31 x64, MySQL 5.5.31 x64 |
||
| Attachments: |
|
| Description |
|
Hi guys |
| Comments |
| Comment by Vladislav Vaintroub [ 2013-06-26 ] |
|
User, that runs mysqld.exe should be able to access fiiles under the directory . MariaDB runs under NetworkService, by default, as it is a (relatively) weak predefined account, for security reasons. MySQL traditionally ran as LocalSystem, the most powerful account (comparable to Unix "root" ), but I think they have changed it with "universal" installer, and run, just like we, as NetworkService. The above means, that if you use symlink to some other directory, you should make sure NetworkService, or whatever user is running mysqld.exe, has full access to the directory. |
| Comment by Vladislav Vaintroub [ 2013-06-26 ] |
|
You can grant full access to directory and files in this directory to NetworkService account like this icacls "C:\path\to\directory" /grant NetworkService:(OI)(CI)F as described here http://stackoverflow.com/questions/2928738/how-to-grant-permission-to-users-for-a-directory-using-command-line-in-windows |
| Comment by Vladislav Vaintroub [ 2013-06-26 ] |
|
I assume this clarifies the issue. I'm closing this as "Not a Bug". But of course, feel free to reopen, if you still think that MariaDB is doing something wrong. |
| Comment by Scott Harman [ 2013-06-27 ] |
|
Yeah - I can accept that as closed |