Experts Round Table Network

Required software packages

To develop and deploy the bank scenario that spans into all three application tiers, you need to make the following choices in those tiers:

    * Web browser
    * Database server
    * Web server
    * Mid-tier server
    * IDE for mid-tier code development
    * IDE for client tier code development

Among the many open source offerings available to fill the need in every layer, the scenario in this series uses the following:

Web browser: Mozilla Firefox 2.0.0.4 or later. Among Firefox's many strengths are usability, online security, and customization through hundreds of add-on applications. You'll also use Firebug, a browser application debugger add-on to Firefox.

Database server: MySQL 5.0.41 or later. It works in client/server mode and embedded mode. It is completely written in C and C++. It is available in two editions: Enterprise server and Community server. Community server is free and is adequate for the needs of the bank scenario in this article.

Web server: Apache Web server 2.2.2. It is highly configurable and extensible with third-party modules.

Mid-tier server: Zend Core 2.0.1 or later. This free, open source server supports PHP 5. It enjoys strong community support. It bundles Apache Web server and supports databases such as MySQL, IBM DB2®, and Oracle. Zend Core for IBM is specially tuned to work well with IBM DB2. Figure 1 shows an overview of Zend Core.

Mid-tier IDE (Integrated Development Environment): Eclipse PDT 0.7 RC3 or later. PDT is the PHP Development Tools framework for the Eclipse platform that includes all development components necessary to develop PHP applications. PHP debugging is also supported in this IDE. Zend, IBM, and other companies are contributing it to open source. At the time of this writing, it is brand new and arrives just in time for developing our bank scenario's mid-tier logic.

Client tier IDE: Aptana Web IDE 0.2.8.14433 or later. This is a free, open source, cross-platform, JavaScript-focused development environment for building Ajax browser applications. It provides code support for JavaScript, HTML, and CSS. It supports JavaScript debugging and includes built-in support for several Ajax frameworks. Above all, it is based on Eclipse.

Internal Server Error 500

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, @@ServerAdmin@@ and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

[Wed Jun 27 12:25:38 2007] [warn] pid file C:/Program Files/Zend/Apache2/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Wed Jun 27 12:25:38 2007] [notice] Apache/2.2.2 (Win32) configured -- resuming normal operations
[Wed Jun 27 12:25:38 2007] [notice] Server built: Oct 17 2006 19:47:26
[Wed Jun 27 12:25:38 2007] [notice] Parent: Created child process 3024
[Wed Jun 27 12:25:38 2007] [notice] Child 3024: Child process is running
[Wed Jun 27 12:25:38 2007] [notice] fcgi: Using [Zend Enabler module, Version 1.3.1] from [Zend Technologies Ltd.]
[Wed Jun 27 12:26:04 2007] [notice] Child 3024: Acquired the start mutex.
[Wed Jun 27 12:26:04 2007] [notice] Child 3024: Starting 250 worker threads.
[Wed Jun 27 12:26:04 2007] [notice] Child 3024: Starting thread to listen on port 80.
[Wed Jun 27 15:34:01 2007] [error] fcgi: Can not read response from C:\\Program Files\\Zend\\Core\\bin\\php-cgi.exe - [109]
[Wed Jun 27 15:34:01 2007] [warn] fcgi: Child process was terminated pid=3056 status=255
[Wed Jun 27 15:34:50 2007] [warn] fcgi: Child process was terminated pid=3364 status=255
[Wed Jun 27 15:34:50 2007] [error] fcgi: Can not read response from C:\\Program Files\\Zend\\Core\\bin\\php-cgi.exe - [109]
[Wed Jun 27 15:40:57 2007] [warn] fcgi: Child process was terminated pid=3472 status=255
[Wed Jun 27 15:40:57 2007] [error] fcgi: Can not read response from C:\\Program Files\\Zend\\Core\\bin\\php-cgi.exe - [109]
[Wed Jun 27 16:37:24 2007] [warn] fcgi: Child process was terminated pid=3624 status=255
[Wed Jun 27 16:37:24 2007] [error] fcgi: Can not read response from C:\\Program Files\\Zend\\Core\\bin\\php-cgi.exe - [109]

