ONLYOFFICE Groups works with MySql database. Perform the following steps to be able to work with the standard configuration:
- Make sure that MySql Server 8.0 or later version is installed on your local server;
- Create a new database with the
onlyoffice
name;
- Run sql-scripts from the
build\sql\
folder
The scripts with the data (the ones with the .data.sql in their names) must be run without opening them for editing as the script size is large.
In case you do not want to use the standard configuration, you can choose your own user name, password or select a database name. Perform the following steps to do that:
- Use any text editor to create a text file and write a database connection string with the following format:
Server={ServerName};Database={DatabaseName};User ID={UserName};Password={UserPassword};Pooling=True;Character Set=utf8
The below parameters can be used (please do not use the curly brackets when substituting the actual values):
{ServerName}
- IP address or network name of the computer with the MySql Server software installed;
{DatabaseName}
- the name of the database used to save ONLYOFFICE Groups data;
{UserName}
- the account name used to connect to the database. Make sure that this account has the write access rights and permissions to add lines from the database table;
{UserPassword}
- the password for the account used to connect to the database.
- Change all the connection strings with the resulting string in the following files:
web\studio\ASC.Web.Studio\web.connections.config
build\config\TeamLabSvc.exe.config
module\ASC.Mail.Aggregator\ASC.Mail.Aggregator.CollectionService\App.config
module\ASC.Mail.Aggregator\ASC.Mail.Watchdog.Service\App.config
- Run sql-scripts from the
build\sql\
folder
The scripts with the data (the ones with the .data.sql in their names) must be run without opening them for editing as the script size is large.