Installing firebird 2.5 on windows. Install firebird subd. Creation of a new base Firebird

Let's take a look at the detailed instructions for installing the Firebird server, which works on the Microsoft Windows platform.

Shgg 1

Get Firebird from the official side of the server or, you need the server version 2.1 or more. Let's run the executable file later. Show up vikno, de need to choose mov installations.

Step2

After you have chosen the language, there is a Firebird installation master who will help you install the server:

Krok 3

Here we hope for a license.

In order to move on to the next rock, it is necessary to accept the mind please. Vibravshi" I accept mind please and having pressed "Dali", we will check the additional information about the installation of the program:

Krok 4

Now, please select the folder where you want to install the server. For zamovchuvannyam us proponuєtsya way usoanovki, evidence in the figure, yoga can be remembered for any other.

Krok 5

For this short, it is necessary to select the configuration of the database server:

To install Firebird on a remote server (where the database itself will be hosted) enter "Reinstalling the server and tools":

In addition, on the shortest it is necessary to choose the configuration of the Firebird server: Classic Server or SuperServer. Without going into the details of the Classic Server and SuperServer features, we suggest you choose the type of Firebird server based on the following criteria:

If the installation is to be installed on a server machine or a rich processor station with a large number of connections (more than 30), then choose Firebird ClassicS3rver.

If the number of connections is small, or the working station is not strong enough - put SuperServer

If we are talking about the implementation details of Classic Server and SuperServer, then Classic Server for the skin client, when connected, launches a small server process, and SuperServer processes all clients in one process.

Croc 6 g Folder creation at the menu Start

Krok 7

At this stage of the installation it is necessary to select additional parameters for the server:

o Check the box Whicoring the Guardian for curing by the server".

o Select " Start as a Service".

Need more Firebird Guardian?

Firebird Guardian is a program that controls the visibility of the Firebird process. As soon as the server has been loaded, it will automatically start. To start the service as a service, there is no sense to beat the function, Windows itself restarts the service, as if it were completed after the pardon.

If you are installing a Firebird server on Windows Vista, check the "Install Applet Panevі Keruvannyait is necessary to take it.

Sha 8

We chose additional tasks for the server, after which everything is ready before installation - we press Install:

When the process is completed, it appears in the window with information, it is recommended to read:

Krok 9 - Launching Firebird

For installation purposes, you will be prompted to start the Firebird SQL Server service. Press "Save". Otzhe, we installed the server on our computer. How to fix Firebird (upload/start services) Control panel and click on "Firebird 2.1 Server Manager":

Automation of the store on the basis of the Firebird server is economically viable, shards, regardless of its cost-free, independent SQL server, to do the hard work and the need, to satisfy the needs of the average holding.

In our practice, the Storehouse Explorer system based on the Firebird server was victorious for automation of a holding of 50 stores throughout Russia. Rozmіr database revisited 30 GB, the database mistila Іnformatsiyu for 10 years, and one hour served from 70 to 120 koristuvachіv (carrying out trading operations and analytics).

>> Get a demo version<<

Installing a Firebird server on UNIX may have its own characteristics, as we would like to show in this article.

Store automation based on Firebird 2.5 server on POSIX (UNIX, LINUX) platforms

Peredmova

The article describes the installation of the Firedird 2.5.2 server on POSIX (Unix-like) operating systems, such as Linux, Unix.

Before the installation, it is necessary to check it out.

1. To install a Firebird server, you need root privileges.
2. If you install Firebird on Linux, then the first time you install it, you are responsible for re-installing, as there is a libstdc++.so.5 library in the system. If not, then install the compat-glibc package (RedHat, CentOs, OpenSuse, Debian) or the libstdc++5 package (Mandriva).
3. If you are planning to install Firebird with the SuperServer architecture on Linux, in order to support the new POSIX threading model, then you should choose the Firebird NPTL build.

I. Choice of distribution

