view release on metacpan or  search on metacpan

lib/ETLp/Manual/Install.pod  view on Meta::CPAN

    make test
    sudo make install

=head2 Configuring the Browser

=over 4

=item 1. Choose a root directory for the browser application that is accessible to your Apache server
=item 1. Copy the code under the web directory to that location
=item 1. Edit the application configuration file
=item 1. Edit the Apache configuration file
=item 1. (Re)start Apache

=back

As B<root>, from the ETLp home directory:

    mkdir   /var/www/etlp/
    cp web/*  /var/www/etlp/

Create the browser config file, /var/www/etlp/conf/etl.conf, and enter the appropriate settings

    user     = <etl user>
    password = <etl password>
    dsn      = <Perl DBI connection string>
    root_url = /etlp
    pagesize = 20

=over 4

=item * user. The username to connect to. This is usually etl.

=item * password. The user's password

=item * dsn. The Perl DBI connection string.

=item * root_url. The portion of the URL after the server name (absolute path). For example (!https://<!MyHost>/etlp would be /etlp)The directory where the main application is configured. It must be readable by the web server user (typically ''apache...

=item * How many items to show on a page. Pagination links will be displayed as appropriate

=back

Create the Apache configuration: /etc/httpd/conf.d/etlp.conf

    Alias /etlp/stylesheets/  "/var/www/etlp/stylesheets/"
    Alias /etlp/javascript/  "/var/www/etlp/javascript/"

    ScriptAlias /etlp/ "/var/www/etlp/cgi-bin/"
    <Directory /var/www/etlp/cgi-bin>
       AllowOverride None
       Options +ExecCGI
       Order allow,deny
       Allow from all

       # This line is only required of Oracle is used:
       SetEnv ORACLE_HOME <ORACLE_HOME>
    </Directory>

Make sure the web files are owned by the apache user (typically ''apache'' or ''nobody''):

    chown -R apache:apache /var/www/etlp

Restart apache:

    service httpd restart

B<Note>: These instructions assume that you are installing against the standard Redhat Enterprise Linux Apache distribution. If you have installed from source on on another operating system flavour, then the locations will be slightly different, e.g.

    /usr/local/apache/bin/apachectl restart

or 

    /etc/init.d/httpd restart

Refer to your system administrator for the details, if required.

=head3 Extra Steps for Oracle

If the ETLp Runtime Browser runs against an Oracle database, it provides functionality to drill down to the running SQL and to also generate an explain plan. However, this feature requires additional privileges, specifically the ability to SELECT fro...

=over 4

=item * v$session

=item * v$sqlarea

=item * v$process

=back

These should be granted to the main ETL user. In order to generate an explain plan, the ETL user must have select privileges on the underlying tables. In addition, further synonyms may need to be provided if the SQL in question does not have fully qu...