Check database connections

After you install B2Bi it is a good practice to verify your database connectivity.

The B2Bi database connection parameters can be modified by running the installer in "configure" mode and making changes parameters there.

Warning: The B2Bi database must allow a minimum of 800 "maximum connections".

B2Bi database

The B2Bi database is used to read and write data.

If you deploy B2Bi in a cluster of multiple computers, all instances of B2Bi use the same database.

The B2Bi database driver and connection information is stored in a file named datastoreconfig.xml. By default, this file is located in the directory <B2Bi_install_directory>\Interchange\conf.

To change the information in this file, run the B2Bi installer in configure mode and make changes on the database connection page.

PassPort database

Database driver and connection information for PassPort is in a file named datastoreconfig.xml in <Passport_install_directory>\conf.

To view or change the information in this file, use the database configuration tool, located in <PassPort_install_directory>\bin. This tool is named dbConfig.cmd in Windows installations, and dbConfig in UNIX installations.

Note   The PassPort database password is encrypted in datastoreconfig.xml, so you must use the tool to change the password. You cannot manually edit datastoreconfig.xml to change the password.

Run dbConfig for PassPort

Windows

To run dbConfig on Windows machines.

From the Start menu

  1. Stop the server.
  2. Start the tool:
    • PassPort database: Select Start > Programs > Axway Software > Axway > PassPort > DB Configuration
  3. The software opens the Datastore Configurator page.
  4. From the Datastore Configurator page, click Test Connection.
  5. If the connection is correct, a confirmation field is displayed.

From the installation folder

  1. Stop the server.
  2. Locate the tool:
    • PassPort server: Go to <PassPort_install_directory>\bin and click dbConfig.cmd.
  3. The software opens the Datastore Configurator screen.
  4. From the Datastore Configurator screen click Test Connection.
  5. If the connection is correct, a confirmation field is displayed.

From the command line

  1. Using the cd command, go to: <PassPort_install_directory>\bin
  2. Execute the command dbConfig.cmd
  3. Test the connection and if necessary change the details.
  4. Save.

Unix / Linux

  1. Stop the PassPort server.
  2. Using the cd command, go to: PassPort_install_directory>\bin
  3. Execute the command ./dbConfig
  4. If necessary modify connection details.
  5. Save.

Related Links