Revision history for germaniumplan


Revision [3373]

Last edited on 2014-08-24 07:00:52 by CalumMcAlinden
Additions:
- backend (perl + ""MyDNS"")
- ""MyDNS"" server to work natively with Germanium
- ""MyDNS"" Export will be able to export the DB zones to real zone files
Deletions:
- backend (perl + MyDNS)
- MyDNS server to work natively with Germanium
- MyDNS Export will be able to export the DB zones to real zone files

Revision [3372]

Edited on 2014-08-24 07:00:34 by CalumMcAlinden
Additions:
The DB structure is very important. The DNS record keeping needs to match the schema ""MyDNS"" uses. By doing this it allows;
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved for ""MyDNS"" are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active
Deletions:
The DB structure is very important. The DNS record keeping needs to match the schema MyDNS uses. By doing this it allows;
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved for MyDNS are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active

Revision [2367]

Edited on 2010-12-30 17:43:17 by JulianDemarchi
Additions:
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved for MyDNS are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active
Deletions:
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active

Revision [2366]

Edited on 2010-12-30 15:58:16 by JulianDemarchi [added mydns needed fields]
Additions:
This table is used to store DNS SOA information. The userid field links the domain to a user. The nsset field links the domain to its nsset in the dns_nsset table. The fields in this table that need to be preserved are; origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active

Revision [2365]

Edited on 2010-12-30 15:45:28 by JulianDemarchi [added mydns needed fields]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;userid;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;UNI;NULL;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}
Deletions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;userid;int(11) unsigned;NO;;NULL;auto_increment;nsset;varchar(255);NO;UNI;NULL;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}

Revision [2364]

Edited on 2010-12-30 15:44:06 by JulianDemarchi [fixed errors]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;userid;int(11) unsigned;NO;;NULL;auto_increment;nsset;varchar(255);NO;UNI;NULL;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}
Deletions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;id;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;;UNI;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}

Revision [2363]

Edited on 2010-12-30 15:42:23 by JulianDemarchi [fixed errors]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;id;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;;UNI;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}
Deletions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;id;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;;NULL;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}

Revision [2362]

Edited on 2010-12-30 15:36:22 by JulianDemarchi [added another DB structure]
Additions:
{{color fg="lightgreen" bg="black" text="dns_nsset"}}
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;id;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;;NULL;;ns1ip;varchar(255);NO;;NULL;;ns2ip;varchar(255);NO;;NULL;;ns3ip;varchar(255);NO;;NULL;;ns4ip;varchar(255);NO;;NULL;;cid;varchar(255);NO;;NULL;"}}

Revision [2361]

Edited on 2010-12-30 12:30:24 by JulianDemarchi [fixed table name]
Additions:
{{color fg="lightgreen" bg="black" text="dns_rr"}}

Revision [2360]

Edited on 2010-12-30 12:22:47 by JulianDemarchi [added another DB structure]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(11) unsigned;NO;PRI;NULL;auto_increment;zone;int(11) unsigned;NO;MUL;NULL;;type;varchar(64);YES;;enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT');;data;varchar(255);NO;;NULL;;aux;int(11) unsigned;NO;;0;;ttl;int(11) unsigned;NO;;86400;;active;enum('N','Y');NO;;Y;;stamp;timestamp;NO;;CURRENT_TIMESTAMP;;serial;int(10) unsigned;YES;;NULL;"}}

Revision [2357]

Edited on 2010-12-30 11:55:21 by JulianDemarchi [changed formatting]
Additions:
{{color fg="lightgreen" bg="black" text="dns_soa"}}
Deletions:
==dns_soa==

Revision [2356]

