...
- Start License Statistics in debug mode. (See our Knowledgebase article Enabling License Statistics debug logs for troubleshooting for instructions on enabling debug mode.)
- Locate the command used to start the Apache web server in the xflicstat.log file; for example:
Wiki Markup \[2012-04-01 08:00:00\] XF_DEBUG: Starting Apache web server process: X:\licstat\apache\bin\httpd.exe \-f "X:\licstat\apache\conf\httpd.conf" \-d "X:\licstat\apache"
- Using this command, manually start the Apache web server and note any errors that occur.
Embedded MySQL server troubleshooting
If the MySQL server does not start properly the first time you start License Statistics, you may see warnings similar to the following in the xflicstat.log file:
Wiki Markup \[2012-12-12 08:00:01\] WARNING: Waiting for mysqld process to start which takes more time than usual...
This warning usually indicates there is not enough memory on the machine hosting the License Statistics installation. You can check whether this is the problem by looking at the MySQL server log file, which can be found in one of the following directories:
..\License Statistics\log\mysql.log
..\License Statistics\mysql_x86\data{color}hostname.err (for 32-bit database)
..\License Statistics\mysql_x64\data{color} hostname.err (for 64-bit database)
where hostname is the hostname of the machine where License Statistics is installed.
If you see messages similar to the following in the MySQL server log, there is an issue with the host memory:
120503 15:27:16 InnoDB: Initializing buffer pool, size = 1.5G
InnoDB: VirtualAlloc(1631846400 bytes) failed; Windows error 8
To resolve this issue, either:
- Ensure there is enough memory on the machine
- Lower the memory requirement in the config.ini file by changing the following setting to the desired value:
innodb_buffer_pool_size = 1536M