Subversion Repositories oidplus

Compare Revisions

No changes between revisions

Regard whitespace Rev 225 → Rev 226

/trunk_oldversion/_private/_old_db_design/wip1/oiddb.htm
0,0 → 1,348
<html>
 
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
<title>OIDDB Format</title>
</head>
 
<body>
 
<h1>&quot;OIDDB/0.1&quot; <font color="red">DRAFT</font> file format description and examples</h1>
 
<p>(C) 2012 ViaThinkSoft, Daniel Marschall</p>
 
<h2>Intended purpose</h2>
 
<ul>
<li>This format describes an OID tree resp. a part of an OID
tree</li>
<li>Main purpose: Format for the OID tree viewer &quot;OID
Plus&quot; by ViaThinkSoft, which is intended for smaller
registration authorities who need a simply way to manage
their OID allocations as well as present their tree to
the public</li>
<li>Another purpose can be to create a more simple
alternative to ORS</li>
<li>Maybe the format could be globally describe OIDs as an
open and human readable format, maybe also for
interchanging informations</li>
</ul>
 
<h2>Use cases</h2>
 
<ul>
<li>Easily administrate, delegate and display the tree for a
specific RA</li>
<li>Look up an OID by identifier, unicode label (like ORS) or
by numerical value =&gt; Alternative to ORS</li>
</ul>
 
<h2>Advantages</h2>
 
<ul>
<li>Highly scaleable: No database needed. The &quot;zones&quot;
are working fine just with textfiles, but dynamic
generated records are also OK!</li>
<li>Node can be delegated, which makes this format also
suitable as an alternative to the complex ORS</li>
<li>Format can be extended easily</li>
<li>No individual name server necessary for ORS functionality</li>
<li>HTTPS connections are no problem</li>
<li>File can be easily filtered by &quot;grep&quot; because
every line contains just 1 attribute and contains the OID
&quot;zone&quot;</li>
<li>Simplyness: The main format is simply: &lt;root zone&gt;
&lt;attribute&gt; &lt;params&gt;</li>
</ul>
 
<h2>Disadvantages</h2>
 
<ul>
<li>The FORMAT itself allows also illegal labels etc. The OID
viewer has to check all data for validity</li>
</ul>
 
<h2>Format</h2>
 
<ul>
<li>Each zone file begins with &quot;[OIDDB/0.1]&quot; in the
first line.</li>
<li>Whitespaces at the beginning or end of every line (except
first line) are tolerated</li>
<li>Every line contains either '#' (comment line) or a &lt;zone
record&gt;</li>
<li>Comments cannot be in the same line as a zone record!
They need an separate line.</li>
<li>&lt;zone record&gt; is defined as &lt;zone&gt; &lt;attribute&gt;
&lt;parameters&gt;</li>
<li>&lt;zone&gt; is either an dot-notation OID or &quot;root&quot;
(root is the &quot;zone&quot; which delegates the OIDS 0,
1 and 2).</li>
<li>&lt;attribute&gt; is an attribute in uppercase (see below
for valid attributes and their &lt;parameters&gt;)</li>
<li>Between zone, attribute and parameters there are
whitespaces (but no line break)</li>
<li>If an attribute is unknown by the client, it will be
simply ignored</li>
</ul>
 
<h2>Current list of attributes</h2>
 
<table border="2">
<tr>
<td><strong>Attribute</strong></td>
<td><strong>Inherited from parent</strong></td>
<td><strong>Scope [1]</strong></td>
<td><strong>Parameters</strong></td>
<td><strong>Comments</strong></td>
</tr>
<tr>
<td>SOA (valid for all NIDs)</td>
<td>No</td>
<td>LOCAL RA</td>
<td>None</td>
<td>Place holder if no delegations or attributes are available for this object.</td>
</tr>
<tr>
<td>RA</td>
<td>If not set [3]</td>
<td>LOCAL RA</td>
<td>&quot;&lt;RA contact information, human-readable, '\n'
allowed&gt;&quot;</td>
<td>[7]</td>
</tr>
<tr>
<td>NAME</td>
<td>No</td>
<td>LOCAL RA</td>
<td>&quot;&lt;Single line name resp very short
description&gt;&quot;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>DESCRIPTION</td>
<td>No</td>
<td>LOCAL RA</td>
<td>&quot;&lt;Description and additional information,
human-readable, '\n' allowed&gt;&quot;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>DELEGATION</td>
<td>No</td>
<td>LOCAL RA</td>
<td>&lt;numeric child identifier&gt; &lt;zone file
location [2]&gt;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>PRIVATECHILD</td>
<td>No</td>
<td>LOCAL RA</td>
<td>&lt;numeric child identifier&gt;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>NUMSECRETCHILDREN</td>
<td>No</td>
<td>LOCAL RA</td>
<td>&lt;number of childnodes which are NOT listed as
CHILD or PRIVATECHILD (i.e. their numerical values are
secret)&gt;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>IDENTIFIER</td>
<td>No</td>
<td>SUPERIOR RA</td>
<td>&lt;identifier value, e.g. example&gt; &lt;numeric
child identifier, e.g. 999&gt;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>UNICODELABEL</td>
<td>No</td>
<td>SUPERIOR RA</td>
<td>&lt;Unicode label, e.g. ViaThinkSoft&gt; &lt;numeric
child identifier, e.g. 12345&gt;</td>
<td>[4]</td>
</tr>
<tr>
<td>FLAG-DRAFT</td>
<td>Yes, cannot be unset</td>
<td>SUPERIOR RA</td>
<td>&lt;numeric child identifier&gt;</td>
<td>[5]</td>
</tr>
<tr>
<td>FLAG-LEAF</td>
<td>Yes, cannot be unset</td>
<td>SUPERIOR RA</td>
<td>&lt;numeric child identifier&gt;</td>
<td>[6]</td>
</tr>
</table>
 
<p>Remarks:</p>
 
<ol>
<li>Defines who may change the attribute for a given OID<br>
LOCAL = (Attributes the local RA can change by itself)<br>
SUPERIOR RA = (Attributes only the superior RA can change)</li>
<li>Zone location. There are 3 possibilities:<br>
A) URL where the zone informations of the child are
stored.<br>
<font color="#FF8000">?? should local file references be
accepted ???</font><br>
Relative urls shall be accepted.<br>
Please note: IDNs (Unicode domain name which needs to be
translated into punycode first) shall be accepted by the
client.<br>
FTP URLs shall be accepted.<br>
HTTPS MUST be accepted by the client. Only with HTTPS,
informations can be ensured authorative.<br>
Also note that the URL can be a simple TXT file or a PHP
script which generates the record files from a database
etc. This makes delegation pretty flexible.<br>
B) &quot;&lt;here&gt;&quot; (without quotes), if the zone
informations are stored in the same file<br>
C) &quot;&lt;none&gt;&quot; (without quotes) if no zone
exists yet resp. if the child is a leaf node. But if you want to set a RA, description or name, you have to create a zone for this OID, since the superior OID cannot define these attributes.</li>
<li>If the RA attribute is NOT set locally, it will be
INHERITED from the superior OID! This makes it very easy
for companies who have many OIDs. They only need to
change the RA for children they delegate to another
person/department.</li>
<li>It could be also an longarc definition, e.g. &quot;root
UNICODELABEL Example 2.999&quot;</li>
<li>(Idea by Daniel Marschall) This indicates that the OID is
a draft resp reserved. It can be removed or changed at
ANY TIME. An OID viewer/resolver SHOULD NOT DISPLAY DRAFT-OIDS.
THESE ENTRIES ARE USUALLY PRIVATE FOR THE OID RA, e.g.
when they draft some new software which is needing an
amount of OIDs. An draft OID usually just reserves the
OID from accidently getting overwritten by another OID.</li>
<li>(Like seen at oid-info.com) This indicates that the OID
is a leaf. A parser will stop searching for children,
resp. children are locked</li>
<li>Note that since the TXT file is publicly available
through HTTP(S), the RA contact information cannot be
made private. If you'd like to be private, just don't
enter your address. You can also e.g. publish a handle
number which can be used to contact you resp. a URL to an
online contact form.</li>
</ol>
 
<h2>EXAMPLE 1: USING OID PLUS FOR MANAGING THE WHOLE OID TREE AS
AN ALTERNATIVE FOR ORS</h2>
 
<p>Making ORS easier would mean:</p>
 
<ul>
<li>People without an own nameserver could implement ORS (note
that nearly no public available DNS hosting company
allows customers to create NAPTR records!)</li>
<li>The easier, the faster it is implemented world wide</li>
</ul>
 
<p>In our example of an ORS-alternative, the resolution would start at https://root.ors.example.com/ with the entry "root". It does not matter if the first arc you want to resolve is an numeric identifier, or an alpha identifier or an non-numeric Unicode label.</p>
 
<pre><strong>[OIDDB/0.1]</strong>
 
<font color="#000080"># -------------------------
# ROOT ZONE FILE WHICH DEFINES THE ATTRIBUTES OF THE OIDS 0, 1 AND 2 AS WELL AS LONGARCS
# -------------------------</font>
 
oid: UNICODELABEL ISO 0
oid: IDENTIFIER iso 0
oid: DELEGATION 0 https://iso.example.com/zone_record.php?oid=0
 
oid: IDENTIFIER itu-t 1
oid: IDENTIFIER itu-r 1
oid: IDENTIFIER ccitt 1
oid: DELEGATION 1 https://itu.example.com/zone_1.txt
 
oid: IDENTIFIER joint-iso-itu-t 2
oid: IDENTIFIER joint-iso-ccitt 2
oid: DELEGATION 2 &lt;here&gt;
 
<font color="#000080"># Longarcs</font>
oid: UNICODELABEL Example 2.999
 
<font color="#000080"># -------------------------
# ZONE FILE FOR OID &quot;2&quot;
# -------------------------</font>
 
oid:2 RA &quot;RA information about Joint ISO/ITU-T&quot;
oid:2 DELEGATION 999 &lt;here&gt;
oid:2 FLAG-LEAF 999
 
<font color="#000080"># -------------------------
# ZONE FILE FOR OID &quot;2.999&quot;
# -------------------------</font>
 
oid:2.999 RA &quot;None&quot;
oid:2.999 NAME &quot;Example OID&quot;
oid:2.999 DESCRIPTION &quot;This OID is used as example&quot;</pre>
 
<h2>EXAMPLE 2: HOW A SMALL COMPANY WHICH OWNS THE OID 2.999.1.2.3
COULD MANAGE ITS OID TREE WITH A SINGLE TXT FILE</h2>
 
<p>They simply create this text file and tell &quot;OID Plus&quot;
to use this textfile as root for displaying/querying everything.
Also, the root OIDs have to be specified (2.999.1.2.3)</p>
 
<pre><strong>[OIDDB/0.1]</strong>
 
<font color="#000080"># -------------------------
# ZONE 2.999.1.2.3</font>
<font color="#000080"># -------------------------
</font>
oid:2.999.1.2.3 RA &quot;My company&quot;
oid:2.999.1.2.3 NAME &quot;My company Root OID&quot;
oid:2.999.1.2.3 DESCRIPTION &quot;This is the OID 2.999.1.2.3 owned by My Company!&quot;
oid:2.999.1.2.3 IDENTIFIER four 4
oid:2.999.1.2.3 IDENTIFIER vier 4
oid:2.999.1.2.3 IDENTIFIER quattro 4
oid:2.999.1.2.3 UNICODELABEL FOUR 4
oid:2.999.1.2.3 UNICODELABEL VIER 4
oid:2.999.1.2.3 UNICODELABEL QUATTRO 4
oid:2.999.1.2.3 DELEGATION 4 &lt;here&gt;
oid:2.999.1.2.3 FLAG-LEAF 4
oid:2.999.1.2.3 FLAG-DRAFT 4
 
oid:2.999.1.2.3 PRIVATECHILD 5
oid:2.999.1.2.3 PRIVATECHILD 6
oid:2.999.1.2.3 PRIVATECHILD 7
 
<font color="#000080"># There are 100 secret children, 3 private children (id 5, 6 and 7) and 1 public child (id 4), so 2.999.1.2.3 has 104 child nodes in total</font>
oid:2.999.1.2.3 NUMSECRETCHILDREN 100
 
<font color="#000080"># -------------------------
# ZONE 2.999.1.2.3.4</font>
<font color="#000080"># -------------------------
</font>
oid:2.999.1.2.3.4 NAME &quot;Cup of tea&quot;
oid:2.999.1.2.3.4 DESCRIPTION &quot;This is the OID 2.999.1.2.3.4!&quot;</pre>
 
<p>Beside "oid" there could be also other NIDs like e.g. "clsid" or "doi" which can be also delegated.
Note that the attribute IDs, e.g. unicodelabel are dependent to the NID oid, e.g. the attribute "unicodelabel"
should behave different on a oid than for a clsid.</p>
 
<h2>More ideas / TODO</h2>
 
<ul>
<li>Add more attributes. Research more use cases</li>
<li>Implement client &quot;OID Plus&quot; with real-world
example &quot;ViaThinkSoft RA&quot;</li>
<li>Attribute: Information how to obtain a child</li>
<li>Erweiterung um java-packagenamen auf die selbe weise zu
verwalten</li>
<li>Attributes as OIDs: vmd attribute? identified by attr-oid.
&quot;X&quot; am anfang bei fremden herstellern</li>
<li>Tool that checks the validity of everything (identifier, leaf status etc)</li>
</ul>
</body>
</html>
Property changes:
Added: svn:mime-type
+text/html
\ No newline at end of property
/trunk_oldversion/_private/_old_db_design/wip2/.volcano_db/.htaccess
0,0 → 1,2
Order Deny,Allow
Deny From All
/trunk_oldversion/_private/_old_db_design/wip2/.volcano_db/todo
0,0 → 1,6
# man müsste auch einzelne attribute durch pwd schützen können?
# z.b. ein "note" attribut
# read-auth, note-read-auth, write-auth :-s
 
# FITLER: kommentare filtern!
 
/trunk_oldversion/_private/_old_db_design/wip2/.volcano_db/viathinksoft
0,0 → 1,231
# VIATHINKSOFT CODENAME VOLCANO
# TEST DATABASE
# !!! PROVIDED DATA IS NOT AUTHORATIVE !!!
# !!! CONFIDENTIAL !!!
 
# TODO: oid:.1.3.6 ?
 
# TODO: irgendwie mit vmd merged?
# TODO: attribute irgendwie einzigartig machen? packagename/oid?
 
# --- ViaThinkSoft OIDs ---
oid:1.3.6.1.4.1.37476 delegation 9999 <here>
oid:1.3.6.1.4.1.37476 identifier example 9999
oid:1.3.6.1.4.1.37476 unicodelabel Example 9999
 
