[firebird-support] embedded firebird on Mac/posix without read-write security database

We're embedding Firebird in our application on Mac OSX (both 2.1.x and 2.5.x at different times). But we have trouble with needing write permission on the security2.fdb security database. We ship the embedded Firebird, including security2.fdb, inside our application bundle. We've been able to

Re: [firebird-support] stale statements in MON$STATEMENTS

On 03/12/16 12:50, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > > I'm also seeing idle transactions in MON$TRANSACTIONS sometimes. That > is presumably the cause of my big issue, which is that I am reading > back old data from the db. OK, here's where

Re: [firebird-support] stale statements in MON$STATEMENTS

On 02/12/16 20:59, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 02.12.2016 8:56, Hamish Moffatt ham...@risingsoftware.com [firebird-support] > wrote: >> I understand that the idle statement >> means they have been prepared but not executed, but this should

[firebird-support] stale statements in MON$STATEMENTS

Hi, I'm trying to debug a concurrency issue I'm having with an application of mine, connecting to Firebird 2.5.6, so I'm trying to understand the various monitor tables. I have dozens of threads all making their own connections to Firebird (superserver). After running for a while my

Re: [firebird-support] stale statements in MON$STATEMENTS

On 03/12/16 00:59, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > I also see a ton of connections on MON$ATTACHMENTS from the same thread > in my application (MON$REMOTE_PID, MON$REMOTE_ADDRESS both the same) > which also makes no sense. Closing a connection implicitly

[firebird-support] "Unable to determine field precison from system tables"

I've just upgraded my Debian Linux system to the new release (stretch/9) and now I'm getting the following error when accessing a db from Python, using either fdb (1.6.1) or the old kinterbasdb (3.3.0). Unable to determine field precison from system tables: Dynamic SQL Error SQL error code =

Re: [firebird-support] "Unable to determine field precison from system tables"

