People who code: we want your input. Take the Survey

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
1answer
42 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. ...
0
votes
0answers
64 views

Firebird 3.0 Super sometimes not backing up

We run a Firebird 3.0 Super on Debian 10.3 Buster. The server runs fine for weeks, but suddenly a backup fails with: gbak: ERROR:Error reading data from the connection. gbak: ERROR:gds_$get_segment ...
0
votes
1answer
30 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? ...
0
votes
0answers
140 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....
0
votes
0answers
17 views

Could not load fb_shash.dll on Firebird hosted on Windows Server 2019

I have a problem with fb_shash.dll. We moved from Debian to Windows Server 2019 and ever since this dll won't load. Obviously I switched the library to windows version. I downloaded it from here: ...
0
votes
1answer
56 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:...
1
vote
1answer
432 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 ...
0
votes
1answer
517 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 ...
0
votes
1answer
48 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 ...
0
votes
1answer
82 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 ...
1
vote
0answers
537 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 ...
1
vote
1answer
312 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 ...
2
votes
1answer
1k 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. ...
3
votes
2answers
590 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 ...
0
votes
1answer
637 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....
0
votes
1answer
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 ...
3
votes
3answers
13k 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. ...
2
votes
4answers
12k 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 ...
2
votes
0answers
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 (...
1
vote
2answers
262 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-...
1
vote
1answer
284 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 ...
1
vote
5answers
3k 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 ...
3
votes
2answers
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 ...
1
vote
2answers
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 ...
2
votes
2answers
14k 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 -...
3
votes
3answers
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 '...
0
votes
2answers
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, ...
1
vote
4answers
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 ...