RE: [firebird-support] Transaction ID overflow

[Brian Dunstan brian.duns...@health.telstra.com [firebird-support]]

Thanks Mark.

From: firebird-support@yahoogroups.com 
Sent: Tuesday, 1 May 2018 5:34 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Transaction ID overflow



On 1-5-2018 09:19, Brian Dunstan 
brian.duns...@health.telstra.com
[firebird-support] wrote:
> Hi,
>
> We have a big customer here who processes large numbers of transactions into 
> a large database and plans to not backup and restore.

They should plan for backups and tests restores. But if you reach the
transaction limit, then there is really no choice but to backup and restore.

> We are using Dialect 3. I think that means that the TID is 32 bits. I think 
> that means they get 4,294,967,296 transactions before overflow - I'm assuming 
> the TID is an unsigned integer. Is that correct?

In Firebird 2.5 and earlier the transaction id is 32 bit. If I'm not
mistaken, it is signed (so effectively 31 bits) with a maximum
transaction id of 2^31 - 1.

> If we move to dialect 3, does the TID become 64 bits?

I assume you mean Firebird 3. In Firebird 3 the transaction id is 48
bits (unsiged), the maximum transaction id is 2^48.

--
Mark Rotteveel

Re: [firebird-support] Transaction ID overflow

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telstra.com 
[firebird-support] wrote:
> Hi,
> 
> We have a big customer here who processes large numbers of transactions into 
> a large database and plans to not backup and restore.

They should plan for backups and tests restores. But if you reach the 
transaction limit, then there is really no choice but to backup and restore.

> We are using Dialect 3. I think that means that the TID is 32 bits. I think 
> that means they get 4,294,967,296 transactions before overflow - I'm assuming 
> the TID is an unsigned integer. Is that correct?

In Firebird 2.5 and earlier the transaction id is 32 bit. If I'm not 
mistaken, it is signed (so effectively 31 bits) with a maximum 
transaction id of 2^31 - 1.

> If we move to dialect 3, does the TID become 64 bits?

I assume you mean Firebird 3. In Firebird 3 the transaction id is 48 
bits (unsiged), the maximum transaction id is 2^48.

-- 
Mark Rotteveel

Re: [firebird-support] gbak of encrypted database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.05.2018 7:57, 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support] 
wrote:
> If you're implementing your own plugin,  you can implement whatever you need.

   Oh, really? How server plugin can affect what client utility does?


-- 
   WBR, SD.






++

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: [firebird-support] Transaction ID overflow

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com 
[firebird-support] wrote:
> If we move to dialect 3, does the TID become 64 bits?

   It is 48 bits in Firebird 3.


-- 
   WBR, SD.






++

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/

[firebird-support] Transaction ID overflow

[Brian Dunstan brian.duns...@health.telstra.com [firebird-support]]

Hi,

We have a big customer here who processes large numbers of transactions into a 
large database and plans to not backup and restore.

We are using Dialect 3. I think that means that the TID is 32 bits. I think 
that means they get 4,294,967,296 transactions before overflow - I'm assuming 
the TID is an unsigned integer. Is that correct?

If we move to dialect 3, does the TID become 64 bits?

Thanks,

Brian
[cid:image004.png@01D39141.C966B6D0]Brian Dunstan, CHIA
Technical Lead
Telstra Health - Communicare

M  +61 419 906 150
E   brian.duns...@health.telstra.com
W  www.telstrahealth.com

This email may contain confidential information.
If I've sent it to you by accident, please delete it immediately



[Non-text portions of this message have been removed]

Re: [firebird-support] isql 2.5 with server 3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 27-4-2018 04:16, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:
> I have a linux server with a local Firebird 2.5.8 server and utilities
> and the Firebird 3.0.1 client library. I need to connect to a remote
> Firebird 3 server as well as the local 2.5 server.
> 
> isql can't connect to the 3 server. I always get
> 
> $ isql-fb fb3server:db -user 123 -password 456
> Statement failed, SQLSTATE = 08004
> connection rejected by remote interface
> Use CONNECT or CREATE DATABASE to specify a database
> 
> Is this expected?

ISQL of Firebird 2.5 uses the fbclient of Firebird 2.5, and for a 
fbclient of Firebird 2.5 to connect to Firebird 3, you need at least 
four things:

- Add Legacy_Auth to the AuthServer setting
- Add Legacy_UserManager to the UserManager setting
- Create a user account with the legacy user manager.
- Set WireCrypt to Enabled (default is Required)

If you don't change these settings then a fbclient 2.5 cannot connect 
because the legacy authentication is not supported, you don't have a 
legacy authentication user to authenticate, and you can't establish a 
connection because wire protocol encryption is required (but not 
supported by the client).

See also 
https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3#jaybird-22-and-earlier
 
(these settings will also work for a fbclient 2.5)
-- 
Mark Rotteveel

Re: [firebird-support] isql 2.5 with server 3

[Hamish Moffatt ham...@risingsoftware.com [firebird-support]]

On 27/04/18 12:16, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:


I have a linux server with a local Firebird 2.5.8 server and utilities
and the Firebird 3.0.1 client library. I need to connect to a remote
Firebird 3 server as well as the local 2.5 server.

isql can't connect to the 3 server. I always get

$ isql-fb fb3server:db -user 123 -password 456
Statement failed, SQLSTATE = 08004
connection rejected by remote interface
Use CONNECT or CREATE DATABASE to specify a database

Is this expected?



I guess this is because isql is linked to libfbembed which is version 
2.5. I'm not sure how to fix this on my Debian install.



Hamish

Re: [firebird-support] gbak of encrypted database

['Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]]

Hello,

 gbak does not support encryption in the standard Firebird 3.0
distribution.

In IBSurgeon's plugin implementation there is a gbak support,  with
transparent encryption of backups with the same key.
https://ib-aid.com/en/firebird-encryption-plugin-framework/

And restored database from the encrypted backup is also encrypted,
otherwise it will be a security hole.

If you're implementing your own plugin,  you can implement whatever you
need.

Regards,
Alexey Kovyazin
IBSurgeon



вт, 1 мая 2018 г., 3:24 Hamish Moffatt ham...@risingsoftware.com
[firebird-support] :

>
>
> If a db is encrypted with Firebird 3 encryption, is a backup made with
> gbak also encrypted?
>
>
> https://www.firebirdsql.org/file/community/conference-2016/encrypting-firebird-databases.pdf
> implies you need to encrypt your backup afterwards so that means no.
>
> Will a restored db from that backup be encrypted automatically or would
> you have to run 'ALTER DATABASE ENCRYPT ...' on the new db afterwards if
> you want it encrypted also?
>
> thanks
>
> Hamish
>
> 
>