Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

Finding root cause for TCP retransmissions

We have an product based on a 3rd party application, running on an apache server connected to a firebird (v2.5.3) database. Unfortunately, we got to a point were we are getting timeouts when users try ...
user avatar
  • 293
0 votes
0 answers
55 views

FBExport - use on Ubuntu

TL;DR : How use FBExport on Ubuntu / how export Firebird query result to csv file. I would to like export query result from firebird database to csv file. On Windows I do similary job using FBExport. ...
user avatar
3 votes
3 answers
465 views

Vmware Esxi - Old 32bit software performance issue on multi core

I've been going crazy for 2 days now and I'm asking for help. I have a program developed in delphi (early 2000s about) that accesses a firebird v3 database, currently installed on the same machine (...
user avatar
0 votes
1 answer
247 views

COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

I'm trying to set up a Docker container just to read a Firebase 3.0 database file. Starting with a ubuntu:20.04 base image and basically just installing firebird3.0-server I get a running container. ...
user avatar
  • 423
1 vote
1 answer
81 views

It is enough secure enabling WireCrypt when connecting over internet

I have a .NET application connecting over the internet to a Firebird 3 installed on a VPS. It is enough secure enabling WireCrypt?Should I use something else like OpenVpn to secure the connection? ...
user avatar
  • 133
0 votes
0 answers
348 views

Interbase driver (Firebird) on Windows PHP

I know have so much questions about it but i don't find the right answer for that searching here and in other websites sorry but I tried all. How to install Interbase on PHP because I have that php....
user avatar
0 votes
1 answer
67 views

Secure port accessing with Open VPN

I've created a secure connection for Firebird 3(an open-source SQL relational database management system) using steps from there now I can connect from a client to server using Open VPN connection:...
user avatar
  • 133
1 vote
1 answer
622 views

Is there any workaround to make Firebird v2.5 under Arch Linux attach existing databases and open them?

I have tried almost everything to get Firebird v2.5 under Arch Linux connect to an existing .fdb database without getting the error message: *** IBPP::SQLException *** Context: Database::Connect ...
user avatar
  • 11
0 votes
1 answer
676 views

Create Firebird 3 VPN/secure connection

I've installed Firebird 3 on a Windows server 2012 10 vps on local port 3050.I need to create from anothere computer a secure connection to db/port by internet. Tried also Openvpn but not able to ...
user avatar
  • 133
0 votes
1 answer
58 views

Is there a way to display the current initialization parameters that are in effect for a database?

If I set a parameter in firebird.conf how to be sure that Firebird took my change? For example: I a set the parameter CpuAffinityMask to 15 in Windows with Firebird 2.5 with SuperServer how to be ...
user avatar
0 votes
1 answer
92 views

Firebird Backups on Google Compute Engine

We are considering moving our systems to GCE and trying to figure the best approach to backup our many firebird databases. Firebird is not VSS aware so we can't use shadow copying. On our current ...
user avatar
  • 15
1 vote
0 answers
598 views

Connection to specific firebird 2.5 server is slow

I have the following setup: Two laptops connected to a network using the same switch Multiple Windows Server running Firebird 2.5. My problem is that when I try to connect to one specific firebird ...
user avatar
  • 123
1 vote
1 answer
388 views

Firebird Backups Failing with Two Installations on Windows

I have a Windows Server running Firebird 2.5.4 on port 3050, and I have another Firebird Server older version on port 3051. I use the 3051 server for compatibility reasons for another application. I ...
user avatar
2 votes
1 answer
2k views

Firebird slowdowns while resources are available

I have a strange slowdown problem with a Firebird database. During the daily use of the database the clients experience significant slowdowns while the system still have lots of resources available. ...
user avatar
  • 917
3 votes
2 answers
641 views

Using pconnect on several databases in PHP on Apache2

I am running PHP in preforked(MOD_PHP) on an apache2 server. The setup is on linux Ubuntu 10.04. The database I am using is a firebird database 2.5.2. The apache2 server are running in a web cluster ...
user avatar
0 votes
1 answer
640 views

Install firebirdsql 2.1 super without dpkg-reconfigure on ubuntu 10.04.3?

I try to install firebird2.1-super with chef. So I can't use dpkg-reconfigure. So I tried to use debconf-set-selections /var/cache/firebird/firebird-server.seed In firebird-server.seed: firebird2....
user avatar
0 votes
1 answer
3k views

How to change Firebird default port in linux?

I'm trying to change firebird (2.5.1) default port from 3050 to 3051 on OpenSuse 11.4 So I installed firebird (install.sh) and in /opt/firebird/firebird.conf I uncommented and changed ...
user avatar
  • 103
3 votes
3 answers
14k views

Firebird CpuAffinityMask for 16 core server?

I have a server with 16 cores. What do I set the CpuAffinityMask to? 1111 1111 1111 1111 is 65535, should I put 65535? Also, how to I configure the SuperClassic server? This is for Firebird 2.5. ...
user avatar
2 votes
4 answers
13k views

High memory utilization with firebird + windows server 2008 r2

i have a Windows Server 2008 R2 (64bit) running a 64bit installation of Firebird 2.1.4.18393_0 in a 4GB phisical server. After a while, the task manager show that all memory is used, but the sum of ...
user avatar
2 votes
0 answers
3k views

Firebird 2.5 Database Corrupt

We have an issue where a database hangs the server when: a backup is performed (Hangs on a specific table) selecting * or count(1) from a specific table or viewing data that is related to the table (...
user avatar
1 vote
2 answers
276 views

QoS for Firebird database connections - how?

Our Firebird database connection goes through a network connection that seems to imply a high latency for normal TCP connections. However, I am quite sure that the network connection supports quality-...
user avatar
  • 280
1 vote
1 answer
289 views

What may the reason of slowness be (see details in message body)?

I've got a really weird situation I'm beating to solve. A performance problem which looks really like an empty waiting sequence set in code (while it probably isn't so). I've got a pretty powerful ...
user avatar
  • 3,258
1 vote
5 answers
4k views

How do I install Firebird and test it to make sure it's working?

I am running Windows XP Professional Service Pack 3. I get really confused between running Firebird as a service or as an application. I'm migrating from Microsoft SQL server and I've simply gotten ...
user avatar
3 votes
2 answers
2k views

Network connection to Firebird 2.1 became slow after upgrading to Ubuntu 10.04

We've got a setup that we're using for different clients : a program connecting to a Firebird server on a local network. So far we mostly used 32bit processors running Ubuntu LTS (recently upgraded ...
user avatar
  • 131
1 vote
2 answers
4k views

Firebird database corruption causes

I am running several different Firebird versions (2.0, 2.1) on multiple entry level Windows-based servers with wildly varying hardware. The only matching thing between them is that they are running ...
user avatar
  • 325
2 votes
2 answers
15k views

Firebird 2.1: gfix -online returns "database shutdown"

Googling this one hasn't made a bit of difference, unfortunately, as most results specify the syntax for onlining a database after using gfix -shut -force 30 (or any other number of seconds) as gfix -...
user avatar
3 votes
3 answers
2k views

Firebird on FreeBSD

Does anybody know on how to install Firebird 2.0 on FreeBSD 7.2? I have updated the ports and the kernels, but when I try to do a "make install", I get the error: Please do not build firebird as '...
user avatar
0 votes
2 answers
10k views

faulting module msvcrt.dll, what is msvcrt.dll?

I have Apache version 2.0.59.200 running locally serving a PHP application that connects to a Firebird database. Recently, I have been having problems with Apache crashing, as best as I can tell, ...
user avatar
1 vote
4 answers
6k views

How to migrate data from a Firebird database to PostGreSQL on Linux

Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly ...
user avatar
  • 16.5k