Vfront Install File in English v0.99.3
Vfront Install File in English v0.99.3
Vfront Install File in English v0.99.3
License
Basic requirements
For those in a hurry ...
Copying files and setting file and folder rights
The configuration file
Database connection
Authentication Settings
Section SMTP and e-mail
section Debug
section Log
section Path
section FOP
Section attachments and links
section Misc
Configuration File Inclusion
automatic installation procedure
Manual installation steps
After installation
system initialization
Test of VFront settings
## Basic Requirements ##
To work VFront needs the following software:
* Apache Web Server 2.x (the application has been developed and tested for t
he Apache 2.x server,
might work with other Web servers)
* MySQL 5.x or PostgreSQL 8.x (Warning PostgreSQL support is in alpha stage)
* PHP version 5.x
The following modules are also required for PHP:
* Php_mysqli (MySQL Improved) - if you use a mysql database
(Or you want to authenticate using an external MySQL server)
* Php_pgsql (library Postgres) - if you are using a postgresql database inst
ead
(Or you want to authenticate via external postgresql server)
Optionally, you also require the following modules
* Php_gd2 - GD library version> = 2.x
* Php_xsl for the use of server-side XSL transformations.
If you did not have a chance to use this extension you can still use
transforms the client side.
* Php_ldap - if you wanted to set the external authentication via LDAP
* Php_odbc - if you wanted to set the external authentication via ODBC
* Php_soap - if you wanted to set the external authentication via SOAP (expe
rimental)
The statistics section instead uses PEAR (http://pear.php.net/) for graphics gen
eration.
Therefore PEAR is required, as well as the PEAR packages:
* Image / Graph (http://pear.php.net/package/Image_Graph)
* html
* tmp
If you want to use the debug using the file rpc.debug.txt (see besides for a des
cription)
then this file also needs to be writable by Apache.
## Database connection ##
The first section of the configuration file is for the database connection.
You can choose whether to use VFront as a front end for a MySQL 5.x database or
a PostgreSQL 8.x database
Please remember that while support for MySQL 5.x has had numerous tests and real
-world applications,
support for PostgreSQL is the still unstable and should be considered in alpha s
tage at present.
The parameters required are:
$ Db1 [ 'dbtype'] = "mysql";
// Indicates the type of database: can be "mysql" or "postgres". It MUST be spec
ified
$ Db1 [ 'host'] = "localhost";
// Server host:
$ Db1 [ 'port'] = "3306";
// Server Port: default 3306 and 5432 for MySQL for PosgreSQL
$ Db1 [ 'user'] = "username";
// User to connect to the database
$ Db1 [ 'Set Password'] = "secret";
// Password for the database connection
$ Db1 [ 'dbname'] = "bank";
// Database name: For postgres use "public", that is, the schema name
$ Db1 [ 'frontend'] = "vfront_test";
// Name of VFront database. In postgres it should match the schema name (we sugg
est "frontend")
$ Db1 [ 'postgres_dbname'] = "database_name";
// Real name of the database (only if you use Postgres)
## Authentication Settings ##
VFront allows authentication using your own table "user" or by another system.
The authentication logic and the accreditation of user rights are in fact separa
ted.
When you use external authentication (for example, using LDAP) if the user exist
s is
automatically authenticated on VFront.
The next step will be the accreditation of rights through the User table:
if the user exists on LDAP and not on the user table you will be automatically e
nrolled in this,
and will be assigned the default rights (group 0). For more information about us
ing groups
and the rights of users, refer to the documentation of VFront.
The parameter for authentication is
$ Conf_auth [ 'tipo_external_auth'] = '';
If set = '' or = null authentication will be done through the VFront database an
d its user table.
The other possible parameters at the moment are
* 'Db': indicates authentication through another database on the same server
(MySQL only)
* 'Db_ext' indicates a MySQL database, PosgreSQL or loosely connected via OD
BC, on another server
* 'Ldap': indicates authentication using LDAP servers such as OpenLDAP or Ac
tive Directory
* 'Soap': indicates authentication by linking SOAP WSDL. This type of authen
tication is experimental.
If you set one of these parameters then these other variables are required:
$ Conf_auth [ 'campo_email'] = 'email';
// Indicates the database field name or LDAP to retrieve the user's email,
// Used for authentication
$ Conf_auth [ 'campo_password'] = 'passwd';
// Indicates the database field name or LDAP to retrieve the user's password,
// Used for authentication
$ Conf_auth [ 'campo_nome'] = 'name'; // optional
// Indicates the field name of the database or LDAP to retrieve the user's name
$ Conf_auth [ 'campo_cognome'] = 'name'; // optional
// Indicates the field name of the database or LDAP to retrieve the user's name
$ Conf_auth [ 'password_crypt'] = 'md5'; // Md5 | sha1 | null
// If the passwords were stored as hash md5 or sha1 set this parameter
ext section).
## Debugging Section ##
The debug section consists of three variables described here:
// Screen errors | errors in email
$ DEBUG_SQL = true;
In a production environment it is recommended to set the variable to FALSE: in c
ase of error
you will be sent an email to the administrator and the developer. In this case i
t will inform you on screen that an error has been generated.
If the variable is TRUE the errors and the SQL will instead be displayed on the
screen.
$ RPC_DEBUG = true;
// Write the SQL calls in a file (default ./rpc.debug.txt) - default: FALSE
This feature can be very useful to read what VFront performed by external calls.
The ./rpc.debug.txt file must be writable by Apache.
## Section ## Log
This section presents one variable that enables or disables the log.
The VFront log allows you to record the date, time, and author of all the transa
ctions carried out
through the forms, shows a historical record and allows a rollback of cancellati
ons and changes.
It is strongly recommended that the parameter is set to TRUE.
$ RPC_LOG = true;
// Writes a log of calls SQL insertion, modification and deletion - default: TRU
E
section Path
In this section the web addresses are configured for VFront on the server:
// Real path
define ( 'FRONT_ROOT', 'D: / htdocs / vfront_test');
// Real path
define ( 'FRONT_REALPATH', 'D: / htdocs / vfront_test');
// Path of the document root
define ( 'FRONT_DOCROOT', 'http: // localhost / vfront_test');
// In most of the following cases the variables may be left as they are:
// Path mysqldump (for MySQL export) - Default: mysqldump
define ( '_ PATH_MYSQLDUMP', "mysqldump");
// Path pg_dump (for the export of Postgres) - Default: pg_dump
define ( '_ PATH_PG_DUMP', "pg_dump");
// Path to the attached file system
define ( '_ PATH_ATTACHMENT', FRONT_REALPATH. "/ files");
// Path to tmp file system for attachments
define ( '_ PATH_ATTACHMENT_TMP', FRONT_REALPATH. "/ files / tmp");
// Path to the file system useful documents
define ( '_ PATH_HELPDOCS', FRONT_REALPATH. "/ files / docs");
// Tmp path accessible via web
define ( '_ PATH_TMP', FRONT_REALPATH. "/ tmp");
// Path to the XSL style sheets attached
define ( '_ PATH_XSL', FRONT_REALPATH. "/ files / xsl_custom");
// Web path to the XSL style sheets attached
define ( '_ PATH_WEB_XSL', FRONT_DOCROOT. "/ files / xsl_custom");
## Section FOP ##
VFront uses Apache FOP (http://xmlgraphics.apache.org/fop/) for XSL-FO transform
ations
and reports generated in PDF.
FOP is not distributed with VFront, but it should be downloaded and installed se
parately.
// Sets whether Vfront can use the application FOP (true or false)
define ( '_ FOP_ENABLED', true);
// Path to FOP on the server:
//define('_PATH_FOP','C:/fop-0.20.5/foptest/fop.bat ');
//define('_PATH_FOP','/usr/local/fop/fop.sh ');
The Apache server must have FOP for the functions to work.
## Section ## Misc
In this section various kinds of constants are defined:
define ( '_ MAX_TEMPO_EDIT', 240);
VFront is designed as multi-user front-end: to avoid concurrent write access to
the same record, there is a "lock" procedure of the individual records when they
are
opened for editing by a user. This constant expresses in seconds the maximum tim
e
for which the records should be considered locked (default 240 seconds, or 4 min
utes).
define ( '_ BASE64_PASSFRASE', "passphrase");
In some operations it uses a base64 encoding of parameters in URLs.
This constant sets a sentence for encoding.
define ( '_ IMG_LOGO', FRONT_DOCROOT. '/ img / vfront090.jpg');
This indicates the path of the logo in the upper left of the VFront pages
define ( '_ NOME_PROJ', 'VFront');
Set the name of VFront interface (for example "Front-end Library" or simply "VFr
ont")
## After installation ##
system initialization
After the installation you must initialize the system.
VFront must read the information schema and enter the database information that
you
have set up in your tables. To do it
1. login with the sysadmin account
2. Go to the administration section
3. In the first menu, select "Initialize registers"
This starts an automatic procedure that will create the ground rules for accessi
ng the tables.
For the configuration of the tables refer to the reference manual VFront.
VFront settings Test
It is also suggested to access the Administration menu,
under "other business" and run the "Test VFront settings".
For more information, please refer to the reference manual VFront.