Setting up Firebird on Ubuntu Linux
Rodney Gedda
Adrian Marius Popa
8 February 2013 – Document version 2.5
Table of Contents
Setting up Firebird on Ubuntu Linux
This article describes the process of installing and running Firebird on Ubuntu Linux. It should also work without modification in the Debian GNU/Linux distribution (testing version named Wheezy and unstable version named Sid). Ubuntu is based on Debian core packages. Installing software with Ubuntu is very straightforward and Firebird is no exception. This guide is based on Ubuntu 12.04 LTS “ The Precise Pangolin ” but it can be used with a current supported stable release.
The version of Firebird packaged with Ubuntu “ Precise Pangolin ” is 2.5.1 and is included by default . For stable Ubuntu releases there is a Firebird stable ppa repository from where you can install the stable versions latest LTS and current stable .
With administrator privileges on the target machine, issue the following command:
Apt’s dependency tracking will automatically propose all the packages required for a complete installation with the following output:
The packages will then download and install on the target machine. A new user “ firebird ” will be created to run the server, but the server will not yet be started by default:
If you want Firebird to start automatically, run dpkg-reconfigure on the package and click the Yes button. Then you will be asked again for the SYSDBA password:
If all goes well, Firebird Superserver will be started:
If you’re a seasoned Unix person but new to Ubuntu, you might be wondering where all the Firebird files are residing in the directory hierarchy. To see where all the files were installed by Apt, simply do:
As mentioned, a new user “ firebird ” is created on the target machine.
Now you can switch to the firebird user with the su command if required.
Install the examples and dev files:
The example databases will wind up in the directory tree /usr/share/doc/firebird2.5-examples/examples/empbuild/ .
Now you can test your Firebird installation by connecting to an example database. Decompress the employee.fdb example database:
Fire up the interactive shell and at the SQL> prompt connect to the employee database using the connect statement:
(replacing SYSDBApassword with the correct password for SYSDBA !)
When you manage to successfully connect to the database you will see the message:
Now, from the SQL> prompt, feel free to browse around the employee database. For instance, you can list the tables and check the server version:
If you want a GUI admin tool, you might check FlameRobin, which is included in the Ubuntu repository. It can be installed with a simple:
If you get an error message like “ Statement failed, SQLCODE = -551 no permission for read-write access to database /var/lib/firebird/2.5/data/employee.fdb ”, then the server process doesn’t have read or write access to the database file. Change the ownership of the database to the user firebird with:
If you’ve made it this far, your Firebird installation on Ubuntu has been a success. Have a nice day!
Источник
Firebird клиент для linux
Каждая удаленная клиентская машина требует наличия клиентской библиотеки – libfbclient.so на Posix-системах или fbclient.dll на Windows-системах – соответствующую версии сервера Firebird.
В целях обеспечения совместимости с продуктами третьих фирм, Firebird начиная с версии 1.5 может, в зависимости от версии и платформы, установить символические ссылки, скопировать библиотеки под именами, используемыми в версии 1.0 (« старые » InterBase-названия) или создать прокси-заглушку (перенаправляющую все вызовы в новую библиотеку).
Кроме этого, необходимо еще кое-что подкрутить.
Windows
В настоящее время нет компактной версии дистрибутива, позволяющей устанавливать клиентскую часть на Windows-клиента. В общем случае, когда нужно обеспечить взаимодействие Windows-клиента с Linux- или другим Posix- сервером Firebird (или другим компьютером под Windows), Вам необходимо загрузить полноценный дистрибутив под Windows, соответствующий версии Firebird, установленной на Вашем Linux или другом сервере.
К счастью, далее все будет просто — запустите инсталлятор и выберите в меню опцию CLIENT ONLY (только клиент).
Linux и некоторые другие Posix-системы
Для установки Linux-клиентов также нет легковесной версии дистрибутива, вдобавок различные варианты Posix-систем и даже различные представители Linux-семейства обладают отличительными особенностями в требованиях к расположению некоторых файлов в рамках файловой системы. Поэтому некоторые дистрибутивы Firebird для Posix-систем даже не предлагают опции по установке только клиентской части.
Следующая последовательность действий должна подойти для установки Firebird-клиента на большинстве Linux-системах. Для осуществления изложенных манипуляций, Вам необходимо войти в систему с правами пользователя root.
На сервере, на котором установлен Firebird, найдите в директории /opt/firebird/lib файл libfbclient.so.1. m.n (где m.n означают минорное значение версии, например 5 для Firebird версии 1.5, и номер сборки соответственно) и скопируйте его на клиентскую машину в директорию /usr/lib.
Создайте символические ссылки, выполнив следующие команды:
ln -s /usr/lib/libfbclient.so.1 /usr/lib/libfbclient.so
замените 1.m.n номером Вашей версии, например, 1.5.0 или 1.6.1
Если Вы используете программы, требующие наличия унаследованных библиотек, создайте дополнительно следующие символические ссылки:
ln -s /usr/lib/libfbclient.so /usr/lib/libgds.so
Скопируйте файл firebird.msg в директорию /opt/firebird
Для того, чтобы обеспечить API-вызовам доступ к сообщениям, в системном профиле интерпретатора команд или с помощью setenv() создайте переменную окружающей среды FIREBIRD, указывающую на /opt/firebird.
Источник
Firebird клиент для linux
- You are here:
- Home
- Downloads
- Server Packages
- Firebird 3.0
- Firebird 3.0.7
- You are here:
- Home
- Downloads
- Server Packages
- Firebird 3.0
- Firebird 3.0.7
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
The primary goals for Firebird 3.0 were to unify the server architecture and to improve support for SMP and multiple-core hardware platforms. Parallel objectives were to improve threading of engine processes and the options for sharing page cache across thread and connection boundaries.
Alongside these aims came new strategies to improve performance, query optimization, monitoring and scalability and to address the demand for more security options. A number of popular features were introduced into the SQL language, including the long-awaited support for the Boolean data type and the associated logical predications.
Documentation: Release Notes (PDF available), Quick Start Guide (PDF available) and other manuals.
 Win32 | Win64 |  Linux x86 | Linux AMD64 |  Android |  Mac OS X |
