Template:OXConfiguration

Open-Xchange configuration

To avoid confusion right at the start notice that Open-Xchange uses multiple administration levels and requires different credentials at some stages at the installation and server management. Note that the passwords chosen at this guide are weak and should be replaced by stronger passwords.

• The MySQL database user
  • Username: openexchange
  • Password used at this guide: db_password
  • Responsibility: Execute all kinds of database operations
• The Open-Xchange Admin Master
  • Username: oxadminmaster
  • Password used at this guide: admin_master_password
  • Responsibility: Manage contexts, manage all kinds of low level server configuration
• The Context Admin
  • Username: oxadmin
  • Password used at this guide: admin_password
  • Responsibility: Manage users/groups/resources inside a context

In order to setup the Open-Xchange Server it is mandatory to have the database running:

$ {{{mysqlstart}}}

Note: in case of a distributed setup, it is recommended to start mysql with --skip-name-resolve or to add all hosts to the hosts file of the database server so that slow DNS responses do not slow down the creation of new database connections.
In a distributed setup you should also take care of the fact that Open-Xchange supports only a Statement Based Replication at the moment (http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html). See also Load_balancing_and_clustering

a good idea is to add the Open-Xchange binaries to PATH:

$  echo PATH=$PATH:/opt/open-xchange/sbin/ >> ~/.bashrc && . ~/.bashrc

Now we have to initialize the Open-Xchange configdb database. This can all be done by executing the initconfigdb script.

$ /opt/open-xchange/sbin/initconfigdb --configdb-pass=db_password -a

Add the -i option if you want to remove an already existing open-xchange configdb.

Note: The -a parameter adds an administrative account to mysql, this administrative account is required for the creation of the oxdatabase database, you may find problems following the instructions of this tutorial if you either set a mysql root password or do not create this administrative account, if you have manually setup this administrative account, grant the permissions for database creation or you may find a problem in the context creation.

Before starting any service, all basic configuration files need to be set up correctly. The --configdb-pass option indicates the password of the openexchange database user previously created, the --master-pass options specifies the password of the Open-Xchange adminmaster user that will be created when executing the oxinstaller script.

Now is a good time to configure the way OX will authenticate to your mail server. Edit the file /opt/open-xchange/etc/groupware/mail.properties and change the com.openexchange.mail.loginSource to use. This is very important for servers that require your full email address to log in with.