Firebird 3 Quick Start Guide

2y ago
30 Views
2 Downloads
373.23 KB
58 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Nadine Tse
Transcription

Firebird 3 Quick Start GuideIBPhoenix Editors, Firebird Project MembersVersion 5.4, 27 June 2020

Table of ContentsTable of Contents1. About this guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32. The Firebird licenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43. Installing Firebird . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53.1. Installation kits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53.2. Installing the Firebird server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53.2.1. Before installation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53.2.2. Installation drives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63.2.3. Installation script or program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63.2.4. Server modes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63.2.5. Installing on Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73.2.6. Installing on Linux and other Unix-like platforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83.3. Installing multiple servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83.4. Testing your installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93.4.1. Pinging the server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93.4.2. Making sure that the Firebird server is running. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93.5. Performing a client-only install . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123.5.1. Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123.5.2. Linux and some other Posix clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124. Default disk locations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144.1. Linux . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144.2. Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175.1. User management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175.1.1. Changing the SYSDBA password . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175.1.2. Adding Firebird user accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185.1.3. The security database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195.1.4. Appointing co-administrators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195.2. Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215.3. Administration tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266. Working with databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276.1. Connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276.1.1. Local connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276.1.2. TCP/IP connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 286.1.3. NetBEUI connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 296.1.4. URL-style connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 306.1.5. Third-party programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316.2. Connecting to an existing database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316.2.1. Connecting with isql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311

Table of Contents6.2.2. Connecting with a GUI client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 326.3. Creating a database using isql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336.3.1. Starting isql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336.3.2. The CREATE DATABASE statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336.3.3. Creating a database as a non-privileged user . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 346.4. Firebird SQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 346.4.1. Division of an integer by an integer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 346.4.2. Things to know about strings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356.4.3. Expressions involving NULL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377. Protecting your data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407.1. Backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407.2. How to corrupt a database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407.2.1. Disabling forced writes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407.2.2. Restoring a backup to a running database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 417.2.3. Allowing users to log in during a restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 418. How to get help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 429. How to give help. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4310. The Firebird Project. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44Appendix A: Document History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Appendix B: License notice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55Alphabetical index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 562

Chapter 1. About this guideChapter 1. About this guideThe Firebird Quick Start Guide is an introduction for the complete newcomer to a few essentials forgetting off to a quick start with a Firebird binary kit. The guide first saw the light as Chapter 1 of theUsing Firebird manual, sold on CD by IBPhoenix. Later it was published separately on the Internet.In June 2004, IBPhoenix donated it to the Firebird Project. Since then, it is maintained, andregularly updated, by members of the Firebird documentation project. Before you read on, verify that this guide matches your Firebird version. Thisdocument covers Firebird 3. For all other Firebird versions, get the correspondingQuick Start Guide at https://www.firebirdsql.org/en/documentation/.3

Chapter 2. The Firebird licensesChapter 2. The Firebird licensesFirebird is a free, open-source database management system, but “free” does not mean thateverything is permitted. The use of Firebird is governed by two licenses: the IPL (InterBase PublicLicense) and the IDPL (Initial Developer’s Public License). The first one covers the parts of thesource code that were inherited from InterBase; the second applies to the additions andimprovements made by the Firebird Project. Both licenses offer similar rights and restrictions. Inshort: Use of the software is free, even for commercial purposes. You may also redistribute thesoftware, separately or with a product of your own, but you may not claim ownership or creditfor it. Any license notices included with Firebird must remain intact. You may modify and recompile the Firebird source code or parts of it. You may distribute suchmodified versions, but if you do so, you must document your modifications and make thempublicly available, at no cost, under the same license as the original code. You may include Firebird source code (modified or not) in a larger work and distribute thatlarger work, in source and/or compiled form, under a license of your own choosing. You neednot publicize the source code for the entire larger work, but you must fulfill the licenseconditions for the parts that were taken from Firebird, whether they were modified or not.Please notice that the above is a simplified overview. Only the original license texts are legallybinding. You can find them here:https://www.firebirdsql.org/ipl/ (IPL)https://www.firebirdsql.org/idpl/ (IDPL)4

