...
You will see a list of connections. You can view a connection by clicking on the it's ID (in green). You can also edit or delete the connection.
Example Database Entry
Connections are stored in the database in the "oa_connection" table. A typical entry will look as below.
| Code Block | ||
|---|---|---|
| ||
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: |
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 -> Database -> List, then clicking on the groups table.
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE `oa_connection` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `org_id` int(10) unsigned NOT NULL DEFAULT '1', `name` varchar(100) 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 DEFAULT CHARSET=utf8; |
Example Database Entry
Connections are stored in the database in the "oa_connection" table. A typical entry will look as below.
| Code Block | ||
|---|---|---|
| ||
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: |
API / Web Access?
You can access the /connections collection using the normal Open-AudIT JSON based API. Just like any other collection. Please see the API documentation for further details.
...