On 08/06/17 14:43, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: I've just upgraded my Debian Linux system to the new release (stretch/9) and now I'm getting the following error when accessing a db from Python, using either fdb (1.6.1) or the old kinterbasdb (3.3.0

Re: [firebird-support] embedded database with Chinese path

On 04/10/17 22:15, DougC d...@moosemail.net [firebird-support] wrote: Hamish- Windows short path names are decidedly NOT for apps that cannot handle Unicode. They were introduced far earlier than that and were intended for programs that could not handle anything but the short 8.3 limits for

[firebird-support] embedded database with Chinese path

I'm trying to connect to a database with a filename containing Chinese characters. The full path to my file is: C:\Users\汉密斯\AppData\Local\Rising Software\data5cloud\rising5.fdb I'm not able to connect to this filename - I'm always told that the path name is wrong. I've tried using the full

Re: [firebird-support] embedded database with Chinese path

On 03/10/17 11:25, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: I'm trying to connect to a database with a filename containing Chinese characters. I tried passing a UTF-8 encoded filename, with the isc_dpb_utf8_filename flag set. However, this is failing

Re: [firebird-support] embedded database with Chinese path

On 03/10/17 18:20, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: But I can't figure out why the Windows short filename doesn't work - it seems Firebird is converting it back somewhere, and then failing on that? isc_file.cpp converts the short filename back to a long

[firebird-support] detect if database has changed

Is there an official way to detect if a database has changed? I have some expensive reports and backups to run, but if I know that the database has not changed since I last ran them I can skip those. fbstat (gstat) shows the next transaction number, but that changes even when only read-only

[firebird-support] select column if it exists

Is there a way to include a column in a SELECT but substitute a value if it doesn't? I need my code to work with different versions of my db schema. eg I want to SELECT A, B, C, ... but C might not exist. SELECT * would work of course, except it will fetch a bunch of columns I don't need.

Re: [firebird-support] embedded database with Chinese path

On 03/10/17 19:59, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 03.10.2017 2:25, Hamish Moffatt ham...@risingsoftware.com [firebird-support] > wrote: >> Any ideas? > Give up. Firebird does not support unicode characters in database name > a

Re: [firebird-support] Firebird stopped after 190 connections

On 02/11/17 20:26, mirc...@gmail.com [firebird-support] wrote: Hi. Today I had this situation - on CentOS 7 server, while Firebird Superserver was working, suddenly it stopped receiving new connections. First I thought that the server was crashed and not started automatically from the

Re: [firebird-support] Strange behaviour on Linux

On 08/12/17 04:48, dam...@wxs.nl [firebird-support] wrote: Hello, When I have the following directory structure on a Linux server: /a/b/c and I want to create a database /a/b/c/test.fdb with gbak, the access rights of directory "c" must be rwx (readable, writeable, executable). Also the

[firebird-support] gbak of encrypted database

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

[firebird-support] isql 2.5 with server 3

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

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

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

[firebird-support] server 2.5.8 deadlocked

I'm getting the Firebird 2.5 superclassic server on Linux deadlocking regularly at the moment. Twice in one day last week, and again today after uptime of less than 6 hours. I just upgraded to 2.5.8 today, from 2.5.6. Our workload isn't huge, but we do have a lot of small databases and maybe

Re: [firebird-support] server 2.5.8 deadlocked

On 13/02/18 13:07, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: I'm getting the Firebird 2.5 superclassic server on Linux deadlocking regularly at the moment. Twice in one day last week, and again today after uptime of less than 6 hours. I just upgraded to 2.5.8 today

Re: [firebird-support] Re: server 2.5.8 deadlocked

On 22/02/18 10:10, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > On 13/02/18 17:55, Dmitry Yemanov dim...@users.sourceforge.net > [firebird-support] wrote: >> 13.02.2018 05:07, Hamish Moffatt wrote: >> >>> I attached gdb and dumped the state

Re: [firebird-support] Re: server 2.5.8 deadlocked

On 22/02/18 20:17, hv...@users.sourceforge.net [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 13/02/18 17:55, Dmitry Yemanov dimitr@... [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I

Re: [firebird-support] How to store a string in Firebird which includes #0's in it?

On 04/08/18 23:06, 'River~~' river14ap...@gmail.com [firebird-support] wrote: To say an octet is in hex is no more wrong than to say some number is stored as a float. It's all just a bucket of bits. Hex or float or Integer are always presentation Float or integer is definitely not a matter

Re: [firebird-support] Suddenly, Firebird stop accepting remote connections.

On 17/7/18 12:13 am, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: Affected versions identified: 2.5.8, 2.5.7 and 2.5.5 all as SuperClassic running on dedicated server with Debian distribution. I'm going through a situation where applications can not connect to

[firebird-support] how to resolve this deadlock

I have a bunch of users logging in to my system at the same time, which causes a simple query like this to run: UPDATE OR INSERT INTO G_CLASS (CLASS_NUM, CLASS_NAME, USER_NUM, SYLLABUS_NUM) VALUES (1, 'Foo', 1001, 43) The field values are identical for each - it's exactly the same query.

[firebird-support] running Firebird without fbintl

We're linking embedded Firebird in to our application on macOS. Ever since macOS 10.13, we are getting crashes whenever our application invokes a file open dialog. We have tracked this down to some sort of conflict with fbintl. If we remove fbintl from our application, everything works. I

Re: [firebird-support] running Firebird without fbintl

On 05/07/18 21:06, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 5-7-2018 09:28, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > So, what is the impact of removing fbintl? What functionality do I lose? You lose almost all character set supp

Re: [firebird-support] running Firebird without fbintl

On 06/07/18 10:34, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: We are using Firebird via Qt. Qt dynamically loads its Firebird driver (libqsqlibase.dylib) which is linked against the Firebird framework which is dynamically loading fbintl. Actually, this isn't

Re: [firebird-support] running Firebird without fbintl

On 05/07/18 22:47, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: <> 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

Re: [firebird-support] running Firebird without fbintl

On 05/07/18 22:52, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: And a couple of final questions, what optimisation level are you using during the build? 32bit or 64bit Firebird? 64-bit. I have not changed any optimisation flags so it looks like it's being compiled with

Re: [firebird-support] running Firebird without fbintl

On 06/07/18 20:15, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: On 06/07/18 18:50, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: On 06/07/18 18:20, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: <using during the build? 32

Re: [firebird-support] running Firebird without fbintl

On 06/07/18 18:50, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: On 06/07/18 18:20, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: <using during the build? 32bit or 64bit Firebird? 64-bit. I have not changed any optimisation flags so it looks l

Re: [firebird-support] running Firebird without fbintl

On 06/07/18 18:20, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: > 2.5.8 64bit

Re: [firebird-support] running Firebird without fbintl

On 06/07/18 18:59, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 06.07.2018 10:45, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] > wrote: >>> With GCC "-fvisibility=internal" can be used to suppress exporting of >>> all symbols. >> We currently use

Re: [firebird-support] running Firebird without fbintl

On 10/07/18 10:00, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > On 06/07/18 18:59, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: >> 06.07.2018 10:45, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] >> wrote: >>>>

Re: [firebird-support] how to resolve this deadlock

On 11/09/18 00:48, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Hi Hamish! > > What exactly do you mean by "The queries kind of don't > actually conflict"? If they're trying to MERGE into the same row > simultaneously, then they do actually conflict, even if they contain

Re: [firebird-support] how to resolve this deadlock

On 10/09/18 22:52, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > > Hi Hamish. > > I am not sure if I understood clearly your problem. If I did, you > probably should use "WITH LOCK" clause. Thanks Hugo, that might work. But as the row might not exist yet, I would have to lock the whole

[firebird-support] update or insert from in-line query

Hi, Is UPDATE OR INSERT INTO table-name SELECT ... not supported? I'm using Firebird 2.5.8. thanks Hamish

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

On 17/4/19 11:12 pm, my...@techsol.org [firebird-support] wrote: Thanks Steve.  That's interesting.  I forgot about stopping xinetd.  So if I understand you right, you are suggesting the following: 1.  Review all FB processes (ps -ax | grep fbserver) and kill -9 on those Yikes. You

Re: [firebird-support] firebird x86

On 16/10/19 6:37 am, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: I'm trying install firebird 2.5.x x86 on debian 10/ubuntu 18. When run install, I got /Extracting install data Please enter new password for SYSDBA user: masterkey ./scripts/postinstall.sh: 114:

Re: [firebird-support] Re: Off-Topic: Firebird future

On 14/10/19 5:17 am, pablo sanchez pab...@adinet.com.uy [firebird-support] wrote: I prefer to connect over vpn/ssh to remote sites and run Flamerobin from my pc. I have all customer connections together, which is very convenient for me . It's convenient, but Firebird (2.5 at least) is *very*

Re: [firebird-support] Re: Off-Topic: Firebird future

On 11/10/19 10:52 am, Daniel Miller dmil...@amfes.com [firebird-support] wrote: There are a few (Windows-only) applications that are quite powerful - but honestly the primary tool I've used has been FirebirdWebAdmin (formerly IBWebAdmin). I'm generally working from a remote site and Thanks

Re: [firebird-support] firebird x86

On 17/10/19 6:55 am, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: W dniu 16.10.2019 o 01:05, Hamish Moffatt ham...@risingsoftware.com [firebird-support] pisze: file /opt/firebird/bin/gsec /opt/firebird/bin/gsec: ELF 32-bit LSB executable, Intel 80386, version 1

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

On 4/3/20 4:23 am, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 02-03-2020 18:24, 'm...@spectrumpacsold.com' m...@spectrumpacs.com [firebird-support] wrote: > > > Hello,  why do we keep getting so many copies of this email?   Thanks. Looking at the headers of the emails,

[firebird-support] gbak via server or not

We are backing up our databases regularly using gbak, running it on the same linux host as the Firebird server (2.5). I've just noticed that we are referring to the database file using the local path alone, rather than using localhost:/pathname. I see that gbak is indeed reading the file

[firebird-support] new Google groups

The firebirdsql.org site lists new Google groups to replace the yahoo firebird-support and firebird-general lists, but the links don't work - I get permission denied errors trying to visit them. Are these new lists set up and ready to go? Hamish