Skip to content

Database

Warning

Mideye Server 4 is no longer updated, and new installations are not supported. Only existing Mideye Server 4 installations and upgrades to latest release are supported. Please use Mideye Server 6 for new installations and continued support.

Database Connection

Refer to Pre install checklist for software and hardware requirements regarding the database.

Configure the Database

After a new installation of the Mideye Server, a popup window with the text “Database Connection not properly set up” will be shown when opening Mideye Configuration Tool.

Installing or upgrading a Mideye Server requires a database account with rights to ALTER, CREATE and DELETE tables in the Mideye database.

Configure the following to complete the database connection:

  • Database Type: Select SQL Server or MySQL.
  • Database address: Enter the database hostname or IP.
  • TCP-port: The default TCP port for SQL Server is 1433. For MySQL it is 3306. This can be modified if needed.

  • Connection idle time: Default value is 10 minutes. This parameter is rarely changed.

  • User: Enter the username of the database user. This user must have alter, create and delete permissions.

  • Password: Enter the password of the database user.
  • Database name: Enter the database name. Be advised that Mideye requires a pre-configured empty database. Refer to Microsoft or CentOS documentation on how to create an empty database.
  • Domain (optional): Enter domain name if the database is part of a domain.
  • Instance(optional): If instances are used, enter the instance name. Be advised that Mideye Server will automatically use port udp/1434 when searching for databases inside an instance.

Note

On Windows, to connect to a MySQL database, the JDBC driver must be installed manually. This operation is done after installing the Mideye Server. Close the Mideye Configuration Tool (if open), and do the following:

  • Download mysql-connector.jar 5.1.49 from MySQL website.
  • Copy mysql-connector.jar to MideyeServer\lib.
  • Copy mysql-connector.jar to MideyeServer\webserver\lib.
  • Copy mysql-connector.jar to MideyeServer\webserver\webapps\ROOT\WEB-INF\lib.

Open the Mideye Configuration Tool. It should now be possible to select and use a MySQL database.

Microsoft SQL Server Express

Note

If the express version is used, TCP/IP is not enabled by default. This can be enabled from “SQL Server Configuration Manager”, submenu “SQL Server Network Configuration”. Once enabled, open properties for TCP/IP and add 1433 to ‘TCP Port” at the bottom of the window (IPAll).

Error message: can't Connect to Database

Mideye Configuration Tool will not start if a connection to the database can't be established. If the connection appears to be hanging, try closing down Mideye Configuration Tool, and take a backup of \Mideye Server\config\ DbConnection.properties, delete the file, and start Mideye Configuration Tool again.