Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

['Daniel Miller' dmil...@amfes.com [firebird-support]]

The performance of vboxsf is horrible - that's why there are so many 
recommendations to use NFS or CIFS for guests.  So again I'm asking if 
there's any issue with accessing the .fdb via NFS - given the exclusive 
access I've described.

I don't see why there would be...other than ensuring that the access is 
indeed exclusive.

--
Daniel

On 10/5/2017 1:02:44 AM, "Elmar Haneke el...@haneke.de 
[firebird-support]"  wrote:

>
>>
>>
>>I have a single Linux host server with several Virtualbox guest VM's.
>>  I've been attempting to move everything possible from the host to one
>>of the guests.
>>
>>One of the last holdovers is Firebird.  The reason is I use NFS to
>>mount host folders within the guest for critical data - and the .fdb
>>certainly counts.
>
>NFS is an networking system not part of virtualbox.
>Virtualbox has an mechanism of its own to allow gests access to host
>filesystem you shoulkd try that instead.
>
>>So for my use case - I have a single Firebird server instance.  There
>>will never be more than one copy of Firebird running.  All write and
>>99.99% read access to the .fdb would be through that single Firebird
>>instance (except for automated remote backup operations running on the
>>host).
>
>It's not an good idea to backup database file while firebird-server is
>running on that file. You should use firebirds backup functionality 
>instead.
>
>>Am I "safe", possibly even correct, in using RemoteFileOpenAbility in
>>this use case?
>
>This option is for pepole knowing what they are doing - those pepole
>usually do not ask if it is ok.
>
>
>Elmar
>
>
>
>
>Posted by: Elmar Haneke 
>
>
>++
>
>Visit http://www.firebirdsql.org and click the Documentation item
>on the main (top) menu.  Try FAQ and other links from the left-side 
>menu there.
>
>Also search the knowledgebases at 
>http://www.ibphoenix.com/resources/documents/
>
>++
>
>
>Yahoo Groups Links
>
>
>

[firebird-support] Image based VM backup and Firebird?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Re: [firebird-support] embedded database with Chinese path

[Richard Damon rich...@damon-family.org [firebird-support]]

On 10/4/17 11:53 PM, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:
>
> On 04/10/17 22:15, DougC d...@moosemail.net [firebird-support] wrote:
>> Hamish-
>>
>> Windows short path names are decidedly NOT for apps that cannot 
>> handle Unicode. They were introduced far earlier than that and were 
>> intended for programs that could not handle anything but the short 
>> 8.3 limits for any given file or folder name. That they often help 
>> with avoiding unicode is a side effect.
>>
>> Sound like your misunderstanding of this may be contributing to your 
>> frustration.
>
> Doug,
>
> I'm aware that short filenames are a work around for applications 
> which can't support long filenames (which date from Windows 95). They 
> also seem to nicely work around applications which are too dumb to 
> support valid Windows 16-bit filenames, like Firebird. I don't agree 
> that it's just a side effect that they avoid unicode, since I had 
> unicode parts that fit in the 8.3 short filename format.
>
> I realise that Firebird needs to use either long or short names 
> consistently so as to avoid inadvertently opening the same file by 
> different names (with locking issues and the like), but the solution 
> is to use only short names or handle long names properly.
>
> Hamish
>
One thing to note, the Short File Names (SFN) can't use 'Unicode' 
characters, only the Extended Ascii character set of the current code 
page (so it may seem you can put some unicode in them). SFNs can't be 
UTF-8. Note, that this also means that changing the system code page 
might change the apparent name of a file that used the extended 
character set, even the separator might change (on the Japanese code 
page, that is the Yen symbol).

The big selling point of Long File Names (LFN) was that they could be 
mostly arbitrary phrases in the users own language, breaking BOTH the 8 
character limit AND the 8 bit char restriction (using 16 bit wchar to 
encode them). There is no such beast as a 8 bit only LFN, or a 16 bit 
(Unicode) encoded SFN.

Every file has a SFN just so that applications (like it appears that 
Firebird is) that don't support LFNs can still access the files.

-- 
Richard Damon

Re: [firebird-support] Service restore from stdin

[Pavel Cisar pci...@ibphoenix.cz [firebird-support]]

Hi,

Dne 4.10.2017 v 19:17 Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] napsal(a):
> 
> Another question: is there a way to abort restore process which would 
> cause server to
> drop half-restored database? For example, if I have a problem of reading 
> backup file.
> Or in this case I must connect to the database and drop it myself?

 From my experience it appears that gbak service process is terminated 
when you close the service, but I don't know if it always works this way 
and any circumstances and if it's applicable to other services. But it 
would have some logic that process will be terminated by engine when 
service connection is closed. Core devs or sources could confirm that 
information. However, this termination will/may leave some artifacts 
behind (like half-restored database, but I would expect cleanup of 
temporary files).

best regards
Pavel Cisar
IBPhoenix







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

[Elmar Haneke el...@haneke.de [firebird-support]]

>
>
> I have a single Linux host server with several Virtualbox guest VM's.
>  I've been attempting to move everything possible from the host to one
> of the guests.
>
> One of the last holdovers is Firebird.  The reason is I use NFS to
> mount host folders within the guest for critical data - and the .fdb
> certainly counts.

NFS is an networking system not part of virtualbox.
Virtualbox has an mechanism of its own to allow gests access to host
filesystem you shoulkd try that instead.

> So for my use case - I have a single Firebird server instance.  There
> will never be more than one copy of Firebird running.  All write and
> 99.99% read access to the .fdb would be through that single Firebird
> instance (except for automated remote backup operations running on the
> host).

It's not an good idea to backup database file while firebird-server is
running on that file. You should use firebirds backup functionality instead.

> Am I "safe", possibly even correct, in using RemoteFileOpenAbility in
> this use case?

This option is for pepole knowing what they are doing - those pepole
usually do not ask if it is ok.


Elmar

Re: [firebird-support] embedded database with Chinese path

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Hello Hamish,

Thursday, October 5, 2017, 4:53:24 PM, you wrote:

[...] all that

Have you considered trying a symbolic link?
https://www.howtogeek.com/howto/16226/complete-guide-to-symbolic-links-symlinks-on-windows-or-linux/