Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
What is the fifth word in this sentence?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: buah
« on: February 10, 2010, 10:59:45 pm »

Of course! Firebird QuickStart Guide:
Quote
You cannot locate components of the server, or any database, on a mapped drive, a filesystem share or a network filesystem.

To add one more issue, which I recently resolved. In case of such an error messages
Quote
2:Unable to complete network request to host "@1".
Failed to establish a connection.
A connection attempt failed because the connected party did not properly respond afer period of time, or established connection failed because connected host has failed to respond.
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Error Code: 401


4:unavailable database
Unsuccessful execution caused by an unavailable resource.
Error Code: 55


ERROR
Failed to open database

most likely you'll have to open 3050 TCP port on your firewall, or any other TCP port defined in firebird.conf, line:
#RemoteServiceName = gds_db
#RemoteServicePort = 3050

Another solution is to add fbserver.exe and/or fbguard.exe services to an exception list in firewall.

I haven't checked if this issue was treated earlier in forum, so I apologize if it was.
Posted by: swinster
« on: February 08, 2010, 11:28:10 pm »

I've been saying UDF, I really meant UNC relating to remote path names  :-[. However, as was show, even mapped drives don't work, although I'm guessing they will resolve to a UNC path.
Posted by: buah
« on: February 08, 2010, 10:15:29 pm »

