== Installing ADEI on SUSE == The binaries are provided through [http://build.opensuse.org/project/show?project=home%3Acsa7fff%3Aadei SuSe Build System]. Find the repository for the installed platform and add it using your favorite packet manager. For example, execute the following command to register repository in the !OpenSuSe 11.2: {{{ zypper ar http://download.opensuse.org/repositories/home:/csa7fff:/adei/openSUSE_11.2/home:csa7fff:adei.repo }}} You will need to install at least ''adei'' and one of configuration packages ''adei-config-*''. To redirect users from the site entrance to the ADEI, please, install ''adei-webroot'' package as well. Example: {{{ zypper install adei adei-config-default adei-webroot }}} In order to update, first synchronize with the ADEI repository and then issue update command: {{{ zypper refresh home_csa7fff_adei zypper update adei }}} If you plan to use local MySQL for ADEI database, you will need to install mysql as well {{{ zypper install mysql }}} == Local repositories within FZK == * OpenSuSE 11 using 'smart' packet manager {{{ smart channel --add adei type=rpm-md name=adei baseurl="http://ipepdvadei.ka.fzk.de/binaries/suse_11/" smart update adei smart install adei }}} * OpenSuSE 11.2 using 'zypper' packet manager {{{ zypper addrepo http://ipepdvadei.ka.fzk.de/binaries/suse_11.2/ adei zypper refresh adei zypper install adei }}} == Configuration Changes == * Add '''php5 rewrite proxy mod_proxy_http''' to the list of the enabled apache modules within ''/etc/sysconfig/apache2'' (APACHE_MODULES). * Next, open ''/etc/apache2/default-server.conf'' and set both '''Options''' and '''!AllowOverride''' parameters of ''/srv/www/htdocs'' directory to '''All'''. * In ''/etc/php5/apache2/php.ini'' a '''short_open_tag''' option should be set to '''On'''. Adjust ''max_execution_time'' and ''memory_limit'' options as well if you wish. * Disable binary logging in MySQL configuration, otherwise mysql user accessing caching database would need a '''SUPER''' privilege. Read more on the topic in [http://dev.mysql.com/doc/refman/5.1/en/stored-programs-logging.html Binary Logging of Stored Programs] in the MySQL documentation. To do so, edit ''/etc/my.cnf'' and comment lines defining '''log-bin''' and '''binlog_format'''. * After making changes to configuration files the mysql and apache servers should be restarted in order to reread configuration. * Finally, configure ''Apache'' and ''MySQL 5'' services to run during the start-up. Create MySQL account with full permissions to manage the ''adei'' database. Configure this account and the database in ''config.actual.php'' in the root of ADEI installation. Creating MySQL account: {{{ CREATE USER 'adei'@'localhost' IDENTIFIED BY 'adei'; GRANT USAGE ON *.* TO 'adei'@'localhost'; GRANT ALL PRIVILEGES ON `adei`.* TO 'adei'@'localhost'; }}} == Additional Packages == * phpMyAdmin - MySQL administration (available under http://localhost/phpMyAdmin) {{{ zypper ar http://download.opensuse.org/repositories/server:/php:/applications/openSUSE_11.2/server:php:applications.repo zypper install phpMyAdmin }}} creating initial administrative account {{{ CREATE USER 'admin'@'localhost' IDENTIFIED BY 'pass'; GRANT ALL ON *.* TO 'admin'@'localhost' WITH GRANT OPTION; }}}