Re: [Firebird-net-provider] fbBackup on remote Clients
You`re welcome :)
2014-06-04 21:39 GMT+03:00 Jiri Cincura :
> Great. Now to pack it, test everything else works, add a nice wrap and
> ship it. :)
>
> Thanks for helping to test it! Appreciate it.
>
>
> On Wednesday, June 4, 2014, Ivan Arabadzhiev
> wrote:
>
>> Confirmed - restore now works :) Thanks a lot
>>
>>
>> 2014-06-04 18:04 GMT+03:00 Ivan Arabadzhiev :
>>
>>> Sorry for the trouble :( I specifically tested importing to check if the
>>> network would break. Looks like there is some host dependency. Don`t have a
>>> reliable host for virtual machines and I move way too much to give you
>>> access to my laptop :)
>>>
>>> Please tell me you have the same restore issues now that you got it
>>> working ?
>>>
>>>
>>> 2014-06-04 16:59 GMT+03:00 Jiri Cincura :
>>>
>>> Never mind, blind luck solved it. ;D
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>>
>>>
>>
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Great. Now to pack it, test everything else works, add a nice wrap and ship
it. :)
Thanks for helping to test it! Appreciate it.
On Wednesday, June 4, 2014, Ivan Arabadzhiev
wrote:
> Confirmed - restore now works :) Thanks a lot
>
>
> 2014-06-04 18:04 GMT+03:00 Ivan Arabadzhiev >:
>
>> Sorry for the trouble :( I specifically tested importing to check if the
>> network would break. Looks like there is some host dependency. Don`t have a
>> reliable host for virtual machines and I move way too much to give you
>> access to my laptop :)
>>
>> Please tell me you have the same restore issues now that you got it
>> working ?
>>
>>
>> 2014-06-04 16:59 GMT+03:00 Jiri Cincura > >:
>>
>> Never mind, blind luck solved it. ;D
>>>
>>>
>>> --
>>> Jiri {x2} Cincura
>>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>>
>>>
>>> --
>>> Learn Graph Databases - Download FREE O'Reilly Book
>>> "Graph Databases" is the definitive new guide to graph databases and
>>> their
>>> applications. Written by three acclaimed leaders in the field,
>>> this first edition is now available. Download your free book today!
>>> http://p.sf.net/sfu/NeoTech
>>> ___
>>> Firebird-net-provider mailing list
>>> Firebird-net-provider@lists.sourceforge.net
>>>
>>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>>
>>
>>
>
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Confirmed - restore now works :) Thanks a lot
2014-06-04 18:04 GMT+03:00 Ivan Arabadzhiev :
> Sorry for the trouble :( I specifically tested importing to check if the
> network would break. Looks like there is some host dependency. Don`t have a
> reliable host for virtual machines and I move way too much to give you
> access to my laptop :)
>
> Please tell me you have the same restore issues now that you got it
> working ?
>
>
> 2014-06-04 16:59 GMT+03:00 Jiri Cincura :
>
> Never mind, blind luck solved it. ;D
>>
>>
>> --
>> Jiri {x2} Cincura
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> --
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and their
>> applications. Written by three acclaimed leaders in the field,
>> this first edition is now available. Download your free book today!
>> http://p.sf.net/sfu/NeoTech
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
So. The bug is fixed, hopefully. Here's the build
http://speedy.sh/TCR3G/FirebirdClient.7z .
Can you check that and confirm it's OK?
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Sorry for the trouble :( I specifically tested importing to check if the
network would break. Looks like there is some host dependency. Don`t have a
reliable host for virtual machines and I move way too much to give you
access to my laptop :)
Please tell me you have the same restore issues now that you got it working
?
2014-06-04 16:59 GMT+03:00 Jiri Cincura :
> Never mind, blind luck solved it. ;D
>
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Never mind, blind luck solved it. ;D
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
BTW "ls /sys/class/net" get
ens35 lo
I believe the network interface are fucked up.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
The network there doesn't work. Can't you just make the VM available
from internet?
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
https://drive.google.com/file/d/0BxNlh1_CctC4Z3VVZUtCaDFETXM/edit?usp=sharing
(turned out smaller than I expected :)). I`ve exported it from VirtualBox
(and tested reeimporting). Should be ready to go at boot. DHCP is enabled.
root password is password. No configuration done on Firebird so I use /tmp
folder for tests.
I retested things at my end, just to be sure (client is XP 32 bit, server
is the VM)
Backup works (and is restorable by gbak)
Restore works *only* on other windows servers (testing only on 32 bit,
can`t say for 64).
Restore to VM throws one of two exceptions :
1 If I use the lib you sent earlier
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): expected backup
description record ---> expected backup description record
at FirebirdSql.Data.Services.FbStreamingRestore.Execute()
2 If I build from the git source tree (which I might be doing wrong ... I
guess)
System.ArgumentNullException: Value cannot be null.
Parameter name: stream
at System.Resources.ResourceReader..ctor(Stream stream)
2014-06-04 12:08 GMT+03:00 Jiri Cincura :
> On Wed, Jun 4, 2014 at 10:55 AM, Ivan Arabadzhiev
> wrote:
> > Won`t that be a problem?
>
> Not for me.
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Wed, Jun 4, 2014 at 10:55 AM, Ivan Arabadzhiev
wrote:
> Won`t that be a problem?
Not for me.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Well ... "System.ArgumentNullException: Value cannot be null. Parameter name: stream at System.Resources.ResourceReader..ctor(Stream stream) at System.Resources.ResourceSet..ctor(Stream stream) at FirebirdSql.Data.Common.IscException.CreateResourceSet(String resourceName) in \FirebirdSql\Data\Common\IscException.cs:line 299 at FirebirdSql.Data.Common.IscException.BuildSqlState() in \FirebirdSql\Data\Common\IscException.cs:line 197 at FirebirdSql.Data.Common.IscException.BuildExceptionData() in \FirebirdSql\Data\Common\IscException.cs:line 158 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadStatusVector() in \FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 723 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessOperation(Int32 operation) in \FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 800 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse() in \FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 788 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in \FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 677 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.R eadGenericResponse() in \FirebirdSql\Data\Client\Managed\Version10\GdsDatabase.cs:line 689 at FirebirdSql.Data.Client.Managed.Version10.GdsServiceManager.Query(ServiceParameterBuffer spb, Int32 requestLength, Byte[] requestBuffer, Int32 bufferLength, Byte[] buffer) in \FirebirdSql\Data\Client\Managed\Version10\GdsServiceManager.cs:line 170 at FirebirdSql.Data.Services.FbService.QueryService(Byte[] items) in \FirebirdSql\Data\Services\FbService.cs:line 417 at FirebirdSql.Data.Services.FbService.ProcessQuery(Byte[] items, Action`2 queryResponseAction) in \FirebirdSql\Data\Services\FbService.cs:line 301 at FirebirdSql.Data.Services.FbService.Query(Byte[] items, Action`2 resultAction) in \FirebirdSql\Data\Services\FbService.cs:line 262 at FirebirdSql.Data.Services.FbService.Query(Byte[] items) in \FirebirdSql\Data\Services\FbService.cs:line 221 at FirebirdSql.Data.Services.FbStreamingRestore.Do() in \FirebirdSql\Data\Services\FbStreamingRestore.cs:line 106 at FirebirdSql.Data.Services.FbStreamingRestore.Execute() in \FirebirdSql\Data\Services\FbStreamingRestore.cs:line 76" As for a VM - I could, but it would be ~2GB in size (a basic Arch with firebird). Won`t that be a problem? -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Wed, Jun 4, 2014 at 12:54 AM, Ivan Arabadzhiev
wrote:
> What do you mean by "first chance exception" ?
There's an exception/error before it get into IscException. That's
what triggered looking for resources with error message. You can put
breakpoint before the above mentioned method and see what's before.
Or if you can create i.e. VM with your setup, I can test then directly.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Not using mono:) I`m refactoring a backup tool for windows. I need xp
support so I keep things on .net 4.0 Client Profile and VS2010. It`s just
that most of the servers worth backing up run linux.
What do you mean by "first chance exception" ? A callstack perhaps?
2014-06-03 20:55 GMT+03:00 Jiri Cincura :
> This looks more like an Mono problem, because it cannot find the
> resource. But there's some exception before anyway. Can you get the
> first chance exception there and post it here.
>
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
This looks more like an Mono problem, because it cannot find the
resource. But there's some exception before anyway. Can you get the
first chance exception there and post it here.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Well, thanks :) I haven`t really been in touch and didn`t know there`s a
github repo. I got the sources from there and the error switched to
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Value cannot be
null.
Parameter name: stream ---> System.ArgumentNullException: Value cannot be
null.
Parameter name: stream
at System.Resources.ResourceReader..ctor(Stream stream)
at System.Resources.ResourceSet..ctor(Stream stream)
at FirebirdSql.Data.Common.IscException.CreateResourceSet(String
resourceName)
Now ... I can confirm that the exact same code works when the server is 32
bit windows. However, I cannot restore to a 64 bit linux server. All my
hosts are version LI-V2.5.2.26540 Firebird 2.5.I tried an Arch and an LFS
host. Both built by me, personally, with no extra tuning of the process. My
laptop is on OpenSUSE, same version - same problem. Backup is still working
:)
I`ll keep digging and try to see what exactly is different. So far I can
only say that the exception is thrown during the second pass of the reading
loop, by the line
response = Query(items); // FbStreamingRestore.cs, line 106
If you happen to have a linux machine to test on - I am curious whether
you`ll have the same issue :)
2014-06-03 13:59 GMT+03:00 Jiri Cincura :
> On Tue, Jun 3, 2014 at 10:46 AM, Ivan Arabadzhiev
> wrote:
> > Here's the restore function (in case it helps)
> >
> >using(io.FileStream BackupInputStream = new
> > FileStream(BackUpPath,FileMode.Open)) {
> > fbServer.FbStreamingRestore restore = new
> > fbServer.FbStreamingRestore();
> > restore.ConnectionString = getConnectionString(Host,
> > User, Pass, Path, Port, 32767);
> > SetRestoreOptions(Ovr, DeactivateIndexes, NoShadows,
> > NoValidity, OneAtTime, UseAllSpace, PageSize, restore);
> > restore.InputStream = BackupInputStream;
> > restore.Execute();
> > return true;
> > }
> >
> > Using a PageSize of 4096 or 16384 (both don't work). Options are Replace
> and
> > NoShadows (defaults, stuck since the end of time). I'm willing to help
> debug
>
> It went fine for me: http://pastecode.org/index.php/view/f1bade8d
> I used the same function as you did
> http://pastecode.org/index.php/view/9d31bb53 , I only added writing
> output. When it fails (you should be able to see it from output).
>
> > if I can get my hands on sources :)
>
> Sources are here
> https://github.com/cincuranet/NETProvider/tree/streaming-backup .
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Tue, Jun 3, 2014 at 10:46 AM, Ivan Arabadzhiev
wrote:
> Here's the restore function (in case it helps)
>
>using(io.FileStream BackupInputStream = new
> FileStream(BackUpPath,FileMode.Open)) {
> fbServer.FbStreamingRestore restore = new
> fbServer.FbStreamingRestore();
> restore.ConnectionString = getConnectionString(Host,
> User, Pass, Path, Port, 32767);
> SetRestoreOptions(Ovr, DeactivateIndexes, NoShadows,
> NoValidity, OneAtTime, UseAllSpace, PageSize, restore);
> restore.InputStream = BackupInputStream;
> restore.Execute();
> return true;
> }
>
> Using a PageSize of 4096 or 16384 (both don't work). Options are Replace and
> NoShadows (defaults, stuck since the end of time). I'm willing to help debug
It went fine for me: http://pastecode.org/index.php/view/f1bade8d
I used the same function as you did
http://pastecode.org/index.php/view/9d31bb53 , I only added writing
output. When it fails (you should be able to see it from output).
> if I can get my hands on sources :)
Sources are here
https://github.com/cincuranet/NETProvider/tree/streaming-backup .
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
https://drive.google.com/file/d/0BxNlh1_CctC4NDhIRnh2VHBDbnM/edit?usp=sharing
- it`s an empty database so "leaking" is not really an issue :)
Here's the restore function (in case it helps)
using(io.FileStream BackupInputStream = new
FileStream(BackUpPath,FileMode.Open)) {
fbServer.FbStreamingRestore restore = new
fbServer.FbStreamingRestore();
restore.ConnectionString = getConnectionString(Host,
User, Pass, Path, Port, 32767);
SetRestoreOptions(Ovr, DeactivateIndexes, NoShadows,
NoValidity, OneAtTime, UseAllSpace, PageSize, restore);
restore.InputStream = BackupInputStream;
restore.Execute();
return true;
}
Using a PageSize of 4096 or 16384 (both don't work). Options are Replace
and NoShadows (defaults, stuck since the end of time). I'm willing to help
debug if I can get my hands on sources :)
2014-06-03 8:50 GMT+03:00 Jiri Cincura :
> On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev
> wrote:
> > Should anything be done to the stream apart from construction? Any
> special
> > modes or anything?
>
> Nope. It should just work.
>
> The restore is tricky 8-). It kept me 3x more time to do it than
> backup. I'm wondering whether it's possible to put the backup
> somewhere so I can try it?
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hi folks, thank you, one more to develop the provider to FB. I use this in some projects without any trouble. But now: I got a virus-alarm by downloding the file a the given URL. GData means: NSIS.Application.InstallMonetizer.E (Engine B) What happend here? Best wishes Niels Am 02.06.2014 15:38, schrieb Jiri Cincura: > Hi, > > here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the > streaming backup/restore implementation. Look at FbStreamingBackup and > FbStreamingRestore classes. It's same as FbBackup/FbRestore with only > different being you need to provide backup/restore via > OutputStream/InputStream property. > > I did some small testing, but more is always welcome. > -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Mon, Jun 2, 2014 at 10:21 PM, Ivan Arabadzhiev
wrote:
> Should anything be done to the stream apart from construction? Any special
> modes or anything?
Nope. It should just work.
The restore is tricky 8-). It kept me 3x more time to do it than
backup. I'm wondering whether it's possible to put the backup
somewhere so I can try it?
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Backup part works great :) Managed to backup a 18GB database (took about
2:30 hours by the VPN, so I consider it as stable as it gets). Restore,
however keeps throwing
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): expected backup
description record ---> expected backup description record
at FirebirdSql.Data.Services.FbStreamingRestore.Execute()
Tested with the StreamingBackup generated file and with one made by gbak -
same thing. Currently restoring the StreamingBackup file (with gbak) -
appears to be intact.
Should anything be done to the stream apart from construction? Any special
modes or anything?
2014-06-02 16:38 GMT+03:00 Jiri Cincura :
> Hi,
>
> here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the
> streaming backup/restore implementation. Look at FbStreamingBackup and
> FbStreamingRestore classes. It's same as FbBackup/FbRestore with only
> different being you need to provide backup/restore via
> OutputStream/InputStream property.
>
> I did some small testing, but more is always welcome.
>
> --
> Jiri {x2} Cincura
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hi,
here's http://speedy.sh/wf5S6/provider.7z (very) rough cut on the
streaming backup/restore implementation. Look at FbStreamingBackup and
FbStreamingRestore classes. It's same as FbBackup/FbRestore with only
different being you need to provide backup/restore via
OutputStream/InputStream property.
I did some small testing, but more is always welcome.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hello,
I guess your question is directed to me - yes, I would like to test and can
offer a slot this week Thursday or in the next weekend.
Niko
-Ursprüngliche Nachricht-
Von: Jiri Cincura [mailto:disk...@cincura.net]
Gesendet: Montag, 26. Mai 2014 15:22
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] fbBackup on remote Clients
Hi,
On Thu, May 1, 2014 at 7:38 PM, Parzival wrote:
> This leads to the question, if this function is on the roadmap for the
> .net provider. Jiri, can please comment on that?
I started work on this today. Would you be willing to do some testing before
release?
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |
http://www.ID3renamer.com
--
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hi,
On Thu, May 1, 2014 at 7:38 PM, Parzival wrote:
> This leads to the question, if this function is on the roadmap for the .net
> provider. Jiri, can please comment on that?
I started work on this today. Would you be willing to do some testing
before release?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Thu, May 1, 2014 at 8:23 PM, Mark Rotteveel wrote:
> You could always use the services API to create a backup on the server,
> but since CORE-2666 it is also possible to stream the backup to the
> client (or from the client to the server for restore).
Good. As I thought. I was confused by the subject of this thread
"remote clients" to be specific. :)
Looks like it's time to implement it.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On 1-5-2014 19:40, Jiri Cincura wrote: > On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel wrote: >> That is no longer true, remote backup has been included in the service API >> in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 > > I'm lost. Wasn't this always the case? Via services API you created > backup on server. But it was/is not possible to create a backup of > remote database to local file. Or it was vice versa? You could always use the services API to create a backup on the server, but since CORE-2666 it is also possible to stream the backup to the client (or from the client to the server for restore). From the README.services_extension.txt: " 4) Services API extension - running gbak at server side with .fbk at the client. (Alex Peshkov, peshk...@mail.ru, 2011-2012) This way of doing backups is specially efficient when one needs to perform backup/restore operation for database, located on ther server accessed using internet, due to the great performance advantage. The simplest way to use this feature is fbsvcmgr. To backup database run approximately the following: fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \ action_backup -dbname some.fdb -bkp_file stdout >some.fbk and to restore it: fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \ action_restore -dbname some.fdb -bkp_file stdin http://p.sf.net/sfu/SauceLabs ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel wrote:
> That is no longer true, remote backup has been included in the service API
> in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666
I'm lost. Wasn't this always the case? Via services API you created
backup on server. But it was/is not possible to create a backup of
remote database to local file. Or it was vice versa?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hello, thanks for the responses. I understand that the limitation of the .net provider fbBackup was caused by a limitation on the server api. The functionality is in place starting with version 2.5.2. This leads to the question, if this function is on the roadmap for the .net provider. Jiri, can please comment on that? Btw: What is the best way to support the Firebird developers - is it a membership in the Firebird Foundation? The effort and very impressive results that are delivered by the develoment team require support. Niko -Ursprüngliche Nachricht- Von: Mark Rotteveel [mailto:m...@lawinegevaar.nl] Gesendet: Donnerstag, 01. Mai 2014 12:21 An: For users and developers of the Firebird .NET providers Betreff: Re: [Firebird-net-provider] fbBackup on remote Clients On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival wrote: >> Is there a way to get fbBackup working on remote Clients? > > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=c om.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_207 97 That is no longer true, remote backup has been included in the service API in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 Mark -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival wrote: >> Is there a way to get fbBackup working on remote Clients? > > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797 That is no longer true, remote backup has been included in the service API in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666 Mark -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
Hi Parzival, I would suggest you consider something like a secured webservice, which can be invoked by the remote client to perform the backup on the server side. However, depending on the size of your resultant backup, you may not want to transfer it back to the client. I hope that helps you practically overcome the problem. :) Kind regards, Scott :) On 01/05/2014 10:49, Jiri Cincura wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival wrote: >> Is there a way to get fbBackup working on remote Clients? > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797 > -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbBackup on remote Clients
On Thu, May 1, 2014 at 8:49 AM, Parzival wrote:
> Is there a way to get fbBackup working on remote Clients?
http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] fbBackup on remote Clients
Hello, I have seen that there is an issue on running fbBackup on remote Client PCs, but it works fine on the firebird server itself. In the ticket there is a reference to the servicemanager using fbBackup. (http://tracker.firebirdsql.org/browse/DNET-287). Is there a way to get fbBackup working on remote Clients? Thanks Niko -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