| Release Date | File Name | Size | Description |
| Sources | |||
| October 20, 2020 | Firebird-3.0.7.33374-0.tar.bz2 | 9 MB | Compressed tarball |
| Win32 | |||
| 32-bit Kits | |||
| October 20, 2020 | Firebird-3.0.7.33374_1_Win32.exe | 7 MB | Windows executable installer, recommended for first-time users |
| October 20, 2020 | Firebird-3.0.7.33374-1_Win32.zip | 12 MB | Zip kit for manual/custom installs |
| 32-bit Debug Kits (Binary + PDB components) | |||
| October 20, 2020 | Firebird-3.0.7.33374_1_Win32_pdb.exe | 9 MB | Windows executable installer (debug information included) |
| October 20, 2020 | Firebird-3.0.7.33374-1_Win32_pdb.zip | 26 MB | Zip kit for manual/custom installs (debug information included) |
| Win64 | |||
| 64-bit Kits | |||
| October 20, 2020 | Firebird-3.0.7.33374_1_x64.exe | 9 MB | Windows executable installer, recommended for first-time users |
| October 20, 2020 | Firebird-3.0.7.33374-1_x64.zip | 14 MB | Zip kit for manual/custom installs |
| 64-bit Debug Kits (Binary + PDB components) | |||
| October 20, 2020 | Firebird-3.0.7.33374_1_x64_pdb.exe | 13 MB | Windows executable installer (debug information included) |
| October 20, 2020 | Firebird-3.0.7.33374-1_x64_pdb.zip | 28 MB | Zip kit for manual/custom installs (debug information included) |
| Linux x86 | |||
| 32-bit Kits | |||
| October 20, 2020 | Firebird-3.0.7.33374-0.i686.tar.gz | 8 MB | Compressed tarball |
| October 20, 2020 | Firebird-debuginfo-3.0.7.33374-0.i686.tar.gz | 77 MB | Debug build, compressed tarball |
| Linux AMD64 | |||
| 64-bit Kits | |||
| October 20, 2020 | Firebird-3.0.7.33374-0.amd64.tar.gz | 8 MB | Compressed tarball |
| October 20, 2020 | Firebird-debuginfo-3.0.7.33374-0.amd64.tar.gz | 80 MB | Debug build, compressed tarball |
| Android | |||
| IMPORTANT! Android builds were not thoroughly tested, therefore they should be treated as experimental. Please report any problems you experience to the development mailing list. | |||
| ARM platform | |||
| October 20, 2020 | Firebird-3.0.7.33374-0.arm.tar.gz | 7 MB | Compressed tarball |
| October 20, 2020 | Firebird-withDebugInfo-3.0.7.33374-0.arm.tar.gz | 69 MB | Debug build, compressed tarball |
| Mac OS | |||
| Mac OS X 10.15+ (only 64-bit builds are supported by MacOS X since version 10.15) | |||
| October 20, 2020 | Firebird-3.0.7-33374-x86_64.pkg | 18 MB | 64-bit package |
The primary goals for Firebird 3.0 were to unify the server architecture and to improve support for SMP and multiple-core hardware platforms. Parallel objectives were to improve threading of engine processes and the options for sharing page cache across thread and connection boundaries.
Alongside these aims came new strategies to improve performance, query optimization, monitoring and scalability and to address the demand for more security options. A number of popular features were introduced into the SQL language, including the long-awaited support for the Boolean data type and the associated logical predications.
Источник
Firebird клиент для linux
- You are here:
- Home
- Downloads
- Server Packages
- Discontinued Versions
- Firebird 2.5
- Firebird 2.5.9
- You are here:
- Home
- Downloads
- Server Packages
- Discontinued Versions
- Firebird 2.5
- Firebird 2.5.9
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
Firebird 2.5.9 Release Notes (PDF available)
For more details about Firebird 2.5 architectures please look at the Firebird 2.5 Architecture Comparison document.
| Win32 | Win64 | Linux x86 | Linux AMD64 | Mac OS X |
Final release: v2.5.9 (End of Series)
| Release Date | File Name | Size | Description |
| Sources | |||
| June 24, 2019 | Firebird-2.5.9.27139-0.tar.bz2 | 13 MB | Compressed tarball |
| Win32 | |||
| 32-bit Classic, Superclassic & Superserver | |||
| June 24, 2019 | Firebird-2.5.9.27139_0_Win32.exe | 6 MB | Windows executable installer for full Superclassic/Classic or Superserver, recommended for first-time users |
| June 24, 2019 | Firebird-2.5.9.27139-0_Win32.zip | 10 MB | Zip kit for manual/custom installs of Superclassic/Classic or Superserver |
| 32-bit Embedded | |||
| June 24, 2019 | Firebird-2.5.9.27139-0_Win32_embed.zip | 4 MB | Embedded, separate download, zip kit. Custom installation required, read the Guide! |
| 32-bit Debug Kits (Binary + PDB components) | |||
| June 24, 2019 | Firebird-2.5.9.27139_0_Win32_pdb.exe | 11 MB | Full Superclassic/Classic or Superserver, installer kit |
| June 24, 2019 | Firebird-2.5.9.27139-0_Win32_pdb.zip | 18 MB | Full Superclassic/Classic or Superserver, zip kit |
| June 24, 2019 | Firebird-2.5.9.27139-0_Win32_embed_pdb.zip | 9 MB | Embedded, separate download, zip kit |
| Win64 | |||
| 64-bit Classic, Superclassic & Superserver | |||
| June 24, 2019 | Firebird-2.5.9.27139_0_x64.exe | 10 MB | Windows executable installer for full Superclassic/Classic or Superserver, recommended for first-time users |
| June 24, 2019 | Firebird-2.5.9.27139-0_x64.zip | 11 MB | Zip kit for manual/custom installs of Superclassic/Classic or Superserver |
| 64-bit Embedded | |||
| June 24, 2019 | Firebird-2.5.9.27139-0_x64_embed.zip | 5 MB | Embedded, separate download, zip kit. Custom installation required, read the Guide! |
| 64-bit Debug Kits (Binary + PDB components) | |||
| June 24, 2019 | Firebird-2.5.9.27139_0_x64_pdb.exe | 15 MB | Full Superclassic/Classic or Superserver, installer kit |
| June 24, 2019 | Firebird-2.5.9.27139-0_x64_pdb.zip | 20 MB | Full Superclassic/Classic or Superserver, zip kit |
| June 24, 2019 | Firebird-2.5.9.27139-0_x64_embed_pdb.zip | 9 MB | Embedded, separate download, zip kit |
| Linux x86 | |||
| IMPORTANT: Note affecting all Linux builds The recommended Linux kernel version is 2.6.34 and glibc should be version 2.12 or higher. Minimum — kernel 2.6.27 and glibc 2.7. If your glibc version is lower than v.2.7, it must be upgraded before using Firebird 2.5 Classic/SuperСЃlassic. | |||
| 32-bit Classic, Superclassic & Embedded | |||
| June 24, 2019 | FirebirdCS-2.5.9.27139-0.i686.rpm | 7 MB | Superclassic/Classic server, RPM kit |
| June 24, 2019 | FirebirdCS-2.5.9.27139-0.i686.tar.gz | 7 MB | Superclassic/Classic server, compressed tarball |
| June 24, 2019 | FirebirdCS-debuginfo-2.5.9.27139-0.i686.tar.gz | 34 MB | Debug Build, Superclassic/Classic server, compressed tarball |
| 32-bit Superserver | |||
| June 24, 2019 | FirebirdSS-2.5.9.27139-0.i686.rpm | 7 MB | Superserver, RPM kit |
| June 24, 2019 | FirebirdSS-2.5.9.27139-0.i686.tar.gz | 7 MB | Superserver, compressed tarball |
| June 24, 2019 | FirebirdSS-debuginfo-2.5.9.27139-0.i686.tar.gz | 33 MB | Debug Build, Superserver, compressed tarball |
| Linux AMD64 | |||
| IMPORTANT: Note affecting all Linux builds The recommended Linux kernel version is 2.6.34 and glibc should be version 2.12 or higher. Minimum — kernel 2.6.27 and glibc 2.7. If your glibc version is lower than v.2.7, it must be upgraded before using Firebird 2.5 Classic/SuperСЃlassic. | |||
| 64-bit Classic, Superclassic & Embedded | |||
| June 24, 2019 | FirebirdCS-2.5.9.27139-0.amd64.rpm | 7 MB | Superclassic/Classic server, RPM kit |
| June 24, 2019 | FirebirdCS-2.5.9.27139-0.amd64.tar.gz | 7 MB | Superclassic/Classic server, compressed tarball |
| June 24, 2019 | FirebirdCS-debuginfo-2.5.9.27139-0.amd64.tar.gz | 34 MB | Debug Build, Superclassic/Classic server, compressed tarball |
| 64-bit Superserver | |||
| June 24, 2019 | FirebirdSS-2.5.9.27139-0.amd64.rpm | 7 MB | Superserver, RPM kit |
| June 24, 2019 | FirebirdSS-2.5.9.27139-0.amd64.tar.gz | 7 MB | Superserver, compressed tarball |
| June 24, 2019 | FirebirdSS-debuginfo-2.5.9.27139-0.amd64.tar.gz | 33 MB | Debug Build, Superserver, compressed tarball |
| Mac OS X | |||
| NOTE: Because use of libstdc++ is now deprecated Mac OS X users should be aware that Firebird 2.5.8 will run only on Mac OS X 10.9 or higher versions. If you want to use an earlier version of OS X you will need to use an earlier version of Firebird. «lipo» are the 64-bit Firebird Server with client libs as fat lib (32 and 64 bits). See here for examples. | |||
| Mac OS X 64-bit Classic, Superclassic & Embedded (Intel) | |||
| June 24, 2019 | FirebirdCS-2.5.9-27139-x86_64.pkg | 7 MB | 64-bit package |
| June 24, 2019 | FirebirdCS-2.5.9-27139-lipo-x86_64.pkg | 12 MB | 64-bit Lipo package |
| Mac OS X 64-bit Superserver (Intel) | |||
| June 24, 2019 | FirebirdSS-2.5.9-271391-x86_64.pkg | 7 MB | 64-bit package |
| June 24, 2019 | FirebirdSS-2.5.9-27139-lipo-x86_64.pkg | 9 MB | 64-bit Lipo package |
| Mac OS X 32-bit | |||
| June 24, 2019 | FirebirdCS-2.5.9-27139-i386.pkg | 7 MB | Mac OS X 32-bit Classic, Superclassic & Embedded (Intel) package, compressed |
| June 24, 2019 | FirebirdSS-2.5.9-27139-i386.pkg | 7 MB | Mac OS X 32-bit Superserver (Intel) package, compressed |
Firebird 2.5.9В Release Notes (PDF available)
For more details about Firebird 2.5 architectures please look at the Firebird 2.5 Architecture Comparison document.
В
Источник
