RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

Release Notes "New ODS Number Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. In the initial release, a database with an older ODS cannot be opened by Firebird 3.0. In order to work with a database with an older ODS it will be necessary to make a backup using gbak

RE: [firebird-support] How to inspect nbak state of a Firebird database

MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge. Regards Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 22 April 2020 09:56 To: Firebird Forum Subject: [firebird-support] How to inspect nbak state of a

RE: [firebird-support] with wrong sql i get no exception or firebird error

< INSERT INTO LOG(WAS) VALUES ('blabla'); causes the error: Statement failed, SQLSTATE = 23000 validation error for column "LOG"."ID", value "*** null ***" if postet with the c++ code: IBPP::Transaction _tr = IBPP::TransactionFactory(db); IBPP::Statement st =

RE: [firebird-support] Basic Re-Start

> 30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > > What the the link for downloading Embedded Firebird? > >None. Read Firebird 3 Release Notes. Or read this... https://www.ibphoenix.com/files/Embedded_fb3.pdf Regards Paul

RE: [firebird-support] Firebird upgrade advise

<> This will help. https://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf Regards Paul

RE: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

<> Yes, by default we build and install as a Framework on MacOS, which means as part of the build process we finesse the locations of all the relevant libraries and executables etc using the install_name_tool. If you look at the source code specifically posix/postfix.darwin, and you will need

RE: [firebird-support] Compling from source.

< ./configure --prefix=/home/pol/Downloads/sw/db/fb/inst > --with-builtin-libtommath then > make Same failure as before (at bottom). I totally get your point about it being to do with libtommath, that much is obvious from the error messages. However, I have tried the solution proposed - i.e.

RE: [firebird-support] Compling from source.

> at a guess it looks like the libtommath you installed wasn't build with =fPIC > a must if you want to include its symbols in another shared library (Firebird) > Perhaps it would be easier if you used the configure command > --with-builtin-libtommath? <> if you do a ./configure --help you

RE: [firebird-support] Compling from source.

<<(phew...), but that's where the fun begins - I hit an error! /usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld:

RE: [firebird-support] Transactions

Kevin, You might want to read this... https://www.ibphoenix.com/resources/documents/search/doc_67 Regards Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: 03 April 2019 06:37 To: Firebird Support Subject:

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

> yes, I follow the one in the blog and run the postinstall script under root > account Then it should work OK... I am not aware of any major changes re. dscl, launchctl etc that should stop it from working. Paul

RE: [firebird-support] Re: installing fb 1.5 in Mac Mojave

Did you actually use the original install script as instructed on the blog, or did you just try and use launchctl? Regards Paul

RE: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

<> http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf Regards Paul

RE: [firebird-support] Apparently timeout on queries

> I would like to know if the Firebird have any kind of timeout on query > execution. Firebird 4.0 http://tracker.firebirdsql.org/browse/CORE-985 Paul

RE: [firebird-support] Re: WireCrypt and win_sspi

Daniel, >><>is only possible for >>ServerAuth=SRP. Is this correnct? Or is there any kind >>of configuration to use WireCrypt with >>ServerAuth=win_sspi?>> >More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf <> Yes, my reading of "Wirecrypt, which sets encryption across

RE: [firebird-support] WireCrypt and win_sspi

<> More info here: https://www.ibphoenix.com/files/Authentication_FB3.pdf Paul

RE: [firebird-support] INET/inet_error: read errno = 10054

> Does anybody know what causes this message in firebird.log? INET/inet_error: read errno = 10054 Winsock.h WSAECONNRESET 10054 Connection reset by peer. An existing connection was forcibly closed by the remote host. This normally results if the peer application on the remote host is

RE: [firebird-support] Create sysdba user

> I there an easy way to create another user with same privileges and can > access all tables as SYSDBA? https://firebirdsql.org/rlsnotesh/rnfb25-admin.html Paul

RE: [firebird-support] backup on amd64 restore on raspberry pi 3

Et al, > on https://www.ibphoenix.com/resources/documents/general/doc_323 > "Rows are restricted to 32767 bytes." That doc has now been updated to reflect all versions of Firebird upto Firebird 3. Regards Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

> < command followed by the path and filename, hitting Enter and then typing in > my username and password (the only user is sysdba and I did change the > password) I get the following error message: > Statement failed, SQLSTATE = 08006 > Can not access lock files directory /tmp/firebird/>> >

RE: [firebird-support] Re: Cannot create new database: "Can not access lock files directory /tmp/firebird/"

> Or ifyou are seriously interested in Firebird http://www.ibphoenix.com/products/books/firebird_book Paul

RE: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

<> You can add your user to the firebird group (without using an ip address or local host you are effectively using firebird in local mode). Addin your user to the firebird group means that you can access the tmp files created when firebird starts up. Or you can rm /tmp/firebird and then

RE: [firebird-support] Re: Mailing list change?

