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

Backup result file receive online as a stream [CORE762] #1140

Closed
firebird-issue-importer opened this issue Oct 17, 2005 · 10 comments
Closed

Backup result file receive online as a stream [CORE762] #1140

firebird-issue-importer opened this issue Oct 17, 2005 · 10 comments

Comments

@firebird-issue-importer

Submitted by: parmaja (parmaja)

Is replaced by CORE2666

Votes: 1

SFID: 1328232#⁠
Submitted By: parmaja

My customers have no permission to access the server
but have to create backups, the backup service generate
a file on server.
How about generate a stream passed to the client then
saved as file or zip it online.

Thanks

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 14, 2006

Commented by: Alice F. Bird (firebirds)

Date: 2005-10-19 03:47
Sender: parmaja
Logged In: YES
user_id=720012

GBAK is client side, thanks for you :) i can use
ShellExecute for it, resolving my problem.
But for that i must install firebird server on the client
computer, or publish gbak.exe with my setup.
i am using delphi isc_ api to use backup service it make
backup file only on server not in client side, that the one,
the two, when i received as stream not file i can compress
it more with LZMA or somthing else before when saving it to file

It is usefull feature for my lazy customers :)

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 14, 2006

Commented by: Alice F. Bird (firebirds)

Date: 2005-10-18 06:30
Sender: robocop
Logged In: YES
user_id=62823

Why can't your customers use gbak? Gbak has existed for more
than 15 years and creates client-side backups.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

Workflow: jira [ 10786 ] => Firebird [ 15193 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 13, 2012

Commented by: PizzaProgram Ltd. (szakilaci)

This would solve 2 problems:
- a security risk by being able to encrypt (and compress) in real time the FBK file
- no need to install / locate gbak file. (It's hard to locate the proper exe file.)

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 11, 2012

Commented by: Artem Petkevych (artem)

Wasn't this made in Firebird 2.5.2 ? "Back Up to or Restore from a Remote Backup File".
Shouldn't this issue be marked as Resolved?

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 12, 2012

Modified by: @dyemanov

Link: This issue is replaced by CORE2666 [ CORE2666 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 12, 2012

Commented by: @dyemanov

Closed in favor of CORE2666.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 12, 2012

Modified by: @dyemanov

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

resolution: Duplicate [ 3 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 12, 2012

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 6, 2013

Commented by: PizzaProgram Ltd. (szakilaci)

I would like to share my experience with everyone trying to encrypt and compress a FBK file on the fly (without intermediate file):

I have tried many different free, undecryptable compressors, but only http://www.7zip.org worked for me yet, because it has an extra -si option to accept a stream as an input.
(Use v9.20 stable DOS version only ! ... alpha versions having currently encryption Bugs !)

BACKUP:
@gbak.exe -B -user sysdba -pas masterkey DEMO.FDB stdout | 7z.exe a -siSOMENAME.FBK -t7z -mx=3 -mtc=on -mhe=on -pMYPASSWORD COMPRESSEDFILE.7z

RESTORE:
@7z.exe e -so -pMYPASSWORD -t7z COMPRESSEDFILE.7z | gbak -c -user sysdba -pas masterkey stdin DEMO2.fdb

Hint:
I'm calling this from Delphi, and there ShellExecute nor other "DOS calling procedures" did not run it properly. Had to use an intermediate bach file (RUNME.BAT) and passed parameters, like:
@"C:\Program Files\Firebird\Firebird_2_1\bin\gbak.exe" -B -T -V -user %1 -password %2 %3 stdout | "E:\MyFolder\7za.exe" a -siCOMPRESSEDFILE.fbk -t7z -mx=3 -mtc=on -mhe=on -p=%4 %5

Someone could put this on the website's FAQ maybe?

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
1 participant