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-issue-importer opened this issue Jun 23, 2010 · 14 comments
Closed

RemoteFileOpenAbility fails on windows [CORE3059] #3439

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2010

Commented by: @hvlad

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

PS Always show exact error message !

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 25, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 13, 2010

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 13, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 13, 2010

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2010

Commented by: Derryck welas (welas)

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2010

Commented by: @dyemanov

Thanks for confirmation.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2010

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 20, 2015

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants