. . . . . 22 6.11. Remote Backups & Restores. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 6.12. Remote Backups and Restores method),version LI-V2.1.3.18185 Firebird 2.1 Firebird/linux (remote server),version LI-V2.1.3.18185 Firebird 2.1/tcp (tux)/P11 Firebird/linux (remote interface), version LI-V2.1.3.18185 Firebird 2.1/tcp (tux)/P11 This switch causes gbak to backup a remote database via the service manager. This causes the backup file to be created on the remote server, so the path format and filename must be valid

response code is always zero — at least up until Firebird 2.0.  When logging into a database on a remote server, you will always be required to pass the -⁠u[ser] and -⁠pa[ssword] parameters. Chapter 3 linux where a multi-database transaction had been run connected to databases linux@my_employee and remote:testlimbo. Both of these database names are aliases. linux> gfix -list my_employee Transaction 67 Site: linux Transaction 67 has been prepared. Remote Site: remote Database path: /opt/firebird/examples/testlimbo.fdb If the command is run against the remote database then nothing will be listed because

listener has been shut down, new connections can’t be made. 3.5. Performing a client-only install Each remote client machine needs to have the client library — libfbclient.so on POSIX clients, fbclient.dll and locating the Providers entry. The default (which is probably commented out) is: #Providers = Remote,Engine13,Loopback Now, either remove the hash mark and the Engine13 provider (this is the one that embedded connections), or — better — add an uncommented line: Providers = Remote,Loopback The Remote provider takes care of remote connections; the Loopback provider is responsible for TCP/IP connections

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 concerns may creates a database (and usually an accompanying client application) for installation on servers at remote sites. At such sites it is usual for a person at that site to have full access to the computer on database — both data and metadata. In such cases the developer may not trust the users at these remote sites to keep the intellectual property represented by the database confidential. The fear may be

concatenates the same strings if they are adjacent to each other, but does not do it if they are remote from each other BLOB Storage • By default, a regular record is created for each BLOB and it is server_spec Remote server specification. Some protocols require specifying a hostname. Optionally includes a port number or service name. Required if the database is created on a remote server. filepath name or IP address of the server where the database is to be created port The port number where the remote server is listening (parameter RemoteServicePort in firebird.conf file) service Service name. Must

as -a and -x also only initiate a non-interactive session. Isql can be run from either a local or remote client: • When connecting using a local client, you may set the environment variables ISC_USER and and ISC_PASSWORD. For more information on these, see below. • When connecting from a remote client, you will need a valid name and password. Chapter 5. Starting An Isql Session 10 Chapter 6. Ending entry by default. 8.1.1. URL-like Syntax Firebird 3.0 introduced a unified URL-like syntax for the remote server specification. In this syntax, the first part specifies the name of the protocol, then a

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.7. Sicherungen auf Remote-Servern (Firebird 2.5+). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . werden. In Firebird 2.5 und höher können die Sicherungs- und Wiederherstellungsaufgaben jedoch auch remote über den Services Manager ausgeführt werden. • Wird der Services Manager nicht verwendet (ab Firebird Sicherungen auf Remote-Servern (Firebird 2.5+) Nbackup selbst arbeitet nur mit lokalen Datenbanken. In Firebird 2.5 und höher können Sicherungen und Wiederherstellungen vom Typ nbackup auch remote über den

DECLARE VARIABLE REMOTE_PROTOCOL VARCHAR(8); DECLARE VARIABLE APP_NAME VARCHAR(253); DECLARE VARIABLE SERVER_PID INTEGER; DECLARE VARIABLE PC_USER_PID INTEGER; BEGIN SELECT M_A.MON$REMOTE_PROTOCOL, M_A M_A.MON$REMOTE_PROCESS, M_A.MON$SERVER_PID, M_A.MON$REMOTE_PID FROM MON$ATTACHMENTS M_A WHERE M_A.MON$ATTACHMENT_ID = CURRENT_CONNECTION INTO :REMOTE_PROTOCOL, :APP_NAME, :SERVER_PID, :PC_PID; INSERT CONNECT_ID, PC_IP, REMOTE_PROTOCOL, APP_NAME, SERVER_PID, PC_PID, DATE_START_CONNECT) VALUES ( CURRENT_USER, CURRENT_CONNECTION, RDB$GET_CONTEXT('SYSTEM', 'CLIENT_ADDRESS'), :REMOTE_PROTOCOL, :APP_NAME

concatenates the same strings if they are adjacent to each other, but does not do it if they are remote from each other BLOB Storage • By default, a regular record is created for each BLOB and it is database file Chapter 5. Data Definition (DDL) Statements 79 Parameter Description server_spec Remote server specification in TCP/IP or Windows Networking style. Optionally includes a port number or Creating a Database Remotely If you create a database on a remote server, you should specify the remote server specification. The remote server specification depends on the protocol being used. If you

Beschreibung filespec Dateispezifikation für primäre Datenbankdatei server_spec Spezifikation des Remote-Servers. Einige Protokolle erfordern die Angabe eines Hostnamens. Enthält optional eine Portnummer IP-Adresse des Servers, auf dem die Datenbank erstellt werden soll port Die Portnummer, auf der der Remote-Server lauscht (Parameter RemoteServicePort in der Datei firebird.conf) service Dienstname. Muss einer Datenbank auf einem Remote-Server Wenn Sie eine Datenbank auf einem Remote-Server erstellen, müssen Sie die Remote-Server- Spezifikation angeben. Die Spezifikation des Remote-Servers hängt vom verwendeten