Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

RemoteFileOpenAbility fails on windows [CORE3059] #3439

Closed
firebird-automations opened this issue Jun 23, 2010 · 14 comments
Closed

RemoteFileOpenAbility fails on windows [CORE3059] #3439

firebird-automations opened this issue Jun 23, 2010 · 14 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Derryck welas (welas)

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 )

Commits: fbb34b2 363cabb

@firebird-automations
Copy link
Collaborator Author

Modified by: Derryck welas (welas)

description:
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 spcific user account (that has RW access to share)

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

=>

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 )

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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

PS Always show exact error message !

@firebird-automations
Copy link
Collaborator Author

Commented by: Derryck welas (welas)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Derryck welas (welas)

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 ?

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Derryck welas (welas)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Thanks for confirmation.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Cannot be tested

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants