Difference between revisions of "Template:OXConfiguration"

(Open-Xchange configuration)
(Open-Xchange configuration)
 
(5 intermediate revisions by 3 users not shown)
Line 6: Line 6:
 
** Password used at this guide: db_password
 
** Password used at this guide: db_password
 
** Responsibility: Execute all kinds of database operations
 
** Responsibility: Execute all kinds of database operations
 +
 
* The Open-Xchange Admin Master
 
* The Open-Xchange Admin Master
 
** Username: oxadminmaster
 
** Username: oxadminmaster
 
** Password used at this guide: admin_master_password
 
** Password used at this guide: admin_master_password
 
** Responsibility: Manage contexts, manage all kinds of low level server configuration
 
** Responsibility: Manage contexts, manage all kinds of low level server configuration
 +
 
* The Context Admin
 
* The Context Admin
 
** Username: oxadmin
 
** Username: oxadmin
Line 15: Line 17:
 
** Responsibility: Manage users/groups/resources inside a context
 
** Responsibility: Manage users/groups/resources inside a context
  
In order to setup the Open-Xchange Server it is mandatory to have the database running:
+
As stated above we assume the MySQL service has been installed previously, and it is running and available.
 
 
$ {{{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. <br>
 
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 http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html]). See also [http://oxpedia.org/wiki/index.php?title=Load_balancing_and_clustering Load_balancing_and_clustering]
 
  
a good idea is to add the Open-Xchange binaries to PATH:
+
A good idea is to add the Open-Xchange binaries to PATH:
  
 
  $  echo PATH=$PATH:/opt/open-xchange/sbin/ >> ~/.bashrc && . ~/.bashrc
 
  $  echo PATH=$PATH:/opt/open-xchange/sbin/ >> ~/.bashrc && . ~/.bashrc
Line 28: Line 25:
 
Now we have to initialize the Open-Xchange ''configdb'' database. This can all be done by executing the ''initconfigdb'' script.
 
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
+
  $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=db_password -a --mysql-root-passwd=root_password
 +
 
 +
Use the ''--mysql-root-passwd'' option to supply the MySQL root password as configured during database installation.
  
 
Add the ''-i'' option if you want to remove an already existing open-xchange configdb.
 
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.
+
'''Note:''' The -a parameter adds an ''openexchange'' account to MySQL. This account will be used for database connections from the OX App Suite middleware and requires [[AppSuite:DB_user_privileges|some privileges]]. You can also create that account manually [[OXLoadBalancingClustering_Database#Creating_Open-Xchange_user|during database installation / configuration]], in which case you can (should) skip the ''-a'' parameter here.
  
 
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.
 
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.
 

Latest revision as of 12:49, 5 June 2018

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

As stated above we assume the MySQL service has been installed previously, and it is running and available.

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 --mysql-root-passwd=root_password

Use the --mysql-root-passwd option to supply the MySQL root password as configured during database installation.

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

Note: The -a parameter adds an openexchange account to MySQL. This account will be used for database connections from the OX App Suite middleware and requires some privileges. You can also create that account manually during database installation / configuration, in which case you can (should) skip the -a parameter here.

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.