It is worth downloading a wide range of Firebird distribution kits of different versions and extensions for different operating systems.
At the time of writing, there are no available stable builds of the server version 2.5.2, which can be used on
32 and 64 bit platforms Windows, LINUX and MacOSX.
However, if you choose the distribution you need first, you need to make a small entry.
Іsnuє kolka variantіv vykonannya or variantіv arkhіtektura Firebird server, Classic itself, SuperServer
and Embeded. The stench is rozraznyayutsya in the way of vikoristannya machine and mesh resources. Without going deep into the details, it is significant, briefly, the features of these architectures:
classic- formally can be described by the formula "n connections to the base - n processes on the server", that is. skin connect to base

launch your process on the server. Practice like this. On POSIX platforms, the [x] inetd daemon is started, which
listening port (port 3050 for locking, otherwise you can use it for consumption). This daemon launches the fb_inet_server process for the successful skin connection *okremium*. Under the skin process, a lot of server resources are being used, and memory cache is being created.

More economical use of computer resources architecture SuperServer.
SuperServer can be briefly described by the formula "n connections to the base - one process and n * streams * on the server". On POSIX systems, the process is fbserver. The superserver is a rich streaming addendum, on top of the Classic architecture. Skin care is served to a healthy potoci.
Embedded- tse architecture, yak pratsyuє at the warehouse of the okremnogo addendum, that at the splendid rozumіnі not є "repair server", tobto. not recognized for work as a server, as a service provider without a connection.
Better for everything, you can choose between Classic architecture and Superserver. If you don’t have the ability to delve deeply into the details, then you can choose quite enough. The format of the data base itself is in no way tied to a specific Classic or Superserver architecture, and you can always reinstall the server, choosing a different architecture.
And if you want, better for everything, you should be like an architecture with these two, є a thought that for beginners, if only you started working with Firebird, the Classic architecture is the best for experimenting with Firebird, like a stіykіsha to a nevіrnyh koristucha.
Respectfully, that the Superserver wins a deep cache of memory and may be the mother of deyakі perevaga at times of one-hour work and a large number of coristuvachiv. The superserver of the surroundings for the size of the operational memory, at the time of writing the statistics of the VIN can not overwrite the memory over 2Gb.
Classic Architecture can be used for memory, which means that it "freezes" the chip processors and may have a large amount of RAM (> 2 GB).
In this article, there is no need for a report analysis and analysis of these architectures, report information about it can be found on the Internet.

II. Select the installation method

To install Firebird, you must be the mother of root.
The Firebird server is up to cost-free products, the distribution kit for this installation can be obtained from the official website of the Firebird Foundation www.firebird.org.
Distributions are formed as *.rpm files or *.tar.gz files, for example:

FirebirdCS-2.5.2.26539-0.i686.rpm

FirebirdCS-2.5.2.26539-0.i686.tar.gz

Note that not all Linux packages will support rpm installation, you can check the documentation for the "RPM Package Manager" distribution platform. In such cases, it is recommended to hack the "tar.gz" file.
On the Internet, descriptions of manual methods for installing the path of unpacking archives and copying files, such methods, for the obviousness of installers in the form of a retailer, are not recommended.

III. Firebird 2.5 server installation

For example, let's take the installation of the Classsic architecture server.
See the system under a root.
To install *.rpm file, type:

$rpm -ivh FirebirdCS-2.5.2.26539-0.i686.rpm

To install *.tar.gz file, type:

$tar -xzf FirebirdCS-2.5.2.26539-0.i686.tar.gz

$cd FirebirdCS-2.5.2.26539-0.i686.tar.gz

After running the installation scripts, the following will be spawned:

