Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
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=119420431iu=/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=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
On Mon, Jan 13, 2014 at 3:52 PM, Andrzej Hunt andr...@ahunt.org wrote: Unfortunately we have no choice but to use the backup format as we have to have to be endian-agnostic. It's possible to modify Firebird to be endian agnostic - I did it for a customer some years ago. Works fine for metadata and structured data, but there's no way to handle the contents of blobs. Firebird really doesn't know what's in a blob, so changing endianness would be a disaster. Historically, Firebird was created aware of endian issues because it ran on Vaxes and Intel machines. At the time, the performance impact of converting binary data on every reference was prohibitive. Then for a long time, different endian machines ran in different shops - not many mixed Mac, Vax, and Intel servers, so having databases of different natures was not a great problem. Then Apple switched endianness and the problem became slightly interesting again. Cheers, Ann -- 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=119420431iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
On 01/14/2014 12:52 AM, Andrzej Hunt wrote: 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 Why do you need services manager when working in embedded mode? To be precise - please describe exactly what do you want from services, and I hope to be able to help you doing it. A. PS. Though Ann's suggestion seem to be much better, I'm afraid at least in nearest release you will have to use gbak. Is it possible to store both DB and gbak in order to avoid restore when endianess is the same? IMHO it's at least 99.99% of usage. PPS. For small databases gbak file is many times smaller than appropriate fdb (a lot of almost empty pages for system relations are not stored), therefore probably an option speed/size can be useful. -- 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=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
The related chage Use firebird backup format for .odb https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=2540c23314d12b94c9ecb9e278969652bfb56c81 On Thu, Jan 9, 2014 at 11:23 AM, marius adrian popa map...@gmail.com 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) -- 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=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
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=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel