Updating the Rate Sheet in the COGEXO Rating Engine

Rate table update on MySQL backed database

The concepts in this guide apply for the DB2 version of the rating engine.

Data Fromat

product_code_call,description,cost,call_type

Data Upload

For the MySQL back-end, use phpMyAdmin to upload the data:

      Log in to phpMyAdmin
      Select the rate table
      Click the import tab
      Select the file that has the comma delimited values (CSV)
      Set the number of lines to skip to 1
      Select CSV radio button
      Set the delimiter to “,”
      Check the replace data with file box
      Click Go

Upon successful import, a message diplaying the number of values imported, for example:
Import has been successfully finished, 1578 queries executed.


Restarting SMTP Service on a Domino Server

Stopping and starting a Domino Server’s SMTP service

Domino Server Settings

After updating mail routing settings on a Domino Server, typically the SMTP service needs to be restarted. The best way to do this operation is from the Domino Server Console.

Domino Server SMTP start

From the Admin UI:

  1. Click the Server – Status tab and select the Server Tasks view.
  2. Click Tools – Task – Start
  3. From the list of server tasks, select SMTP Server.
  4. Click Start Task.
  5. Click Done to close the Start New Task dialog box.

From the server console:
Load SMTP

Look for diagnostic messages on the console. Allow several minutes on a busy server.

Domino Server SMTP stop

From the Admin UI:

  1. Click the Server – Status tab and select the Server Tasks view.
  2. Select SMTP Server from the list of tasks.
  3. Click Tools – Task – Stop, and then click Yes.

From the server console:
Tell SMTP quit

Look for diagnostic messages on the console. Allow several minutes on a busy server.

Domino Server SMTP restart

From the Admin UI:

  1. Click the Server – Status tab and select the Server Tasks view.
  2. Select SMTP Server from the list of tasks.
  3. Click Tools – Task – Restart, and then click Yes.

From the server console:
Restart Task SMTP

Look for diagnostic messages on the console. Allow several minutes on a busy server.

For more articles from the NewPush Managed Domino Server Team see Domino Server Support and Collaboration Services.