Server Fault Stack Exchange
Server Fault Stack Exchange

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.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

30 questions
1
vote
5 answers

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 used to just running SQL Server Management Studio…
Cape Cod Gunny
1
vote
2 answers

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 same home built application with the same database…
Rytis
  • 325
  • 5
  • 16
1
vote
1 answer

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? thanks
mrapi
  • 143
  • 2
  • 8
0
votes
1 answer

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:there is a IP assigned for the server and I can…
mrapi
  • 143
  • 2
  • 8
0
votes
1 answer

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 configure it,I have no experience using vpn. please…
mrapi
  • 143
  • 2
  • 8
0
votes
1 answer

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 sure that Firebird is using 4 cores/cpus? Edit: Is…
Javier Cintrón
  • 1
  • 1
  • 1
0
votes
1 answer

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 host, we create backups of every single database with…
RudiBR
  • 15
  • 4
0
votes
2 answers

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, randomly. I get the following error…
user24191
0
votes
1 answer

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.1-super …
sebastian_sch
  • 1
  • 1
0
votes
1 answer

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 RemoteServicePort to 3051, reboot the server but the service is…
JustMe
  • 103
  • 1
  • 3
0
votes
0 answers

Firebird - programmatically determine if database is online

Is there a way to determine if a database is online? Specifically if it's not in "full shutdown" mode. Using gstat requires running as root or the firebird user according to the docs: gstat-fb -header "$db" | grep -E 'Attributes.+full…
Bangaio
  • 150
  • 1
  • 7
0
votes
0 answers

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 to make requests to the server. When opening…
justadev
  • 303
  • 1
  • 4
  • 14
0
votes
0 answers

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. Unfortunetly I don't know use this tool on…
Tomasz Filipek
  • 101
  • 1
0
votes
1 answer

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. When openin a specific .fdb Database from within…
Udo G
  • 423
  • 4
  • 9
  • 19
0
votes
0 answers

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.ini and I added the line…
HideMyFace
  • 1
  • 1
1
2