Post-Installation Tasks
After Garoon is installed and initialized, perform additional tasks such as checking the log file and configuring settings on Garoon for starting its operation.
Checking the Log File
You can view the grn_initialize.log file to check whether the initialization completed successfully.
The grn_initialize.log file is stored in the following directory if Garoon was installed in the default installation directory:
- For Windows: C:\inetpub\scripts\cbgrn\
- For Linux: /var/www/cgi-bin\cbgrn
2023-08-15 14:37:15 Writing to log file:/var/www/cgi-bin/cbgrn/grn_initialize.log 2023-08-15 14:37:15 Garoon: Version 6.0.x 2023-08-15 14:37:15 Operating System: Linux (hostname) 5.14.0-284.11.1.el9_2.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Apr 12 10:45:03 EDT 2023 x86_64 2023-08-15 14:37:15 Command Line Parameters: db_admin_password='cybozu' db_user_password='cybozu' garoon_admin_password='cybozu' default_timezone='Asia/Tokyo' default_locale='ja' init_data='1' 2023-08-15 14:37:15 Starting 2023-08-15 14:37:41 Done in 26 seconds.1
Changing MySQL Settings
When your server machine has 8 GB or more memory installed, change the mysqld settings. To change the mysqld settings, edit the MySQL configuration file (my.ini or my.cnf).
-
Stop the Web server service.
-
Stop Garoon services.
For details, refer to the Stopping Services section. -
Back up the MySQL configuration file.
- If you installed MySQL bundled in the Garoon installer and installed Garoon in the default installation directory, the configuration file exists in the following directory:
- For Windows: C:\Program Files\Cybozu\mysql-5.0\etc\my.ini
- For Linux: usr/local/cybozu/mysql-5.0/etc/my.ini
- If you use your existing MySQL installation, rather than installing MySQL along with Garoon, back up the configuration file of the existing MySQL installation.
- Example of the directory in the Windows Environment: C:\ProgramData\MySQL\MySQL Server 8.0\my.ini
- Example of the directory in the Linux environment: /usr/my.cnf
- If you installed MySQL bundled in the Garoon installer and installed Garoon in the default installation directory, the configuration file exists in the following directory:
-
Edit the configuration file to change the setting values.
For details, refer to Recommended Values in the Configuration File (my.ini or my.cnf). -
Start Garoon services.
For details, refer to the Starting Services section. -
Start the Web server service.
Recommended Values in the Configuration File (my.ini or my.cnf)
Recommended values vary depending on the amount of memory installed on the server machine where MySQL is running.
Leave the default values for all items except "innodb_buffer_pool_size" and "max_connections".
Item | 8GB | 16GB | 24GB | 48GB | 80GB |
---|---|---|---|---|---|
Amount of memory consumed by Garoon | 5.2GB | 12GB | 18GB | 36GB | 60GB |
Setting values for innodb_buffer_pool_size | 4600M | 11200M | 17100M | 34600M | 57700M |
Setting values for max_connections | 50 | 50 | 50 | 50 | 100 |
Item | 128GB | 154GB | 180GB | 206GB | 232GB | 256GB |
---|---|---|---|---|---|---|
Amount of memory consumed by Garoon | 96GB | 115.5GB | 135GB | 154.5GB | 174GB | 192GB |
Setting values for innodb_buffer_pool_size | 92800M | 111400M | 130500M | 149100M | 168100M | 185300M |
Setting values for max_connections | 100 | 150 | 150 | 200 | 200 | 250 |
Configuring Anti-virus Software
When you install Garoon on the same server where anti-virus software is running, you must exclude the following directories from anti-virus scanning.
- (CGI directory)/(installation identifier)
- (document root directory)/(installation identifier)
- (installation directory)/directories under mysql-5.0, except "files" directory
In the default settings, Garoon is installed in the following directory path.
For Windows:
- C:\inetpub\scripts\cbgrn
- C:\inetpub\wwwroot\cbgrn
- Windows OS: Directories other than "files" under C:\Program Files\Cybozu\mysql-5.0
For Linux:
- /var/www/cgi-bin/cbgrn
- /var/www/html/cbgrn
- Directories other than "files" under /usr/local/cybozu/mysql-5.0
Configure Necessary Settings to Start the Operation of Garoon
Register customer information and system administrator, and configure the necessary Garoon settings before you start the operation of Garoon. For details, refer to Introduction Flow.