Versions Compared

Old Version 47

changes.mady.by.user Former user

Saved on

compared with

New Version 48

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download the Database Connector Standalone bundle.
  2. Unzip the database.zip file to a location of your choice. We will refer to this directory as <db-home>
  3. Install the JDBC driverDriver
  4. Choose one of these methods to start the connector:

    • Method 1: Using java in a command window
      1. Navigate to <db-home>\database-connector-2.5.x

      1. .Type java -jar database.war
    • Method 2: for Windows OS
      1. Double click the <db-home>\database-connector-2.5.x\Install-Service.bat file to install the connector as a Windows service. Click the Start-DBConnector-Service.bat to start
    the service
      1. it
    • Method 3 for *nix OS
      1. Execute the  DB Connector.sh shell script for Unix/Linux operating systems.

Method 4 for *nix OS

...


The Database Connector can also run as a service using systemd for Linux systems.

Expand
titleClick here for the details

It is possible to manage the Database Connector using systemd ‘service’ scripts.

  1. Copy the sample service file located in /bin/dbconnector.service to /etc/systemd/system
  2. Review it's contents and
  3. Make sure it is executable.

You can now use systemd to manage the dbconnector service:

  • systemctl start dbconnector.service

  • systemctl stop dbconnector.service

  • systemctl restart dbconnector.service

  • systemctl status dbconnector.service

To flag the service to start automatically on system boot use the following command:

Code Block
systemctl enable dbconnector.service

Consult the service unit configuration man page for more details.

  1. Test the connector installation by copying this URL directly into your browser:

    http://localhost:8081/database/status - Note the standalone connector runs on port 8081 by default.  

  2. When the status returns Passed for each queryset, you are ready to configure the Database Connector.



  3. If the status returns failures or disabled Connector Test failed then:

    1. Review the previous installation steps
    2. See starting and testing the connector installation for more detailed instructions and common problems.

     
Expand
titleClick to see standalone bundle content details

Excerpt

The database.zip file has the following structure:

Note the files in the database-connector-2.5.x directory that are used to manage the Database Connector as services on *nix and Windows operating systems: These files should be run as an administrator.

  • Install-Service.bat - installs the Database Connector on a Windows system as a service named frevvo Database Connector.

  • Uninstall-service.bat - uninstalls the frevvo Database Connector on a Windows operating system

  • Start-DB Connector-Service.bat - starts the frevvo Database Connector on a Windows operating system

  • Start-DBConnector.sh - starts the frevvo Database Connector as a *nix console instance.

  • Restart-DBConnector-Service.bat - restarts the frevvo Database Connector on a Windows operating system

  • Restart-DBConnector.sh - restarts the frevvo Database Connector as a *nix console instance.

  • Stop-DBConnector-Service.bat - stops the frevvo Database Connector on a Windows operating system.

  • Stop-DbConnector.sh - stops the frevvo Database Connector *nix console instance.

There is another option for Linux systems. The Database Connector can also run as a service using systemd

Systemd is used by many Linux distributions.It is possible to manage the Database Connector using systemd ‘service’ scripts.

  • Copy the sample service file located in /bin/dbconnector.service to /etc/systemd/system
  • Review it's contents and
  • Make sure it is executable.

You can now use systemd to manage the dbconnector service:

  • systemctl start dbconnector.service

  • systemctl stop dbconnector.service

  • systemctl restart dbconnector.service

  • systemctl status dbconnector.service

To flag the service to start automatically on system boot use the following command:

Code Block
systemctl enable dbconnector.service

Consult the service unit configuration man page for more details

  • .

Install a JDBC Driver

The connector relies on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database.

...