oid:1.3.6.1.4.1.37476 delegation 1 <here>
oid:1.3.6.1.4.1.37476 delegation 2 <here>
 
oid:1.3.6.1.4.1.37476.1 identifier members
oid:1.3.6.1.4.1.37476.1 description :Members of ViaThinkSoft
 
oid:1.3.6.1.4.1.37476.2 identifier products
oid:1.3.6.1.4.1.37476.2 description :Products of ViaThinkSoft
 
oid:1.3.6.1.4.1.37476.9999 delegation 1 <here>
oid:1.3.6.1.4.1.37476.9999.1 delegation 2 <here>
oid:1.3.6.1.4.1.37476.9999.1.2 delegation 3 <here>
oid:1.3.6.1.4.1.37476.9999.1.2.3 delegation 4 <here>
oid:1.3.6.1.4.1.37476.9999.1.2.3 description :hello world
oid:1.3.6.1.4.1.37476.9999.1.2.3 description : this is a test
oid:1.3.6.1.4.1.37476.9999.1.2.3 description : another test http://www.example.com/
#oid:1.3.6.1.4.1.37476.9999.1.2.3.4 delegation 5 <here>
 
# --- ViaThinkSoft CLSIDs ---
clsid:viathinksoft delegation decoder <here>
clsid:viathinksoft.decoder delegation {0001} <here>
 
# TODO: clsid:{0001} nicht möglich?
clsid:viathinksoft.decoder.{0001} name Test CLSID
 
# --- ViaThinkSoft Package names ---
packagename:de.viathinksoft delegation example <here>
packagename:de.viathinksoft.example soa
 
# --- ViaThinkSoft DOIs ---
 
# --- ViaThinkSoft MISC ---
misc:viathinksoft delegation members
misc:viathinksoft delegation az
misc:viathinksoft.members
misc:viathinksoft.az
misc:viathinksoft.az.a.2012
 
# --- ViaThinkSoft licenses ---
licmgr:viathinksoft delegation decoder
licmgr:viathinksoft.decoder delegation vclA
licmgr:viathinksoft.decoder license GPL
 
licmgr:viathinksoft.decoder.vclA license LGPL
 
# --- ViaThinkSoft IPv4 delegations ---
 
# TODO: datumsangaben
# TODO: cahost
# TODO: revdns
 
ipv4:de.viathinksoft delegation alpha
ipv4:de.viathinksoft.alpha status cancelled
 
ipv4:de.viathinksoft.alpha delegation 84.16.234.13
ipv4:de.viathinksoft.alpha.84.16.234.13 status cancelled
ipv4:de.viathinksoft.alpha.84.16.234.13 if eth0
ipv4:de.viathinksoft.alpha.84.16.234.13 type ipv4
ipv4:de.viathinksoft.alpha.84.16.234.13 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.234.13 network 84.16.234.0
ipv4:de.viathinksoft.alpha.84.16.234.13 network-cidr 84.16.234.0/24
ipv4:de.viathinksoft.alpha.84.16.234.13 broadcast 84.16.234.255
ipv4:de.viathinksoft.alpha.84.16.234.13 gateway 84.16.234.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 217.20.116.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 217.20.115.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 62.80.2.35
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 213.221.110.235
ipv4:de.viathinksoft.alpha.84.16.234.13 service www
ipv4:de.viathinksoft.alpha.84.16.234.13 service mail
 
ipv4:de.viathinksoft.alpha delegation 84.16.228.116
ipv4:de.viathinksoft.alpha.84.16.228.116 status cancelled
ipv4:de.viathinksoft.alpha.84.16.228.116 if eth0:0
ipv4:de.viathinksoft.alpha.84.16.228.116 type ipv4
ipv4:de.viathinksoft.alpha.84.16.228.116 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.228.116 network 84.16.228.0
ipv4:de.viathinksoft.alpha.84.16.228.116 network-cidr 84.16.228.0/24
ipv4:de.viathinksoft.alpha.84.16.228.116 broadcast 84.16.228.255
ipv4:de.viathinksoft.alpha.84.16.228.116 service ssh
ipv4:de.viathinksoft.alpha.84.16.228.116 service ftp
ipv4:de.viathinksoft.alpha.84.16.228.116 service www
 
ipv4:de.viathinksoft.alpha delegation 84.16.228.117
ipv4:de.viathinksoft.alpha.84.16.228.117 status cancelled
ipv4:de.viathinksoft.alpha.84.16.228.117 if eth0:1
ipv4:de.viathinksoft.alpha.84.16.228.117 type ipv4
ipv4:de.viathinksoft.alpha.84.16.228.117 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.228.117 network 84.16.228.0
ipv4:de.viathinksoft.alpha.84.16.228.117 network-cidr 84.16.228.0/24
ipv4:de.viathinksoft.alpha.84.16.228.117 broadcast 84.16.228.255
ipv4:de.viathinksoft.alpha.84.16.228.117 service www
 
ipv4:de.viathinksoft delegation beta
ipv4:de.viathinksoft.beta status cancelled
 
ipv4:de.viathinksoft.beta delegation 89.149.253.178
ipv4:de.viathinksoft.beta.89.149.253.178 status cancelled
ipv4:de.viathinksoft.beta.89.149.253.178 if eth1
ipv4:de.viathinksoft.beta.89.149.253.178 type ipv4
ipv4:de.viathinksoft.beta.89.149.253.178 netmask 255.255.255.0
ipv4:de.viathinksoft.beta.89.149.253.178 network 89.149.253.0
ipv4:de.viathinksoft.beta.89.149.253.178 network-cidr 89.149.253.0/24
ipv4:de.viathinksoft.beta.89.149.253.178 broadcast 89.149.253.255
ipv4:de.viathinksoft.beta.89.149.253.178 gateway 89.149.253.1
ipv4:de.viathinksoft.beta.89.149.253.178 dns-nameserver 217.20.116.1
ipv4:de.viathinksoft.beta.89.149.253.178 dns-nameserver 217.20.115.1
ipv4:de.viathinksoft.beta.89.149.253.178 service www
ipv4:de.viathinksoft.beta.89.149.253.178 service ftp
ipv4:de.viathinksoft.beta.89.149.253.178 service ssh
ipv4:de.viathinksoft.beta.89.149.253.178 service mail
 
ipv4:de.viathinksoft delegation gamma
ipv4:de.viathinksoft.gamma status active
 
ipv4:de.viathinksoft.gamma delegation 95.211.38.42
ipv4:de.viathinksoft.gamma.95.211.38.42 status active
ipv4:de.viathinksoft.gamma.95.211.38.42 if eth0
ipv4:de.viathinksoft.gamma.95.211.38.42 type ipv4
ipv4:de.viathinksoft.gamma.95.211.38.42 netmask 255.255.255.224
ipv4:de.viathinksoft.gamma.95.211.38.42 network 95.211.38.32
ipv4:de.viathinksoft.gamma.95.211.38.42 network-cidr 95.211.38.32/27
ipv4:de.viathinksoft.gamma.95.211.38.42 broadcast 95.211.38.63
ipv4:de.viathinksoft.gamma.95.211.38.42 gateway 95.211.38.62
ipv4:de.viathinksoft.gamma.95.211.38.42 dns-nameserver 62.212.65.123
ipv4:de.viathinksoft.gamma.95.211.38.42 dns-nameserver 62.212.64.122
ipv4:de.viathinksoft.gamma.95.211.38.42 revdns viathinksoft.de
ipv4:de.viathinksoft.gamma.95.211.38.42 service www
ipv4:de.viathinksoft.gamma.95.211.38.42 service mail
 
