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

Re: [firebird-support] permissions nbackup

... # That's a pity, but required if root RunUser choosen. then chmod a=rw $FileName else # This is good secure setting chmod ug=rw,o= $FileName fi Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32

Re: [firebird-support] permissions nbackup

Apologies, it does get changed, I was looking in the wrong place in the MacOS installer... SuperServer chmod 600 security2.fdb Classic chmod 660 security2.fdb Regards Paul

Re: [firebird-support] permissions nbackup

he following -rw-r--r-- 1 pbeach staff 729088 Feb 15 16:54 security2.fdb And on install I do not make any effort to change it. Regards Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32

[firebird-support] Re: nbackup : Error assessing database due a missing delta file

The Chequered Career of nBackup By Helen Borrie http://www.ibphoenix.com/resources/documents/search/doc_394 Regards Paul Beach

[firebird-support] internal firebird consistency check

<<1. I got following error reported Firebird-3.0.2.32703_0_Win32 : "internal firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4676)">> Try a gbak using something like the following gbak -b -v -i -g copy1.fdb{path}copy1a.fbk using the –g switch to signify

RE: [firebird-support] Ask : firebird 1.5 to firebird 2.5

> If our software running on firebird 1.5 and now going to move over to > firebird 2.5, > technical-wise, what are the points we can convince people to change over? > Can you kindly advise? Have you tried reading the release notes? https://www.firebirdsql.org/en/release-notes/ Regards Paul

AW: [firebird-support] RE: Firebird SuperClassic hangs

<> Thats what a lock print is for - when it "hangs the next time" get a lock print fb_lock_print -a -d

RE: [firebird-support] RE: Firebird SuperClassic hangs

to investigate why deadlock scans are being instigated.. With thanks to Ann Harrison :-) Regards Paul Beach

[firebird-support] Potential Causes for Query to Slow Down

<> Garbage collection usually. Regards Paul Beach

[firebird-support] Re: FB3 - Limbo and consistency check

> Do you have reproducible example ? Could you send it to me (or regiser at > tracker), please ? http://tracker.firebirdsql.org/browse/CORE-3679 Regards Paul

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> The pseudo table MON$ATTACHMENTS will tell you. Regards Paul

Re: [firebird-support] Help: firebird and apache Processes doesn't die

<> SuperServer wil hold cached data as long as any connections exist. Only when the last "real" user disconnects from the database will the cache be cleared. Which two users are still connected to the database? CACHE WRITER and GARBAGE COLLECTOR? If so then these should also finish with the

RE: [firebird-support] On Connect triggers are dangerous, aren't they?

<> gbak -nodbtriggers - Suppresses Database Triggers from running [Firebird 2.1] Regards Paul Beach

[firebird-support] Encryption on FB3

<<2) Use the new FB 3 encrytion, we do not have any idea how to, is there any document we can read to start testing?>> IBPhoenix have a working plugin thats available for use. http://www.ibphoenix.com/products/software/encryptionplugin Regards Paul

RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

> The problem there would be that the BDE has reached its end of life for > some years now. The BDE was put on death row when IBX was made available, the same time Interbase 6.0 became available and Firebird was open sourced. Some 16 years ago... Paul Beach Tel (France): +33 (0) 2 47 58

RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

<> "The clause can take an optional OF to target updates at specific cursor columns" The Firebird Book Vol 2 p220 Regards Paul

[firebird-support] Problem Firebird 2.5

<> Usually caused (AFAIK) by a restore done with Firebird 2.1 or an earlier gbak, or if a Firebird 2.5 backup was restored to Firebird 2.1, backed up and then restored on Firebird 2.5 On the original database you can do DROP ROLE RDB$ADMIN; COMMIT; When you restore, gbak.exe should recreate

AW: [firebird-support] Support for OS X 10.11 El Capitan

<> And are now available for download. http://sourceforge.net/projects/firebird/files/firebird-MacOS-X_darwin/2.5.4-Release/ Regards Paul

AW: [firebird-support] Support for OS X 10.11 El Capitan

Having identified and fixed a problem in file_params.h and Info.plist, we now have a working prototype installer via pkgbuild, albeit very alpha, but its installing and working OK for me on El Capitan. Hopefully I should have something constructive early next week. Regards Paul

[firebird-support] Support for OS X 10.11 El Capitan

How to manually install Firebird on El Capitan, for those who need to know. http://paulbeachsblog.blogspot.fr/2015/10/how-to-installupgrade-firebird-manually.html Paul

RE: [firebird-support] Support for OS X 10.11 El Capitan

