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
Example of grn_initialize.log (for Linux)
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
1: After the initialization is completed, this line indicates how much time the process took.

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).

Steps:
  1. Stop the Web server service.

  2. Stop Garoon services.

    For details, refer to the Stopping Services section.

  3. 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

  4. Edit the configuration file to change the setting values.

  5. Start Garoon services.

    For details, refer to the Starting Services section.

  6. 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".

If the Amount of Installed Memory Is 80 GB or Less
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
If the Amount of Installed Memory Is 128 GB or More
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.