ipv4:de.viathinksoft.gamma delegation 95.211.38.108
ipv4:de.viathinksoft.gamma.95.211.38.108 status active
ipv4:de.viathinksoft.gamma.95.211.38.108 confidential
ipv4:de.viathinksoft.gamma.95.211.38.108 network-cidr 95.211.38.96/27
ipv4:de.viathinksoft.gamma.95.211.38.108 if eth0:1
ipv4:de.viathinksoft.gamma.95.211.38.108 type ipv4
ipv4:de.viathinksoft.gamma.95.211.38.108 netmask 255.255.255.224
ipv4:de.viathinksoft.gamma.95.211.38.108 network 95.211.38.96
ipv4:de.viathinksoft.gamma.95.211.38.108 broadcast 95.211.38.127
ipv4:de.viathinksoft.gamma.95.211.38.108 gateway 95.211.38.126
ipv4:de.viathinksoft.gamma.95.211.38.108 dns-nameserver 62.212.65.123
ipv4:de.viathinksoft.gamma.95.211.38.108 dns-nameserver 62.212.64.122
# TODO: ändern?
# ipv4:de.viathinksoft.gamma.95.211.38.108 revdns ssh.viathinksoft.de
ipv4:de.viathinksoft.gamma.95.211.38.108 revdns hosted-by.leaseweb.com
ipv4:de.viathinksoft.gamma.95.211.38.108 service ssh
 
# --- ViaThinkSoft IPv6 delegations ---
 
ipv6:de.viathinksoft.gamma delegation 2001:1af8:4100:a061:1::/112
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 name ViaThinkSoft IPv6 Rack address space (in 2001:1af8:4100:a061::/64 net)
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 type ipv6-net
 
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 delegation 2001:1af8:4100:a061:1::1337/128
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 status active
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 assignment daniel-marschall@viathinksoft.de 2012-02-22
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 if eth0
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 type ipv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 netmask 64
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 gateway 2001:1af8:4100:a061::1
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 name ViaThinkSoft Main IPv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 revdns ipv6.viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 service www
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 service mail
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 cahost viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 cahost www.viathinksoft.de
 
# TODO: read/write auth... multi auth entries ...? jedes element ein anderer auth.
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 delegation 2001:1af8:4100:a061:1::4041/128
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 read-auth plain:vierzig
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 read-auth MD5:
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 status active
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 confidential
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 assignment daniel-marschall@viathinksoft.de 2012-02-26
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 if eth0
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 type ipv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 netmask 64
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 gateway 2001:1af8:4100:a061::1
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 name ViaThinkSoft Auth IPv6
# TODO: ändern?
# ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 revdns ssh.viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 service ssh
 
# --- ViaThinkSoft domain managment ---
 
# TODO uvst
# TODO: projektorientierte anordnung
 
# 1&1
domain: delegation de.viathinksoft
 
# Speedbone
domain: delegation de.personal-webbase
domain: delegation de.md-technologie
domain: delegation de.md-technology
domain: delegation com.viathinksoft
domain: delegation com.personal-webbase
 
& United Domains
domain: delegation de.gegen-killerspiele
 
# --- ViaThinkSoft CA managment ---
 
# --- ViaThinkSoft Aktenzeichen ---
 
# --- Human Resources ---
 
hr:de.viathinksoft soa
hr:de.viathinksoft delegation marschall
hr:de.viathinksoft.marschall short ma
hr:de.viathinksoft delegation vn
 
 
# TODO: <here> optional?
# TODO: problem bei nicht-präfix delegation (z.b. clsid, ipv6)
# TODO: wie informationen geheim halten?
 
/trunk_oldversion/_private/_old_db_design/wip2/filter.php
0,0 → 1,122
<?php
 
# todo: via post erhalten
$cfg_auth_passwords = array();
$cfg_auth_passwords[] = 'marie,marie';
$cfg_auth_passwords[] = 'vierzig';
$cfg_auth_passwords[] = 'johnl17';
 
if (!headers_sent()) header('Content-Type: text/plain');
echo output(__DIR__ . '/.volcano_db/*', $cfg_auth_passwords);
 
# ---
 
# todo fut: oop
function check_auth($auth_passwords, $auth_objs) {
foreach ($auth_objs as &$auth_obj) {
$auth_method = $auth_obj[0];
$auth_data = $auth_obj[1];
 
$auth_method = strtolower($auth_method);
 
foreach ($auth_passwords as $p) {
if ($auth_method == 'plain') {
if ($p == $auth_data) return true;
} else if ($auth_method == 'md5') {
if (md5($p) == strtolower($auth_data)) return true;
} else if ($auth_method == 'md5-salt') {
$auth_data_ary = explode(':', $auth_data, 2);
$auth_data_salt = $auth_data_ary[0];
$auth_data_hash = $auth_data_ary[1];
if (md5($auth_data_salt.$p) == strtolower($auth_data_hash)) return true;
} else if ($auth_method == 'sha1') {
if (sha1($p) == strtolower($auth_data)) return true;
} else if ($auth_method == 'sha1-salt') {
$auth_data_ary = explode(':', $auth_data, 2);
$auth_data_salt = $auth_data_ary[0];
$auth_data_hash = $auth_data_ary[1];
if (sha1($auth_data_salt.$p) == strtolower($auth_data_hash)) return true;
} else {
# todo exception
}
}
unset($p);
}
 
return false;
}
 
function output($wildcard, $cfg_auth_passwords = array()) {
$file = file_glob($wildcard, FILE_IGNORE_NEW_LINES);
 
$auth_array = array();
foreach ($file as &$f) {
preg_match_all('@^\s*([^:\s]+):(\S*)(\.){0,1}([^.\s]*)\s+READ-AUTH\s+([^:\s]+):(\S+)\s*$@isU', $f, $m, PREG_SET_ORDER);
 
foreach ($m as $x) {
$nid = $x[1];
$parent = $x[2];
$dot = $x[3];
$child = $x[4];
$auth_method = $x[5];
$auth_data = $x[6];
 
$regex = '';
if ($parent == '' && $child == '') {
$regex = '@^\s*'.preg_quote($nid, '@').':(.*)$@isU';
$replace = '# CONFIDENTIAL MATERIAL REDACTED DUE TO MISSING AUTHENTIFICATION';
$auth_array[$regex][$replace][] = array($auth_method, $auth_data);
} else {
$regex = '@^\s*('.preg_quote($nid, '@').':'.preg_quote($parent, '@').')\s+(DELEGATION)\s+('.preg_quote($child, '@').')(|\s+.*)$@isU';
# todo option ob man delegation pub oder nicht pub machen will
$replace = '\1 \2 ???';
$auth_array[$regex][$replace][] = array($auth_method, $auth_data);
 
$regex = '@^\s*'.preg_quote($nid, '@').':'.preg_quote($parent.$dot.$child, '@').'\s+(.*)$@isU';
$replace = '# CONFIDENTIAL MATERIAL REDACTED DUE TO MISSING AUTHENTIFICATION';
$auth_array[$regex][$replace][] = array($auth_method, $auth_data);
}
}
}
 
global $cfg_auth_passwords;
 
$forbidden_regex = array();
foreach ($auth_array as $search => &$tmp1) {
foreach ($tmp1 as $replace => &$auth_objs) {
if (!check_auth($cfg_auth_passwords, $auth_objs)) {
$forbidden_regex[$search] = $replace;
}
}
}
 
var_dump($forbidden_regex);
 
foreach ($file as &$f) {
foreach ($forbidden_regex as $search => &$replace) {
$num = 0;
$f = preg_replace($search, $replace, $f, -1, $num);
if ($num > 0) {echo '!!!'; break;}
}
}
 
return implode("\n", $file);
}
 
