Re: [firebird-support] Firebird 2.5 and CentOS 7.7
This is a known problem with the EPEL rpms. Workarounds include using the rpm packages for superclassic, which don't have the problem, or installing the project-provided rpms (which install under /opt). It *might* also work if you replace that specific file with the one from the EPEL rpm from 2.5.7 (the problem appeared in 2.5.8). Good luck!
[firebird-support] XNET and IpcName
XNET is not mentioned in the firebird.conf comments on IpcName, nor IpcName is mentioned in README,xnet. Still I believe the two are connected. Am I wrong? With multiple Firebird installation on Windows it is necessary to change the IpcName in each firebird.conf, but it seems only the one with the default value is accessible via XNET. Or maybe there is some way to give the modified values to the client so it can connect to the others too? Could someone please explain how this is supposed to work? What am I missing? Thanks in advance, Emil
[firebird-support] Re: Problem installing Firebird 2.5.8
I had a similar problem, although with a different error messages. I had to rename the package (amd64 -> x86_64) and forc the installation with rpm -ivh --force --nodeps FirebirdSS-2.5.8.27089-0.x86_64.rpm and now it works OK on my system. The Firebird 2.5.8 rpm has some problems on Centos 7, which have been recorded in the tracker, but not yet resolved. There is also a Centos-specific RPM on Epel, but unfortunately it is currently broken as well.
[firebird-support] fbintl problems with 2.5.8 on Centos 7
I ran into problems after upgrade from 2.5.7 to 2.5.8 (using the EPEL repository, firebird-superserver). The server returns an error when trying to access WIN1251 character fields, and there are log entries "Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'" at server startup. (there is really no "fbintl.so" in that location, just "fbintl", but this is the same for 2.5.7 and it works). The same problems appears also when installing 2.5.8 on a clean CentOS 7 system. Installing from the firebirdsql.org RPM seems to work fine (though I had to use rpm -i --nodeps --force to make it install). Q1: What can be the reason for this and is there a way to work around it (change some config, copy some file from the firebirdsql.org rpm or something like that. Q2. What would be the proper way to reach the EPEL firebird maintainer (I think it is Phillipe Makowski) for reporting this issue? Thanks Emil PS ldd -d /usr/lib64/firebird/intl/fbintl undefined symbol: gds__log (/usr/lib64/firebird/intl/fbintl) could that be related?
[firebird-support] ROLE on EXTERNAL DATA SOURCE in Firebird 3
In Firebird 3.0.3 the current role is not passed to the external data source when using 'execute statement ... on external'. This has been acknowledged as a bug and fixed for 2.5.3 (see http://tracker.firebirdsql.org/browse/CORE-4054) However there is a note in the tracker saying "FB3 will have different approach for role's handling, so patch is not ported forward ". Can the correct behavior be achieved in Firebird 3, and if yes - how? Regards Emil
[firebird-support] GET LINGER?
Hi As far as I understand, the Firebird 3 LINGER value is actually a property of the database (file). How can I check if this is set and to what? I thought GSTAT -h might show it, but it doesn't. Regards Emil
[firebird-support] Version statement
I feel it would be nice if in some highly visible place on the firebird site there is a clear statement about the versions and sub-versions available and recommended. Like they have it at http://httpd.apache.org/: "This latest release from the 2.4.x stable branch represents the best available version of Apache HTTP Server." Or at php.net: "This is a security release. Several security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version." People keep telling me that their vendors say things like "Our application works best with firebird 2.5.0, it doesn't perform well with 2.5.6". I know the minor version upgrades have been discussed often in this list, but it would be good to be able to point people not following it at a definitive statement from the project team. Regards Emil
Re: [firebird-support] [EDatabaseError] How to simultaneously connect to a firebird database in elevated and non-elevated mode.
---In firebird-support@yahoogroups.com, wrote : > I am using Firebird embedded 3.0.1. > I receive an EDatabase error : "[ODBC Firebird Driver]Database is > probably already opened by another engine instance on another Windows > session." > when trying to connect to a firebird db simultaneously in > Adminstrator (elevated) mode and non-elevated mode with the same user > account. It is not a question of "elevated" vs "non-elevated" users. Embedded is *by design* a single-user model. A successful embedded connection locks out all other users from connecting to the same database - hence the error message you see. The *same user* can make multiple connections from within the same application space. > Does anyone know how to solve this issue? It depends on the issue you are trying to solve. But if you want multi-user access then you need to install a server. If you want multiple embedded connections to connect concurrently, configure the server as Classic or Superclassic. Note that the default server installation is Superserver, which also cannot share with embedded connections. Describe what you want to achieve in real life and someone will advise you about the best model for your requirements. Incidentally, since you are using Delphi, be aware that embedded is a deployment model, not a development one. You can't have an embedded connection in the IDE space and another one in the executable space. So you need to have a server running for your Delphi development, even if you intend to deploy an embedded app for single-user use. Helen Actually this is only true for superserver embedded mode, prior to 2.5. In 2.5 embedded mode on windows is superclassic, and multiple connections from multiple applications using the same embedded library are normally possible. There is some issue however that does not allow this from some context, e.g. from a normal application and from a script, executed by the web server. I don't remember now the exact details, but it was not a question of user account - even when the web server was using the same user account, it didn't work. I believe there is at least one discussion somewhere in the list history about this issue. Emil
Re: [firebird-support] Install 2.1 on RH 6
Thanks a lot, it worked! And I even remembered that 7 years ago I knew that :( I still couldn't install the rpm - yum complained the architecture amd_64 is different from x86_64, then rpm itself was still looking for libncurses.so.5 is needed by FirebirdSS-2.1.7.18553-0.amd64 libstdc++.so.5 is needed by FirebirdSS-2.1.7.18553-0.amd64 But the tar.gz installed alright (still getting some complaint - /usr/bin/dirname: extra operand `-start') and the service is now working. Emil ---In firebird-support@yahoogroups.com, wrote : You need to install compat-libstdc++-33 package. That package will give you the needed C++ libraries to run firebird on RHEL/CentOS 6 On Sat, Apr 18, 2015 at 10:37 PM, Emil Totev emilt@... mailto:emilt@... [firebird-support] mailto:firebird-support@yahoogroups.com> wrote: I will have to install firebird 2.1 (preferably latest 2.1.7) on 64-bit RHEL/CentOS 6 based linux. (I understand 2.1 is discontinued, but some program vendors don't). The rpm and tar.gz packages from firebird.sql seem to fail [at least] because of libstdc++ - if I understand correctly, they need libstdc++.so.5 while I have libstdc++.so.6 I couldn't find an rpm or pre-compiled 2.1.7 binary for RHEL/CentOS6, but maybe I didn't know how and where to look. Can anyone suggest anything else to try before I start trying to compile from sources? (Never done that and have the impression it may not be that easy). Thanks Emil
[firebird-support] Install 2.1 on RH 6
I will have to install firebird 2.1 (preferably latest 2.1.7) on 64-bit RHEL/CentOS 6 based linux. (I understand 2.1 is discontinued, but some program vendors don't). The rpm and tar.gz packages from firebird.sql seem to fail [at least] because of libstdc++ - if I understand correctly, they need libstdc++.so.5 while I have libstdc++.so.6 I couldn't find an rpm or pre-compiled 2.1.7 binary for RHEL/CentOS6, but maybe I didn't know how and where to look. Can anyone suggest anything else to try before I start trying to compile from sources? (Never done that and have the impression it may not be that easy). Thanks Emil
[firebird-support] Database paths and aliases
Hi Can there be any problem with a database, accessed simultaneously by some or all of the following methods: -- database file full path, /srv/firebird/mydb.fdb -- database alias, mydb = /srv/firebird/mydb.fdb -- another alias, another = /srv/firebird/mydb.fdb -- /srv/firebird/link, which is a symlink to /srv/firebird/mydb.fdb -- /var/firebird/mydb.fdb, where /var/firebird is a symlink to /srv/firebird I'd expect firebird to be clever enough to know that it is serving the same file, but I'd like to be sure it is true, and for all the architectures (classic/super). Thanks ET
Re: [firebird-support] Help!!! - Problem with Firebird Embeded
I saw a hint to the bitness of the client library - is you application 64-bit or 32-bit? The client library (embedded or not) should match the application.