Edited on 2010-12-30 11:53:36 by JulianDemarchi [added dns_soa tbl structure]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment;userid;int(11) unsigned;NO;;NULL;;nsset;varchar(255);NO;;NULL;;expiredate;int(11) unsigned;NO;;NULL;;period;int(11) unsigned;NO;;NULL;;origin;varchar(255);NO;UNI;NULL;;ns;varchar(255);NO;;NULL;;mbox;varchar(255);NO;;1;;serial;int(11) unsigned;NO;;NULL;;refresh;int(11) unsigned;NO;;28800;;retry;int(11) unsigned;NO;;7200;;expire;int(11) unsigned;NO;;604800;;minimum;int(11) unsigned;NO;;86400;;ttl;int(11) unsigned;NO;;86400;;active;enum('N','Y');NO;MUL;NULL;"}}
Deletions:
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| userid | int(11) unsigned | NO | | NULL | |
| nsset | varchar(255) | NO | | NULL | |
| expiredate | int(11) unsigned | NO | | NULL | |
| period | int(11) unsigned | NO | | NULL | |
| origin | varchar(255) | NO | UNI | NULL | |
| ns | varchar(255) | NO | | NULL | |
| mbox | varchar(255) | NO | | NULL | |
| serial | int(11) unsigned | NO | | 1 | |
| refresh | int(11) unsigned | NO | | 28800 | |
| retry | int(11) unsigned | NO | | 7200 | |
| expire | int(11) unsigned | NO | | 604800 | |
| minimum | int(11) unsigned | NO | | 86400 | |
| ttl | int(11) unsigned | NO | | 86400 | |
| active | enum('N','Y') | NO | MUL | NULL | |
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment"}}

Revision [2355]

Edited on 2010-12-30 11:40:24 by BrianKoontz [added dns_soa tbl structure]
Additions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;id;int(10) unsigned;NO;PRI;NULL;auto_increment"}}
Deletions:
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;
id;int(10) unsigned;NO;PRI;NULL;auto_increment"}}

Revision [2354]

Edited on 2010-12-30 11:38:00 by JulianDemarchi [bug example]
Additions:
- backend (perl + MyDNS)
=====Frontend=====
====DB Structure====
===DNS DB Structure===
The DB structure is very important. The DNS record keeping needs to match the schema MyDNS uses. By doing this it allows;
- MyDNS server to work natively with Germanium
- MyDNS Export will be able to export the DB zones to real zone files
==dns_soa==
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| userid | int(11) unsigned | NO | | NULL | |
| nsset | varchar(255) | NO | | NULL | |
| expiredate | int(11) unsigned | NO | | NULL | |
| period | int(11) unsigned | NO | | NULL | |
| origin | varchar(255) | NO | UNI | NULL | |
| ns | varchar(255) | NO | | NULL | |
| mbox | varchar(255) | NO | | NULL | |
| serial | int(11) unsigned | NO | | 1 | |
| refresh | int(11) unsigned | NO | | 28800 | |
| retry | int(11) unsigned | NO | | 7200 | |
| expire | int(11) unsigned | NO | | 604800 | |
| minimum | int(11) unsigned | NO | | 86400 | |
| ttl | int(11) unsigned | NO | | 86400 | |
| active | enum('N','Y') | NO | MUL | NULL | |
{{table columns="6" cellpadding="1" cells="Field;Type;Null;Key;Default;Extra;
id;int(10) unsigned;NO;PRI;NULL;auto_increment"}}
====UI====
Deletions:
- backend (perl)

Revision [2353]

Edited on 2010-12-30 11:16:27 by JulianDemarchi [added category]
Additions:
----
CategoryArchitecture

Revision [2348]

Edited on 2010-12-30 11:12:01 by JulianDemarchi [created page content]
Additions:
Developement for Germanium will be done in sections. This way it will ensure multiple people can design the system and not step on toes. This wiki page will contain the plan for moving forward with the recode of Galimufred into Germanium.
There are two parts I envision for this system;
- frontend (lamp)
- backend (perl)
Here we will discuss the parts and plan in detail.
Deletions:
This page will contain the plan to move forward with the Germanium deveopement.

Revision [2282]

The oldest known version of this page was created on 2010-12-21 13:46:53 by JulianDemarchi [created page content]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki