Firebird 2 Migration & Installation Helen Borrie (Collator/Editor) 19 June 2012 - Document v. mi215_01 - for Firebird 2.1.5 Firebird 2 Migration & Installation 19 June 2012 - Document v. mi215_01 - instsvc.exe ................................................................................ 10 2. INSTALLATION NOTES ....................................................................................... ............ 14 Installation Choices ...................................................................................................................... 14 Choosing an Installation Method ........

............................................................................. 11 Testing your installation ............................................................................................. Classic packages with FirebirdCS. For Windows, there is a combined installation package; you choose the architecture during the installation process. Embedded Server for Windows On Windows platforms only Firebird installation on Linux. Some of the locations may be different on other Unix-like systems. Table 2. Firebird 2 component locations on Linux Component File Name Default Location Installation directory

............................ 6 Installation drives ...................................................................................................... 6 Installation script or program ............. ......................................................................... 7 Testing your installation .................................................................................................. running database .............................................................. 21 4. Allowing users to log in during a restore ................................................................ 22 Where to next

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.1. Installation kits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.2.1. Before installation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.2.2. Installation drives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 3.2.3. Installation script or program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Overview The isql utility is a text-mode client tool located in the bin directory of the Firebird installation. It provides a command line interface for interactive access to a Firebird database. It accepts Firebird bin directory on your path, then either go to the bin subdirectory of your Firebird installation and type isql (Windows) or ./isql (Linux) at the command prompt, or, type the full path to the database named employee.fdb is located in the examples/empbuild subdirectory of your Firebird installation. Users can use this database to experiment with Firebird. Note that on some POSIX systems, the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 7.4. Gbak log file Cannot Be Overwritten . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . displayed. The default is to display the output to the screen, but you can redirect the output to a log file using the -y switch. -Y or the text "suppress" Used in conjunction with the -v[erify] The log file must not exist. If it does, the backup or recovery operation will fail: tux> rm employee.log tux> gbak -backup employee.fdb employee.fbk -y employee.log -v tux> ls -l employee.log -rw-r--r--

13. LOG(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319 Table of Contents 7 8.2.14. LOG10() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . external log table that might be used by an exception handler in a stored procedure or trigger. The external table is chosen because the messages from any handled exceptions will be retained in the log, even

423 8.2.16. LOG(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 423 8.2.17. LOG10(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 731 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . be used with expressions and values of the DECFLOAT type. They are: ABS CEILING EXP FLOOR LN LOG LOG10 POWER SIGN SQRT The aggregate functions SUM, AVG, MAX and MIN work with DECFLOAT data, as do all

secure installations. Embedded server is discussed in more detail later. Every Firebird server installation has a “SYSDBA” user, this user has unrestricted access to any database available to that server dependent on the level of security required for a particular installation. This will vary considerably from installation to installation. This means that, for reasonable security, installations should help developers who, having written Chapter 2. Background 3 databases for distribution and installation to remote sites, may wish to protect the intellectual property carried in their databases. Such

16. LOG(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 Inhaltsverzeichnis 8 8.2.17. LOG10() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 657 RDB$LOG_FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Nachricht. Die dritte Spalte speichert das Zeilentrennzeichen: CREATE TABLE ext_log EXTERNAL FILE 'd:\externals\log_me.txt' ( stamp CHAR (24), message CHAR(100), crlf CHAR(2) -- for a Windows