function file_glob($wildcard, $flags = 0, $context = null) {
$files = glob($wildcard);
sort($files);
 
$res = array();
foreach ($files as $file) {
$bn = basename($file);
if ($bn[0] == '.') continue; // ., .., or .htaccess
$res = array_merge($res, file($file, $flags, $context));
}
unset($file);
unset($files);
 
return $res;
}
 
?>
/trunk_oldversion/_private/_old_db_design/wip2/index.php
0,0 → 1,119
<?php
 
# Volcano Format
 
error_reporting(E_ALL | E_NOTICE | E_STRICT | E_DEPRECATED);
 
class VOF_Category {
public $nid;
public $localrootElement;
public $localrootFile;
public $authrootElement;
public $authrootFile;
 
public function __construct($nid, $localrootElement, $localrootFile, $authrootElement, $authrootFile) {
$this->nid = $nid;
$this->localrootElement = $localrootElement;
$this->localrootFile = $localrootFile;
$this->authrootElement = $authrootElement;
$this->authrootFile = $authrootFile;
}
}
 
$categories = array();
include __DIR__ . '/local_config.inc.php';
 
 
 
# Aufruf:
# nid, obj, route[]
print_r(show_obj('1.3.6.1.4.1.37476.9999.1.2.3.4', 'oid', array(
'1.3.6.1.4.1.37476',
'1.3.6.1.4.1.37476.9999',
'1.3.6.1.4.1.37476.9999.1',
'1.3.6.1.4.1.37476.9999.1.2',
'1.3.6.1.4.1.37476.9999.1.2.3'
)));
die();
 
 
 
$req_cat = $_GET['cat']; # todo als hash (nid, localelement)
$req_obj = $_GET['obj'];
 
if ($req_cat == '') {
// List all categories
list_nids();
} else {
// List specific object
$cat = get_cat($req_cat);
$title = $cat->nid . ' - ' . $req_obj;
echo "<h1>$title</h1>";
$localRoot = $cat->localrootElement;
}
 
function list_nids($categories) {
echo '<ul>';
foreach ($categories as $x) {
$id = cat_id($x);
$desc = $x->nid;
echo '<li><a href="?cat='.$id.'">'.$desc.'</a></li>';
}
echo '</ul>';
}
 
function cat_id($cat) {
return sha1($cat->nid.':'.$cat->localrootElement);
}
 
function get_cat($categoryId, $categories) {
foreach ($categories as $cat) {
if ($categoryId == cat_id($cat)) return $cat;
}
return false;
}
 
 
function show_obj($obj, $nid, $route) {
global $categories;
foreach ($categories as $c) {
if (($c->nid == $nid) && ($c->localrootElement == $route[0])) {
$cur_obj = $c->localrootElement;
$cur_fil = $c->localrootFile;
}
}
if (!isset($cur_obj)) return false;
if (!isset($cur_fil)) return false;
 
foreach ($route as $i => $r) {
if ($i == 0) continue;
$x = search_delegation_file($cur_fil, $nid, $cur_obj, $r);
if ($x === false) return false;
if ($x != '') $cur_file = $x;
$cur_obj = $r;
}
 
return array($cur_fil, $cur_obj);
}
 
function search_delegation_file($file, $nid, $rootobj, $childobj) {
$cont = file($file); # todo: cache
 
echo "R=$rootobj, C=$childobj => ";
if (substr($childobj.'.', 0, strlen($rootobj)+1) == $rootobj.'.') {
$childobj = substr($childobj, strlen($rootobj)+1);
}
echo "$childobj\n";
 
foreach ($cont as $c) {
preg_match_all("@^\s*$nid:$rootobj\s+delegation\s+$childobj\s*(.+)\$@", $c, $m);
if (!isset($m[1][0])) continue;
$x = $m[1][0];
$x = trim($x);
if ($x == '<here>') $x = '';
return $x;
}
return false;
}
 
?>
/trunk_oldversion/_private/_old_db_design/wip2/local_config.inc.php
0,0 → 1,6
<?php
 
$categories = array();
$categories[] = new VOF_Category('oid', '1.3.6.1.4.1.37476', __DIR__.'/viathinksoft', '', 'http://www.example.com/optional_auth_dummy');
 
?>
/trunk_oldversion/_private/_old_db_design/wip3/db
0,0 → 1,266
# VIATHINKSOFT CODENAME VOLCANO
# TEST DATABASE
# !!! PROVIDED DATA IS NOT AUTHORATIVE !!!
# !!! CONFIDENTIAL !!!
 
# TODO: feldtest, attribute auch mit oids / mergen mit vmd?
 
 
 
 
 
 
.1.3.6.1.4.1.37476 desc:ViaThinkSoft Root
 
.1.3.6.1.4.1.37476.30 identifier:oidplus
.1.3.6.1.4.1.37476.30 desc:OID+ Information Objects for ViaThinkSoft
 
.1.3.6.1.4.1.37476.30.1 type:domains
.1.3.6.1.4.1.37476.30.1 desc:Domains controlled by ViaThinkSoft
 
.1.3.6.1.4.1.37476.30.1.1 desc:Registered at prosite.de
 
.1.3.6.1.4.1.37476.30.1.1.1 desc:Account viathinksoft.com
 
.1.3.6.1.4.1.37476.30.1.1.1.1 desc:ViaThinkSoft
 
.1.3.6.1.4.1.37476.30.1.1.1.1.1 desc:viathinksoft.com
.1.3.6.1.4.1.37476.30.1.1.1.1.1 price(eur/month):1
.1.3.6.1.4.1.37476.30.1.1.1.1.1 search(str):viathinksoft.com
.1.3.6.1.4.1.37476.30.1.1.1.1.1 ssl
 
 
.1.3.6.1.4.1.37476.30.2 type:ipv4
 
 
 
2.999.0 id:IPv4 192.168.69.0/24
2.999.0.1 id:IPv4 192.168.69.1/32
 
2.999.0 desc product A
2.999.0.1 id:CLSID {abc}
2.999.0.2 id:CLSID {def}
2.999.0.2 ref whois://vts.de
 
 
 
 
 
# --- ViaThinkSoft OIDs ---
1.3.6.1.4.1.37476 delegation 9999 <here>
1.3.6.1.4.1.37476 identifier example 9999
1.3.6.1.4.1.37476 unicodelabel Example 9999
 
1.3.6.1.4.1.37476 delegation 1 <here>
1.3.6.1.4.1.37476 delegation 2 <here>
 
1.3.6.1.4.1.37476.1 identifier members
1.3.6.1.4.1.37476.1 description :Members of ViaThinkSoft
 
1.3.6.1.4.1.37476.2 identifier products
1.3.6.1.4.1.37476.2 description :Products of ViaThinkSoft
 
