locations of a 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 Typical locations on 32- bit systems are: • for Windows 95/98/ME: C:\Windows\System • for Windows NT/2000: C:\WINNT\System32 • for Windows XP: C:\Windows\System32 For 64-bit systems, read the next note. Firebird Firebird 2.0 and 2.1 Quick Start 9 Important notice for 64-bit Windows users On 64-bit Windows systems, the “Program Files” directory is reserved for 64-bit programs. If you try to install a 32-bit application

Chapter 3. Installing Firebird 9 3.4.1. Pinging the server The ping command — available on most systems — is a quick and easy way to see if you can connect to a server machine via the network. For example launched, the Firebird server should be running: On Linux or other Unix-like systems As a service. On Windows server systems As a service or as an application. Service is default and highly recommended locations of a Firebird installation on Linux. Some locations may be different on other Unix-like systems, or on certain Linux distributions. Table 1. Firebird 5.0 component locations on Linux Component

If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. could be the size of a CD, the 2GB limit on individual file sizes on a DVD, where some Unix file systems have a 2 GB limit and so on. Gbak allows the dump files to be split into various sizes (with a database if it doesn’t already exist, and will exit with an error if it does. In POSIX compatible systems, the error code in $? is 1 in this case. Further examples of backing up and restoring remote databases

 It is possible on some operating systems that users will not be able to run gsec, even if they know the SYSDBA password. This is because those operating systems allow the system administrator to set Windows (Change '1_5' to suit your Firebird version) • /opt/firebird for Linux and other Unix systems. The gsec utility manipulates data in the table(s) in the security database, and by doing so, allows If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards.

command-line utility for installing and uninstalling the Firebird service. It does not apply to Windows systems that do not have the ability to run services (Win9x, WinME). For detailed usage instructions, refer fb_inet_server.exe on Windows that listens for connection requests from network clients. On POSIX systems, the [x]inetd daemon performs this listening role. The stub process or daemon creates a separate process for each successful connection. Each process has its own private page cache and, on 32-bit systems, can use up to 2 GB of RAM. • Superserver is a process named fbserver.exe on Windows, fbserver on

operating systems imposed a limit which defined how large a single file could become. This limit was 2 Gb on some systems, and 4 Gb on others. For example, on HP-UX 10.20 or 11.00 Unix systems, the maximum the file system has the largefiles option turned on. This limit still exists on some operating systems. Gsplit is a filter utility introduced with Interbase 5.0 which allows the output file from the

Windows 2000 and XP, the Guardian is a convenience rather than a necessity, since these two operating systems have the facility to watch and restart services. It is recommended that you keep Guardian active Firebird for Windows kits installed the InterBase Manager applet into the Control Panel of operating systems that support services. It was omitted from Firebird 1.0 because a number of Firebird-specific “Firebird user name and a valid pass- word. Any user other than SYSDBA, root (on Posix systems), or Administrator (on Windows systems, if Firebird runs as this user) needs also to have permissions to objects inside

If the file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. populated with data it can be changed to read only mode, and then used on a CD (or other read only file systems) with no problems.  Firebird uses SQL internally to maintain its internal structures with details Chapter 13. Database Validation and Recovery 34 Chapter 14. Database Write Mode Many operating systems employ a disk cache mechanism. This uses an area of memory (which may be part of your server’s overall

start up process may be inconvenient, but it can provide excellent security for unattended computer systems. Software with these capabilities includes: TrueCrypt (www.truecrypt.org), Bestcrypt from Jetico functions to prevent or deny access. Such features may offer some limited use for closed source systems, where the obscurity of the implementation helps to hide exactly how information is being protected least extract their own data (in appropriate formats) in order to be able to move to alternative systems. Can you trust the users to respect your intellectual property while you are still in business and

databases are considered an anachronism. It made sense to use multi-file databases on old file systems where the size of any file is limited. For instance, you could not create a file larger than 4 GB problems may be very important for web sites handling thousands of concurrent writers, or for ERP/CRM systems operating in large corporations, most application programs do not need to work in such conditions was introduced in Firebird 4.0.1.  The PKCS_1_5 option is only for backward compatibility with systems applying PKCS 1.5 padding. For security reasons, it should not be used in new projects.  • This