[#CORE-3059] RemoteFileOpenAbility fails on windows

Firebird Core

RemoteFileOpenAbility fails on windows

Created: 23/Jun/10 09:17 AM Updated: 04/Feb/11 01:07 PM

Component/s:

Engine

Affects Version/s:

2.5 RC2

Fix Version/s:

2.5.1, 3.0 Alpha 1

Time Tracking:

Not Specified

Environment:

Windows 2003/windows xp

Planning Status:

Unspecified

Description

« Hide

Enable RemoteFileOpenAbility =1 in firebird conf

try connect to //<server>/<share>/database.fdb it fails.

also fails :

create shadow 1 //<server>/<share>/database.fdb
backup to //<server>/<share>/database.bck

btw i'm using Classic server >RC2 /RC3 snapshot

tried running fb_inet_server under local system account and specific user account (that has RW access to share)

(may be this only works with super server but that is not stated in release notes )

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 23/Jun/10 09:27 AM

IIRC, it's supposed to work for mapped drives only. UNC paths are not allowed, as the "//host/path" syntax is a valid Named Pipes (aka NetBEUI) connection string, so it's considered being a network request.

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 23/Jun/10 09:34 AM

Windows used \\ not //
Not sure if it matters, but try \\server\share\path syntax

PS Always show exact error message !

[ Permalink | « Hide ]

Derryck welas added a comment - 23/Jun/10 10:26 AM - edited

using isql from a 2.5 install , X: is windows shared disk
(ISQL Version: WI-V2.5.0.25920 Firebird 2.5 Release Candidate 2)

D:\data>isql

SQL> CONNECT "localhost:X:\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxxxxx';
Statement failed, SQLSTATE = 08001
unavailable database

SQL> CONNECT "X:\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxxxx';
Statement failed, SQLSTATE = 08001
unavailable database

(just testing the \\)
SQL> CONNECT "localhost:\\10.235.108.58\data\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxx';
Statement failed, SQLSTATE = 08001
unavailable database

SQL> CONNECT "\\10.235.108.58\data\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxx';
Statement failed, SQLSTATE = 28000
Access to database "C:\WINDOWS\SYSTEM32\DATA\MONITOR22.FDB" is denied by server administrator

(From an XP desktop )

D:\data>isql -z
ISQL Version: WI-V2.5.0.26038 Firebird 2.5 Release Candidate 3

SQL> CONNECT "localhost:z:\data\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxxxxx';
Statement failed, SQLSTATE = 08001
unavailable database

SQL> CONNECT "z:\data\monitor22.fdb"
CON> user 'SYSDBA' password 'xxxxxx';
Statement failed, SQLSTATE = 08001
unavailable database

[ Permalink | « Hide ]

Sean Leyne added a comment - 23/Jun/10 04:18 PM

Mapped drives are not available to Windows services, the mapping definitions are only available to the interactive user.

Therefore, support for mapped drives is only available for the embedded engine.

[ Permalink | « Hide ]

Derryck welas added a comment - 25/Jun/10 10:18 AM

oke, "interactive user ": when classic started like this fb_inet_server -a then i can connect to X:
where x is a network drive. Also tested "CREATE SHADOW" with a network share.

only problem , workability of this solution wont fly in a production environment )-;

Thinking out loud :
maybe a config to disable "NetBEUI" /Named Pipes etc.. and then enable "//<host>/<path>" syntax for
"RemoteFileOpenAbility" functionality ?

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 13/Nov/10 06:42 AM

Derrick, could you please test the next (tomorrow's) v2.5 snapshot build regarding this ticket and report back your findings.

[ Permalink | « Hide ]

Derryck welas added a comment - 18/Nov/10 09:04 AM

Tested ISQL,GBAK works oke with //<host>/<path> syntax.
also "create shadow " works .
many thanks !!!!

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 18/Nov/10 11:40 AM

Thanks for confirmation.