Chapter 3. Installing FirebirdChapter 3. Installing FirebirdThe instructions given below for the installation of Firebird on Windows and Linux should besufficient for the vast majority of cases. However, if you experience problems or if you have specialneeds not covered here, be sure to read the Release Notes. This is especially important if you areupgrading from a previous version or if there are remnants of an old (and maybe long gone)InterBase or Firebird installation floating around your system (DLLs, Registry entries, environmentvariables )3.1. Installation kitsAt the Firebird website, https://firebirdsql.org, the installation kits have names like:Firebird-3.0.0.bbbbb p x64.exeWindows executable installerFirebird-3.0.0.bbbbb-p x64.zipWindows zip kit for manual installationFirebird-3.0.0.bbbbb p Win32.exeWindows executable installer, 32 bitsFirebird-3.0.0.bbbbb-p.amd64.rpmLinux RPM kitFirebird-3.0.0.bbbbb-p.amd64.tar.gzLinux compressed tarballFirebird-3.0.0.bbbbb-p.i686.rpmLinux RPM kit, 32 bitsFirebird-3.0.0.bbbbb-x86 64.pkgMac OS-X 64-bit package.where bbbbb is the build number (32483 for the initial 3.0.0 release) and p the packaging number(usually 0 or another low one-digit number).Firebird 3 packages will also undoubtedly wind up in various Linux distributions and their onlinerepositories. These will have their own naming schemes.3.2. Installing the Firebird server3.2.1. Before installationIt is almost always advisable to uninstall any previous Firebird installations completely (afteryou’ve read the next paragraph!) and also hunt the Windows system dirs for old copies of gds32.dlland fbclient.dll. If you’re using Linux, the uninstall scripts should have removed any copiesand/or symlinks in /usr/lib[64], but it won’t hurt to look if anything named libfbclient. orlibgds. is still lying around.Furthermore, you should be aware that Firebird 3 won’t open databases that were created by olderversions. So before taking down your existing setup, you should back up all your databases in orderthat you can restore them later under Firebird 3.5

Chapter 3. Installing FirebirdYou may also want to back up your old security database security2.fdb. Firebird 3 comes with anSQL script security database.sql (located in misc/upgrade/security) that will upgrade the oldsecurity database to Firebird 3, preserving all information except SYSDBA's and except anypasswords. For more information, see Compatibility Issues :: Upgrading a v.2.x Security Database inthe Firebird 3 Release Notes.3.2.2. Installation drivesThe Firebird server — and any databases you create or connect to — must reside on a hard drivethat is physically connected to the host machine. You cannot locate components of the server, orany database, on a mapped drive, a filesystem share or a network filesystem. (Well, you can, butyou shouldn’t, and this technique isn’t covered here.) You can mount a read-only database on a CD-ROM drive, but you cannot runFirebird server from one.3.2.3. Installation script or programAlthough it is possible to install Firebird by a filesystem copying method — such as untarring asnapshot build or decompressing a structured .zip archive — it is strongly recommended that youuse the distributed release kit (.exe for Windows, .rpm for Linux), especially if this is the first timeyou install Firebird. The Windows installation executable, the Linux rpm program and theinstall.sh script in the official .tar.gz for various Posix platforms all perform some essential setuptasks. Provided you follow the installation instructions correctly, there should be nothing for you todo upon completion but log in and go!3.2.4. Server modesSome installers ask you to choose between Classic, SuperClassic and Superserver mode. What arethey? Classic mode (aka MultiProcess) involves a single listening process that spawns off an additionalprocess for each client connection. Using a locking mechanism, it allows shared connections todatabase files. SuperClassic (ThreadedShared) is a single server process. Client connections are handled byseparate threads, each having their own database page cache. Other processes (e.g. embeddedservers) may open the same database simultaneously (hence the Shared). Superserver (ThreadedDedicated) is also a single server process with threads handling clientconnections. There is a single, common database page cache. The server requires exclusiveaccess to each database file it opens (hence the Dedicated).Each mode is fully stable and there is no reason to categorically prefer one to the other. Of course,you may have your own specific considerations. When in doubt, just follow the installer default fornow. Changing the server mode later can be done via the configuration file firebird.conf andrequires a restart but not reinstallation. The server mode can even be configured per database(consult the Release Notes for details).6

