Q: What I need to install properly this package?
A: The base requirements are:

Perl 5.005_03 or higher,
Unix/Linux or Windows 9x/NT/XP

Recomended:

Perl 5.6,

Unix/Linux OS,
MySQL

You really need Unix/Linux based OS to enjoy all features in this module. Also you need MySQL to get speed with your session/user support! Of cource you can use our Flat Db driver (based on DBD::Sprite) to enjoy session/user functions.

To run scripts you also may need to install follow standart modules

DBI (for DB access - In all cases!)

MySQL (for MySQL access)

DBD-ODBC (for MS Access)

 

Q: How can I configure this package?
A: The only one configuration file in this package is "config.pl" and you can find it in 'conf' directory. Please configure FIRST! (More info about config.pl you can find in docs directory, please read HELP.html)

NOTE: For easy configure you can use our web based install.cgi script instead of manual edit of config file!

To install WebTools you must read INSTALL.html (located in your docs directory. Please read it!)
Before you can start any script you 'must' run check test that show your active configuration.
To do this, you must have already
configured "config.pl"
To perform check please type follow in browser:

http://yourhost/cgi-bin/webtools/process.cgi

where 'cgi-bin' is your web server cgi directory;
'webtools' is your cgi based package directory;
process.cgi is you sub 'compiler' :-))


After you have passed the 'test' successfully you have to turn 'off' variable $check_module_functions to run your scripts normal (for more information see config.pl)

Anyway you need to read INSTALL.html and/or next FAQ.

 

Q: Why I get "Internal error" in browser?
A: Commonly you get this error when your shebang (path to your perl compiler) is not correctly set. You have to change it only in one place: process.cgi (found in base directory of your package).
NOTE:
If you intend to use install.cgi (easy configurator) you have to edit and it's shebang too.
On default it's set to: #!/usr/bin/perl

If you don't know where is your Perl, you can use follow Unix command: whereis perl
to find out where is it.
Of course the reason for that unconfortable error can be hidden in your installation!

Please check out for common errors like mode of your process.cgi (is it 755 ?) and/or directories?
Other often error is related to Apache's(your web server) permissions, i.e. Apache can be unable to run
scripts (!!!) and you must make Apache able to run them properly. More information you can fetch from INSTALL.html (please read careful).

 

Q: How I can learn more about "WebTools"?
A: Reading this FAQ and you will :-)
The real help actualy is in all the examples that I wrote (with some friends help) placed into docs/examples sub directory. A quick reference of functions you can find in Help.html (found into docs directory)

 

Q: Why some SQL queries works and other not?
A: Well, all sql_* functions are able to support sessions and users functions but when you try to use it for your private needs, you must care about what exacly you 'insert', 'update' and so on... i.e. you must be very carefull when use these functions for anything else! Please QUOTE all data and take care about what kind of DB engine you prepare to use!

Example:
So best way to insert, update...your data is:

$sth = sql_query("INSERT INTO TABL VALUES($val1,$val2,...)",$dbh);

where: $val1, $val2,... must be quoted using sql_quote() on that way:
$val1 = sql_quote($unquoted_var1,$dbh);

Note: If inserted data is numeric then you don't need to quote them!

Using that style you will remove most problems with insert/update!

Note: Flat DB and Ms Access does not support binary files, so please don't insert binary files into session with these engines! However session support via MySQL and Flat files (not Flat DB) is FULL!

 

Q: How I can report errors and make comments?
A: Every help, suggessions and reports I will appreciate very high!


Please mail it to: julian@proscriptum.com