127.0.0.1 - - [27/Jun/2007:15:34:41 +0100] "POST /phpMyAdmin/index.php HTTP/1.1" 500 535
127.0.0.1 - - [27/Jun/2007:15:40:24 +0100] "GET /phpMyAdmin HTTP/1.1" 301 236
127.0.0.1 - - [27/Jun/2007:15:40:24 +0100] "GET /phpMyAdmin/ HTTP/1.1" 200 3615
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/css/print.css?lang=en-utf-8&convcharset=iso-8859-1&collation_connection=utf8_unicode_ci&token=fb964a7db425d55c1835bb682a9cde45 HTTP/1.1" 200 1063
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/css/phpmyadmin.css.php?lang=en-utf-8&convcharset=iso-8859-1&collation_connection=utf8_unicode_ci&token=fb964a7db425d55c1835bb682a9cde45&js_frame=right&nocache=1182955224 HTTP/1.1" 200 20322
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/themes/original/img/logo_right.png HTTP/1.1" 200 5658
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/themes/original/img/b_info.png HTTP/1.1" 200 234
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/themes/original/img/s_notice.png HTTP/1.1" 200 247
127.0.0.1 - - [27/Jun/2007:15:40:25 +0100] "GET /phpMyAdmin/favicon.ico HTTP/1.1" 200 18902
127.0.0.1 - - [27/Jun/2007:15:40:48 +0100] "POST /phpMyAdmin/index.php HTTP/1.1" 500 535
127.0.0.1 - - [27/Jun/2007:16:36:33 +0100] "POST /phpMyAdmin/index.php HTTP/1.1" 302 -
127.0.0.1 - - [27/Jun/2007:16:36:34 +0100] "GET /phpMyAdmin/index.php?lang=en-utf-8&token=68748c064f49a624d5eaf9d044b06562 HTTP/1.1" 200 1851
127.0.0.1 - - [27/Jun/2007:16:36:35 +0100] "GET /phpMyAdmin/js/querywindow.js HTTP/1.1" 304 -
127.0.0.1 - - [27/Jun/2007:16:36:35 +0100] "GET /phpMyAdmin/navigation.php?lang=en-utf-8&token=68748c064f49a624d5eaf9d044b06562 HTTP/1.1" 200 3326
127.0.0.1 - - [27/Jun/2007:16:36:35 +0100] "GET /phpMyAdmin/css/phpmyadmin.css.php?token=68748c064f49a624d5eaf9d044b06562&js_frame=left&nocache=1182958595 HTTP/1.1" 200 3618
127.0.0.1 - - [27/Jun/2007:16:36:36 +0100] "GET /phpMyAdmin/main.php?lang=en-utf-8&token=68748c064f49a624d5eaf9d044b06562 HTTP/1.1" 200 48410
127.0.0.1 - - [27/Jun/2007:16:36:36 +0100] "GET /phpMyAdmin/css/phpmyadmin.css.php?token=68748c064f49a624d5eaf9d044b06562&js_frame=right&nocache=1182958596 HTTP/1.1" 200 20322
127.0.0.1 - - [27/Jun/2007:16:36:42 +0100] "GET /phpMyAdmin/navigation.php?server=1&db=globalexpat&table=&lang=en-utf-8&collation_connection=utf8_unicode_ci HTTP/1.1" 200 22265
127.0.0.1 - - [27/Jun/2007:16:36:45 +0100] "GET /phpMyAdmin/css/phpmyadmin.css.php?token=68748c064f49a624d5eaf9d044b06562&js_frame=left&nocache=1182958602 HTTP/1.1" 200 3618
127.0.0.1 - - [27/Jun/2007:16:36:42 +0100] "GET /phpMyAdmin/db_structure.php?server=1&db=globalexpat&table=&lang=en-utf-8&collation_connection=utf8_unicode_ci HTTP/1.1" 200 101441
127.0.0.1 - - [27/Jun/2007:16:36:46 +0100] "GET /phpMyAdmin/css/phpmyadmin.css.php?token=68748c064f49a624d5eaf9d044b06562&js_frame=right&nocache=1182958603 HTTP/1.1" 200 20322
127.0.0.1 - - [27/Jun/2007:16:37:16 +0100] "POST /phpMyAdmin/index.php HTTP/1.1" 500 535

LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule authn_anon_module modules/mod_authn_anon.so
#LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authn_file_module modules/mod_authn_file.so
#LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule cgi_module modules/mod_cgi.so
#LoadModule dav_module modules/mod_dav.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
#LoadModule deflate_module modules/mod_deflate.so
LoadModule dir_module modules/mod_dir.so
LoadModule env_module modules/mod_env.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule file_cache_module modules/mod_file_cache.so
#LoadModule headers_module modules/mod_headers.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule include_module modules/mod_include.so
LoadModule info_module modules/mod_info.so
LoadModule isapi_module modules/mod_isapi.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
#LoadModule proxy_module modules/mod_proxy.so
#LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
#LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
#LoadModule proxy_connect_module modules/mod_proxy_connect.so
#LoadModule proxy_http_module modules/mod_proxy_http.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule speling_module modules/mod_speling.so
LoadModule status_module modules/mod_status.so
#LoadModule unique_id_module modules/mod_unique_id.so
LoadModule userdir_module modules/mod_userdir.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so
#LoadModule ssl_module modules/mod_ssl.so

# 'Main' server configuration
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#

#
# ServerAdmin: Your address, where problems with the server should be
# e-mailed.  This address appears on some server-generated pages, such
# as error documents.  e.g. admin@your-domain.com
#
ServerAdmin @@ServerAdmin@@

#
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
ServerName localhost:80

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "C:/Program Files/Zend/Apache2/htdocs"

#
# Each directory to which Apache has access can be configured with respect
# to which services and features are allowed and/or disabled in that
# directory (and its subdirectories).
#
# First, we configure the "default" to be a very restrictive set of
# features. 
#
<Directory />
    Options FollowSymLinks
    AllowOverride None
    Order deny,allow
    Deny from all
    Satisfy all
</Directory>

#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# This should be changed to whatever you set DocumentRoot to.
#
<Directory "C:/Program Files/Zend/Apache2/htdocs">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.2/mod/core.html#options
    # for more information.
    #
    Options Indexes FollowSymLinks

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   Options FileInfo AuthConfig Limit
    #
    AllowOverride None

    #
    # Controls who can get stuff from this server.
    #
    Order allow,deny
    Allow from all

</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
    DirectoryIndex index.php index.html index.htm
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.ht">
    Order allow,deny
    Deny from all
</FilesMatch>

#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog logs/error.log

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

<IfModule log_config_module>
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>

    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
    CustomLog logs/access.log common

    #
    # If you prefer a logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    #CustomLog logs/access.log combined
</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to
    # exist in your server's namespace, but do not anymore. The client
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://www.example.com/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:
    # Alias /webpath /full/filesystem/path
    #
    # If you include a trailing / on /webpath then the server will
    # require it to be present in the URL.  You will also likely
    # need to provide a <Directory> section to allow access to
    # the filesystem path.

    #
    # ScriptAlias: This controls which directories contain server scripts.
    # ScriptAliases are essentially the same as Aliases, except that
    # documents in the target directory are treated as applications and
    # run by the server when requested rather than as documents sent to the
    # client.  The same rules about trailing "/" apply to ScriptAlias
    # directives as to Alias.
    #
    ScriptAlias /cgi-bin/ "C:/Program Files/Zend/Apache2/cgi-bin/"

</IfModule>

#
# "C:/Program Files/Zend/Apache2/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "C:/Program Files/Zend/Apache2/cgi-bin">
    AllowOverride None
    Options None
    Order allow,deny
    Allow from all
</Directory>

