Install
From i-doit documentation
Contents |
Requirements
- Unix / Windows-based platform
- Apache web server (http://httpd.apache.org/) which we recommend or any other php compatible web server
- PHP 5.1 or higher
- mySQL 5.x
- ( SVN Client )
- General experience in web server configuration and PHP specs
Obtain the source code
Download from http://www.i-doit.org
OR
Use a SVN client to download the most recent (unstable) source code
Either use your favourite SVN client to download the source code, or try the command line client:
- www-data = your Apache-User
- username = "anon"
- password = ""
- Create necessary paths
mkdir -p /var/www/i-doit cd /var/www/i-doit
- Get the source code for our most recent version (password is empty)
svn checkout --username anon --password "" http://dev.synetics.de/svn/idoit/trunk .
- Set required directory permissions
chown -R www-data:www-data ./temp ./src/themes/default/smarty/templates_c ./src/themes/default/smarty/cache
Basic Apache configuration
Ensure that you know how to assign the PHP5 Interpreter / module to Apache Directory configurations. Here is an working example configuration:
<Directory /var/www/i-doit/> AddHandler php-script .php Action php-script /cgi-bin/php5 Options ExecCGI Indexes FollowSymLinks MultiViews AllowOverride AuthConfig Order allow,deny allow from all </Directory>
As you can see, we're using PHP5-CGI Version (since this is easier to integrate in a complex configuration with multiple PHP versions installed). You need to have mod_action activated in order to get this working. Be sure, that your PHP5 binary is accessible and executable in your cgi-bin Directory (which is declared as ScriptAlias here).
Automatic Installation
If you want to configure i-doit automatically with our installation system, you can just open your web browser and navigate to your i-doit installation. (e.g. http://your-ip/idoit/). You should arrive at our automatic Webinstaller.
Otherwise, follow the next steps, although we recommend the automatic installation!
Manual Installation
Use our integrated installer (please care, that src/config.inc.php does NOT exist yet, it will be created automatically) in order to create the databases. The installer automatically starts if there is no config.inc.php found in your /src/ directory. If you choose to use the installer you can now stop reading further. If you have any problems go to our forum [1] which is hosted in english and german.
The other possibility is to stick to the following installation procedure:
After downloading the source code, you can find recent database dumps in the 'sql'-directory. Before importing, create the databases as root:
CREATE DATABASE idoit_sys; CREATE DATABASE idoit_data;
Now import both SQL files into your mySQL database:
mysql -h db-host -P db-post -u user -p pass -D idoit_sys < \ setup/sql/idoit_system.sql mysql -h db-host -P db-post -u user -p pass -D idoit_data < \ setup/sql/idoit_data.sql
And give your database-user access rights to the databases:
GRANT ALL PRIVILEGES ON idoit_sys.* TO 'i-doit'@'%' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON idoit_data.* TO 'i-doit'@'%' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION;
If webserver and sql-server are on the same machine you may need to grant access additionally to localhost:
GRANT ALL PRIVILEGES ON idoit_sys.* TO 'i-doit'@'localhost' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON idoit_data.* TO 'i-doit'@'localhost' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION;
i-doIT is partitioned across one mandatory system database and at least one mandator database. In the system database system and language constants are stored, furthermore the global i-doIT registry and references to all available mandator databases in the table 'isys_mandator'. Let's look at one entry here:
<isys_mandator> <isys_mandator__id>1</isys_mandator__id> <isys_mandator__title>Your company name</isys_mandator__title> <isys_mandator__description>description</isys_mandator__description> <isys_mandator__dir_cache>cache_your_company</isys_mandator__dir_cache> <isys_mandator__dir_tpl>default</isys_mandator__dir_tpl> <isys_mandator__db_host>localhost</isys_mandator__db_host> <isys_mandator__db_port>3306</isys_mandator__db_port> <isys_mandator__db_name>idoit_data</isys_mandator__db_name> <isys_mandator__db_user>i-doit</isys_mandator__db_user> <isys_mandator__db_pass>we-doit</isys_mandator__db_pass> <isys_mandator__sort>1</isys_mandator__sort> <isys_mandator__default_lang_const> ISYS_LANGUAGE_GERMAN </isys_mandator__default_lang_const> <isys_mandator__default_language_short> de </isys_mandator__default_language_short> </isys_mandator>
If you want to use an english i-doIT version, use ISYS_LANGUAGE_ENGLISH for the XML-Parameter 'isys_mandator__default_lang_const' and 'en' for 'isys_mandator__default_language_short'.
These are the record information for one mandator database, configure this in order to modify mandator-specific database settings.
For more information about adding mandators or your initial one: Take a look at step three of New Mandator
Basic i-doIT configuration
Yes, and i-doIT itself also needs to be configured.
- Rename src/config_template.inc.php to src/config.inc.php
- Open it and take a look at the $g_config array.
The 'www_dir'-entry is defining which base directory to prepend to URLs. If you have i-doIT installed in /var/www/i-doit and the DocumentRoot is /var/www, you have to use /i-doit/. After that you have to configure the connection parameters for the "idoit_sys" system database:
$g_db_system = array( "host" => "localhost", "port" => 3306, "user" => "i-doit", "pass" => "we-doit", "name" => "idoit_sys" );
Additionally, some features are very time-consuming, especially, if the DBMS is located on a server in another network. Thus you must increase the maximal execution time of PHP-scripts in your php.ini (configuration setting is max_execution time).
StartUp
We hope everything has been well done so far. You can do your first test by browsing on http://your-host/i-doit/. Login with one of the following accounts:
------------------------------------------------ Username | Pass | Permissions ------------------------------------------------ admin | admin | All rights! reader | reader | Read-only editor | editor | Read and write author | author | New, read and write archivar | archivar| Read and delete ------------------------------------------------
You can change the passwords and users in the contact management.