Chapter 3. Installing Firebird Users of Firebird 2.5 or earlier: please notice that as from Firebird 3, Superserverfully supports the use of multiple processors/cores out of the box, so lack of SMPsupport is no longer a reason to avoid it.3.2.5. Installing on WindowsMake sure you run the installer program as Administrator (i.e. right-click on the executable andchoose “Run as Administrator”) or you may run into permission problems later!On Windows server platforms Firebird will run as a system service by default, but duringinstallation you can also choose to let it run as an application. Don’t do this unless you have acompelling reason.The installer will also ask if you want to enable authorization for legacy (i.e. pre-3.0) Firebirdclients. If security is a concern (as it should be), don’t allow this or allow it only temporarily whileyou upgrade your existing clients to Firebird 3.0. The legacy connection method sends passwordsover the wire unencrypted; it also limits the usable length of the password to 8 characters.During installation you have the option of providing a password for Firebird’s superuser, SYSDBA.Firebird passwords may be up to 255 bytes long, but due to the nature of the hashing algorithm the7

Chapter 3. Installing Firebird“effective length” is around 20 bytes, so it’s not very useful to enter a password that’s much longerthan that. Notice however that if you do enter such a password, you must supply it in its full lengthevery time you connect — it won’t work if you truncate it to the first 20 characters!Use the Guardian?The Firebird Guardian is a utility that monitors the server process and tries to restart it if itterminates abnormally. During a Windows install, you can opt to use the Guardian when runningin SuperClassic or Superserver mode. However, since modern Windows systems have the facility towatch and restart services, there is no reason to use the Guardian if Firebird runs as a service(which it should).The Guardian may be phased out in future versions of Firebird.3.2.6. Installing on Linux and other Unix-like platformsIn all cases, read the Release Notes for the Firebird version you’re going to install. There may besignificant variations from release to release of any Posix operating system, especially the opensource ones. Where possible, the build engineers for each Firebird version have attempted todocument any known issues.Aside from being packaged with the download kits, Release Notes for all officially released versionsof Firebird can also be found at https://www.firebirdsql.org/en/release-notes/.If you have a Linux distribution that supports rpm installs, consult the appropriate platformdocumentation for instructions about using RPM Package Manager. In most distributions you willhave the choice of performing the install from a command shell or through a GUI interface.For Linux distributions that cannot process rpm programs, and for Unix flavours for which no .rpmkit is provided, use the .tar.gz kit. Quite often, installation is just a matter of untarring the archiveand running install.sh. In some cases, the Release Notes or packed Readmes may instruct you toedit the scripts and make some manual adjustments.3.3. Installing multiple serversFirebird allows the operation of multiple servers on a single machine. It can also run concurrentlywith Firebird 1.x or InterBase servers. Setting this up is not a beginner’s task though. If you need torun multiple servers on the same machine, the second and subsequent servers must be installedand configured manually. They need to have different service names and should listen on differentTCP/IP ports. The file install windows manually.txt in the doc subdir may be of help if you’re doingthis on Windows, but bear in mind that it was written for Firebird 2.1.Also read the chapter Configuring the Port Service on Client and Server in the Firebird 1.5 (!) mentation/release firebirdsql.org/file/documentation/release notes/Firebird-1.5.6-ReleaseNotes.pdf#page 968

Chapter 3. Installing Firebird3.4. Testing your installationIf you want to connect to your Firebird server across a network, then before testing the Firebirdserver itself you may want to verify that the server machine is reachable from the client at all. Atthis point, it is assumed that you will use the recommended TCP/IP network protocol for yourFirebird client/server connections. (On Windows networks, NetBEUI is also supported.)3.4.1. Pinging the serverThe ping command — available on most systems — is a quick and easy way to see if you can connectto a server machine via the network. For example, if your server’s IP address in the domain that isvisible to your client is 192.13.14.1, go to a command shell on the client machine and type thecommandping 192.13.14.1substituting this example IP address with the IP address that your server is broadcasting. If you areon a managed network and you don’t know the server’s IP address, ask your system administrator.Of course, you can also ping the server by its name, if you know it:ping vercingetorixIf you are connecting to the server from a local client — that is, a client running on the samemachine as the server — you can ping the virtual TCP/IP loopback server:ping localhostorping 127.0.0.1If you have a simple network of two machines linked by a crossover cable, you can set up yourserver with any IP address you like except 127.0.0.1 (which is reserved for a local loopback server)and, of course, the IP address which you are using for your client machine. If you know the “native”IP addresses of your network cards, and they are different, you can simply use those.Once you have verified that the server machine is reachable from the client, you can go on to thenext step.3.4.2. Making sure that the Firebird server is runningMost — but not all — installation packages start up the Firebird server as one of the final stepsduring installation, and also make sure that Firebird is started at every reboot.After being launched, the Firebird server should be running:9

