All configuration settings are done in the file configuration.inc.php which is located inside of the inc directory of your ibWebAdmin installation. Some settings are changeable by the users on the customizing panel inside of ibWebAdmin. But the defaults for these settings are also given in inc/configuration.inc.php. The configuration file is an ordinary php file. So you have to pay attention for correct syntax or you will get parse errors on execution.
All none empty path settings have to include a trailing slash and you have to use slashes (no backslashes) on windows also.
4.1 Substantial Settings
This are the settings you have to adjust according to your environment before you will be able to run ibWebAdmin.
BINPATH The path where php respectively the webserver can access the command line tools (isql, gsec, gbak, ...) which were installed beside your database server. If the path is not empty it must include a trailing slash and you have to use slashes instead of backslashes on windows also.
SECURITY_DB The complete path including the filename for the security database used by our database server to store usernames and passwords. The name depends on the database server and version you are using. Commmon names are security.fdb, isc4.gdb and admin.ib.
Don't include a hostname into this setting. The given path is extended with the hostname specified on the database login panel.
TMPPATH Insert the name of a directory where the webserver have write permissions. The directory is used to place temporary files into it which ibWebAdmin is using for sql scripts. This scripts are necessary for database modelling tasks not available throught the php api, e.g. creating databases or stored procedures. Normally the temporary files are deleted immediatly after execution. But if you find a file named like 40dd8cf916986.sql in your TMPPATH this is propably a left over sql-script and you can delete it unscrupulous.
You can use the DEBUG_FILES setting to keep the temporary sql-scripts undeleted.
The TMPPATH directory is also used to store the generated html pages for debugging purposes if DEBUG_HTML is set TRUE.
4.2 Security
PROTOCOL Set this option to https to force the usage of ssl encrypted webserver access. This will only work if ssl encryption is supported by your webserver. Check the mod_ssl user manual or the apache 2 docs about mod_ssl for details. Default value is https.
4.3 Login Defaults
These are the default settings for the textfields on the login-panel. DEFAULT_USER
4.4 Appearance
4.5 Behavior
CONFIRM_DELETE Decides wether deleting of database objects or data must be confirmed through a dialog or if deletion is done immediatly. Default value for this setting is TRUE and it is changeable by the users on the configuration panel.
SQL_MAXSAVE Maximum number of lines a sql command or a loaded script on the sql-panel can have to be stored in the session. This didn't mean that you cannot execute bigger scripts but that the script will not be saved in the sql history buffer and it will be gone if perform other action in the meantime. Defaults on 100 lines.
IBWA_PREFIX The prefix string used for the naming of database objects created by ibWebAdmin for its own usage. By now it is only used for SP_LIMIT_NAME. Defaults to IBWA_.
SP_LIMIT_NAME Name of the stored procedure created by ibWebAdmin and used by the Watch Table panel if WT_STORED_PROCEDURE is selected as the WATCHTABLE_METHOD. Defaults to IBWA_LIMIT.
SESSION_NAME Name of the php session which is used as cookie name or as name for the get-parameter that holds the session-id. If empty the php default PHPSESSID will be used. Default value is ibwa.
TRANS_READ The arguments used for the ibase_trans() function calls when a transaction gets started for reading data. Defaults to IBASE_COMMITTED|IBASE_NOWAIT|IBASE_READ.
TRANS_WRITE The arguments used for the ibase_trans() function calls when a transaction gets started for writing data. Defaults to IBASE_COMMITTED|IBASE_NOWAIT|IBASE_WRITE.
META_REDIRECT Decides wether to use server-side or client-side redirection for invoking other scripts programamticly. Defaults to FALSE which means that server-side redirection is used. The only reason for changing this should be if your webserver didn't support server-side redirection with php's header() function.
4.6 Debugging
These settings are used during the development for tracking down errors by providing additional informations. So they may also be helpfull for you if you are experiencing problems when using ibWebAdmin.
DEBUG IF set to TRUE some links are displayed at the bottom of each page. By this links the session-, post- and get-data can be displayed. Another link is calling a script inc/phpinfo.php which is not included in the distribution for security reasons. The second affect is that several informations, mainly the executed sql statements, get printed on the info-panel. Default value is FALSE.
DEBUG_HTML If set to TRUE the html source code for the actual page gets written to the directory defined with the TEMPPATH setting. Default value is FALSE.
DEBUG_COMMANDS Set this one TRUE and you will get the external command calls (isql, gfix, etc.) displayed on the info-panel. ibWebAdmin is using the external commands for a lot of tasks which are not available through php. If one of these tasks is failing it is a good idea to change this setting, cut & paste the command to the command line and to execute it directly. Default value is FALSE.
DEBUG_FILES Temporary sql files are created in the TEMPPATH directory for execution by isql for DDL-statements which are not allowed to execute with php's ibase_query() function. If this setting is TRUE the temporary files are retained, otherwise they are deleted. Default value is FALSE.