4. Configuration

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.

$ALLOWED_DIRS

$ALLOWED_FILES

$DATABASE_SUFFIXES

BACKUP_DIR

$HIDE_PANELS

$SQL_DISABLE

SYSDBA_GET_ALL

4.3 Login Defaults

These are the default settings for the textfields on the login-panel. DEFAULT_USER

DEFAULT_DB

DEFAULT_PATH

DEFAULT_HOST

DEFAULT_ROLE

DEFAULT_CACHE

DEFAULT_CHARSET

DEFAULT_DIALECT

DEFAULT_SERVER

4.4 Appearance

LANGUAGE

TABMENU_STYLE

MENU_WIDTH

DATAPATH

TTF_FONT

TTF_SIZE

ICON_SIZE

COLOR_BACKGROUND

COLOR_PANEL

COLOR_AREA

COLOR_HEADLINE

COLOR_MENUBORDER

COLOR_LINK

COLOR_LINKHOVER

COLOR_SELECTEDROW

COLOR_SELECTEDINPUT

COLOR_FIRSTROW

COLOR_SECONDROW

BG_TRANSPARENT

SQL_AREA_COLS

SQL_AREA_ROWS

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.

SQL_HISTORY_SIZE

SHOW_OUTPUT_ROWS

DATA_MAXWIDTH

MAX_CSV_LINE

DEFAULT_ROWS

BLOB_WINDOW_WIDTH

BLOB_WINDOW_HEIGHT

USE_DHTML

CACHE_STYLESHEET

WATCHTABLE_METHOD

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.

PERSISTANT_CONNECTIONS

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.