Chapter 3. Installing FirebirdOn Linux or other Unix-like systemsAs a service.On Windows server systemsAs a service or as an application. Service is default and highly recommended.The following sections show you how to test the server on each platform.Server check: Linux and other UnicesUse the top command in a command shell to inspect the running processes interactively. If aFirebird 3 server is running, you should see a process named firebird and possibly also fbguard(the Guardian process).The following screen shows the output of top, restricted by grep to show only lines containing thestring firebird:paul@fili top -b -n1 grep [f]irebird7169 firebird 20029668992560 S7171 firebird 200 22816058763048 S0,00,00,00,10:00.00 fbguard0:00.01 firebirdAs an alternative to top, you can use ps -ax or ps -aux and pipe the output to grep.The process name is firebird regardless if Firebird is running in Superserver, Classic orSuperClassic mode. However, it is possible to configure a Classic-mode Firebird in such a way that itruns as a service under (x)inetd. In that case, you will only see a firebird process if a clientconnection has been made.Another way of testing the server after installation is by starting a Firebird client (e.g./opt/firebird/bin/isql) and connecting to a database or creating one. These operations aredescribed later in this guide.If it turns out that the server hasn’t been started after all, you may need to do this manually, e.g.with /etc/init.d/firebird start or systemctl start firebird and systemctl enable firebird,depending on the type of Linux system and your Firebird installation package.Server check: Windows, running as serviceOpen Control Panel › Administrative Tools › Services.This illustration shows the Services applet display on Windows 7. The appearance may vary fromone Windows server edition to another.10

Chapter 3. Installing FirebirdYou should at least find the Firebird server in the services listing. The Guardian may or may not berunning, depending on the choices you made during installation. If you didn’t opt to start the serverat the end of the installation process, you may do so now by right-clicking on the Firebird entry (orthe Guardian) and choosing Start.Server check: Windows, running as applicationIf Firebird is up and running as an application, it is represented by an icon in the system tray: A green and grey server symbol if controlled by the Guardian; A round yellow and black graphic if running standalone.A flashing icon indicates that the server is in the process of starting up (or at least trying to do so). Ared icon, or an icon with an overlying red stop sign, indicates that startup has failed.One way to make 100% sure if the server is running or not is to press Ctrl Alt Del and look forthe firebird process (and possibly fbguard) in the task list. You may need to check the box “Showprocesses of all users” for these processes to become visible.On some occasions, you may need to start the Guardian or server once explicitly via the Start menueven if you opted for “Start Firebird now” at the end of the installation process. Sometimes a rebootis necessary.You can shut the server down via the menu that appears if you right-click on the tray icon. Noticethat this also makes the icon disappear; you can restart Firebird via the Start menu.11

Chapter 3. Installing FirebirdIn Classic mode (but not SuperClassic!) a new process is launched for everyconnection, so the number of firebird processes will always equal the number of client connections plus one. Shutdown via the tray icon menu only terminates thefirst process (the listener). Other processes, if present, will continue to functionnormally, each terminating when the client disconnects from the database. Ofcourse, once the listener has been shut down, new connections can’t be made.3.5. Performing a client-only installEach remote client machine needs to have the client library — libfbclient.so on Posix clients,fbclient.dll on Windows clients — that matches the release version of the Firebird server.Firebird can install symlinks or copies named after the 1.0 libs (with the “old” InterBase names), tomaintain compatibility with third-party products which need these files.Some extra pieces are also needed for the client-only install.3.5.1. WindowsAt present, no separate installation program is available to install only the client pieces on aWindows machine. If you are in the common situation of running Windows clients to a Linux orother Unix-like Firebird server (or another Windows machine), you need to download the fullWindows installation kit that corresponds to the version of Firebird server you install on yourserver machine.Fortunately, once you have the kit, the Windows client-only install is a breeze. Just run theinstallation program and when you arrive at the “Select Components” screen, choose one of theclient-only options from the drop-down list or uncheck the “Server Components” checkbox.3.5.2. Linux and some other Posix clientsA small-footprint client install program for Linux clients is not available either. Additionally, somePosix flavours — even within the Linux constellation — have somewhat idiosyncratic requirementsfor filesystem locations. For these reasons, not all *x distributions for Firebird even contain a clientonly install option.For most Linux flavours, the following procedure is suggested for a manual Firebird client-onlyinstall. Log in as root for this.1. Look for libfbclient.so.3.0.n (n being the patch version number) in /opt/firebird/lib on themachine where the Firebird server is installed. Copy it to /usr/lib on the client (or /usr/lib64 ifboth server and client are 64-bits).2. Create chained symlinks using the following commands:ln -s /usr/lib/libfbclient.so.3.0.n /usr/lib/libfbclient.so.2ln -s /usr/lib/libfbclient.so.2 /usr/lib/libfbclient.so12

