Step 3. Install and Configure a Relational DataBase Manager
DataWise® Environmental Monitoring, Inc. prefers the use of the MySQL (or MariaDB) relational database. Non-MySQL databases can be used but their installation is not covered here. Instructions for downloading and installing MySQL can be found at https://dev.mysql.com/downloads/ and for MariaDB, at https://mariadb.com/kb/en/installing-mariadb-msi-packages-on-windows/. For either database server, a 32-bit ODBC connector must be downloaded and installed. Currently, DataWise® Environmental Monitoring, Inc. personnel find that downloads from MariaDB to be somewhat easier to use than MySQL downloads.


To Install the MariaDB

• Create a directory in which to install the software. This example will use C:\MariaDB although any directory can be used.
• Download the above referenced installer package. It should have a name starting with mariadb with a .msi extension.
• Execute the downloaded installer package. Select the C:\MariaDB directory for installation. Set the password to "datawise" or whatever is prefered. Remember it.
• Check the enable access from remote machines "check box" if that funcionality is desired.
• Make sure the "Install as service" checkbox is checked.
• Make sure the "Enable networking" checkbox is checked.
• Make sure the TCP port is set to 3306 unless there is some need to use another port.
• Download and install the 32-bit ODBC connector from https://mariadb.com/downloads/connectors/.
• Create an empty database in one of two ways
  1. Perform the following steps from a DOS command window:
     Type "cd \MariaDB\bin"
     Type "mysql -u root -p"
     You will be asked for the password. Enter "datawise" or whatever password was given to the root username.
     Type "create database datawise ;"
     Type "bye ;"
     
  2. Download adminer.php from www.adminer.org/.
     Place the file adminer.php in \Apache24\htdocs
     From a browser, bring up the URL http://localhost/adminer.php (or equivalent)
     Connect to the RDB using the table name "mysql"
     Click on the "SQL Command" link and enter the command "create database datawise ;"
     
• Create an ODBC Connection Point to the Newly Created Database by performing the following steps. Note that the DataWise® executables currently require a 32-bit ODBC connector.
  1. Create a shortcut to "\Windows\SysWOW64\odbcad32.exe".
  2. Execute the above referenced odbcad32.exe with administrative rights.
  3. Select the "System DSN" tab.
  4. Click "Add".
  5. Select the MySQL ODBC Driver and click on the "Finish" button.
  6. Enter the "Data Source Name" which will be how the database created above will be referenced. Most likely "datawise".
  7. Enter a description
  8. Leave the TCP/IP Server button checked and insure that the Port is 3306.
  9. Enter the User and Password fields (most likely root and datawise).
  10. Select the newly created database from the drop-down list.
  11. Click the "Test" button. If a successful connection has been made, click on OK.
  
  

Previous  Next