This is an old revision of the document!
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.propsfile which contains default database settings - Rename the file
BASServerMySQL.propstoBASServer.props - Use any text editor to change server name, port and root user credentials to the following lines in the
BASServer.propsfile:
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