Should be really called 'Gotchas' Definitely Alpha code but is in production on a couple of sites Tested with =========== Informix 7.24/7.30/7.31/9.14/9.20 (Limited extended type support) Compiled 6.20/7.31 4gl, ESQL 2.41/2.50 C Compilers gcc-2.95.2, SUNWcpro, AIX std compiler Solaris 2.6/7 on Sun E450,E1000,10,20 AIX S70 Linux RH6.2 Web Servers Apache 1.3.12 (with/without mod_ssl), 1.3.14 Netscape-Enterprise/3.6 SP1 Perl 5.6.0 Installation ============ Run the install script Apply whatever Web based security restrictions are required. The minimum is probably configuring directory level security for the directory containing dbweb.pl General Stuff ============= When an Informix instance is selected then a username/password will be requested. If the instance is changed then dbweb will try to use the same username/password combination, if this fails then a new username/password will be requested. Only the current instance username/password are maintained. Directory Structure =================== DBW_BINPATH: Where the dbweb binary is located DBW_TMP: The directory to be used for local temporary storage DBW_HTMLROOT: The path form the Web site root CGIPATH: The cgi-bin for the website DBW_HOME: The home of dbwebd, the area that the PID file is located and a temporary area for holding of local output files from the requested command Formatting ========== The html pages can be formatted as either fixed width or as a percentage of the current window depending on the setting of TABWIDTHFIXED (html.h). The variable TABWIDTH then specifies the table width, for fixed width formats this is in pixels, for non fixed width it is the percentage of the current screen. By default all the SQL column types are returned in uppercase, including the named types. This is controlled via DBW_COLUPPER (coltype.ec). When the output is formatted, particularly stored procedures, triggers, and views, then are translated into html spaces. By default this is 8 per tab and is controlled via DBW_INDENT (dbweb.h) Things to note ============== 1 The password files are kept in clear. 2 The dbweb.pl file must in the cgi-bin directory. 3 If the Informix environment is not set when the web server is started then the dbweb.pl script should be altered. INFORMIXSERVER INFORMIXDIR LD_LIBRARY_PATH 4 There are two debug options, one just tracks function usage (DEBUG), the other tracks the html calls (HTMLDBB), both are located in dbweb.h