Re: [Dokan] Digest for dokan@googlegroups.com - 4 updates in 1 topic

[Kyle Hamilton]

I believe that MSSQL requires sparse file support. Dokan doesn't handle or expose the necessary fsctls.

-Kyle H

On Wed, Jan 29, 2020, 00:42 <do...@googlegroups.com> wrote:

do...@googlegroups.com

Google Groups

Topic digest
View all topics

• Dokany as file system for MS SQL server databases? - 4 Updates

Dokany as file system for MS SQL server databases?

Hristo Stoyanov <hr.st...@gmail.com>: Jan 28 09:26AM -0800 Has anyone successfully deployed Dokany-based virtual drive/mount point to back by MS SQL server database location?   I tried to use cryptomator encrypted local driver as a test (dokany-nio-driver), but MS SQL does not recognize the dokany-based virtual drive/mount point and refuses to store data files there. I wonder if dokany is truly a filesystem, or MS SQL uses some obscure tests to figure out if the database filesystem is genuine/native or not?   Thanks. Hristo

Adrien JUND <soultai...@gmail.com>: Jan 28 06:33PM +0100 Hi!   Could you try to mount the mirror sample installed in the dokan folder and enable the mount manager option? It can make the difference with applications not seeing the filesystem by default.   Best regards Adrien JUND   Le mar. 28 janv. 2020 à 18:26, Hristo Stoyanov <hr.st...@gmail.com> a écrit :

Hristo Stoyanov <hr.st...@gmail.com>: Jan 28 08:10PM -0800 *Adrien*, Thanks for the hint! ...So, I mounted a mirror drive* Z:* onto my* c:\hristo_test\mirror *folder, with the /o option, as you suggested:     *Unmount the drive with CTRL + C in the console or alternatively via "dokanctl /u MountPoint".PS C:\Program Files\Dokan\DokanLibrary-1.3.0> .\mirror.exe /r c:\hristo_test\mirror /o /l Z:*   Next, I created a* Z:\DATA* folder with no issues, but when I tried to create a MS SQL database in Z:\DATA with SQL Server Management Studio by executing this script:                                     *USE master;GOdrop database SolutionsGOCREATE DATABASE SolutionsON( NAME = Solutions_dat, FILENAME = 'z:\data\Solutionsdat.mdf', SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 5MB ) LOG ON( NAME = Solutions_log, FILENAME = 'z:data\Solutionslog.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB );GO*   I get the below error. I tried to set permissions, etc., but could not get rid of this error:   *Msg 3701, Level 11, State 1, Line 3* *Cannot drop the database 'Solutions', because it does not exist or you do not have permission.* *Msg 5123, Level 16, State 1, Line 5* *CREATE FILE encountered operating system error 1307(This security ID may not be assigned as the owner of this object.) while attempting to open or create the physical file 'z:\data\Solutionsdat.mdf'.* *Msg 1802, Level 16, State 4, Line 5* *CREATE DATABASE failed. Some file names listed could not be created. Check related errors.*     Please advise.   Note that this happens only with the Dokany drive Z: - any of the normal hard disk drives on my machine worked fine with the above steps.   This can be easily reproduced if you download SQL Server Express (FREE from Microsoft) and repeat my steps.   I used Windows 2012 server for th etests.           On Tuesday, January 28, 2020 at 5:34:05 PM UTC, Liryna wrote:

Hristo Stoyanov <hr.st...@gmail.com>: Jan 28 08:26PM -0800 If this helps, here is the captured output when MIRROR.EXE is run with /d /s options:   CreateFile status = c0000034 ###Create 0264 CreateFile : c:\hristo_test\mirror\data\Solutionsdat.mdf AccountName: MSSQL$SQLEXPRESS, DomainName: NT SERVICE ShareMode = 0x3 FILE_SHARE_READ FILE_SHARE_WRITE DesiredAccess = 0x100080 FILE_READ_ATTRIBUTES SYNCHRONIZE FlagsAndAttributes = 0x200080 FILE_ATTRIBUTE_NORMAL FILE_FLAG_OPEN_REPARSE_POINT OPEN_EXISTING error code = 2     CreateFile status = c0000034 ###Create 0265 CreateFile : c:\hristo_test\mirror\DATA AccountName: MSSQL$SQLEXPRESS, DomainName: NT SERVICE ShareMode = 0x3 FILE_SHARE_READ FILE_SHARE_WRITE DesiredAccess = 0x100080 FILE_READ_ATTRIBUTES SYNCHRONIZE Cannot open a dir as a file CreateFile status = c00000ba ###Create 0266 CreateFile : c:\hristo_test\mirror\DATA AccountName: MSSQL$SQLEXPRESS, DomainName: NT SERVICE ShareMode = 0x3 FILE_SHARE_READ FILE_SHARE_WRITE DesiredAccess = 0x100080 FILE_READ_ATTRIBUTES SYNCHRONIZE FlagsAndAttributes = 0x200080 FILE_ATTRIBUTE_NORMAL FILE_FLAG_OPEN_REPARSE_POINT OPEN_EXISTING   CreateFile status = 0 ###Cleanup 0266 Cleanup: c:\hristo_test\mirror\DATA         On Wednesday, January 29, 2020 at 4:10:22 AM UTC, Hristo Stoyanov wrote:

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to dokan+un...@googlegroups.com.

[Hristo Stoyanov]

Kyle,
If true, that would be a show stopper for me.

... Although,the below error couldindicate something else -security related?

[Adrien JUND]

Yes it looks more to be a security issue. Probably from an inheritance not handle from the parent folder.

Would need the mirror log here. 

--
You received this message because you are subscribed to the Google Groups "Dokan" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dokan+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dokan/18052095-ef0b-401b-8734-5944305835b7%40googlegroups.com.

[Hristo Stoyanov]

Adrien,
I already provided a snippet in my earlier post. I can produce a full log for tomorrow, if this is going to help.

The steps I provided in the previous post makes it very easy to test with sql server express, a fee download from Microsoft.

[Adrien JUND]

Oh my bad I will check the log tomorrow!

I just do not have my env available for now. 

As soon as I get it I will do the test. 

Best regards 

Liryna 

--
You received this message because you are subscribed to the Google Groups "Dokan" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dokan+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/dokan/39d7b16f-ac04-4d65-8756-b292e71bdfd4%40googlegroups.com.