1.3.6.1.4.1.37476.9999 delegation 1 <here>
1.3.6.1.4.1.37476.9999.1 delegation 2 <here>
1.3.6.1.4.1.37476.9999.1.2 delegation 3 <here>
1.3.6.1.4.1.37476.9999.1.2.3 delegation 4 <here>
1.3.6.1.4.1.37476.9999.1.2.3 description :hello world
1.3.6.1.4.1.37476.9999.1.2.3 description : this is a test
1.3.6.1.4.1.37476.9999.1.2.3 description : another test http://www.example.com/
#1.3.6.1.4.1.37476.9999.1.2.3.4 delegation 5 <here>
 
# --- ViaThinkSoft CLSIDs ---
clsid:viathinksoft delegation decoder <here>
clsid:viathinksoft.decoder delegation {0001} <here>
 
# TODO: clsid:{0001} nicht möglich?
clsid:viathinksoft.decoder.{0001} name Test CLSID
 
# --- ViaThinkSoft Package names ---
packagename:de.viathinksoft delegation example <here>
packagename:de.viathinksoft.example soa
 
# --- ViaThinkSoft DOIs ---
 
# --- ViaThinkSoft MISC ---
misc:viathinksoft delegation members
misc:viathinksoft delegation az
misc:viathinksoft.members
misc:viathinksoft.az
misc:viathinksoft.az.a.2012
 
# --- ViaThinkSoft licenses ---
licmgr:viathinksoft delegation decoder
licmgr:viathinksoft.decoder delegation vclA
licmgr:viathinksoft.decoder license GPL
 
licmgr:viathinksoft.decoder.vclA license LGPL
 
# --- ViaThinkSoft IPv4 delegations ---
 
# TODO: datumsangaben
# TODO: cahost
# TODO: revdns
 
ipv4:de.viathinksoft delegation alpha
ipv4:de.viathinksoft.alpha status cancelled
 
ipv4:de.viathinksoft.alpha delegation 84.16.234.13
ipv4:de.viathinksoft.alpha.84.16.234.13 status cancelled
ipv4:de.viathinksoft.alpha.84.16.234.13 if eth0
ipv4:de.viathinksoft.alpha.84.16.234.13 type ipv4
ipv4:de.viathinksoft.alpha.84.16.234.13 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.234.13 network 84.16.234.0
ipv4:de.viathinksoft.alpha.84.16.234.13 network-cidr 84.16.234.0/24
ipv4:de.viathinksoft.alpha.84.16.234.13 broadcast 84.16.234.255
ipv4:de.viathinksoft.alpha.84.16.234.13 gateway 84.16.234.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 217.20.116.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 217.20.115.1
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 62.80.2.35
ipv4:de.viathinksoft.alpha.84.16.234.13 dns-nameserver 213.221.110.235
ipv4:de.viathinksoft.alpha.84.16.234.13 service www
ipv4:de.viathinksoft.alpha.84.16.234.13 service mail
 
ipv4:de.viathinksoft.alpha delegation 84.16.228.116
ipv4:de.viathinksoft.alpha.84.16.228.116 status cancelled
ipv4:de.viathinksoft.alpha.84.16.228.116 if eth0:0
ipv4:de.viathinksoft.alpha.84.16.228.116 type ipv4
ipv4:de.viathinksoft.alpha.84.16.228.116 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.228.116 network 84.16.228.0
ipv4:de.viathinksoft.alpha.84.16.228.116 network-cidr 84.16.228.0/24
ipv4:de.viathinksoft.alpha.84.16.228.116 broadcast 84.16.228.255
ipv4:de.viathinksoft.alpha.84.16.228.116 service ssh
ipv4:de.viathinksoft.alpha.84.16.228.116 service ftp
ipv4:de.viathinksoft.alpha.84.16.228.116 service www
 
ipv4:de.viathinksoft.alpha delegation 84.16.228.117
ipv4:de.viathinksoft.alpha.84.16.228.117 status cancelled
ipv4:de.viathinksoft.alpha.84.16.228.117 if eth0:1
ipv4:de.viathinksoft.alpha.84.16.228.117 type ipv4
ipv4:de.viathinksoft.alpha.84.16.228.117 netmask 255.255.255.0
ipv4:de.viathinksoft.alpha.84.16.228.117 network 84.16.228.0
ipv4:de.viathinksoft.alpha.84.16.228.117 network-cidr 84.16.228.0/24
ipv4:de.viathinksoft.alpha.84.16.228.117 broadcast 84.16.228.255
ipv4:de.viathinksoft.alpha.84.16.228.117 service www
 
ipv4:de.viathinksoft delegation beta
ipv4:de.viathinksoft.beta status cancelled
 
ipv4:de.viathinksoft.beta delegation 89.149.253.178
ipv4:de.viathinksoft.beta.89.149.253.178 status cancelled
ipv4:de.viathinksoft.beta.89.149.253.178 if eth1
ipv4:de.viathinksoft.beta.89.149.253.178 type ipv4
ipv4:de.viathinksoft.beta.89.149.253.178 netmask 255.255.255.0
ipv4:de.viathinksoft.beta.89.149.253.178 network 89.149.253.0
ipv4:de.viathinksoft.beta.89.149.253.178 network-cidr 89.149.253.0/24
ipv4:de.viathinksoft.beta.89.149.253.178 broadcast 89.149.253.255
ipv4:de.viathinksoft.beta.89.149.253.178 gateway 89.149.253.1
ipv4:de.viathinksoft.beta.89.149.253.178 dns-nameserver 217.20.116.1
ipv4:de.viathinksoft.beta.89.149.253.178 dns-nameserver 217.20.115.1
ipv4:de.viathinksoft.beta.89.149.253.178 service www
ipv4:de.viathinksoft.beta.89.149.253.178 service ftp
ipv4:de.viathinksoft.beta.89.149.253.178 service ssh
ipv4:de.viathinksoft.beta.89.149.253.178 service mail
 
ipv4:de.viathinksoft delegation gamma
ipv4:de.viathinksoft.gamma status active
 
ipv4:de.viathinksoft.gamma delegation 95.211.38.42
ipv4:de.viathinksoft.gamma.95.211.38.42 status active
ipv4:de.viathinksoft.gamma.95.211.38.42 if eth0
ipv4:de.viathinksoft.gamma.95.211.38.42 type ipv4
ipv4:de.viathinksoft.gamma.95.211.38.42 netmask 255.255.255.224
ipv4:de.viathinksoft.gamma.95.211.38.42 network 95.211.38.32
ipv4:de.viathinksoft.gamma.95.211.38.42 network-cidr 95.211.38.32/27
ipv4:de.viathinksoft.gamma.95.211.38.42 broadcast 95.211.38.63
ipv4:de.viathinksoft.gamma.95.211.38.42 gateway 95.211.38.62
ipv4:de.viathinksoft.gamma.95.211.38.42 dns-nameserver 62.212.65.123
ipv4:de.viathinksoft.gamma.95.211.38.42 dns-nameserver 62.212.64.122
ipv4:de.viathinksoft.gamma.95.211.38.42 revdns viathinksoft.de
ipv4:de.viathinksoft.gamma.95.211.38.42 service www
ipv4:de.viathinksoft.gamma.95.211.38.42 service mail
 
