install.rc

使用perl和C写的基于Web的管理数据库表的程序

#
# This is a Template-File for WWWdb
#
#
#

# --- Description of the data to access -----------------------------------------
[Data]
Table    =
Order    =

UpdFields =
QryFields =

# Buttons for all states
# please note that "-" deactivates a Button
[State All]
BtnCancel  = -
BtnHelp    = -
BtnExit = -

# This is the state when the form is called the first time, or the Back-button
# is pressed
[State Init]
BtnNew = -
BtnQry = -

Header = WWWdb Help - Installation

# --- Here are the examples for the single fields -------------------------------
[Layout Label header]
Pos   = +1.+0+4.0
Text  = <<EOF
How to install <B>WWWdb</B>
<BR><BR>
EOF
Font = color=blue
Big  = yes
Align = center

[Layout Label install0]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
General information
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center



[Layout Label install0_0]
Pos   = +1.+0+4.0
Align = left
Text  = <<EOF

<B>WWWdb</B> is in a beta state. This means, that tons of ideas
are waiting to be implemented, not that the software isn't stable. Of
course, there are some bugs in, but you should run it stable on your
system, as we do.

<BR><BR>

Because of the beta state, bigger changes in the
config-file could be expected. So I plan for the future, to store all
informations in the database. Of course, there will be tools which
do the conversion!

Also no automated installation-process is available yet, but in the future
it will come. :-)
<BR><BR>

This examples are working on a SuSE 6.2 Distribution with apache
installed in the /usr/local/httpd-hierarchy.

EOF


[Layout Label install0_1]
Pos   = +1.+0+4.0
Align = left
Text  = <<EOF

NOTE:
<BR>
Every Line prefixed with a '$' shows you, what to type for doing this
installation-step.

The installation works as follows:
EOF

[Layout Label install1]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
Unpack WWWdb
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center


[Layout Label install1_0]
Pos   = +1.+0+4.0
Text  = <<EOF

Untar the tar-ball in the directory you want it, (by example
<TT>/usr/local/lib</TT>) with:

EOF

