Differences

This shows you the differences between two versions of the page.

--- docs:1100_inst_guide:0350_db_integration:0100_mysql [2023/07/29 02:17] – removed - external edit (Unknown date) 127.0.0.1
+++ docs:1100_inst_guide:0350_db_integration:0100_mysql [2025/10/29 23:57] (current) – aware_support3
@@ Line 1: / Line 1: @@
+{{tag>Index Installation Integration DB MySQL}}
+[<10>]
+===== MySQL =====
+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 AwareIM 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 AwareIM 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 AwareIM
+If you installed AwareIM as Windows service you can perform database integration manually without using the AwareIM Control Panel. To do this:
+  - Delete the default ''AwareIM/bin/BASServer.props'' file which contains default database settings
+  - Rename the file ''BASServerMySQL.props'' to ''BASServer.props''
+  - Use any text editor to change server name, port and root user credentials to the following lines in the ''BASServer.props'' file:
+<code>
+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
+</code>
+{{simplenavi>docs:1100_inst_guide:0350_db_integration:0100mysql:}}