ipv4:de.viathinksoft.gamma delegation 95.211.38.108
ipv4:de.viathinksoft.gamma.95.211.38.108 status active
ipv4:de.viathinksoft.gamma.95.211.38.108 confidential
ipv4:de.viathinksoft.gamma.95.211.38.108 network-cidr 95.211.38.96/27
ipv4:de.viathinksoft.gamma.95.211.38.108 if eth0:1
ipv4:de.viathinksoft.gamma.95.211.38.108 type ipv4
ipv4:de.viathinksoft.gamma.95.211.38.108 netmask 255.255.255.224
ipv4:de.viathinksoft.gamma.95.211.38.108 network 95.211.38.96
ipv4:de.viathinksoft.gamma.95.211.38.108 broadcast 95.211.38.127
ipv4:de.viathinksoft.gamma.95.211.38.108 gateway 95.211.38.126
ipv4:de.viathinksoft.gamma.95.211.38.108 dns-nameserver 62.212.65.123
ipv4:de.viathinksoft.gamma.95.211.38.108 dns-nameserver 62.212.64.122
# TODO: ändern?
# ipv4:de.viathinksoft.gamma.95.211.38.108 revdns ssh.viathinksoft.de
ipv4:de.viathinksoft.gamma.95.211.38.108 revdns hosted-by.leaseweb.com
ipv4:de.viathinksoft.gamma.95.211.38.108 service ssh
 
# --- ViaThinkSoft IPv6 delegations ---
 
ipv6:de.viathinksoft.gamma delegation 2001:1af8:4100:a061:1::/112
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 name ViaThinkSoft IPv6 Rack address space (in 2001:1af8:4100:a061::/64 net)
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 type ipv6-net
 
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 delegation 2001:1af8:4100:a061:1::1337/128
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 status active
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 assignment daniel-marschall@viathinksoft.de 2012-02-22
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 if eth0
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 type ipv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 netmask 64
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 gateway 2001:1af8:4100:a061::1
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 name ViaThinkSoft Main IPv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 revdns ipv6.viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 service www
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 service mail
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 cahost viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::1337/128 cahost www.viathinksoft.de
 
# TODO: read/write auth... multi auth entries ...? jedes element ein anderer auth.
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112 delegation 2001:1af8:4100:a061:1::4041/128
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 read-auth plain:vierzig
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 read-auth MD5:
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 status active
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 confidential
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 assignment daniel-marschall@viathinksoft.de 2012-02-26
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 if eth0
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 type ipv6
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 netmask 64
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 gateway 2001:1af8:4100:a061::1
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 name ViaThinkSoft Auth IPv6
# TODO: ändern?
# ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 revdns ssh.viathinksoft.de
ipv6:de.viathinksoft.gamma.2001:1af8:4100:a061:1::/112.2001:1af8:4100:a061:1::4041/128 service ssh
 
# --- ViaThinkSoft domain managment ---
 
# TODO uvst
# TODO: projektorientierte anordnung
 
# 1&1
domain: delegation de.viathinksoft
 
# Speedbone
domain: delegation de.personal-webbase
domain: delegation de.md-technologie
domain: delegation de.md-technology
domain: delegation com.viathinksoft
domain: delegation com.personal-webbase
 
# --- ViaThinkSoft CA managment ---
 
# --- ViaThinkSoft Aktenzeichen ---
 
# --- Human Resources ---
 
hr:de.viathinksoft soa
hr:de.viathinksoft delegation marschall
hr:de.viathinksoft.marschall short ma
hr:de.viathinksoft delegation vn
 
 
# TODO: <here> optional?
# TODO: problem bei nicht-präfix delegation (z.b. clsid, ipv6)
# TODO: wie informationen geheim halten?
 
/trunk_oldversion/_private/_old_db_design/wip4/db
0,0 → 1,254
# VIATHINKSOFT CODENAME VOLCANO
# TEST DATABASE
# !!! PROVIDED DATA IS NOT AUTHORATIVE !!!
# !!! CONFIDENTIAL !!!
 
# TODO alles updaten und mit offiziellen VTS daten bestücken
 
# todo domain ssl datasets
 
.1.3.6.1.4.1.37476 description:ViaThinkSoft Root
 
.1.3.6.1.4.1.37476.30 identifier:oidplus
.1.3.6.1.4.1.37476.30 description:OID+ Information Objects for ViaThinkSoft
 
# --- DOMAINS
 
.1.3.6.1.4.1.37476.30.1 type:domains
.1.3.6.1.4.1.37476.30.1 description:Domains controlled by ViaThinkSoft
 
.1.3.6.1.4.1.37476.30.1.1 description:Registered at prosite.de
.1.3.6.1.4.1.37476.30.1.1.1 description:Account viathinksoft.com
.1.3.6.1.4.1.37476.30.1.1.1.1 identifier:de
.1.3.6.1.4.1.37476.30.1.1.1.1 description:Sub-identifiers are the crc32 values of the full domain name. In case of a conflict, the next free available OID is used.
.1.3.6.1.4.1.37476.30.1.1.1.1 allocation-mech:crc32(domain)/conflict=+1
.1.3.6.1.4.1.37476.30.1.1.1.2 identifier:com
.1.3.6.1.4.1.37476.30.1.1.1.2 description:Sub-identifiers are the crc32 values of the full domain name. In case of a conflict, the next free available OID is used.
.1.3.6.1.4.1.37476.30.1.1.1.2 allocation-mech:crc32(domain)/conflict=+1
 
.1.3.6.1.4.1.37476.30.1.2 description:Registered at Strato
.1.3.6.1.4.1.37476.30.1.2.1 description:Account of Michael Düpjohann
.1.3.6.1.4.1.37476.30.1.2.1.1 identifier:de
.1.3.6.1.4.1.37476.30.1.2.1.1 description:Sub-identifiers are the crc32 values of the full domain name. In case of a conflict, the next free available OID is used.
.1.3.6.1.4.1.37476.30.1.2.1.1 allocation-mech:crc32(domain)/conflict=+1
 
.1.3.6.1.4.1.37476.30.1.3 description:Registered at United Domains
.1.3.6.1.4.1.37476.30.1.3.1 description:Account of ViaThinkSoft
.1.3.6.1.4.1.37476.30.1.3.1.1 identifier:de
.1.3.6.1.4.1.37476.30.1.3.1.1 description:Sub-identifiers are the crc32 values of the full domain name. In case of a conflict, the next free available OID is used.
.1.3.6.1.4.1.37476.30.1.3.1.1 allocation-mech:crc32(domain)/conflict=+1
 
.1.3.6.1.4.1.37476.30.1.4 description:Registered at 1&1
.1.3.6.1.4.1.37476.30.1.4.1 description:Account of ViaThinkSoft
.1.3.6.1.4.1.37476.30.1.4.1.1 identifier:de
.1.3.6.1.4.1.37476.30.1.4.1.1 description:Sub-identifiers are the crc32 values of the full domain name. In case of a conflict, the next free available OID is used.
.1.3.6.1.4.1.37476.30.1.4.1.1 allocation-mech:crc32(domain)/conflict=+1
 
# --- Network (IPv4, IPv6)
 
.1.3.6.1.4.1.37476.30.2 type:network
 
# --- ViaThinkSoft OIDs ---
 
.1.3.6.1.4.1.37476.1 identifier:members
.1.3.6.1.4.1.37476.1 description:Members of ViaThinkSoft
 
.1.3.6.1.4.1.37476.2 identifier:products
.1.3.6.1.4.1.37476.2 description:Products of ViaThinkSoft
 
.1.3.6.1.4.1.37476.9999 identifier:example
.1.3.6.1.4.1.37476.9999 unicodelabel:Example
 
# --- ViaThinkSoft CLSIDs ---
 