1. We will try to upload all the working Firebird servers.
2. What has not yet been created, will be created koristuvach " firebird i group firebird".
3. Up to catalog /opt/firebird the security software will be installed, at the catalo /usr/lib will be created
4. for libraries y catalog /usr/include file headers will be placed.
5. Up to catalog /etc/services A gds_db entry will be added for port 3050, as there is no such entry.
6. Add localhost.localdomain and HOSTNAME to directory /etc/gds_hosts.equiv.
7. When SuperServer is installed, it will only install a script to start the server /etc/rc.d/init.d/firebird.
8. If Classic is installed, then the startup script will be installed /etc/xinet.d/firebird otherwise, for some younger versions of inetd-systems, an entry will be added before /etc/inetd file.
9. New messages will be written to /usr/bin for the init.d script and a configuration entry for the Firebird server will be created etc/rc.config.
10. It will be possible to start the server/service and Firebird can start automatically.
11. If the password is generated by the password of the SYSDBA coristuvacha and records in the file /opt/firebird/SYSDBA.password.
12. You will add an alias for the test database employee.fdb to aliases.conf.

At this stage, you can check the correct installation of the Firebird server. For which we need the password of the SYSDBA cloud entry, which can be retrieved from the /opt/firebird/SYSDBA.password file.
Let's dial from the command line:

$cd /opt/firebird/bin

$./isql -user sysdba -password

SQL>connect localhost:employee.fdb;

SQL>select * from sales;

According to these commands, the Firebird server connects to the employee.fdb test database and retrieves all records from the sales table.
The Firebird server for locking starts with the name "firebird". Before locking, the server was called as "root". Starting the server as "root" is not correct from a security point of view , Oskіlki, koristuvach "root" nayvishchi rights in the system and vіn can create and see files and directories in the boundaries of the file system. These rights for the Firebird server must be assigned, then you should review and configure the server configuration for the robot with the name "firebird".

For whom:

1. coristuvach "firebird" is responsible for the mother of the right to write to the directory in which the data bases will be created.
2. The DatabaseAccess parameter in the /opt/firebird/firebird.conf file is guilty of having been set in such a way as to block access to all files and directories, for little reason, which is recognized for saving databases. If we create an alias for the file in the aliases.conf file, then the firebird.con file is responsible for giving access to that file.
3. it is recommended (bazhano, but not obov'yazkovo) to enter a variant alias for inserting abstract messages on data base files, without specifying a more specific physical parsing.

On the example of creating an empty data base test.fdb, we reconsider that the creation of the Firebird server was successful.
There is more than one way to create an empty base (for example, on a client, using the additional IBExpert program),
here the simplest way is suggested, by the staff of Firebird on the server.
Oberomo placement catalog var/firebird.
Otzhe, required:
1. Check the presence and create the /var/firebird directory for the day. As a keeper of this catalog, do not write "firebird", then change the keeper to "firebird":

$mkdir -p /var/firebird

$chown firebird:firebird /var/firebird

2. In the /opt/firebird/firebird.conf file, add permission to create a database in the /var/firebird directory.

DatabaseAccess = Restrict /var/firebird

3. create a base

$/opt/firebird/bin/isql -u SYSDBA -p

SQL>connect "/var/firebird/test.fdb";

A practical robot with a Firebird server may need the following tools:
- changeDBAPassword.sh- Script for changing the SYSDBA password.
- createAliasDB.sh- script for creating an empty data base, creating an alias and an entry in aliases.conf;
Vikoristan example:

$createAliasDB.sh

IV. Something went wrong...

As it turns out, the Firebird server worked just fine yesterday, but today it doesn’t start, or it starts, but it doesn’t work properly, you can fix the problem by helping you to log the firebird.log.

V. Installing Firebird on Solaris, FreeBSD, Debian platforms

At the time of writing this article, installing Firebird 2.5 for operating systems Solaris, FreeBSD, Debian is not yet available, please check forward versions of Firebird, for example 2.0.

(c) Milkevich Taras
polaris-soft team,

Literature:

1. Firebird 2 Migration & Installation, Helen Borrie (Collator/Editor) 6 April 2008 - Document v. mi210_20 - for Firebird 2.1.
2. World of Interbase. Architecture, administration and expansion of database add-ons from Interbase/Firebird/Yaffil. Vidannya 2nd, supplementary. Oleksiy Kovyazin, Sergiy Vostrikov, KUDITS-OBRAZ, Moscow 2003.

Important! If you previously installed the InterBase database server, it is necessary to remove it (deinstall), otherwise the Firebird database server will work normally. For help, you can use the utility “Installed that Remote Program” at the “Keruvannya Panel” (sound out in the “My Computer” folder). If you have Windows XP SP2 or an earlier version installed, we recommend that you upgrade to Service Pack 3 (SP3).

1) Get the distribution kit of the Firebird server, as well as all the necessary instructions: http://*****/category/programs_for_mlm.

