Would you like to...

Print this page

Email this page

Post a comment

Subscribe me

del.icio.us

Digg it

Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (3 votes)

100% 0%

---

How would you rate this answer?

Helpful

Not helpful Help us improve. Why was this unhelpful?

Thank you for rating this answer.

Last Updated: 07th November 2011 08:54:45 am

License Statistics can work with an external MySQL database. The minimal supported version is MySQL 5.1. To use an external database with License Statistics:

1. Create the database. For example, type the following in the MySQL console:

mysql> CREATE DATABASE database_name;

2. Edit or replace your existing mysqld configuration file with the MySQL config.ini file included in the License Statistics distribution. These settings are important for performance, because the default mysqld configuration file is not configured for the high volume of data License Statistics pushes through the database.

3. Edit the following settings in the configuration file xflicstat.cfg:

MYSQL_SERVER: MySQL server name or IP address
MYSQL_PORT: 3306 (default)
MYSQL_USERNAME: Username for the account created in the License Statistics database
MYSQL_PASSWORD: Password for the account created in the License Statistics database
MYSQL_DATABASE: Name of database created for License Statistics