Versions Compared

Old Version 1

changes.mady.by.user Unknown User (jaredg)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (jaredg)

Saved on

Key

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

...

Name

Null?

Data Type

Use

NODENAME

NOT NULL

VARCHAR2(100)

DNS host name

IPADDRESS

 

VARCHAR2(15)

IPv4 address

SITENAME

 

VARCHAR2(100)

Domain name of the node

NICKNAME

 

VARCHAR2(35)

Abstraction of the hostname with the TLD first.1

FULLNAME

 

VARCHAR2(100)

Human-friendly description of the node/site

LOCATION

 

VARCHAR2(100)

City and/or State/Province/Region for nodenode^2^

COUNTRY

 

VARCHAR2(100)

Country for node

CONTINENT

 

VARCHAR2(100)

Continent or region where node is thought to be located2located^3^

LATANDLONG

 

VARCHAR2(25)

Latitude and longitude of node

PROJECTTYPE

 

VARCHAR2(10)

Flags describing how nodes are used^4^

PINGSERVER

 

VARCHAR2(100)

URL for requesting a ping from this node to another 5

TRACESERVER

 

VARCHAR2(100)

URL for requesting a traceroute from this node to another 5

DATASERVER

 

VARCHAR2(100)

URL for retrieving PingER data from this node 5

URL

 

VARCHAR2(100)

 

URL for the home page for the institution running the node

GMT

 

VARCHAR2(10)

 

Node's time offset from GMT, not used

COMMENTS

 

VARCHAR2(4000)

 

Comments and notes on when and how the node's record was last updated ^6

APP_USER

 

VARCHAR2(20)

Windows user name of the last user to edit the node's record

CONTACTS

 

VARCHAR2(100)

Name and email address(es) of the node's maintainer(s)

PING_SIZE

 

NUMBER

Size of pings to be sent to the node - only controls SLAC's PingER install

Anchor
colnote1
colnote1
1. This field should be of the form: TLD.Rest of site domain.N# where # is a sequential number assigned to each node at a site. For non-US hosts not using their country code TLD, u8se the country code TLD at the start of the identifier and include the actual TLD in the site domain string. Examples: \

  • EDU.SLAC.STANFORD.N3 - third node at SLAC, hostname pinger.slac.stanford.edu
  • CH.CERN.N2 - second node at CERN, hostname wanmoninst1.cern.ch
  • AO.UCAN.EDU.N1 - first node at University of in Angola, hostname www.ucan.edu
    Anchor
    colnote2
    colnote2
    2. Location information is either provided by the site or is based off a geographic IP database like GeoIPTool

User interface

A user interface for the table was created in Oracle's HTML DB / Application Express and can be accessed at https://oraweb.slac.stanford.edu/apex/slacprod/f?p=123:1. Authorized users are authenticated by their SLAC Windows credentials.

...

Code Block
update nodedetails set country = 'United States, continent = 'North America'
where nodename = 'EDU.SLAC.STANFORD.N3'

It may be necessary to exit and re-launch the UI in order to get the new country and continent to appear in the list of values.