Integrating Aware IM with MySQL database
If you do not have MySQL database software you can download one free of charge from the MySQL web site at https://dev.mysql.com/downloads. Run MySQL installation program and follow the instructions (see MySQL Installation Guide for details). We recommend that you install MySQL as a Windows service. Once the installation has been completed make sure that MySQL is running and perform the integration steps described below.
- Start the Aware IM Control Panel
- Select the Settings/Database menu item and select MySQL as the database engine
- Enter credentials of the MySQL account. Note that the account you specify here must have root user privileges, otherwise Aware IM will not work
- Specify MySQL server name and the port number where MySQL listens to requests (if these are different from the default values)
- Click OK and restart Aware IM
If you installed Aware IM as Windows service you can perform database integration manually without using the Aware IM Control Panel. To do this:
- Delete the default
AwareIM/bin/BASServer.props
file which contains default database settings - Rename the file
BASServerMySQL.props
toBASServer.props
- Use any text editor to change server name, port and root user credentials to the following lines in the
BASServer.props
file:
DriverURL=jdbc:mysql://localhost/BASDB?user=root&password=blah DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root&password=blah BootstrapURL=jdbc:mysql://localhost/?user=root&password=blah