Chapter 3. Installing Firebird.replacing 3.0.n with your version number, e.g. 3.0.0 or 3.0.4If you’re running applications that expect the legacy libraries to be present, also create thefollowing symlinks:ln -s /usr/lib/libfbclient.so /usr/lib/libgds.so.0ln -s /usr/lib/libfbclient.so /usr/lib/libgds.so3. Copy firebird.msg to the client machine, preferably into the /opt/firebird directory. If you placeit somewhere else, create a system-wide permanent FIREBIRD environment variable pointing tothe right directory, so that the API routines can locate the messages.4. Optionally copy some of the Firebird command-line tools — e.g. isql — to the client machine.Instead of copying the files from a server, you can also pull them out of a Firebird tar.gz kit.Everything you need is located in the /opt/firebird tree within the buildroot.tar.gz archive that’spacked inside the kit.13

Chapter 4. Default disk locationsChapter 4. Default disk locationsThe tables below show you where you’ll find the Firebird files and directories after a standardinstallation. Please notice that the listings are not exhaustive.4.1. LinuxThe following table shows the default component locations of a Firebird installation on Linux.Some of the locations may be different on other Unix-like systems, or on certain Linuxdistributions.Table 1. Firebird 3.0 component locations on LinuxComponentFile NameDefault LocationInstallation-/opt/firebird (may vary perdirectory (referredd

Chapter 1. About this guide The Firebird Quick Start Guide is an introduction for the complete newcomer to a few essentials for getting off to a quick start with a Firebird binary kit. The guide first saw the light as Chapter 1 of the Using Firebird manual, sold on CD by IBPh

Related Documents:

Cloudera ODBC Driver for Apache Hive (v2.05.10.1003) Apache Software Foundation - Apache Hive JDBC v0.13.1 license. Firebird . Firebird 2.0 Firebird ODBC Driver Jaybird JDBC Driver LGPL, source & license IBM DB2 for z/OS . v8, v9, and v10 DB2 UDB Client for Windows 8.0 or later IBM Data Server

Firebird database events returned by triggers and stored procedures Use of Microsoft ODBC cursors (odbccr32.dll, odbccu32.dll) Firebird Services API (backup & restore, statistics, repair) by way of the function SQLConfigDataSource The schemas SCHEMA or OWNER for cases where a schema is required for cross-DBMS compatibility in .

pieces, Stravinsky usually prepared the piano reductions of his music himself, both for rehearsal purposes and for extra income, and such is the case with Firebird. In both of the Firebird piano reductions, one finds that the reprise of the bassoon melody reflects exactly what is found in the original score, above.

Stravinsky: Suite from The Firebird (1919) A handsome prince, a captive princess, an evil ogre and a good fairy are the main characters in Stravinsky’s ballet The Firebird. His orchestral suite is a capsule version, presenting all the main characters. We can follow the outlines of the scenario through the music, which incorporates some

Piotr Ilyich Tchaikovsky (1840-1893) Introduction and Waltz from The Sleeping Beauty Igor Stravinsky (1882-1971) Suite from The Firebird (1919) Introduction The Firebird and its Dance— Variation of the Firebird Ring Dance of the Princesses Infernal Dance of King Kascheï Lullaby Finale Sergei Rachmaninoff (1873-1943) Concerto No. 2 in C Minor .

4.1 Quick Start Tutorial When Collect is opened for the first time, the Quick Start tutorial is displayed. Quick Start is a series of five screens that provide a summary review of the main capabilities of the app. Tap the Forward icon to move through the Quick Start screens. Tap Start to open the app after finishing with the Quick Start screens .

CorelDRAW Home & Student Suite 2018 Quick Start Guide Author: Corel Keywords: CorelDRAW Home & Student Suite 2018 quick start guide; quick start guide; CorelDRAW Home & Student Suite 2018 Getting Started Created Date: 4/29/2020 7:51:12 AM

BSc Accounting and Finance Department of Accounting Pie chart showing breakdown by country yet to place *Data for registered BSc Accounting and Finance students in years 1-3 in 2013-14 This guide is printed on recycled stock. The programme The BSc Accounting and Finance programme is widely regarded as being at the forefront of international teaching in its field. It is known for pioneering .