Hi All,
I've been doing some of the work on using the backup format for LO:
Unfortunately we have no choice but to use the backup format as we
have to have to be endian-agnostic. However speed shouldn't be too
huge an issue as I suspect most users (when using a database embedded
in a .odb) won't have huge databases -- for huge databases using an external
database (either .fdb file or full server) would probably be reccomended
in any
case.
For login details: we already use isc_dpb_trusted_auth, but only when
connecting
to a db: for the services manager we currently have notspecial
parameters -- I've
noticed there is also an isc_spb_trusted_auth, but the documentation
suggests it
shouldn't be used (I think using isc_spb_trusted_auth gave me some
errors, but I might be remembering wrongly).
However we've still not had any success in getting the backup service to
work, the only
error shown by isc_service_query is:
gbak:Exiting before completion due to errors
which doesn't really help figure out what is going wrong, I guess it
might be needed
to debug firebird itself to discover what we're missing?
Cheers,
Andrzej
On 09/01/14 11:24, Alex Peshkoff wrote:
> On 01/09/14 13:23, marius adrian popa wrote:
>> The related bug
>> https://bugs.freedesktop.org/show_bug.cgi?id=72987
>>
>> and in Embeeded there is need for security2.fdb for backup api ?
>> (discussion at the end the bug)
> FB 2.5:
> When using embedded connection, there is no need in security2.fdb as
> long as you do not specify user/password in DPB when connecting to database.
> To specify user name different from current OS user you may use
> isc_dpb_trusted_auth. This works with embedded, but do not expect it to
> work with server!
>
> FB3:
> There is no need in security3.fdb at all when using embedded
> connections. You may specify arbitrary user name (isql -user sysdba
> your.fdb), password is ignored.
> isc_dpb_trusted_auth works too for backward compatibility.
>
> But telling true I do not like an idea of always using gbak to store
> database in OOO file. Restore process is far not the fast most - it
> includes rebuilding all indices.
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
