Versions Compared

Old Version 9

changes.mady.by.user Mark Unwin

Saved on

compared with

New Version 10

changes.mady.by.user Oscar Berlanga

Saved on

Key

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

Table of Contents

Introduction

As at 1.12.8 we have introduced the Connections endpoint.

NOTE - Page under revision for v2.0.

How Does it Work?

 

This endpoint enables you to add the connections that are part of your network infrastructure, it allows you to customize a variety of attributes, specify where this connection is located and the organization that it belongs.

Creating a Connection

A connection can be created using the web interface if a user has a role that contains the connection::create permission. Go to menu: Manage -> Resources -> Connections -> Create . There is also a create button on the collection pageConnection. Also can be created from the Connection View, using the "Create" button.

View Connection Details

Go to menu -> Admin : Manage-> Connections -> List Connections.

You will see a list of connections. You can view a connection by clicking on the

...

blue view icon. You can also edit or delete the connection.

Database Schema

The schema for the database is below. It can also be found in the application is the user has database::read permission by going to menu -> Admin Manage -> Database -> List Database, then clicking on the groups table.

Code Block
themeEclipse
languagesqltext
Create Table: CREATE TABLE `connections` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `org_id` int(10) unsigned NOT NULL DEFAULT '1',
  `name` varchar(100200) NOT NULL,
  `provider` varchar(100) NOT NULL,
  `service_type` varchar(100) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `service_identifier` varchar(100) NOT NULL,
  `speed` float(7,3) NOT NULL DEFAULT '0.000',
  `location_id_a` int(10) unsigned NOT NULL DEFAULT '1',
  `location_id_b` int(10) unsigned NOT NULL DEFAULT '1',
  `system_id_a` int(10) unsigned DEFAULT NULL,
  `system_id_b` int(10) unsigned DEFAULT NULL,
  `line_number_a` varchar(100) NOT NULL,
  `line_number_b` varchar(100) NOT NULL,
  `ip_address_external_a` varchar(30) NOT NULL,
  `ip_address_external_b` varchar(30) NOT NULL,
  `ip_address_internal_a` varchar(30) NOT NULL,
  `ip_address_internal_b` varchar(30) NOT NULL,
  `edited_by` varchar(200) NOT NULL DEFAULT '',
  `edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Example Database Entry

Connections are stored in the database in the "connections" table. A typical entry will look as below. 

Code Block
themeEclipse
languagesqltext
                   id: 5
               org_id: 0
                 name: Marks Home Connection
             provider: Telstra 23
         service_type: Cable
         product_name: Bigpond Cable Ultimate
   service_identifier: 
                speed: 100.000
        location_id_a: 2
        location_id_b: 2
          system_id_a: 0
          system_id_b: 0
        line_number_a: 
        line_number_b: 
ip_address_external_a: 
ip_address_external_b: 
ip_address_internal_a: 
ip_address_internal_b:

...