> In principal I like your idea of a Firebird powered archive of Firebird > related emails. http://www.ibphoenix.com/products/dvd/developer_dvd "A browsable, search application for Windows and Linux for the whole of the Firebird Support and Developer Lists to date" Regards Paul

RE: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

<< it may be worth considering and adjunct piece of software to Firebird, called "HqBird", which uses Firebird as its base database engine. "HqBird" was designed for Firebird databases that are by necessity very large and require more power and capabilities than the standard version may offer.

RE: [firebird-support] running Firebird without fbintl

>With GCC "-fvisibility=internal" can be used to suppress exporting of all > symbols. We currently use -fvisibility-inlines-hidden and -fvisibility=hidden for clang... Paul > ++ > > Visit http://www.firebirdsql.org and

RE: [firebird-support] running Firebird without fbintl

<> 2.5.8 64bit Firebird now compiles with -O0 because of a problem with optimisation in fbintl that caused Firebird to crash... Paul

RE: [firebird-support] running Firebird without fbintl

And a couple of final questions, what optimisation level are you using during the build? 32bit or 64bit Firebird? Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: 05 July 2018 14:47 To: firebird-support@yahoogroups.com

RE: [firebird-support] running Firebird without fbintl

<> MacOS does not use a full icu implementation, so I doubt you are linking against the system icu lib (/usr/lib/libicucore.dylib) unless of course you are specifically requesting it. To be honest I doubt you could build Firebird if you hadn't installed a proper copy of icu from elsewhere.

RE: [firebird-support] GET LINGER?

Mark, > You can use select rdb$linger from rdb$database Neat, I didn't know about that. Thanks. Paul

RE: [firebird-support] GET LINGER?

<> AFAIK, you cannot "view" this setting however you can set it and adjust it using the following commands... https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-enhance-linger Paul

RE: [firebird-support] NVME drive optimize for firebird engine

<> 1. I don't understand how RAID 0 gives you redundancy... "RAID 0 (also known as a stripe set or striped volume) splits ("stripes") data evenly across two or more disks, without parity information, redundancy, or fault tolerance. Since RAID 0 provides no fault tolerance or redundancy, the

RE: [firebird-support] Firebird log, error

What might be causing this, any ideas? Server: Firebird 64bit classic on Ubuntu Linux (2.5.4.26856) Client: Windows 10 After this error, the connection drops & client app hangs. Mar 24 15:05:58 kernel: [2481720.238260] fb_inet_server[10098]: segfault at 0 ip 7f5cba31bb05 sp

RE: [firebird-support] Does gstat "max version">1000 indicates about problems?

RE: [firebird-support] Restore firebird 1.5 backup into firebird 2.5.8 database with GBAK Fails

<

RE: [firebird-support] "Over the wire" Connection Encryption: AES

<> As far as I am aware the only current commercially available plugins for Firebird are for encryption. If your customer is interested in such a plugin, we could probably develop one for them. Regards Paul

RE: [firebird-support] info

> If I try the select, I don’t have any record where realindex is null Then I would next check the database for any possible problems... corruption etc. http://www.ibphoenix.com/resources/documents/how_to/doc_5 Regards Paul

RE: [firebird-support] info

Try the following... Partner index description not found (175)) internal gds software consistency check (partner index description not found. Missing index for a primary or a foreign key. The problem may be caused by physical database corruption or by a bug. Recovery process: To find the

RE: [firebird-support] Firebird database corrupt with wrong page type error on table

http://www.ibphoenix.com/resources/documents/how_to/doc_5 Regards Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 21 December 2017 13:14 To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird

RE: [firebird-support] Issue with GBAK and upgrading old DB (1.5 -> 3.x)

<> Please read Upgrading from Firebird 1.5 to 2.5 and beyond (.pdf) (161.31K) by Pavel Cisar http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf It will help... Regards Paul

RE: Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

<> Simply put. As long as the database on the NFS mount cannot be accessed by another Firebird server on another system then you can use this "feature" (RemoteFileOpenAbility). Regards Paul

RE: [firebird-support] Transaction Management Failing?

> > The logic is that straightforward. The InsertMyData inserts lines of an > > invoice or any > > other customer transaction into ledgers, each identified by a transaction > > number. The > > problem is that when the issue occurs, multiple copies of the data end up > > in the database, > >

RE: [firebird-support] Firebird 3 crashes, unable to capture crash dumps ( terminated abnormally (4294967295) )

<

RE: [firebird-support] file size and transactions

> I read somewhere that the "read only" transactions are absolutelly harmless > to the GC and sweeping. Is that so? >>Read only transactions only physically have an impact on the TIP/Header >>page(s), however a long running read only transaction >>will have the same effect as a long running

RE: [firebird-support] file size and transactions

<> Not really, 2 weeks or 2 months would be a huge time. > I read somewhere that the "read only" transactions are absolutelly harmless > to the GC and sweeping. Is that so? Read only transactions only physically have an impact on the TIP/Header page(s), however a long running read only