[Layout Label install1_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ tar xvfz WWWdb-&lt;Version&gt;.tar.gz"


[Layout Label install2_0]
Pos   = +1.+0+4.0
Text  = "Switch to the new created directory:"

[Layout Label install2_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ cd WWWdb-&lt;Version&gt;"

[Layout Label install3]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
Set up the web-server to work with WWWdb
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center


[Layout Label install3_0]
Pos   = +1.+0+4.0
Text  = <<EOF
Configure the Apache-Server (if you haven't done this with a previous version
of <B>WWWdb</B>):
<UL>
<LI>must be compiled and installed with perl_mod</LI>
<LI>make apache recognize URIs of the form:<BR>
    http://localhost/WWWdb/&lt;Session-Id&gt;/&lt;Database&gt;/&lt;Config-file&gt;
</LI>
</UL>
    This steps must be done as root

    (and do not forget to use >> for redirection, else your
    httpd-config-file gets killed):
EOF

[Layout Label install3_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ cat ApacheConfig.addon >>/etc/httpd/httpd.conf"

[Layout Label install4_0]
Pos   = +1.+0+4.0
Text  = <<EOF
    Now the pointer to your Address-translation-handler is installed.
    Of course the handler itself must be installed. On my System it's
    done with:
EOF

[Layout Label install4_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ cp WWWdb_TransUri.pm /usr/lib/perl5/site_perl/5.005/i586-linux/Apache"


[Layout Label install5_0]
Pos   = +1.+0+4.0
Text  = <<EOF
Now the apache-sever must be restarted:
EOF

[Layout Label install5_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ /sbin/init.d/apache restart"


[Layout Label install6_0]
Pos   = +1.+0+4.0
Text  = <<EOF
If no error-messages appear, apache should be working correct now.
EOF


[Layout Label install7]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
Now we install <B>WWWdb</B> ...
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center


[Layout Label install7_0]
Pos   = +1.+0+4.0
Text  = "Install the script WWWdb.cgi:"

[Layout Label install7_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ cp WWWdb.cgi /usr/local/httpd/cgi-bin"


[Layout Label install8_0]
Pos   = +1.+0+4.0
Text  = "Install the WWWdb-data-directory (here with a symbolic link)"

[Layout Label install8_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = "$ ln -sf `pwd` /usr/local/httpd/htdocs/WWWdb"

[Layout Label install8_1_0]
Pos   = +1.+0+4.0
Text  = "Create and set the right permissions for the tmp-directory"

[Layout Label install8_1_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ mkdir tmp<BR>
$ chmod 777 tmp<BR>
EOF

[Layout Label install8_2_0]
Pos   = +1.+0+4.0
Text  = "Set your hostname in lib/WWWdb/Pre.rc"

[Layout Label install8_2_2]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ vi lib/WWWdb/Pre.rc
EOF

[Layout Label install9_0_0]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
Prepare your Database
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center

[Layout Label install9_1_0]
Pos   = +1.+0+4.0
Text  = "Set your db-name etc in lib/WWWdb/Db/&lt;Db&gt;.rc"

[Layout Label install9_1_2]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ vi lib/WWWdb/Db/&lt;Db&gt;.rc
EOF

[Layout Label install9_2_1]
Pos   = +1.+0+4.0
Text  = "<BR>Create links for the db-dummys '' and Default."

[Layout Label install9_2_2]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ ln -sf lib/WWWdb/Db/&lt;Db&gt;.rc lib/WWWdb/Db/.rc<BR>
$ ln -sf lib/WWWdb/Db/&lt;Db&gt;.rc lib/WWWdb/Db/Default.rc<BR>
$ ln -sf lib/WWWdb/Db/&lt;Db&gt;.pl lib/WWWdb/Db/.pl<BR>
$ ln -sf lib/WWWdb/Db/&lt;Db&gt;.pl lib/WWWdb/Db/Default.pl<BR>
EOF

[Layout Label install9_3_1]
Pos   = +1.+0+4.0
Text  = <<EOF

<BR>

Now, you need to setup the database. Currently a script for PostgreSQL
is in the distribution. It sets up a complete new database from the
scratch.
<BR>
EOF

[Layout Label install9_3_2]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ psql &lt;your_database_name&gt;<BR>
Welcome to the POSTGRESQL interactive sql monitor:<BR>
Please read the file COPYRIGHT for copyright terms of POSTGRESQL<BR>
<BR>
   type \? for help on slash commands<BR>
   type \q to quit<BR>
   type \g or terminate with semicolon to execute query<BR>
 You are currently connected to the database: wwwdb<BR>

wwwdb=> \i lib/WWWdb/Db/wwwdb.dump
<BR>
EOF

[Layout Label install9_4]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
Prepare your Perl-Distribution
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center


[Layout Label install9_4_0]
Pos   = +1.+0+4.0
Text  = <<EOF
Here on my 'clean' SuSE 6.2 Distribution, the following perl-modules
must be added (in this sequence):

<OL>
<LI><B>DBD-Oracle</B>      - DBI-Driver for Oracle and/or</LI>
<LI><B>DBD-Pg</B>          - BI-Driver for Postgres</LI>
<LI><B>DBI</B>             - The Database-Interface</LI>
<LI><B>DBIx::Recordset</B> - The basic mechanism for db-access</LI>
<LI><B>IniConf</B>         - Parsing of config-files</LI>
<LI><B>HTML-Parser</B>     - HTML en-/decryption</LI>
<LI><B>LogCarp</B>         - Redirect perl-error-messages</LI>
<LI><B>Carp-Assert</B>     - Security-assertions for development</LI>
<LI><B>Digest-MD5</B>      - creating of unique Hashes</LI>
</OL>

To make it easier to install this modules, they are packed in the
<TT>./contrib</TT>-subtree.
<BR><BR>
The installation-process is easy:
EOF

[Layout Label install9_4_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ tar xvfz &lt;Module&gt;.tar.gz<BR>
$ cd &lt;Module&gt;<BR>
$ perl Makefile.PL<BR>
$ make<BR>
$ make test    # if you want<BR>
$ make install # as root<BR>
EOF



[Layout Label install9_5_0]
Pos   = +1.+0+4.0
Text  = <<EOF

If you use some datatypes like <i>date</i> etc., you have also to
replace some perl-modules, until my patched versions get included into
the distributions.

<BR><BR>

On my sytem the following commands are neccesary (as root):

EOF

[Layout Label install9_5_1]
Pos     = +1.+0+4.0
BgColor = #f0f0f0
Font    = face=fixed
Text    = <<EOF
$ cp contrib/Oracle.pm    /usr/lib/perl5/site_perl/5.005/i586-linux/DBD<BR>
$ cp contrib/Compat.pm    /usr/lib/perl5/site_perl/5.005/DBIx<BR>
$ cp contrib/Recordset.pm /usr/lib/perl5/site_perl/5.005/DBIx<BR>
EOF


[Layout Label install9_6_0]
Pos   = +1.+0+4.0
Text  = <<EOF

<BR>
Enter the url http://&lt;hostname&gt;/wwwdb and enjoy !!!!
<BR><BR>

If you have any troubles, please feel free to contact me at <a
href="mailto:[e-mail]">[e-mail]</a> or visit our bugtracker at
<a href="http://www.twc.de/jitterbug">http://www.twc.de/jitterbug</a>

EOF

[Layout Label install10]
Pos   = +1.+0+4.0
Text  = <<EOF
<BR><BR>
... now it's done!!
<BR><BR>
EOF
Font = color=blue
Bold  = yes
Align = center