I found this line (#128) in firebird.conf:"UdfAccess = None". That could explain a lot...
Posted by: buah
« on: February 07, 2010, 04:30:02 pm »

Quote from: swinster on February 07, 2010, 04:15:40 pm
Maybe examples of what WON'T work would be as useful as what will.

Absolutely. And that's how existing wiki entry could be updated? Unfortunately, my English is not so good :(

Cheers
Posted by: swinster
« on: February 07, 2010, 04:15:40 pm »

Quote from: buah on February 07, 2010, 03:48:20 pm
Quote from: swinster on February 07, 2010, 04:40:36 am
I really appreciate all this, but I had a thought and have finally resolved the issue.

server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd

Quote from: buah on February 07, 2010, 01:09:46 am
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

Quote from: buah on February 07, 2010, 02:05:54 am
Yes, but I meant instead "server" to enter it's address.

With those two comments above, that's exactly what I suggested, too. I never suggested to use remote path.



Again apologies. However, as it was shown earlier (and above), if the path is actually a route to server share (either UDF or a mapped drive) it won't work. The database HAS to physically be located on the machine with the instance of FB is running AND the path MUST be local to that machine. I must admit, I didn't see the WIKI entry until after the fact.

For instance, all of these refer to exactly the same location, and would be acceptable references to access the resource from each machine, but only the first one works:

server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, local path on server - WORKS!

server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, share on the same server - DOESN'T Work
127.0.0.1:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on local machine, share on remote server - DOESN'T Work
127.0.0.1:Z:\My Documents\Personal Video Database\movies.pvd - FB on local machine, mapped drive to remote server - DOESN'T Work


The biggest issue for me was that as I run a server and have all the users files redirected to shares on a server, and even though these shares use off-line files (so essentially I am using a local copy), the default install of PVD creates the DB in the "My Docs" folder - which is actually a server share.

Maybe examples of what WON'T work would be as useful as what will.
Posted by: buah
« on: February 07, 2010, 03:48:20 pm »

Quote from: swinster on February 07, 2010, 04:40:36 am
I really appreciate all this, but I had a thought and have finally resolved the issue.

server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd

Quote from: buah on February 07, 2010, 01:09:46 am
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

Quote from: buah on February 07, 2010, 02:05:54 am
Yes, but I meant instead "server" to enter it's address.

With those two comments above, that's exactly what I suggested, too. I never suggested to use remote path.

Quote from: swinster on February 07, 2010, 11:41:45 am
I think the problem was that UDF share names do not seem to be liked by Firebird in the Connection string.

It's not that Firebird doesn't like UDF. It's how it was designed to be, I think?

Existing Wiki entry was totally ok saying:
Quote
Remote server path configuration
The database path for the Firebird server can be entered using one the following formats:

   1. local path (if both client and server are on the same computer)
   2. computer name:local path
   3. ip:local path

You always have to specify database's local path.
The following paragraph "Movie path configuration" explains how to handle remote paths. And that's another little gem of PVD.



Posted by: swinster
« on: February 07, 2010, 11:41:45 am »

Quote from: rick.ca on February 07, 2010, 05:18:13 am
This is exactly what I meant by "[server name]:[database path]", but I obviously didn't have the words to convey this effectively. Maybe someone familiar with a network/server environment (i.e., not me) can improve the existing wiki entry, but it seems to cover it as is.

Actually, the WIKI entry seems to be quite good. I think the problem was that UDF share names do not seem to be liked by Firebird in the Connection string, and the error messages provided by Firebird where a little obscure. Not to mention lavish amounts of stupidity on my part - I really should know the difference between absolute and relative path names (Rick - I think your sig is quite apt in this case!)


Posted by: rick.ca
« on: February 07, 2010, 05:18:13 am »

This is exactly what I meant by "[server name]:[database path]", but I obviously didn't have the words to convey this effectively. Maybe someone familiar with a network/server environment (i.e., not me) can improve the existing wiki entry, but it seems to cover it as is.
Posted by: swinster
« on: February 07, 2010, 04:40:36 am »

I really appreciate all this, but I had a thought and have finally resolved the issue.

You can specify the remote server as indicated in the posts above, but you need to pass the physical location of the database file on the SERVER, rather then with refernce to the local machine. So, we end up with a connection string that's:


server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd


Still, I'm a little confused as to why UDF notation didn't work, as this is still accessible from the server (i,e, \\server\users\me....).

This might be useful to stick in you solved problem in case anyone else wishes to run the database from a remote location.


Many thanks all. Now I just need to figure out how it all works.

Posted by: buah
« on: February 07, 2010, 02:41:53 am »

1. Did you try to copy movies.pvd to a local disc and to open it without connecting to a server?
2. Did you try with stopping firebird services first, then to open it from a local disc?
3. Did you install Kroozbox, maybe? If so, try to uninstall it, then open database from local disc?
Posted by: swinster
« on: February 07, 2010, 02:35:26 am »

Just to let you know, both my user account and the System account have full permissions on both the folder and file. The firebird service is started used the Local System account.
Posted by: swinster
« on: February 07, 2010, 02:26:32 am »

Quote from: buah on February 07, 2010, 02:24:28 am
Can you open movies.pvd from mapped drive without connecting to server?
No

I get the error:

2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24
Posted by: buah
« on: February 07, 2010, 02:24:28 am »

Can you open movies.pvd from mapped drive without connecting to server?
Posted by: swinster
« on: February 07, 2010, 02:16:40 am »

Quote from: buah on February 07, 2010, 02:05:54 am
Yes, but I meant instead "server" to enter it's address. I would also check sharing and security permissions. If that wouldn't work, I would map network drive so I could try 127.0.0.1 syntax... Although, if you could map it, it would meant that sharing and security permissions were ok.

I have tried connecting to the local machine and server (using both IP or machine name), using both UDF and mapped network drive, but still no joy. Tried connections such as:

127.0.0.1:Z:\My Documents\Personal Video Database\movies.pvd
server:Z:\My Documents\Personal Video Database\movies.pvd
etc

Any further ideas?
Posted by: buah
« on: February 07, 2010, 02:05:54 am »

Yes, but I meant instead "server" to enter it's address. I would also check sharing and security permissions. If that wouldn't work, I would map network drive so I could try 127.0.0.1 syntax... Although, if you could map it, it would meant that sharing and security permissions were ok.
Posted by: swinster
« on: February 07, 2010, 01:44:13 am »

Quote from: buah on February 07, 2010, 01:09:46 am
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

It works for me fine.
although 127.0.0.1 refers to you local machine, I have tried

server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd

and I now get the error:

1:unavailable database
Unsuccessful execution caused by an unavailable resource
Error Code:55

As said, all permissions seem fine.  
Posted by: buah
« on: February 07, 2010, 01:09:46 am »

Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?

It works for me fine.
Posted by: swinster
« on: February 07, 2010, 12:08:39 am »

apologies - didn't see the -user and -pass parameters that can be passed - will try that

Now tried

server:Users\me\My Documents\Personal Video Database\movies.pvd -user SYSDBA -pass masterke

same error as:

2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24

I only get the the user name/password error when I try to OPEN (not Connect) the movies.pvd file, but only then once I close down PVD and re-open

Posted by: swinster
« on: February 07, 2010, 12:03:31 am »

Quote from: rick.ca on February 06, 2010, 11:32:53 pm
Does this help? You shouldn't need to login to Firebird.
Unfortunately not. As you say, I shouldn't need a username and password and there isn't the moption to insert them anywhere.

Quote from: rick.ca on February 06, 2010, 11:32:53 pm
How, exactly, are you specifying the connection? "[server name]:[database path]" should work.
I have tried a simple ip address or machine name, UDF convention and not your suggested method (with the braces). So I have:

server:Users\me\My Documents\Personal Video Database\movies.pvd

With this I get the error message:
2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24

Not sure what else to try.
Posted by: rick.ca
« on: February 06, 2010, 11:32:53 pm »

Does this help? You shouldn't need to login to Firebird.

How, exactly, are you specifying the connection? "[server name]:[database path]" should work.
anything