exponential.earth / exponential / documentation / Installation / manual installation / manual configuration of exponential
These documentation pages are no longer maintained. Please visit the new documentation site.
This section describes how to manually configure a fresh Exponential installation. Please keep in mind that manual installation is for expert users only. Unless there exists a good reason/requirement for doing a manual configuration, it is recommended that people use the a normal installation method. The following steps will work on both Linux/UNIX and Windows environments.
Database
Create a database using MySQL or PostgreSQL, make sure that Exponential can access it (you'll need to know the hostname of the computer running the database-server application, the name of the database itself and a username-password combination to access it). Initialize the database by running the "kernel_schema.sql" and the "cleandata.sql" SQL scripts. These scripts can be found inside the "kernel/sql/mysql/" and "/kernel/sql/postgresql/" subdirectories.
Using MySQL:
1. Go to script directory: $ cd <exponential-directory>/kernel/sql/mysql 2. Login to MySQL server and database: $ mysql -u<mysql_username> -p<mysql_password> <database> 3. Run script: mysql> source <script>
Permissions
Windows users can skip this part. If Exponential is installed on a Linux/UNIX based system, then a couple of file permissions need to be changed. There exists a shell script that takes care of this. This script must be run, or else, Exponential will not function properly. The script needs to be run from within the Exponential directory, like this:
$ cd <exponential-directory> $ bin/modfix.sh
The modfix script alters the permission settings of the following directories:
var/* (recursive)
settings/* (recursive)
design/* (recursive)
If you know the user and group of the webserver it is recommended to use a different set of permissions. Example:
chmod og+rwx -R var chown -R nouser.nouser var
The nouser.nouser notation must be changed to your webserver username and groupname.
Editing site.ini
The settings/site.ini configuration file contains some general/default settings. Some of these settings need to be changed, or else Exponential will not function properly. Use your favourite text editor to edit the file. Windows users will probably have to use wordpad (instead of notepad) since the configuration files are in the UNIX textfile format.
Database settings
Modify all settings that belong to the [DatabaseSettings] section. The system needs to know the type of database you are using, the hostname of the database-server, the username, the password and the name of the database.
Mail transport settings
Under the [MailSettings] section, modify the "transport" setting. This section is used to configure how Exponential delivers its outgoing E-mail. There are two options:
- Direct delivery through sendmail (must be available on the server).
- Indirect delivery using an SMTP relay server.
The Exponential system uses E-mail to send out important notices such as user registration and content approval. On Linux/UNIX: try to use sendmail. On Windows: use an SMTP server.
Sendmail: Mail is delivered directly using the sendmail transfer agent. The sendmail binary is usually available on most Linux/UNIX systems. If sendmail is not available then SMTP should be used.
SMTP: Mail is delivered through an SMTP server. At the minimum, the hostname of the SMTP server and the port used (default/standard is 25) must be specified. Hint: check the SMTP settings in your E-mail application.
Administrator E-mail settings
Modify "AdminEmail=nospam@ez.no" by changing "nospam@ez.no" to the E-mail address of the site administrator.
Regional settings
Under the [RegionalSettings] section, modify the "Locale=eng-GB" setting if the desired primary language of the site is not U.K. English. Refer to the share/locale directory in your Exponential installation for a list of possible primary languages. In addition, you'll also need to set the "ContentObjectLocale" to the same as the locale.
Disabling the setup wizard
Normally, the setup wizard is initiated the first time someone attempts to browse the site. This functionality needs to be disabled (the setup wizard is not needed since configuration is done manually). Set the "CheckValidity" parameter to false.
Character set
To make Exponential handle Unicode properly, the different layers (that the character-sets use) must be configured. The database, internal locale and the default template charset need to be set. The following files (located within the settings subdirectory) contain the necessary settings:
site.ini
i18n.ini
Changes that have to be made:
File: site.ini Section: [DatabaseSettings] Parameter: Charset=utf-8
File: i18n.ini Section: [CharacterSettings] Parameter: Charset=utf-8
Translation settings in database
Exponential attempts to translate the content automatically. The primary language needs to be set within the database. The following example (two SQL commands) demonstrates how to change from British English to Norwegian:
SQL command #1: UPDATE ezcontentobject_name SET content_translation='nor-NO', real_translation='nor-NO' WHERE content_translation='eng-GB' OR real_translation='eng-GB'; SQL command #2: UPDATE ezcontentobject_attribute SET language_code='nor-NO' WHERE language_code='eng-GB';
Comments
cleandata.sql loads eng-GB content
Colin Angel
Saturday 19 March 2005 7:41:00 pm
If your siteaccess is configured for a different locale, you will get the above errors, because no content could be found for your locale.
The section in the manual above is under "Translation settings in database" is mandatory... you must run these commands (using your locale) before being able to load your user or admin sites.
Editing site.ini should be avoided
Kor Dwarshuis
Tuesday 31 August 2004 2:58:42 pm
"Overriding site.ini
If we edit directly into site.ini we might have several problems if we wish to upgrade to a new version later on. The file might be overwritten by the new install, or if we take a backup of our file first, we might loose new settings included in the newer release.
To avoid these problems we have an override system for the configuration file. In settings/override/ we create a file called site.ini.append or site.ini.append.php. You should always use site.ini.append.php and place the variables inside PHP-comments (/* and */) on a non-virtual host setup for security reasons.
All variables placed in this file would override the variables placed in the main site.ini file."
Location of modfix.sh
Gustave Stresen-Reuter
Tuesday 01 June 2004 6:46:33 pm