Timo, <>. Thanks - that tells me where to look and try and fix the problem. Regards Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32

RE: [firebird-support] Support for OS X 10.11 El Capitan

<> I suspect its not SIP, but the fact that we use an outdated package format. Looks like El Capitan has finally deprecated it. I found this https://forums.developer.apple.com/thread/8676 Note the error message, they then switched from /var to /Applications and all was ok. While we use

RE: [firebird-support] Support for OS X 10.11 El Capitan

[firebird-support] Need Help

If by QBICSYSTEMS you mean QBIC III Systems Inc. then the database will be Firebird. Regards Paul

RE: [firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

Hopefully Dmitry will come up with some answers. He seems to be the man that knows. I’m sure he was one of the IBSurgeon guys at the recent Prague seminar on performance tuning etc. Just as an FYI - Dimitry is *not* one of the IBSurgeon guys - he happens to be the Firebird project's lead

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

I tried it out and it said the following: Ryans-MacBook-Pro:~ ryanashton1$ ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird Then the sh file has done nearly all its job... the comments

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Type 'sudo ./remove.sh' [Enter] If you are in the same directory as the shell file. Regards Paul

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Ryans-MBP:~ ryanashton1$ sudo ./remove.sh Launchctl /Library/LaunchDaemons/org.firebird.gds.plist: Could not find specified service Remove Framework Remove Receipt Remove /tmp/firebird Ryans-MBP:~ ryanashton1$ Is that correct? Did it all work? Yes. Also, under Users and Groups in

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

Must I type vi remove.sh into the Terminal window first? yes, you are in effect creating a shell file that can be excuted later. before you paste the commands you will probably need to change vi into insert mode :i should do it. Regards Paul

[firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

And then do I hit Enter/Return when I have pasted that info into the Terminal window? No, you exit vi using the command :wq Regards Paul

RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

other suggestions for osx 10.10. ? regards rené Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com [firebird-support] firebird-support@yahoogroups.com: The following will work. cd /etc vi services change gds_db 3051/udp gds_db 3051/tcp for example. cd /Library

[firebird-support] Accessing/repairing embedded server database file

When I try to connect to it using Maestro, I get engine error 335544745 Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login. I can't say whether this comes due to the file damage or this is the way how embedded server should

Re: [firebird-support] Accessing/repairing embedded server database file

Have you got any suggestions how to try to access/fix that file? I am not a Firebird expert, so I may have missed something (but I studied a lot of docs how to try to fix my problem). Nothing simple and straightforward comes to mind. If you want to acess the database using Firebird's own

[firebird-support] TCP connection issue

in the application or on the network. Regards Paul Beach Tel (France): +33 (0) 2 47 58 30 43 Mob (France): +33 (0) 6 79 24 32 32

[firebird-support] firebird-support@yahoogroups.com

of a hard crash, but the filesystem/database as whole needs to remain consistent. http://www.ibphoenix.com/resources/documents/search/doc_26 Paul Beach IBPhoenix

[firebird-support] Firebird slowdowns while resources are available

sense? Can they be improved by some parameter tuning? Rejects = Lock requests that cannot be satisfied no big deal No wait locks? Engine locks? I wouldn't worry about it. Looking at your Lock Header - it looks fine. Your problem is elsewhere. Paul Beach IBPhoenix

[firebird-support] Transaction statistics issue

I found a strange issue when sweep is executed. I'm using Firebird 2.5.2 Super Server for Linux AMD 64 bits. I first execute SHOW DATABASE in isql: PAGE_SIZE 16384 Number of DB pages allocated = 524480 Sweep interval = 2 Forced Writes are OFF Transaction - oldest = 26483174 Transaction -

[firebird-support] Re: [Mac][mavericks] build firebird server through macports?

Marius, Here is the full name of the option --with-system-icu Thats not the problem Regards Paul

[firebird-support] Embedded on MacosX

How can I setup an embedded database on MacOSX to ignore username and password on login. On Windows security2.fdb is not required, how can I reach that on MacOSX by trying to pass -EMBEDDED to the compile line - No guarentees it will compile though. Paul

[firebird-support] Re: Help, tunning database

Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long transactions - temp cache limit set to 128MB - there are a few numbers errors in

RE: [firebird-support] firebird 2.5.1 on Lion Server 10.7.2

Hi all, I am trying to run Firebird on a Mac. (OSX Lion Server 10.27.2, Filebird 2.5.1). Actually, I tried CS and SS and both of them behave unstable. The server can run for awhile (several hours) before crash. Interesting thing is that after the first crash the server does not work.