Issue Details (XML | Word | Printable)

Key: CORE-3059
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Derryck welas
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
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: Ascending order - Click to sort in descending order
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.

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 !

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



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.

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 ?


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.

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 !!!!

Dmitry Yemanov added a comment - 18/Nov/10 11:40 AM
Thanks for confirmation.