#
# Apache parses all CGI scripts for the shebang line by default.
# This comment line, the first line of the script, consists of the symbols
# pound (#) and exclamation (!) followed by the path of the program that
# can execute this specific script.  For a perl script, with perl.exe in
# the C:\Program Files\Perl directory, the shebang line should be:

   #!c:/program files/perl/perl

# Note you _must_not_ indent the actual shebang line, and it must be the
# first line of the file.  Of course, CGI processing must be enabled by
# the appropriate ScriptAlias or Options ExecCGI directives for the files
# or directory in question.
#
# However, Apache on Windows allows either the Unix behavior above, or can
# use the Registry to match files by extention.  The command to execute
# a file of this type is retrieved from the registry by the same method as
# the Windows Explorer would use to handle double-clicking on a file.
# These script actions can be configured from the Windows Explorer View menu,
# 'Folder Options', and reviewing the 'File Types' tab.  Clicking the Edit
# button allows you to modify the Actions, of which Apache 1.3 attempts to
# perform the 'Open' Action, and failing that it will try the shebang line.
# This behavior is subject to change in Apache release 2.0.
#
# Each mechanism has it's own specific security weaknesses, from the means
# to run a program you didn't intend the website owner to invoke, and the
# best method is a matter of great debate.
#
# To enable the this Windows specific behavior (and therefore -disable- the
# equivilant Unix behavior), uncomment the following directive:
#
#ScriptInterpreterSource registry
#
# The directive above can be placed in individual <Directory> blocks or the
# .htaccess file, with either the 'registry' (Windows behavior) or 'script'
# (Unix behavior) option, and will override this server default option.
#

#
# DefaultType: the default MIME type the server will use for a document
# if it cannot otherwise determine one, such as from filename extensions.
# If your server contains mostly text or HTML documents, "text/plain" is
# a good value.  If most of your content is binary, such as applications
# or images, you may want to use "application/octet-stream" instead to
# keep browsers from trying to display binary files as though they are
# text.
#
DefaultType text/plain

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig conf/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
    # AddHandler allows you to map certain file extensions to "handlers":
    # actions unrelated to filetype. These can be either built into the server
    # or added with the Action directive (see below)
    #
    # To use CGI scripts outside of ScriptAliased directories:
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    #AddHandler cgi-script .cgi

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    #AddType text/html .shtml
    #AddOutputFilter INCLUDES .shtml
</IfModule>

#
# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type.  The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#
#MIMEMagicFile conf/magic

#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://www.example.com/subscription_info.html
#

#
# EnableMMAP and EnableSendfile: On systems that support it,
# memory-mapping or the sendfile syscall is used to deliver
# files.  This usually improves server performance, but must
# be turned off when serving from networked-mounted
# filesystems or if support for these functions is otherwise
# broken on your system.
#
#EnableMMAP off
#EnableSendfile off

# Supplemental configuration
#
# The configuration files in the conf/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server, or you may simply copy their contents here and change as
# necessary.

# Server-pool management (MPM specific)
#Include conf/extra/httpd-mpm.conf

# Multi-language error messages
#Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
#Include conf/extra/httpd-autoindex.conf

# Language settings
#Include conf/extra/httpd-languages.conf

# User home directories
#Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include conf/extra/httpd-info.conf

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include conf/extra/httpd-dav.conf

# Various default settings
#Include conf/extra/httpd-default.conf

# Secure (SSL/TLS) connections
#Include conf/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

<Location /server-info>
    SetHandler server-info
    Order deny,allow
    Deny from all
    Allow from 127.0.0.1
</Location>

<Location /server-status>
    SetHandler server-status
    Order deny,allow
    Deny from all
    Allow from 127.0.0.1
</Location>

LoadModule zend_enabler_module "C:/Program Files/Zend/Core/modules/apache2.2/zend_fcgi.dll"
FastCgiConfig "C:/Program Files/Zend/Core/etc/fastcgi.conf"
AddHandler fastcgi-script .php
AddType application/x-httpd-php .php
<Location /ZendCore>
  Order deny,allow
  Allow from all
</Location>
Alias /ZendCore "C:/Program Files/Zend/Core/GUI"