.1.3.6.1.4.1.37476.30.3 type:clsid
 
.1.3.6.1.4.1.37476.30.3.999 identifier:example
 
.1.3.6.1.4.1.37476.30.3.999.1 identifier:myclsid
.1.3.6.1.4.1.37476.30.3.999.1 search(clsid):{0001}
 
# --- ViaThinkSoft Package names ---
#packagename:de.viathinksoft delegation example
#packagename:de.viathinksoft.example soa
 
# --- ViaThinkSoft DOIs ---
 
# --- ViaThinkSoft Package names ---
 
# --- ViaThinkSoft MISC ---
#misc:viathinksoft.members
#misc:viathinksoft.az
#misc:viathinksoft.az.a.2012
 
# --- ViaThinkSoft licenses ---
#licmgr:viathinksoft delegation decoder
#licmgr:viathinksoft.decoder license:GPL
 
#licmgr:viathinksoft.decoder.vclA license LGPL
 
# --- ViaThinkSoft IPv4 delegations ---
 
# TODO: datumsangaben
# TODO: cahost
# TODO: revdns
 
.1.3.6.1.4.1.37476.30.2.1 description:netdirekt e.K.
.1.3.6.1.4.1.37476.30.2.1.1 description:Customer ViaThinkSoft
.1.3.6.1.4.1.37476.30.2.1.1.1 description:Server Alpha
.1.3.6.1.4.1.37476.30.2.1.1.1 status:cancelled
 
.1.3.6.1.4.1.37476.30.2.1.1.1.4 identifier:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.1.4 allocation-mech:crc32(cidr)/conflict=+1
 
# TODO network cidr unterkategorie
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 cidr:84.16.234.13/32
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 status:cancelled
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 if:eth0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 type:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 netmask:255.255.255.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 network:84.16.234.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 network-cidr:84.16.234.0/24
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 broadcast:84.16.234.255
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 gateway:84.16.234.1
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 dns-nameserver:217.20.116.1
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 dns-nameserver:217.20.115.1
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 dns-nameserver:62.80.2.35
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 dns-nameserver:213.221.110.235
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 service:www
.1.3.6.1.4.1.37476.30.2.1.1.1.4.715489493 service:mail
 
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 cidr:84.16.228.116/32
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 status:cancelled
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 if:eth0:0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 type:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 netmask:255.255.255.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 network:84.16.228.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 network-cidr:84.16.228.0/24
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 broadcast:84.16.228.255
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 service:ssh
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 service:ftp
.1.3.6.1.4.1.37476.30.2.1.1.1.4.4150533370 service:www
 
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 cidr:84.16.228.117/32
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 status:cancelled
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 if:eth0:1
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 type:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 netmask:255.255.255.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 network:84.16.228.0
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 network-cidr:84.16.228.0/24
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 broadcast:84.16.228.255
.1.3.6.1.4.1.37476.30.2.1.1.1.4.1339587487 service:www
 
.1.3.6.1.4.1.37476.30.2.1.1.2 description:Server Beta
.1.3.6.1.4.1.37476.30.2.1.1.2 status:cancelled
 
.1.3.6.1.4.1.37476.30.2.1.1.2.4 identifier:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.2.4 allocation-mech:crc32(cidr)/conflict=+1
 
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 cidr:89.149.253.178/32
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 status:cancelled
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 if:eth1
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 type:ipv4
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 netmask:255.255.255.0
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 network:89.149.253.0
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 network-cidr:89.149.253.0/24
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 broadcast:89.149.253.255
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 gateway:89.149.253.1
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 dns-nameserver:217.20.116.1
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 dns-nameserver:217.20.115.1
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 service:www
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 service:ftp
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 service:ssh
.1.3.6.1.4.1.37476.30.2.1.1.2.4.2313053751 service:mail
 
###
 
.1.3.6.1.4.1.37476.30.2.2 description:Leaseweb
.1.3.6.1.4.1.37476.30.2.2.1 description:Customer ViaThinkSoft
.1.3.6.1.4.1.37476.30.2.2.1.1 description:Server Gamma
.1.3.6.1.4.1.37476.30.2.2.1.1 status:active
 
.1.3.6.1.4.1.37476.30.2.2.1.1.4 identifier:ipv4
.1.3.6.1.4.1.37476.30.2.2.1.1.4 allocation-mech:crc32(cidr)/conflict=+1
 
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 cidr:95.211.38.42/32
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 status:active
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 if:eth0
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 type:ipv4
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 netmask:255.255.255.224
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 network:95.211.38.32
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 network-cidr:95.211.38.32/27
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 broadcast:95.211.38.63
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 gateway:95.211.38.62
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 dns-nameserver:62.212.65.123
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 dns-nameserver:62.212.64.122
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 revdns:viathinksoft.de
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 service:www
.1.3.6.1.4.1.37476.30.2.2.1.1.4.2069468249 service:mail
 
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 cidr:95.211.38.108/32
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 status:active
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 confidential
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 network-cidr:95.211.38.96/27
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 if:eth0:1
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 type:ipv4
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 netmask:255.255.255.224
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 network:95.211.38.96
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 broadcast:95.211.38.127
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 gateway:95.211.38.126
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 dns-nameserver:62.212.65.123
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 dns-nameserver:62.212.64.122
# TODO: ändern?
# .1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 revdns:ssh.viathinksoft.de
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 revdns:hosted-by.leaseweb.com
.1.3.6.1.4.1.37476.30.2.2.1.1.4.3825059945 service:ssh
 
.1.3.6.1.4.1.37476.30.2.2.1.1.6 identifier:ipv6
.1.3.6.1.4.1.37476.30.2.2.1.1.6 allocation-mech:crc32(cidr)/conflict=+1
 
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814 network-cidr:2001:1af8:4100:a061:1::/112
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814 type:ipv6
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814 name:ViaThinkSoft IPv6 Rack address space (in 2001:1af8:4100:a061::/64 net)
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814 description:Sub-identifier is the last 16 bits of the address in decimal format
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814 allocation-mech:lastIpBits(16)
 
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 name:block-1337
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 cidr:2001:1af8:4100:a061:1::1337/128
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 status:active
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 assignment:daniel-marschall@viathinksoft.de 2012-02-22
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 if:eth0
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 type:ipv6
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 netmask:64
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 gateway:2001:1af8:4100:a061::1
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 name:ViaThinkSoft Main IPv6
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 revdns:ipv6.viathinksoft.de
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 service:www
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 service:mail
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 cahost:viathinksoft.de
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.4919 cahost:www.viathinksoft.de
 
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #name:block-4041
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #cidr:2001:1af8:4100:a061:1::4041/128
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #status:active
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #confidential
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #assignment:daniel-marschall@viathinksoft.de 2012-02-26
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #if:eth0
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #type:ipv6
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #netmask:64
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #gateway:2001:1af8:4100:a061::1
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #name:ViaThinkSoft Auth IPv6
# TODO: ändern?
# .1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #revdns:ssh.viathinksoft.de
.1.3.6.1.4.1.37476.30.2.2.1.1.6.890164814.16449 #service:ssh
 
# --- ViaThinkSoft CA managment ---
 
# --- ViaThinkSoft Aktenzeichen ---
 
# --- Human Resources ---
 
#hr:de.viathinksoft soa
#hr:de.viathinksoft delegation marschall
#hr:de.viathinksoft.marschall short ma
#hr:de.viathinksoft delegation vn