2) If you want to install in the operating system Windows Vista or Windows 7, then click on the distribution kit "Firebird_25.exe" (by naming the file with the distribution kit, you can change it in a fallacious version) with the right mouse button in the menu, select the item "Run as administrator" , then we will confirm the launch in the name of the administrator, so that the system for monitoring public records of the coristuvachs can see the valid request. For operating systems Windows XP, Windows 2000 and younger versions of Windows, simply double-click on the distribution file "Firebird_25.exe".

Important! Database server Firebird in operating systems Windows Vista or Windows 7 must be installed as an administrator!

3) Select a language in the window, as if it will be changed during the installation process (the key should be "Ukrainian") and click on the "OK" button:

https://pandia.ru/text/78/399/images/image002_57.jpg" width="503" height="385 src=">

5) Place a dot in front of the inscription “I accept the mind please”:

https://pandia.ru/text/78/399/images/image004_30.jpg" width="503" height="385 src=">

https://pandia.ru/text/78/399/images/image006_18.jpg" width="504" height="385 src=">

https://pandia.ru/text/78/399/images/image008_11.jpg" width="504" height="385 src=">

11) Take a tick navpacki "Whikoristovuvati Guardian for keruvannya by the server". Tick ​​the boxes on the contrary, “Run as a Program” means you install the program in the operating system Windows XP, Windows 2000 or younger versions of Windows, or “Run as a Service” means you install the program in the operating system Windows Vista or Windows 7. Tick ​​the boxes such as "Start Firebird automatically on skin storm", "Copy Firebird's client library from the directory » and «Create GDS32.DLL to support declining programs». Tick ​​the boxes on the contrary, "Install Applet Panel Kernel", which means that you install the program in the operating system Windows XP, Windows 2000 or younger versions of Windows. In operating systems Windows Vista and Windows 7, it is not necessary to check the box!

https://pandia.ru/text/78/399/images/image010_9.jpg" width="504" height="385 src=">

13) Check while the installer installs the Firebird server on your computer:

https://pandia.ru/text/78/399/images/image012_9.jpg" width="504" height="385 src=">

15) Press the "Finish" button:

https://pandia.ru/text/78/399/images/image014_5.jpg" width="589 height=442" height="442">

On the screen, the next window will appear:

Rice. one Rice. 2

How do you see the picture on the screen? Rice. one(at the top, instructed by the logo, it says "The Firebird service is running"), then the Firebird database server is running. How do you see the picture on the screen? Rice. 2(the logo is crossed with a red cross, and the instruction is written "The Firebird service is not running"), then the Firebird database server is up and running, for which you need to press the "Start" button at the top left corner of the window.

Check if the "Start" field has a dot next to "Automatically". If it costs more to write "Manually", then click on the "Automatically" and press the "Apply" button - in this way the server will start automatically when the computer is occupied.

The Firebird database server can be installed (launched, run soon) in Windows Vista or Windows 7 only through service provisioning. To click on the "Start" button (the button on the task manager or the keyboard key from the image of the MicroSoft logo):

Then, right-click on the mouse on the "Computer" item, select "Management" from the menu.

Looks like it's coming:

Double click on "Services and Programs", and then on "Services".

Find the "Firebird Server" service in the list of services:

If the “Practice” service is set, then the Firebird database server is launched, if the middle “Stand” has the status of empty (empty), it needs to be launched. To do this, right-click on the name of the "Firebird Server" service, select "Start" from the menu.

Running Firebird on Linux/UNIX

1.1.3.1. Running the Linux Installer You will need to flash your computer to download from the CD. Sound the hour when the computer starts up and you can see on the prompt screen: Press DEL to enter SETUP or Press F2 to enter SETUP