Partners
Firebird PHP Generator online Help
| Prev | Return to chapter overview | Next |
How to connect to Firebird
Connection properties
Set the connection parameters for the database you want the PHP scripts to work with.
Script connection properties
Specify here connection parameters for Firebird server relatively to the webserver. For example, if your webserver and Firebird server are installed on the same computer, set Host as localhost.
Firebird PHP Generator allows you to connect to Firebird servers directly or via Secure SHell (SSH) tunnel.
| • | Direct connection is the most preferable connection mode. |
| • | If your Firebird server does not allow direct connections from remote workstations, you can establish connection to intermediate SSH server and forward all Firebird commands through the Secure SHell (SSH) tunnel. |
More about SSH tunnel connection
To establish connection to intermediate SSH server and forward all Firebird commands through the secure tunnel, you need to:
Host name Specify the host name or IP of your site.
Port number Enter the port number for the SSH server. Enter valid User name for the remote server, select the authentication type: by password or by private key and set the Password or the path to the Private key file with the corresponding Passphrase to log in to the remote server.
Note: Firebird host name always should be set relatively to the SSH server. For example, if both of Firebird and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
|
Irrespectively of a connection mode you should specify common credentials as follows:
Protocol (Standard server, Embedded server)
The software supports only TCP/IP protocol, you need to select only the type of server you are connecting to.
Host
The name of machine the Firebird server and database file resides on. It is usually possible to specify TCP/IP address instead of name (like 192.168.12.34), however this functionality is not built into Firebird, instead, it is provided by underlying network layer (e.g. WinSock2), and for some implementations/configurations it can be much slower than using name. In case the server is not localhost, specify the TCP/IP port as Port number.
Login information
Since version 2.1, Windows authentication has been used for configuring the server authentication mode along with the traditional login info, requiring users to log in using a user name and password defined in the security database. To use Windows authentication, check the corresponding box. Under the right conditions, this may be the most secure way to authenticate on Windows. Otherwise, set the following server security options:
User name |
The username used to connect to Firebird. User names are case insensitive on the server. |
Password |
The password for the user account on server. The server checks the user name and password against the security database. Case sensitivity is retained for the comparison. Only first 8 characters of Password are verified. |
Role |
Specify the role that the user adopts on connection to the database or leave it blank. Regardless of role memberships granted, the user has the privileges of a role at connect time only if a Role clause is specified in the connection. The user must have previously been granted membership in the role to gain the privileges of that role. |
Database name
This is either name of database file (as seen from the server), or alias defined in aliases.conf file. It is better (but not required) to use fully qualified filename, e.g. "d:\databases\db.fdb" (avoid using partially specified filenames like "d:databases\db.fdb").